February 2010
Using the Deadlock graph event class lets you easily gather information on SQL Server deadlocks that you can display graphically in SQL Server Profiler or SQL Server Management Studio or review in XML for more detailed information.
January 2010
By using table variables as parameters, you can make code maintenance easier.
January 2010
Deal with the limitations of SQL Server 2008’s built-in policies by creating a table-driven solution that lets you insert policy exceptions and regulate policy execution.
December 15, 2009
Ted Kummert, senior vice president of the business and platform division at Microsoft, discusses the explosive growth of the MySpace SQL Server implementation.
December 15, 2009
SQL Azure Database supports many—but not all—SQL Server features. Here are some commonly used features that SQL Azure doesn't support.
December 15, 2009
SQL Azure Database supports many—but not all—SQL Server features. Here are some commonly used features that SQL Azure doesn't support.
February 2010
Implement this solution to provide data owners with a way to audit access to data they’re responsible for.
February 2010
Minimize downtime when patching clusters by upgrading your SQL Server 2005 clusters to SQL Server 2008 to take advantage of its rolling upgrade functionality.
December 7, 2009
Follow these best practices to provide DBAs with the necessary information to identify errors when they arise.
December 3, 2009
Although with LINQ you can query data in your object model seamlessly, you need to consider a few best practices to ensure that your application performs well.
December 2009
Running DBCC can be problematic on VLDBs. Use the author's Admin/Worker Job approach to ease the process.
December 2009
Jump into advanced BI by using this step-by-step guide to making your first cube.
December 2009
Have you ever had a stored procedure that could accept a NULL value as a parameter but didn't seem to work correctly when you did so? Here's what might have gone wrong.
December 2009
Find out how to use specific T-SQL queries to pull useful information out of tables in SharePoint’s content databases.
November 2009
If you need to enforce business rules on multiple tables, try indexed views, which let you join tables and enforce uniqueness on the result set.
November 2009
The PIVOT statement is a great tool for presenting data in an easy-to-read format, but it has one key limitation: You must know about and include all the column names in the PIVOT query. You can work around this limitation with dynamic pivoting.
November 2009
Use these techniques and sample reports to get answers to your most frequently asked reporting questions.
October 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 transposition of a query’s result set.
October 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.
October 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.
Add these Headlines to your Website
