Database Fundamentals #11: Why Learn T-SQL
If you’ve been following along with the previous 10 Database Fundamentals blog posts, you have a SQL Server installed and...
2017-09-21 (first published: 2017-09-18)
1,987 reads
The Scary DBA
Speaking at IT/DevConnections 2017
If you’re going to be in the San Francisco area in October, let’s get together and talk. I’ll be at...
2017-09-13
351 reads
Database Fundamentals #10: Modifying Tables
Invariably, either while building a new database, or while maintaining old ones, you will find that the business needs change...
2017-09-12
450 reads
Database Fundamentals #9: Schemas As Containers
Schemas are a very useful tool for managing the objects in your database. From security through process, through placement, schemas...
2017-09-14 (first published: 2017-09-06)
2,323 reads
Luck and the PASS Summit
I recently read an article asking the question whether or not we downplay the role that luck plays in our...
2017-09-05
337 reads
Ich werde Deutschland beriesen
Guten Tag!
OK, switching back to English for the rest of this.
I’m going to be spending a few weeks in Germany...
2017-08-30
541 reads
Database Fundamentals #8: All About Data Types
SQL Server provides all different kinds of data types in order to give you more flexibility and control for how...
2017-08-29
654 reads
Database Fundamentals #8: All About Data Types
SQL Server provides all different kinds of data types in order to give you more flexibility and control for how...
2017-08-29
1,435 reads
Speaking at Live360 Orlando
Are you going to be in Florida in November? Me too. I’m privileged to say that I get to speak...
2017-08-28
444 reads
Speaking at Live360 Orlando
Are you going to be in Florida in November? Me too. I’m privileged to say that I get to speak...
2017-08-28
290 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