Datediff: We’ve Been Doing It Wrong
One of the most common mistakes people make when writing T-SQL is using a function in the where clause, and...
2017-01-23
2,240 reads
Blog Posts
Error While running PowerShell code from SQL Agent job – “Path Does Not Exist”
Issue: When I am running code from PowerShell console its running fine but when I execute it through SQL agent...
2017-01-23
1,046 reads
How to Exclude Entire Sections in VS Schema Compare
Right now I am so excited, and a little embarrassed. After using Visual Studio (VS) for database projects for the...
2017-01-23
6,232 reads
Monday Coffee 2017-01-23
I like to think of myself as a fairly hardworking, motivated person. However I recently met someone who regularly gets...
2017-01-23
313 reads
Notes from the January 2017 oPASS/MagicPASS Meeting
This was a good meeting. About 50 attendees showed up at Nova (we use their space for joint meetings) to...
2017-01-23
377 reads
Power BI Subscriptions
Newly added to the Power BI Service is a much awaited feature called Power BI Subscriptions. If you’ve worked in...
2017-01-23 (first published: 2017-01-17)
2,290 reads
SQL Server 2016: JSON integration
Abstract
This article helps to explain the application of JSON data and the use of new SQL 2016 constructs that enable...
2017-01-23
5,408 reads
Useful #SQLPrompt Tips
One of the tools that Redgate write is SQL Prompt. This might be my favorite product, and I’m constantly impressed...
2017-01-23
710 reads
Using Extended Events Telemetry Session
You are probably wondering what this is, quite honestly I was wondering too. Well it is an extended events session...
2017-01-23
1,926 reads
What Is Your Career Investment Portfolio?
Every year, financial advisors will recommend their clients to take a review of their investment portfolio and make necessary changes...
2017-01-23
733 reads
Blogs
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...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
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