SSIS architecture: Tips for package design

You can design your SSIS packages in various ways, but you should always keep your goals and other factors in mind

03/26/2010

SQL Server Management Objects: Finally ready for prime time

PowerShell gives DBAs a reason to begin using SMO for real, so now we'll find out about all the gory details

03/10/2010

Just call it an internal DoS attack

If unnecessarily heavy workloads are hitting your SQL box, it's time to start treating them like inside hacking jobs

02/19/2010

Are you a professional coder or a professional baby?

It's time developers grow up and stop making excuses -- and learn to code the right way

01/12/2010

A different type of disaster recovery

Have you made plans for recovering from those employees who leave a catastrophe in their wake?

12/17/2009

The last-minute Xmas wish list 2009

Here are some cool gifts for that special DBA in your life

12/15/2009

IT audits are useless

Auditors and IT seem to speak different languages, even when they're talking about the same data

12/08/2009

Be careful when following SSIS best practices

Don't blindly adhere to any old advice

12/04/2009

Is SQL Server's latest security hole a real threat?

Sentrigo discovered a new security hole in SQL Server, but so far Microsoft isn't paying attention. Let me show you why they should

09/09/2009

PragmaticWorks has some of the best BI training available

It's affordable and timely, and you never have to leave the house

09/01/2009

Database tough love

Sometimes it's necessary to exercise tough love to get your systems running well

08/03/2009

Getting over layoff depression

You have to get over the depression from being laid off and find your next gig

07/28/2009

Microsoft Office 2010 Visual Studio debacle

Visual Studio stopped working in Office 2010, so Sean McCown switched back to Office 2007

07/23/2009

What to do when you're unemployed

Here are a few suggestions for keeping your skills sharp and making sure you're at the top of the list when the interviews start flowing again

07/20/2009

Microsoft may be taking security too seriously

What is Microsoft thinking when it deployd guards to interrupt a SQL Server presentation?

07/17/2009

When you should and shouldn't use PowerShell in SQL Server

PowerShell is cool, but it's not always appropriate. Here's a quick list to help you decide when to use it

07/13/2009

What are disaster recovery plans for anyway?

A disaster recovery plan is useless if you're just doing it to pass your audit

07/09/2009

When troubleshooting a problem, it's important to ask the right questions

Know what you should ask users before troubleshooting -- it'll save you a lot of time

05/19/2009

How compatible is Katmai with Windows 7?

I tried an upgrade to Windows 7 with both Katmai and Visual Studio 2008 installed. How did it go?

05/04/2009

What if food were licensed like software?

Could you afford to feed your family if food were licensed like software?

04/06/2009

Load More