Testing New Features in SQL Azure Service Update 1
It seems to be SQL Azure night for me tonight… I thought I would try out some of the new...
2010-02-19
707 reads
Glenn Berry
Cumulative Update Package 8 for SQL Server 2005 Service Pack 3
Microsoft has released CU8 for SQL Server 2005 SP3, which you can get here. This is Build 4285. This CU...
2010-02-18
672 reads
Mirroring a Large Number of Databases in a Single SQL Server Instance
Microsoft SQLCAT team members Sanjay Mishra and Prem Mehra have published a new Technical Note called Mirroring a Large Number...
2010-02-17
972 reads
MVP Summit Impressions From Day 1
Well, today was the opening day of the 2010 MVP Global Summit in Bellevue, WA. There were a few “side...
2010-02-17
637 reads
Presenting in Colorado Springs on May 19, 2010
I will presenting at the Colorado Springs SQL Server User’s Group (CSSQLUG) on Wednesday, May 19, 2010. I will be...
2010-02-16
639 reads
SQL Server 2005/2008 Servicing Plans
Microsoft Group Program Manager Matthias Berndt has a post up on the Microsoft SQL Server Release Services blog (which is...
2010-02-13
589 reads
Round Two of Insert Benchmark Tests
After seemingly exhausting my physical file layout and instance configuration options in Round One of testing, I decided to “throw...
2010-02-09
524 reads
Speaking at the Rocky Mountain Tech Trifecta on February 27
I will be giving my Dr. DMV: How to Use Dynamic Management Views to Monitor and Diagnose Performance Issues With...
2010-02-09
501 reads
Some Initial Insert Test Benchmarks on SQL Server 2008 R2
They say that imitation is the sincerest form of flattery. I have been following along as Paul Randal has been...
2010-02-07
4,335 reads
Detecting and Troubleshooting Non-Yielding Worker Threads in SQL Server 2005/2008
I had a little bit of excitement with one of my production servers couple of days ago, that I thought...
2010-02-04
2,992 reads
Blogs
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Free Online Sessions – Building the €100 DWH and Indexing for Dummies
I’m giving two online sessions soon on virtual events that are free to attend....
Forums
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Revisiting SQL Server Window Functions- A Practical Walkthrough
Comments posted to this topic are about the item Revisiting SQL Server Window Functions-...
Tables with a SPARSE Column and Consumption
Comments posted to this topic are about the item Tables with a SPARSE Column...
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers