How to Use xp_delete_file to Purge Old Backup Files
Continuing on my recent trend of using undocumented stored procedures, this week I thought we can cover using xp_delete_file to...
2012-11-21
4,467 reads
Lost in Translation – Deprecated System Tables – syspermissions
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-21
1,110 reads
Final 2012 Learning Opportunity
There’s still a little time left in the year. I know some businesses have allocated training budgets and if they...
2012-11-21
1,116 reads
Top 3 Books on Writing Transact-SQL (TSQL)
This weeks blog posts have been focusing on books that I have read, like and recommend for learning SQL Server...
2012-11-21
967 reads
blogging fun: dealing with spammers like Psychz Networks
@PsychzNetworks is spamming me non-stop. Every minute of every day.
I googled them and it seems Psychz Networks are famous for...
2012-11-21
1,514 reads
PASS Summit 2012 Recordings Available
Did you attend PASS Summit and miss out on some sessions because there were so many or you were busy...
2012-11-21
1,256 reads
CTEs beyond SELECT
The other day I was writing a query to pull some DMV information and I ended up using several CTEs...
2012-11-20
1,993 reads
Explore file physical structure - Insert Row - Part 2
1. Create sample db
use master
go
CREATE DATABASE [test] ON PRIMARY
( NAME = N'test', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master\test.mdf' , SIZE = 3072KB , FILEGROWTH = 1024KB...
2012-11-20
653 reads
SQL Server 2012 Service Pack 1 CU1 is Available
Microsoft has released SQL Server 2012 Service Pack 1 Cumulative Update 1, which is Build 11.0.3321. I count 44 fixes...
2012-11-20
1,466 reads
Explore file physical structure - Insert Row - part 1
1. Create sample db
use master
go
CREATE DATABASE [test] ON PRIMARY
( NAME = N'test', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master\test.mdf' , SIZE = 3072KB , FILEGROWTH = 1024KB...
2012-11-20
685 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Forums
It's Never Just One Thing
Comments posted to this topic are about the item It's Never Just One Thing
Calculating Min-Max Normalization in PowerBI
Comments posted to this topic are about the item Calculating Min-Max Normalization in PowerBI
Checking the Error Log III
Comments posted to this topic are about the item Checking the Error Log III
Question of the Day
Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers