SQL Server Query Tuning and Optimization by Benjamin Nevarez
I was recently asked to review SQL Server Query Tuning and Optimization by Benjamin Nevarez (blog|twitter), and as soon as ... Continue reading
2022-08-16
114 reads
SQLStudies
Using DBCC CLONEDATABASE to create a schema only copy of your database.
DBCC CLONEDATABASE is one of those features that I don’t use often but it’s really cool when I need it. ... Continue reading
2022-08-24 (first published: 2022-08-11)
523 reads
Visiting with DBAs at midnight : T-SQL Tuesday #153
Memories, not being alone in the moonlight Kevin Kline (blog|twitter) is our host for this month’s episode of ... Continue reading
2022-08-09
14 reads
What’s next III
In case you didn’t know I was given notice about a month and a half ago. Since I’ve talked about ... Continue reading
2022-08-04
19 reads
SQL Homework – August 2022 – Replication part 1
You’ll hear a lot of people complain about replication. Including me. That said, replication is an amazing tool. There really ... Continue reading
2022-08-15 (first published: 2022-08-02)
248 reads
Perspective
I recently passed the second anniversary of the start of my stay in the hospital. A lot has happened since ... Continue reading
2022-07-28
25 reads
EXECUTE AS USER vs EXECUTE AS LOGIN
I use impersonation a lot. It’s a really easy way to check if someone has the permissions they are supposed ... Continue reading
2022-08-03 (first published: 2022-07-26)
753 reads
SSMS Put pinned tabs in their own row
A while back (6 years ago 
) I talked about how you can change the behavior of SSMS so that ... Continue reading
2022-07-21
113 reads
#PowershellBasics: Multi-line commands
When I’m sharing code one of the things I hate most is having a scroll bar along the bottom. I ... Continue reading
2022-07-19
102 reads
#PowershellBasics: Write the output to a file.
Last week I posted about a request to get a list of services. The first problem I ran into was ... Continue reading
2022-07-14
221 reads
Blogs
SQL Inventory Dashboards: From Raw Data to Real Insight
Tired of inventory headaches? Stock shortages and gluts don't just cause stress; they cost...
Free SQL Practice: 9 Killer Resources to Boost Your Query Skills
So, you want to get your SQL skills razor-sharp without dropping any cash? You're...
DevOps Devour Hour Slides
By Steve Jones
Here are the slides from my talk today at the Redgate NYC Devour Hour:...
Forums
Isolation Level in Azure SQL Database
Hello, Can you please clarify the following: In Azure SQL DB both ALLOW_SNAPSHOT_ISOLATION/READ_COMMITTED_SNAPSHOT are set...
Question of the Day
CONCAT_WS
What output do the queries produce?
SET CONCAT_NULL_YIELDS_NULL ON; SELECT CONCAT_WS ('-', NULL, NULL); SET CONCAT_NULL_YIELDS_NULL OFF; SELECT CONCAT_WS ('-', NULL, NULL);See possible answers