The Week in Awesome – Plugins, Cars, Food, and France
This week in awesome: Denny Cherry – our own @mrdenny – has created a Password Vault WordPress plugin. That looks seriously cool....
2014-05-30
1,092 reads
Blog Posts
Types of Join in SQL Server
You use a join to combine data from different tables into a single result set. Joins most commonly use foreign...
2014-05-30
1,611 reads
Can you partition a temporary table?
Reading that title, you might sit and wonder why you would ever want to partition a temporary table. I too...
2014-05-29 (first published: 2014-05-23)
3,786 reads
Introducing What_To_Compress V2
Hello Dear Reader! I'm about 32,000 feet in the air leaving St. Louis after a great Performance Tuning Workshop for...
2014-05-29 (first published: 2014-05-22)
2,394 reads
Notes From The May 2014 MagicPASS Meeting
Quick notes:
About a dozen people attended, attributed to the combination of having the meeting on a different than usual night...
2014-05-29
1,168 reads
Quick Tips–SSMS Select a vertical block
I saw this years ago in a presentation from Aaron Bertrand. At the time I thought it was super cool...
2014-05-29
1,653 reads
The database principal owns a schema in the database, and cannot be dropped
Problem
You are trying to drop a database user, but are getting the following error message:
The database principal owns a schema...
2014-05-29
2,517 reads
The End of the Mentoring Experiment
Back in April 2011 Steve Jones and I launched The Mentoring Experiment. We had some ideas and some goals, but...
2014-05-29
1,282 reads
We’re Giving Away SQLSaturday Orlando Vans!
We’re in full marketing mode here in Orlando, looking for ways to grow attendance for our next SQLSaturday coming up...
2014-05-29
1,424 reads
Auditing and Event SubClasses
A recent discussion got me to thinking about Auditing. To be honest, it got started with a complaint about some documentation that seemed overly light about the various fields...
2014-05-28
5 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