Odd Behavior With LOB/Overflow Data
In writing some sample demos around LOB and Row-Overflow data I found a couple of oddities in the way reads...
2019-02-20
133 reads
Gavin Draper's SQL Server Blog
SQL Server, What's In My Buffer Cache?
When SQL Server reads pages it stores them in an area of memory called the buffer cache, things like memory...
2019-03-06 (first published: 2019-02-19)
2,116 reads
SQL Server, What Waits Happened In The Last X Seconds
There are plenty of scripts out there that can show you the waits that are occurring on your server, however,...
2019-02-18
138 reads
SQL Server Script To Check Your Backup RPO Status
I recently wanted a script to tell me that for every database on a given server
What levels of backups I...
2019-02-28 (first published: 2019-02-13)
2,711 reads
How To Check How Far Behind Your SQL Server Log Shipping Secondary Is
Log shipping is one of the simplest and most bulletproof methods to get SQL Server to replicate data to a...
2019-02-21 (first published: 2019-01-31)
2,665 reads
Backing Up and Restoring Your On-Premise Databases To and From the Cloud
I’ve been meaning to start a series of posts on “Dipping your toes into the cloud” for a while now,...
2019-01-30
165 reads
How to Encrypt and Restore Your SQL Server Database Backups
We’ve had backup encryption out of the box since SQL Server 2014, yet I’ve rarely seen it used. In an...
2019-02-19 (first published: 2019-01-28)
2,675 reads
Why You Shouldn't Use SELECT * In Production Systems (EVER!)
OK so the title is a bit of a bold statement but bear with me, I’ve been burned by this...
2019-02-11 (first published: 2019-01-23)
5,856 reads
Leveling Up Your TSQL
I thought I’d use this post to round up some of my other posts into a list of often overlooked/unknown...
2019-01-22
222 reads
Supercharge Your SQL Server Scalar Functions By Switching To Table Value Functions
User defined functions in SQL server can cause all kinds of performance problems, there are however some tricks that are...
2019-01-18
228 reads
Blogs
GotoWebinar (and Teams) won’t screen share after macOS update to Catalina (10.15)
By HamishWatson
This blog post is about the situation where after upgrading to the latest macOS...
Improving TweetDeck with Better TweetDeck
By John
If you are at involved with the #sqlfamily, you are bound to hear about...
Interview with Bob Ward
By damianwidera
This is the eight interview we have done. This time our guest is the...
Forums
Protecting Data from the Inside
Comments posted to this topic are about the item Protecting Data from the Inside
Remove the middle of a string between wildcards
I have a field called 'jsonpayload' in a table called 'auditlog' that is populated...
Is SSIS really that bad?
Today we had our weekly team meeting. Part of my team is working on...
Ask SSC