Sharon Dooley’s Lightening Talk and the WIT Luncheon
At the end of last week I received an email from my friend and colleague Sharon Dooley telling me her...
2011-08-31
2,536 reads
SQL Server, EarthQuakes and the End…Of DBAs?
SQL Server, EarthQuakes and the End…Of DBAs?
What does the advent and integration of VMs, SSDs, and the Cloud mean for...
2011-08-31
2,599 reads
Book Status #1: Indexing for Performance
As some of you may know, I am writing a book on indexing. So far I’ve written and submitted four...
2011-08-31
1,423 reads
Mobile Commerce and SQL Performance Tuning
I was reading through Gartners Top Predictions and one prediction captured my attention:
“By 2014, over 3 billion of the world's...
2011-08-31
1,742 reads
Shrinking Transaction Logs
I see questions on forums all the time about DBA’s or System Admins finding they are out of drive space...
2011-08-31
2,220 reads
Computed Columns and UDFs
I wrote about the basics of computed columns and also using CASE in a computed column recently, but there’s a...
2011-08-30
3,420 reads
PASS Regional Mentor
Wow, how time flies by. It seems like just a month ago I was made the PASS Regional Mentor for...
2011-08-30
1,409 reads
Strong Manager or Weak Manager?
Here’s the link to my editorial on SSC last week. I was pleasantly surprised by the discussion, and was interested...
2011-08-30
1,725 reads
Using PowerShell to Monitor SQL Server
By Ian Treasure
Over the past few years, I have used a number of approaches to monitor SQL Server. For example,...
2011-08-30
7,365 reads
TRUNCATE_ONLY is not a recognized BACKUP option
Executing the code below in SQL Server 2008 will throw an error message:
BACKUP LOG ‘MyDatabase’ WITH TRUNCATE_ONLY
Msg 155, Level 15,...
2011-08-30
9,172 reads
Blogs
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Forums
The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Planning for Change
Comments posted to this topic are about the item Planning for Change
Importing Excel files into SQL Server, Azure Edition
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
The ##MS_DatabaseConnector## User
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers