Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: May 2011

Pray For Me…I’m Writing the Bible!

Prayer Cat Prays

Well not THE Bible, but rather the SQL Server Bible! I’m incredibly excited and proud to say I’ll be one of the primary authors on the 2011 edition (aka “Denali”). Who are the rest of the folks involved on this venture? Check out this great list… Read more

1 comments, 181 reads

Posted in SQL Chicken on 24 May 2011

Pragmatic Tools Week: Task Factory

If you've ever spent any time doing SSIS development work, you'll eventually come to a point when developing something and you think to yourself "there has GOT to be an easier way of doing this". We at Pragmatic Works feel the same way so our team of developer monkey ninjas…

Read more

0 comments, 633 reads

Posted in SQL Chicken on 11 May 2011

SQLRally Overdrive: Birds of a Feather Discussions Event

Just wanted to post a quick note/invitation to everyone to come join us on Thursday, May 12th from 5:45-7:00 for the SQLRally Overdrive: Birds of a Feather Discussions event.

We’ll have several tables, each with a dedicated expert in the field hosting conversations. Want to delve into some shop… Read more

0 comments, 159 reads

Posted in SQL Chicken on 11 May 2011

Pragmatic Tools Week: BIxPress

Much like Tim “The Toolman” Taylor had his themed weeks, we’re going to do something similar. This week we salute: (play fanfare music here) the Pragmatic Works BI toolset. Today we’re going to talk about BIxPress.

I’ve previously posted on BIxPress and how it helps DBAs out,… Read more

0 comments, 188 reads

Posted in SQL Chicken on 9 May 2011

SQLRally OverDrive Events!

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… Read more

0 comments, 151 reads

Posted in SQL Chicken on 6 May 2011

SQL University: Precedence Constraints

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… Read more

0 comments, 1,130 reads

Posted in SQL Chicken on 6 May 2011

Policy-Based Management and Local Password Policy

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… Read more

1 comments, 492 reads

Posted in SQL Chicken on 4 May 2011

SQL University: Parents Just Don’t Understand

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… Read more

0 comments, 170 reads

Posted in SQL Chicken on 2 May 2011

Parents Just Don’t Understand

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… Read more

0 comments, 204 reads

Posted in SQL Chicken on 2 May 2011