SQL Server Utility in SQL Server 2008 R2
One of the new management related features in SQL Server 2008 R2 is SQL Server Utility. SQL Server Utility gives...
2010-03-15
4,171 reads
Glenn Berry
SharePoint 2010 and Various Versions of SQL Server
Microsoft has recently announced that SharePoint 2010 and Office 2010 will RTM in April 2010, and will be officially launched...
2010-03-11
5,822 reads
How to Easily Log SQL Server 2008 Instance Level Metrics
If you want to record the results of some useful, instance level DMV queries somewhere where you can easily query...
2010-03-09
1,149 reads
Easy Ways to Detect I/O Pressure in SQL Server 2008
It is pretty common for large, busy SQL Server instances to run into I/O bottlenecks. Even smaller, less busy systems...
2010-03-09
4,519 reads
T-SQL Tuesday #004 Hosted by Mike Walsh
I just wanted to remind people to participate in T-SQL Tuesday #004 on the subject of IO. You just need...
2010-03-08
556 reads
More SQL Azure Samples
I have been playing around some more with SQL Azure in order to get ready for an upcoming presentation, so...
2010-03-05
2,271 reads
Using the OUTPUT clause to retrieve new identity values from SQL Server 2008
Microsoft has a new KB article outlining issues with using SCOPE_IDENTITY and @@IDENTITY to retrieve values inserted into an identity...
2010-03-03
2,731 reads
Rocky Mountain Tech Trifecta Impressions
I attended and presented at the Rocky Mountain Tech Trifecta yesterday, where I had a very nice time. Julie Yack...
2010-02-28
1,479 reads
Weekly Electrical Usage from Google PowerMeter
Since I like to measure and monitor things (maybe that is why I am a DBA), and I care about...
2010-02-28
1,565 reads
Dr. DMV Script for Rocky Mountain Tech Trifecta
Here is the script that has the diagnostic queries that I will be using during my presentation at the Rocky...
2010-02-26
2,762 reads
Blogs
Local LLM Models at SQL Saturday Boston 2025
By Steve Jones
I’m starting a long trip at Boston this weekend. I’ll be there Saturday speaking,...
3 things you must do to start data quality management right
As a data & AI strategist who’s seen countless projects succeed and fail, I...
Set Theory vs. Batch Mode in SQL Server
By SQLPals
Set Theory vs. Batch Mode in SQL Server Not long ago,...
Forums
SSC Website Deployment 24 Sept 2025
We are planning on a fairly big code deployment to set the stage for...
Timeout when expanding the table
Experts, I am hoping to get some help and feedback. I have a server...
Single User SQL Server on Linux
Comments posted to this topic are about the item Single User SQL Server on...
Question of the Day
Single User SQL Server on Linux
How can I start SQL Server on Linux in single-user mode to restore the master database?
See possible answers