Red Gate Dependency Tracker - Making Databases Into Moving Art
data structures are art
If anyone thinks that working with complex data structures is boring... I don't know what world they...
2016-04-27
1,065 reads
Sheldon Hull
- Website: https://www.sheldonhull.com
Automating SSMS 2016 Updates & Install
Figured I'd share a way to automate the SSMS 2016 updates until it gets it's own fancy self updater. I...
2016-04-26 (first published: 2016-04-19)
2,709 reads
Cool Tools: Powershell ISE-Steroids
Disclaimer: I have been provided with a free license because I am reviewing. This doesn't impact my assessment of the...
2016-04-14
1,266 reads
Failed to Initialize SQL Agent Log... not worthy
Moving system databases in SQL Server takes a bit of practice. I got that again, along with a dose of...
2016-04-01
8,301 reads
Calculating Some Max Mirror Stats
This turned out to be quite a challenge. I couldn’t find anything that made this very clean and straight forward...
2016-03-18
421 reads
Failover all databases to other server
Quick snippet I threw together to help with failing over synchronized databases to the other server in bulk. No way...
2016-03-18
849 reads
Previewing the new SSRS 2016 portal
Ran into an issue with the “Preview New Reporting Portal” link on a fresh install of 2016 giving me a...
2016-03-18
450 reads
SQL 2012 SP3 and entity framework conflict
the problem
An issue with SQL Server 2012 SP3 was identified that impacted EF4/5 due to additional datatypes in the dll....
2016-03-18
7,502 reads
TFS Work-Item Fancy Filtering
If you want to create a TFS query that would identify work items that have changed, but were not changed...
2016-03-18
427 reads
Should I use option(recompile)?
Should I use option(recompile)?
This will probably be a multiple stage discussion. The notes I’m providing today were sparked off of...
2016-02-02
6,994 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