CISL 1.1.0: cstore_doMaintenance (Columnstore Maintenace Solution Explained)
After the initial release of the SQL Server Maintenance Solution in CISL 1.1.0, I felt that a separate blog post...
2016-01-24
651 reads
Notes from the January 2016 MagicPASS Meeting
I did my presentation on automated restores for the second time, changed a few things. It was/is a presentation with...
2016-01-22
658 reads
Notes from SQLSaturday #480 in Nashville
Late posting, so reduced notes!
Speaker party was good. Room was loud when full due to wood walls and nothing to...
2016-01-22
636 reads
The SQL Server Security Model, Part 1: Logins [Foundations Friday]
How secure are your databases?
No, not your network. Just your databases. If your company is like most, the strongest security...
2016-01-22
775 reads
Using Change Tracking in SSIS
Recently, I wrote about how to get started with SQL Server change tracking, and I demonstrated a design pattern I...
2016-01-22
2,681 reads
What Do You Want?
It’s that time of year, planning for PASS Summit 2016. We’ve already put out the Call for Volunteers, which closes...
2016-01-22
393 reads
Overview of Published Articles – 2015Q4
Here is an overview of the articles I published in the final quarter of 2015:
Integrated Logging with the Integration Services Package...
2016-01-22
503 reads
Foundations Friday starts now
Earlier this month, my friend Tim Ford (b|t) proposed an idea:
A 2016 challenge to technical bloggers: 1 introductory level blog...
2016-01-21
451 reads
Push Button Deployments
I worked in an Agile team in 2000 and we deployed changes to our web platform every Wednesday for over...
2016-01-21
533 reads
Easy Installing .NET 3.5 for SQL Admins
Rule "Microsoft .NET Framework 3.5 Service Pack 1 is required" failed.
This is a common problem and relatively easy fix for...
2016-01-27 (first published: 2016-01-21)
1,501 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