SQL Server 2008 R2 RTM Cumulative Update 6 Released
Microsoft actually released SQL Server 2008 R2 Cumulative Update 6 on February 21, 2011, so I am a little late...
2011-03-01
1,071 reads
Glenn Berry
Don’t Be Afraid of Windows Failover Clustering!
One of the more exciting features in SQL Server code-named “Denali” (which is the current official name for the next...
2011-02-28
1,863 reads
Some Suggested SQL Server 2008 R2 Instance Configuration Settings
Depending on your anticipated workload and which SQL Server components you have installed, there are a number of instance level...
2011-02-25
13,787 reads
New SQL Server 2005 Cumulative Updates
Microsoft has released two new Cumulative Updates for SQL Server 2005. The first one is SQL Server 2005 SP3 CU14,...
2011-02-23
580 reads
New Version of CPU-Z (1.57) has Been Released
On February 18, Franck Delattre released version 1.57 of the very useful CPU-Z Utility. Here is a list of the...
2011-02-20
2,230 reads
Is CPU-Z Risky To Run on a Production Server?
There was a conversation on Twitter recently (with the #sqlhelp hashtag) about whether it was completely safe to run the...
2011-02-19
1,775 reads
How to Interpret SELECT @@VERSION in SQL Server
One common point of confusion that I often see when people run the SELECT @@VERSION query is how to properly...
2011-02-17
1,546 reads
Windows Server 2008 R2 SP1 Released and Installed
Microsoft has made Windows Server 2008 R2 Service Pack 1 (and Windows 7 SP1) available on MSDN and TechNet earlier...
2011-02-16
1,476 reads
Recent AMD Processor News
AMD has released five new specific models in their Opteron 6100 series line. Of these, the one you should be...
2011-02-15
462 reads
SQL Server and the “Lock pages in memory” Right in Windows Server
Another Windows setting you might want to enable is “Lock pages in memory”. There is some controversy within the SQL...
2011-02-14
1,718 reads
Blogs
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers