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
905 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,746 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
828 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,526 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
854 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
904 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
817 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
765 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
724 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,440 reads
Blogs
SQL Server Source Control on a $0 Budget
By Kevin3NF
The Source Control Dilemma Every DBA has been there. Trying to keep track of...
CHOOSE’ing a Beer: #SQLNewBlogger
By Steve Jones
We recently published an article on CHOOSE at SQL Server Central. I thought it...
Don’t Treat Your Data Catalog Like a Data Museum
Introduction Treating your data catalog like a “data museum”—a static collection where information quietly...
Forums
The Inefficiencies of Kubernetes
Comments posted to this topic are about the item The Inefficiencies of Kubernetes
The Backup Space Needed
Comments posted to this topic are about the item The Backup Space Needed
Implementing Fuzzy Search in SQL Server Using New Inbuilt Functions
Comments posted to this topic are about the item Implementing Fuzzy Search in SQL...
Question of the Day
The Backup Space Needed
How do I calculate the amount of space needed for I/O buffers during a backup operation?
See possible answers