Audit Database Offline Events
Knowing when an event occurred within the database environment is a very important thing. Being able to act quickly when certain events occur is equally as important. Sometimes, we...
2018-11-13
6 reads
Blog Posts
Bert & Pinal Troubleshoot a Slow Performing SQL Server
What happens when you run into performance tuning expert Pinal Dave? Talk about how to troubleshoot a slow performing SQL...
2018-11-13
345 reads
Bert & Pinal Troubleshoot a Slow Performing SQL Server
Watch this week's video on YouTube
What happens when you run into performance tuning expert Pinal Dave? Talk about how to troubleshoot a slow performing SQL Server of course!
This week...
2018-11-13
3 reads
Bert & Pinal Troubleshoot a Slow Performing SQL Server
Watch this week's video on YouTube
What happens when you run into performance tuning expert Pinal Dave? Talk about how to troubleshoot a slow performing SQL Server of course!
This week...
2018-11-13
4 reads
Deploying SQL Server Availability Groups in Kubernetes
In this blog post, we’re going to work on deploying a SQL Server Availability Group in a Kubernetes Cluster in on-premises virtual machines. I’m going to walk you through...
2018-11-13
9 reads
Deploying SQL Server Availability Groups in Kubernetes
In this blog post, we’re going to work on deploying a SQL Server Availability Group in a Kubernetes Cluster in...
2018-11-13
1,938 reads
Drive space check SQL server steps and scripts
AdvertisementsFollowing is the script used for drive space related issues.
--SQL 2000
-- select name,(size/128.0) as size_mb,* from master.dbo.sysaltfiles order by size_mb...
2018-11-13
637 reads
How Much Will Compression Really Gain Me?
Did you know compression can gain you more than just space on a disk, it can allow you to fit...
2018-11-13 (first published: 2018-10-31)
2,606 reads
Steps to Create an In-Memory table for SQL Server
Creating a table to be in memory compared to standard tables that use the files on disk can have several...
2018-11-13 (first published: 2018-10-31)
7,701 reads
T-shaped knowledge and learning about the cloud: T-SQL Tuesday #108
Upper management at my company has started asking for something called T-Shaped knowledge. The idea is that we have a...
2018-11-13
226 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
Optimism Without Illusion or Why AI Needs Blunt Technologists
Comments posted to this topic are about the item Optimism Without Illusion or Why...
SSIS with VS2022 64/32 issue with Excel files
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Case part is sloooooow
Hi So the case statement is slowing this down - but for the life...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers