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,056 reads
Sheldon Hull
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,694 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,196 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,221 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
813 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
444 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
411 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,477 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
417 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,759 reads
Blogs
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Identities and Sequences III
Comments posted to this topic are about the item Identities and Sequences III
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers