Automated Source Control: A Librarian For Your Database Objects, Part 2
I assume that by now you’ve tried the script from Part 1, and have seen how easy it is to...
2014-08-29 (first published: 2014-08-25)
6,931 reads
Blog Posts
Friday Followup For August 29, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-08-29
1,157 reads
Reblog: August 22 to August 28
Photo credit – Husso
I’ve always been a fan of the feeling when I find an old blog post that’s got just...
2014-08-29
1,365 reads
Continuous Integration/Delivery without Testing!
Anything we can do to automate our builds and deployment should be considered. After all, the point isn’t just to...
2014-08-28 (first published: 2014-08-25)
7,614 reads
Dear IT Guy, Why do you hesitate to attend my meetings?
I was attending Microsoft’s on-boarding training last week and one of the managers there mentioned that a lot of IT...
2014-08-28
868 reads
I Didn’t Hyperventilate!
I gave what is officially my second presentation this week. I presented at the Triad SQL BI (Twitter | PASS) user...
2014-08-28
1,291 reads
My SQLBits Session Recordings
Last month, I had the pleasure of presenting two of my favorite sessions at the SQLBits conference in Telford, UK.
A few days...
2014-08-28
1,032 reads
Parameterization Part 2: Seven Ways to Execute Your Query
This is the second post in my series on parameterization. In the first post I wrote about plan caching and...
2014-08-28 (first published: 2014-08-25)
9,123 reads
What I Wish I Had Known Sooner…as a DBA
Yesterday I took a minute and to review some posts by some Data Professionals and in doing so I came...
2014-08-28
1,104 reads
Presenting At OPASS August 2014 Meeting On 8/28
Thursday night (8/28) I'll be presenting Inspector Insert And The Case Of The Mistaken IDENTITY for the Orlando SQL User...
2014-08-27
1,183 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Cross-DB Ownership Chaining problem
We want to setup a gateway db to host stored procedures which use tables...
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers