An Easter SQL
Since Easter is nearly upon us, I got to thinking once again about how challenging it is to calculate the...
2015-03-31
3,768 reads
Blog Posts
Apress April Fools 40% Discount Promo & Healthy SQL
April 1, 2015 – I am delighted to take part in the April
Fool’s Promotion by Publisher Apress, who are
featuring some of...
2015-03-31
1,593 reads
Exam Prep 70-463: Logging in SSIS 2012
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2015-03-31 (first published: 2015-03-09)
7,178 reads
2015-03-31
1,525 reads
Microservices and Databases
I ran across a post on microservices recently and was intrigued. I always like the idea of loosely coupled, independent...
2015-03-31
2,797 reads
Parsing XML Child Nodes and Converting to DateTime with PowerShell
As part of my organiser role for SQLSaturday Exeter (Training Day Information here and Saturday Information here) I needed to...
2015-03-31 (first published: 2015-03-21)
6,930 reads
PASS Board Update: March 2015
Hello all,
It’s been a while since my last update. Sorry. I’ve just been traveling and presenting and working on books...
2015-03-31
1,113 reads
Creating a large data warehouse in Azure
Microsoft Azure provides you two options when hosting your SQL Server-based data warehouse: Microsoft Azure SQL Database and SQL Server...
2015-03-30 (first published: 2015-03-19)
7,718 reads
Intro to SQL Server Automation with PowerShell
March 26th, 2015, a date which will live in infamy!
Well, at least for me it will. March 26th, 2015...
2015-03-30
915 reads
Latches, Spinlocks & Lock-Free Data Structures Recording
A few weeks ago I have spoken at the SQLRally Nordic conference in Copenhagen about Latches, Spinlocks, and Lock-Free Data...
2015-03-30
1,310 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