T-SQL Tuesday #38 Recap
This is the wrap up for TSQL Tuesday #38. We had a good turnout this month with some new faces...
2013-01-15
1,002 reads
SQL Server – Enabling backup CHECKSUM with Trace Flag 3023
You can use WITH CHECKSUM option to perform checksum when backup is created. When used this verifies each page for...
2013-01-15
2,367 reads
Ragged Flat File Processing in SSIS
Frequently I am asked how to properly use SQL Server Integration Services to handle ragged flat files, an example of...
2013-01-15
2,195 reads
Day 13 of 31 Days of Disaster Recovery: Standard Backup Scripts
31 Days of Disaster Recovery
Today’s post took longer to prepare than I had anticipated which is why day 13...
2013-01-15
1,463 reads
The server principal “xxxx” is not able to access the database “msdb” under the current security context.
Problem :
Yesterday Night, One of my team member called & report that some users are getting below error no. 1 while...
2013-01-15
34,387 reads
Full-Text Search – Word Breakers and Stemmers
There are numerous components to the Full-Text Search (FTS) subsystem in SQL Server that help provide efficient, relative answers to...
2013-01-14
4,512 reads
Find the (available) amount of memory available to SQL Server (instance / machine)
From time to time, I see the following question posted on various SQL forums asking how we can determine the...
2013-01-14
4,395 reads
New Year Aspirations
Every year millions of people around the world decide to make new years resolutions. In these resolutions they promise themselves...
2013-01-14
672 reads
SQL Server Performance Tuning with Free Tools!
The following is a recording of my Performance Tuning for Pirates session recorded by UserGroup.TV at SQL Saturday 125 in...
2013-01-14
941 reads
Last Weeks Top 10 “Reading” Links #15
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2013-01-14
584 reads
Blogs
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
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...
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