By Leo Flores, 09/28/2009
Ever need to create temp tables with cursors in T-SQL to mimic the utility of an array? You can use the array in C# to easily provide a solution to a common need: the ...
By Michael Otey, 09/15/2009
Despite the fact that SQL Server’s BI capabilities have been around for more than 10 years many SQL Pros don't use them. So what’s so hard about BI? I think you can sum it up with ...
By Kerrie Meyler, 09/15/2009
The SQL Server management pack in Microsoft System Center Operations Manager 2007 can help you monitor SQL Server 2008 locks, space utilization, backup jobs, and more.
By Sivakumar Mahalingam, 09/14/2009
Use this method to generate a simple backup status report that you can use to ensure all your SQL Server systems are backed up when they’re suppose to be.
By Gabriela Nanau, 09/10/2009
Using SSIS's WMI Data Reader task, you can collect a lot of useful information about the hardware and software installed on your servers.
By Itzik Ben-Gan, 09/09/2009
Four new date- and time-related data types in SQL Server 2008 address the limitations of previous versions’ DATETIME and SMALLDATETIME data types.
By Shaunt Khaldtiance, 09/03/2009
SQL Server Management Studio (SSMS) doesn't have a GUI that lets you easily obtain information about partitioned tables. Here's a stored procedure that helps fill this gap.
By Kevin Kline, 09/03/2009
Automate and script SQL Server database tasks and schema objects quickly and easily using this set of command-line tools.
By Sheila Molnar, 09/01/2009
Microsoft’s Donald Farmer explains how SQL Server 2008 R2’s Gemini will benefit both end users and IT pros.
By Michael Otey, 08/24/2009
DBMoto 6.6 solves the problem of cross-platform communication through real-time database replication between almost all popular database platforms
By Michael Otey, 08/10/2009
Support for 256 logical processors, a new Master Data Services feature, and BI-oriented Project Gemini are some of the SQL Server 2008 R2 features in our top five list.