Announcing SQL Saturday Chicago Precon Training Session
Heraflux is proud to announce that I am teaching a preconference training session at this year’s upcoming SQL Saturday in Chicago....
2017-01-04
357 reads
Blog Posts
Comparing plan consistency and query performance using the Query Store Replay script
The 1.2 version of the Query Store Replay script a number of new features are added that return information of...
2017-01-04 (first published: 2016-12-30)
2,019 reads
Create quick queries quickly with SSAS in Azure
In a perfect world a data warehouse would always return all queries very quickly, no matter what the size or...
2017-01-04
286 reads
Finding Automatic Soft-NUMA
If you already know about Automatic Soft-NUMA in SQL Server 2016, then you probably already read the blog post SQL...
2017-01-04 (first published: 2016-12-30)
2,243 reads
Quick Prompt Tips–Custom Procedure Templates
One of the things that I often do is create stored procedures. The syntax for doing so is simple, but...
2017-01-04
513 reads
When was SQL Server installed?
In this blog post. Let us learn about how to retrieve date and time when the SQL Server was installed. To retrieve...
2017-01-04
13,837 reads
Be Careful of Your Create Stored Procedure Batch
I was rehearsing a demo with someone recently and we had some stored procedure code that looked like this:
CREATE PROCEDURE...
2017-01-03
3,768 reads
Books of 2016
I set myself a reading goal of 75 books for last year, and managed 73. I’m not overly happy about that, there were months where I barely managed to...
2017-01-03
7 reads
Books of 2016
I set myself a reading goal of 75 books for last year, and managed 73. I’m not overly happy about...
2017-01-03
505 reads
Books of 2016
I set myself a reading goal of 75 books for last year, and managed 73. I’m not overly happy about...
2017-01-03
166 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