Finding Next Business Day in T-SQL
Let’s say you have a table that records transactions along with the date of when the transaction took place. Wait,...
2015-09-22
5,204 reads
Blog Posts
Finding the worst running query in a stored procedure
The other day I was asked to tune a stored procedure. Not exactly an uncommon task, but I worked something...
2015-09-22 (first published: 2015-09-10)
4,841 reads
Heading To PASS Summit 2015 – Now What?
You’ve heard about it for some time now, and you finally got the gumption to ask your boss if the...
2015-09-22
542 reads
Heading To PASS Summit 2015 – Now What?
You’ve heard about it for some time now, and you finally got the gumption to ask your boss if the...
2015-09-22
330 reads
Improving Networking at PASS Events–Part 1
This week I’m spending some drive time thinking about how we might improve networking at SQLSaturday and that led to...
2015-09-22 (first published: 2015-09-10)
1,164 reads
Most Read: My Top 5 SQL Server Articles and Blogs
There has been some really useful blogs and articles posted over the last week or so, this is my top...
2015-09-22
531 reads
Populating My DBA Database for Power Bi with PowerShell – Databases
Following my post about using Power Bi with my DBA Database I have been asked if I would share the...
2015-09-22
864 reads
Power BI Custom Visuals Contest Round-up
It's really exciting to see the first round of entries into the Power BI Best Visuals Contest, which has been...
2015-09-22
848 reads
Power BI Custom Visuals Contest Round-up
It's really exciting to see the first round of entries into the Power BI Best Visuals Contest, which has been...
2015-09-22
405 reads
Repairing a replication subscriber
It’s a question which has come up a couple of times. If a subscriber of a transactional replication publication becomes...
2015-09-22
1,138 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