Setting a Dedicated Login To Run DMV Queries in SQL Server 2005\2008
In order to run server scoped DMV queries, you must have VIEW SERVER STATE permission for the login you are...
2010-01-20
910 reads
Glenn Berry
SQL Server 2008 SP1 Cumulative Update 6 Released
Microsoft has released Cumulative Update 6 (CU6) for SQL Server 2008 SP1, which you can request here. This is Build...
2010-01-19
1,750 reads
Three Big Things That Got Me Here
I was tagged by Steve Jones in the meme that Paul Randal started a few days ago, so I need...
2010-01-19
838 reads
A Few Useful Queries for SQL Server 2008 Integrated Full Text Search (iFTS)
I had a hardware issue this past weekend on one of my database servers where I am running SQL Server...
2010-01-18
1,530 reads
Intel Nehalem-EX and Database Performance
Intel is talking about the upcoming launch of the next generation Intel Xeon processor (Nehalem-EX) being bigger than the Xeon...
2010-01-18
859 reads
Second Shot Promotion For Microsoft Certification Exams
Microsoft and Prometric have renewed their Second Shot promotion for certification exams. This allows you to retake a failed exam...
2010-01-16
908 reads
The Energy Detective TED 5000 Installed And Working
Back in October, I ordered one of the new TED 5000 energy monitors directly from Energy, Inc. in Charleston, SC....
2010-01-16
822 reads
PASS 2009 Speaker Evaluation Scores
Since quite a few PASS 2009 speakers have gone public with their speaker evaluation scores, I might as well do...
2010-01-15
772 reads
Using Synthetic Benchmarks To Help Evaluate Database Server Hardware Choices
As a DBA, I think it is very important to stay current on trends in x64 based hardware. The DBA...
2010-01-15
733 reads
Installing SQL Server 2008 and 2008 R2 on Windows Server 2008 R2
There is a recent post on the Microsoft SQL Server Support Blog about how to get SQL Server 2008 and...
2010-01-12
1,470 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