UNDERCOVER TOOLBOX: Find Untrusted Foreign Keys and Orphaned Key data
SQL Server tracks untrusted Foreign keys in sys.Foreign keys with a column called is_not_trusted, there may be a number of...
2017-10-24
202 reads
Power BI Custom Visuals Class (Module 74 – Cylindrical Gauge MAQ Software)
In this module you will learn how to use the Cylindrical Gauge Custom Visual by MAQ Software. The Cylindrical Gauge...
2017-11-07 (first published: 2017-10-24)
1,610 reads
Webcast: Troubleshooting SQL Server Connection Issues
I will be doing a live webcast on Thursday, November 9th 2017 at 3 PM Eastern Time (8 PM UTC...
2017-10-23
463 reads
But I Don't *Want* To "Restore from a backup of the database or repair the database!"
Do you like Log Shipping?
Before my time at Ntirety I had done quite a bit of work with failover clustering...
2017-11-02 (first published: 2017-10-23)
3,249 reads
SQL Clone Server Service Permissions
SQL Clone is amazing, and it can really save time and disk space for many organizations. I’ve got a series...
2017-11-03 (first published: 2017-10-23)
1,105 reads
Monday Night Networking at Summit 2017
Next week is the PASS Summit in Seattle. Thousands of SQL Server professionals are going, many coming Sunday or Monday...
2017-10-23
468 reads
Podcast with SQL Data Partners on Patching Best Practices
Recently, I joined Carlos L Chacon (site|@CarlosLChacon), Steve Stedman (blog|@SqlEmt), and the rest of the SQL Data Partners Podcast team...
2017-10-23
460 reads
Dynamic Data Masking – Tracking all masked columns in your database
dotnetvibes
I have presented on Making Developers lives easier with SQL Server 2016 multiple times over the last couple of months,...
2017-10-23
355 reads
Why would a SQL Server DBA be interested in Python?
If we follow blogs and publications on the technological advancement with respect to SQL, we notice the increase in the...
2017-10-23
493 reads
When is it a good idea to consolidate multiple instances?
In this age of cost-saving after cost-saving, one way you may be looking at saving money is by combining multiple...
2017-11-01 (first published: 2017-10-23)
2,122 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers