Continuation from the previous 39 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
It’s time to take a look into the algorithms that Microsoft is...
2014-09-09
313 reads
This month’s T-SQL Tuesday topic is passwords. I’m neither a DBA nor server/system admin, so the only passwords I get to manage are my own. But there’s still lots to...
2014-09-09
17 reads
This weekend is SQL Saturday #300 in Kansas City. I’ll be traveling Friday for the event, hoping to arrive in...
2014-09-08
732 reads
Do you ever copy query results out of SQL Server Management Studio, paste them into your text editor, and then...
2014-09-11 (first published: 2014-09-08)
10,907 reads
I’ve seen this mistake more than once, from DBAs with a middling to fair amount of experience. So it bears repeating....
2014-09-08
934 reads
This is just a short update. I will be speaking at SQL Saturday Kansas City! I really hope to see...
2014-09-08
605 reads
Ah, an interesting week for registrations. We’ve jumped to 426 registered, making my goal of 500 doable. The jump is...
2014-09-08
527 reads
This is part of a series of tips for speakers to make your presentations better.
Please, please, please, learn how to set...
2014-09-08
835 reads
This is the fourth post in the “Parameterization” series. In the previous post I wrote about parameter sniffing, and I...
2014-09-11 (first published: 2014-09-08)
7,150 reads
A short post today to pass on a script I wrote to fulfil a requirement I had.
Which indexes are on...
2014-09-07
549 reads
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item Planning for Change
Comments posted to this topic are about the item Importing Excel files into SQL...
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