Speaking at SQLBits
I got an early Christmas present this year, I found out I had been selected to speak at SQLBits! That’s...
2019-01-04
146 reads
Blog Posts
Year in Review 2018 – The Year of Making a Difference – Up to 50
Rough Year, But 50 Kids, Can’t Beat That!
Last year was a pretty rough year personally. I totaled two cars, not...
2019-01-04
152 reads
Automating CRUD procedures generation using T-SQL (enhanced).
In this post I will describe the helper procedure that based on metadata generates numerous database objects around views and...
2019-01-03
388 reads
Changing the Collation of the Instance, the Databases, and All Columns in All User Databases: What Could Possibly Go Wrong?
Demystifying What “sqlservr -q” Actually Does
(last updated: 2019-01-07 @ 02:25 EST / 2019-01-07 @ 07:45 UTC )
For various reasons, people sometimes find themselves...
2019-01-03 (first published: 2018-06-12)
8,750 reads
Event Tracing for Windows Target
There are many useful targets within SQL Server's Extended Events. Of all of the targets, the most daunting is probably the Event Tracing for Windows (ETW) target. The ETW...
2019-01-03
15 reads
Event Tracing for Windows Target
There are many useful targets within SQL Server’s Extended Events. Of all of the targets, the most daunting is probably...
2019-01-03
1,352 reads
File Maintenance – Cleaning Up Old Files
Using SSIS to Maintain the File System
We have all run into a need or a desire to clean up old...
2019-01-03 (first published: 2018-12-21)
2,881 reads
Forecasting Kyle Kuzma’s Field Goal Percentage (FG%)
More and more tools are becoming available for data analysts and data scientists. These tools provide convenience and lower the bar...
2019-01-03 (first published: 2018-12-22)
2,447 reads
Let’s talk SQL Server Waits: Topic 1 – SOS_SCHEDULER_YIELD
Over the next few weeks we will be reviewing some of the common SQL Server Waits. We will explain what...
2019-01-03
1,561 reads
Query Store max size limit is not a hard limit
If you’re on SQL Server 2016 or above, maybe you’re thinking about using the Query Store. That’s good! It’s an...
2019-01-03
1,601 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
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...
Forums
Midjourney, Healthcare?
Comments posted to this topic are about the item Midjourney, Healthcare?
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
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers