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,001 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,361 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,191 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,457 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,376 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,511 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,381 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
669 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
935 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
583 reads
Blogs
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...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers