How SQL Server stores data types: XML
This week we’re looking at how the database engine stores the XML data type in SQL Server and Azure SQL Database. If you would like to read about storage of...
2020-09-09
165 reads
Blog Posts
New Microsoft Azure Certifications presentation at BRSSUG
Hi internet!
Thanks to the surprising number of you who joined our first ever virtual meeting of the Baton Rouge .NET and SQL Server User Groups tonight!
I presented on the...
2020-09-09
12 reads
Podcast recording – Mixed Extents 01 – Cloud vs. On-Prem
I’m thrilled to have been part of the second EightKB Mixed Extents podcast recording where Joey D’Antoni, Melody Zacharias, Andrew Pruski, Mark Wilkinson, Anthony Nocentino, and I talked about...
2020-09-09 (first published: 2020-08-28)
215 reads
Resizing Tempdb (When TEMPDB Wont Shrink)
Occasionally, we must resize or realign our Tempdb log file (.ldf) or data files (.mdf or .ndf) due to a growth event that forces the file size out of...
2020-09-09
162 reads
Speaking at SQLSaturday Denmark 2020
I’m delighted to announce I’m speaking at the virtual SQLSaturday Denmark at the 26th of September 2020. I’ll be speaking about the cloud datawarehouse Snowflake and its integration with...
2020-09-09
21 reads
SQLpassion Online Training about SQL Server on VMware
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2020-09-09
80 reads
SQLpassion Online Training about SQL Server on VMware
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2020-09-09
12 reads
Troubleshooting Performance issue like Microsoft Engineers Part 2
In the first PART we talked about the built-in tools in SQL Server management studio and some other custom packages scripts can help us in troubleshooting performance issues, but...
2020-09-09
9 reads
Troubleshooting Performance issue like Microsoft Engineers Part 2
In the first PART we talked about the built-in tools in SQL Server management studio and some other custom packages scripts can help us in troubleshooting performance issues, but...
2020-09-09
35 reads
Troubleshooting Performance issues Like Microsoft Engineers
IF you are a Database administrator and managing SQL Server Database so this article for you, this article is a parent for 3 parts for How to troubleshoot the...
2020-09-09
4 reads
Blogs
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
Forums
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers