Why I’m Only Casting One Vote This Year in the PASS Election
First, a reminder/disclaimer that I am serving on the PASS NomCom this year. The four candidates in the election are...
2014-09-26 (first published: 2014-09-23)
6,531 reads
The Magic Alt Button
Lately I have been using more and more the awesomeness of the Alt-button in SQL Server Management Studio (SSMS). What...
2014-09-23
856 reads
SQL Server Query Performance Tuning
The latest update to my book, SQL Server Query Performance Tuning was released last week. This is the fourth edition...
2014-09-23
791 reads
SSIS ReportGenerator Task
Did you ever faced a situation when needing to generate dynamically a SQL Server Reporting Services Report on-demand, at some...
2014-09-22
415 reads
Launching PASSWatch
I’ve wanted to do this for a while, decided to make the time commitment and see what happens. See the...
2014-09-22
553 reads
The Mentoring Experiment – Closing Thoughts
Andy wrote a post today called The End of the Mentoring Experiment, which is something we’ve talked about for some...
2014-09-22
731 reads
SQL Server Cluster LooksAlive and IsAlive Check
Windows Cluster Service use the “heartbeat” process to check whether each node is alive at both the OS level and SQL Server level. Heartbeat signals works on UDP. Microsoft...
2014-09-22
25 reads
Grant for President
Grant Fritchey is running for the PASS board. He’s not running for President, though I’m not sure why he shouldn’t...
2014-09-22
781 reads
Communication and the Board: #PASSVotes
The whole idea behind PASS is to build a community of people who can assist each other in their daily...
2014-09-22
563 reads
Changing configuration settings with sp_configure
I was recently asked where to go in Configuration Manager to change the settings for xp_cmdshell. It was then that...
2014-09-24 (first published: 2014-09-22)
8,053 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