Pray For Me…I’m Writing the Bible!

Posted on

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 of authors: Primary Authors Adam Jorgensen (Blog | Twitter) […]

Share

Pragmatic Tools Week: Task Factory

Posted on

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 put together a nifty toolset […]

Share

SQLRally Overdrive: Birds of a Feather Discussions Event

Posted on

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 talk about PowerShell? Curious about how […]

Share

Pragmatic Tools Week: BIxPress

Posted on

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, but the heart of this product is really […]

Share
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 […]

Share

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 […]

Share

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 […]

Share

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 […]

Share