SQL Server, Error message 1785, and cascading deletes: How it kills kittens
I've been gone for a bit, forgive the long delay. Who would have thought the hatred for a cascading delete...
2015-03-03
1,085 reads
Blog Posts
T-SQL EXCEPT and INTERSECT
T-SQL EXCEPT and INTERSECT
Both T-SQL EXCEPT and INTERSECT are set based operators that combine multiple query results back in the same...
2015-03-03 (first published: 2015-02-23)
9,015 reads
Unit Test Sql Server Code
In part 3 of this series of blogs on "getting more agile" I am going to look at unit testing...
2015-03-03
398 reads
Unit Test Sql Server Code
In part 3 of this series of blogs on “getting more agile” I am going to look at unit testing...
2015-03-03
50 reads
Unit Test Sql Server Code
In part 3 of this series of blogs on “getting more agile” I am going to look at unit testing...
2015-03-03
61 reads
Unit Test Sql Server Code
In part 3 of this series of blogs on “getting more agile” I am going to look at unit testing and why we need to do it.
My code is...
2015-03-03
4 reads
NJ SQL UG Event: 13 Advanced SSAS Tips - Kevin S. Goff
Greetings! If you are local, or in the NY/Central NJ area, mark you calendars for WED. MARCH 11, 2015 @ 6:00PM,...
2015-03-02
1,228 reads
No Such Thing as a DevOps DBA
Sjor Takes (b|t) has just barely started blogging, but he’s got a great post about a discussion he had with...
2015-03-02
771 reads
Rochester SQL Server User Group February Meeting - Slides & Demos
On Thursday, February 26th I presented “Easing Into Windows PowerShell” to a packed house at the Rochester SQL Server User Group meeting. Thanks to Matt Slocum (blog | twitter)...
2015-03-02
3 reads
Should I check tempdb for corruption?
You all know that checking our databases for corruption regularly is a must. But what about tempdb? Do you need...
2015-03-02
4,575 reads
Blogs
Flyway Tips: AI Helps with Commit Messages
By Steve Jones
At Redgate, we’re experimenting with how AI can help developers and DBAs become better...
Startup scripts in SQL Server containers
I was messing around performing investigative work on a pod running SQL Server 2025...
Using SQL Compare with Redgate Data Modeler
By Steve Jones
Redgate recently released SQL Compare v16, which included a new feature to work with...
Forums
What is Page Density
Comments posted to this topic are about the item What is Page Density
T-SQL in SQL Server 2025: Fuzzy String Search II
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Azure-SSIS, Self-Hosted Integration Runtime, & Data Gateway?
Looking to confirm my understanding of these three products and how they can be...
Question of the Day
What is Page Density
In SQL Server, there is a concept of page density. This is determined by how much data is stored on each page. What is a page density of 90%?
See possible answers