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
1,998 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
11 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,142 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,609 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
511 reads
Presenting with SSMS (Day 29)
If you are presenting with SSMS, then there are some extra steps that you need to take. These steps are...
2018-01-29
860 reads
SQL Undercover Podcast – Feb 2018
The first SQL Undercover podcast where Adrian introduces the Undercover Inspector, David releases sp_restorescript 1.2 along with a bit of...
2018-01-29
452 reads
Power BI Data Security – Sharing
Microsoft recently added more sharing capabilities that may change my view on sharing within the enterprise. As with all things...
2018-02-06 (first published: 2018-01-29)
1,647 reads
Youtube Channel Update
Hello,
I just wanted to take a moment to promote the work I’ve been doing with the YouTube Channel.
I’ve published four...
2018-01-29
290 reads
Blogs
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers