Book review – Extending SSIS with .NET Scripting
Recently I got my hands on a copy of Extending SSIS with .NET Scripting, written by SQL Server MVP Joost...
2016-01-29 (first published: 2016-01-21)
2,868 reads
Counting Your VLFs, or, Temp Tables Inside IF...ELSE Blocks
There are many many blog posts out there about Virtual Log Files (VLFs) - one of the absolute best is "8...
2016-01-21
877 reads
Return of the .NET - NYC
Thought I would share a note that I received from Nick Landry, Sr. Technical Evangelist for NY Metro & NJ, about...
2016-01-21
1,262 reads
What is RapidMiner
RapidMiner Overview
If you are searching for a data mining solution be sure to look into RapidMiner. RapidMiner is an open...
2016-01-21
579 reads
Transaction Logging & Recovery (part 3)
Transaction Logging & Recovery (part 3)
… Continuation of some notes regarding the excellent content by Paul Randal in *Pluralsight: SQL Server:...
2016-01-20
840 reads
Power BI and Google Analytics
One of the more underused features of Power BI is the Google Analytics data source. Working closely with marketers and...
2016-01-20
1,324 reads
Installing SQL Server 2016 Community Technology Preview
This post is designed to explain the installation steps of some of the new features in 2016 and just how...
2016-01-20
785 reads
Advent of Code–Day 2
I’ve continued working along, and while I found Day 2 to be straightforward in Python and PowerShell, I thought it...
2016-01-20
628 reads
HA/DR for Azure SQL Database
Azure SQL Database is a relational database-as-a-service in the cloud. It uses a special version of Microsoft SQL Server as...
2016-01-20
984 reads
Transaction Logging & Recovery (part 3)
… Continuation of some notes regarding the excellent content by Paul Randal in *Pluralsight: SQL Server: Logging, Recovery, and the Transaction...
2016-01-20
419 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