SQLRally

SQLRally OverDrive Events!

Posted on

So you’re going to SQLRally in Orlando next week? Want to take advantage of ALL of the awesome opportunities presented? In addition to all of the amazing training content you’ll see at the event itself, we’re holding some great stuff after-hours on Thursday. We’re calling this SQLRally OverDrive! These are three different panel events being […]

SQL University: Precedence Constraints

Posted on

Welcome back, class! In our last class, we setup a parent-child package configuration and showed how you can pass variables between the two in order to complete a unit of work. In today’s class we’re going to continue exploring that data load package and take a look at another critical piece of SSIS that you […]

Policy-Based Management and Local Password Policy

Posted on

This post is based on an interesting question/situation that was posted over at ASKSSC.com today. The user asked how to create a policy condition that enforces local sql accounts to adhere to password expiration policies. First off, to create the condition itself is relatively easy. Below I’ve provided the T-SQL code so that you can […]

SQL University: Parents Just Don’t Understand

Posted on

Welcome to the second week of SSIS this semester at SQL University. Today we’re going to talk about the relationship between children and parents. Ever had communication issues with your kids when you ask them to complete a chore? When they’re done, wouldn’t it be nice if they always came back and let you know they […]

Masters BIverse

Be the Master of your Data Warehouse Universe at SQLRally!

Posted on

Do you have a data warehouse initiative in your current organization and looking for a way to learn how to properly build and support it? Would you like to learn how to do this straight from the Masters of the BIverse themselves? Well you’re in luck! Next month at SQLRally there’s going to be a […]

Find Table Heaps Using Policy-Based Management

Posted on

This is just a quick post in regards to a conversation I just had via Twitter. If you don’t already use Twitter, the SQL Community has setup a great resource on there using the hashtag of #sqlhelp. Today a conversation came up due to a forum question over at SQLServerCentral regarding applying policies to databases […]

SQL_University_Web1

SQL University Lecture Series: Women in Tech

Posted on

This week SQL University is on Spring Break but we’ve lined up some activities to help keep students busy (you know what they say about idle hands and whatnot!). In continuation of Women’s History Month, and properly coming off of the heels of the 24 Hours of PASS event, we’re proud to have our next […]

24hop

24 Hours of PASS: Day 1

Posted on

Yesterday was the first day of PASS’ 24 Hours of PASS event. For those not familiar, 24 Hours of PASS is an event that brings together 24 different presenters and they present on various topics on SQL Server ranging from performance tuning, internals to business intelligence and previews at vNext of SQL Server. This month’s event is […]

Making WIT awesome since 1993

Oh Yes It’s Ladies Ni…errr…Month

Posted on

It’s March and this month sees a lot of celebration, amongst the parties are Mardi Gras and St. Patrick’s Day. This month we also celebrate women as it is Women’s History Month as well! If you’ve spent any time in the SQL Community you may have noticed that we have an especially strong support for […]