Reports in SSMS (Day 30)
SSMS has a lot of reports available for you to use. Most of the reports in SSMS are off of...
2018-01-30
542 reads
Server Audit Mystery 2: Filtering action_id gets Error Msg 25713
(last updated: 2018-06-05)
This post is, for the most part, a continuation of Server Audit Mystery 1: Filtering class_type gets Error...
2018-02-12 (first published: 2018-01-30)
3,291 reads
Layman’s Guide to Performance Tuning
Performance tuning is one of those things that is hard to get right when you do not have an established...
2018-02-08 (first published: 2018-01-30)
3,530 reads
sp_RestoreScript 1.2 is now available
sp_RestoreScript 1.2 is now available HERE and on GitHub
Changes include Service Broker options and the ability to restore a database in...
2018-01-30
646 reads
The Fastest Way To Locate Errors In Your SQL Query
Photo by N. on UnsplashIn about 60 seconds you will never debug error messages in SQL Server Management Studio the same way again.
Coming...
2018-01-30
2,011 reads
The Fastest Way To Locate Errors In Your SQL Query
In about 60 seconds you will never debug error messages in SQL Server Management Studio the same way again.
Coming from a .NET background, I'm used to receiving relatively helpful...
2018-01-30
15 reads
Converting a Power BI Desktop File from Import to Live Query
A customer of mine is in the midst of a proof of concept using SQL Server and Power BI. During...
2018-01-30
1,151 reads
Ten Ways To Help Your BI Consultant Be Successful
I’ve been working in the field of business intelligence for over ten years, as a consultant for over five years....
2018-02-12 (first published: 2018-01-30)
2,768 reads
Managing SQL Prompt Code Analysis Rules
I work for Redgate and write about products. I’ve got a series of SQL Prompt posts here on little things...
2018-02-08 (first published: 2018-01-29)
1,611 reads
No Default CONTEXT_INFO()
I was doing a little testing of Row-Level Security (RLS) for the stairway, and one of the ways that some...
2018-01-29
513 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers