The idea of a skunk works is to build a project that works under the radar, by a small and loosely organized group of people. Used to fuel innovation, this is an idea that you might apply to SQL Server BI projects.

Multi-subnet Failover Clusters

by Robert Davis

SQLServerCentral.com

Blogs

Multi-subnet Failover Clusters
I want to take a closer look at one of the new features in SQL Server Denali. While...

SQL Server Unit Testing with tSQLt

by Additional Articles

SimpleTalk

Testing

When one considers the amount of time and effort that Unit Testing consumes for the Database Developer, is surprising how few good SQL Server Test frameworks are around. tSQLt , which is open source and free to use, is one of the frameworks that provide a simple way to populate a table with test data as part of the unit test, and check the results with what should be expected. Sebastian Meine and Dennis Lloyd, who created tSQLt, explain

Why Every DBA Needs a Buddy

by John Sansom

SQLServerCentral.com

Blogs

If you truly desire to be an effective SQL Server Database Administrator then you absolutely must have a buddy.
SQL Server...

Data Scientists

by Steve Jones

SQLServerCentral.com

Editorial

Would you want to be a data scientist? Are you one now? Steve Jones talks about this skill that we might appreciate in our daily work.

Making a more reliable and flexible sp_MSforeachdb

by Additional Articles

MSSQLTips.com

Administration

While the system procedure sp_MSforeachdb is neither documented nor officially supported, most SQL Server professionals have used it at one time or another. This is typically for ad hoc maintenance tasks, but many people (myself included) have used this type of looping activity in permanent routines. Sadly, I have discovered instances where, under heavy load and/or with a large number of databases, the procedure can actually skip multiple catalogs with no error or warning message. Since this situation is not easily reproducible, and since Microsoft typically has no interest in fixing unsupported objects, this may be happening in your environment right now

SQL University: Spring 2011

by sqlchicken

SQLServerCentral.com

Blogs

The new SQL University Logo
Welcome back students! We’re very excited to start up a new semester and SQLU is back and...

ETL Security Holes

by Steve Jones

SQLServerCentral.com

Editorial

The growth of ETL processes and secondary systems for reporting, decision support and other analysis creates an issue. Steve Jones points out that we ought to be remembering that security needs to be applied to data, not just systems.