sql server scripts and managing databases
Managing a large SQL Server inventory requires an efficient management processes.
Following on from DBA productivity and less is more , this...
2012-03-01
1,296 reads
Blog Posts
A Script A Day - Day 25 - Performance Counters
Today’s script is based on performance counters and in particular the sys.dm_performance_counters DMV. There are many ways in which to...
2012-02-29
2,313 reads
A Script A Day - Day 26 - RESTART a Database Restore
Today’s script is another one based on database restores. There is a little known clause of the RESTORE DATABASE command...
2012-02-29
2,849 reads
A Script A Day - Day 27 - Missing Database Backups
Today’s script is one I have used many times in the past to check for missing backups. The script will...
2012-02-29
3,480 reads
AdventureWorks in SQL Server 2012 RC0
The sample databases for SQL Server 2012 haven’t been completely finalized, but I was able to find the latest version...
2012-02-29
1,933 reads
Azure is Down
I saw a note about an outage on Windows Azure, apparently one that’s been going on for seven hours. Once...
2012-02-29
1,745 reads
Download free eBook for SQL Server 2012
Microsoft has released one more free eBook, this time it is on SQL Server 2012. However, this is the second...
2012-02-29
3,560 reads
MERGE with OUTPUT clause
A few days back I was presented with a theoretical challenge, and now I thought I would share my solution...
2012-02-29 (first published: 2012-02-21)
9,068 reads
PASS SQLRally Dallas 2012 Pre-Con: How to Perform a SQL Server Health Check
If you are attending the PASS SQLRally this May in Dallas, I will be presenting a one day preconference session...
2012-02-29
2,516 reads
Script SQL Server Agent Jobs Using PowerShell
It’s that time of the month again, no not that one, it’s T-SQL Tuesday time and this weeks topic is...
2012-02-29
4,743 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