Synonyms in SQL Server – Good and Bad
When SQL Server 2005 was released, a nifty little feature was included called synonyms. Despite being around since SQL Server...
2018-12-14
302 reads
Blog Posts
Synonyms in SQL Server – Good and Bad
How you use a synonym can be a huge asset or it can be a significant dampener to performance. There are benefits and uses for these nifty little things....
2018-12-14
39 reads
The Year in Review Webinar–Dec 18
Join me for our Year in Review Webinar next week, Dec 18, at 4pm GMT. I’ll be joining Kendra and...
2018-12-14
879 reads
Things I Learned at Summit v20 - Trace Flag 4199
Part of a series of posts on cool stuff I learned at PASS Summit v20 (2018) - in this first post...
2018-12-14 (first published: 2018-11-29)
3,579 reads
Change Tracking Inserts Require SELECT Permission
I’ve been writing about change tracking in SQL Server for some time now, but I recently came across a permissions...
2018-12-13
200 reads
Difference Between Restore with Recovery & Restore with Norecovery
Every tech-conscious person is familiar with restoration process in the world of computing. This process is usually followed by the...
2018-12-13
43,797 reads
Difference Between Restore with Recovery & Restore with Norecovery
Every tech-conscious person is familiar with restoration process in the world of computing. This process is usually followed by the process of backup. In case of SQL Server, restoration...
2018-12-13
61 reads
Maintenance Plan Owner – Back to Basics
We all inherit things from time to time through our profession. Sometimes we inherit some good things, sometimes we inherit...
2018-12-13
226 reads
Maintenance Plan Owner – Back to Basics
Have you ever taken over a server that had several maintenance plans on it? Have you ever really checked who the owner of those plans is? Or, maybe you...
2018-12-13
44 reads
Naming Convention Hall of Shame
Call me pedantic, but I can be a stickler for standardized naming conventions. Whether it’s application code, database objects, documentation,...
2018-12-13
211 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