Downtime
I was speaking at a conference recently and when I bumped into a friend, the first thing she said to...
2018-07-16
242 reads
Blog Posts
Quickly Change SQL Job Owners
It is not unusual to find a server where some random user created a bunch of jobs to be run by SQL Agent. Sometimes, the user creating the job(s)...
2018-07-16
12 reads
SQL Agent for Azure SQL Database? Not quite
The following post shows my preferred way to automate / schedule some code against my Azure SQL Database. No it is...
2018-07-16 (first published: 2018-07-09)
2,394 reads
SQL Saturday Louisville–Bout That Time
SQL Saturday Louisville is less than a week away!! A lot of hard work has gone into putting on this...
2018-07-16
172 reads
Understanding Data Sharing in SQL Server Docker Containers
This article talks about shared volumes and the preferred mechanism for data persistence using the Docker containers. This article covers...
2018-07-16
552 reads
What Is The Preferred Join Operator in SQL Server?
I schedule many of my blog posts at least 2-3 weeks out, so I have time to adjust them, change,...
2018-07-16 (first published: 2018-07-09)
3,806 reads
Install SQL via Windows Command Line
I have been on a mission to find easier ways to install SQL Server. I have recently been working on...
2018-07-13
2,006 reads
SQL Homework – July 2018 – Create a SQL Agent Job
For this month’s homework let’s try something a bit different. SQL Agent jobs are a very powerful tool frequently used...
2018-07-13 (first published: 2018-07-02)
2,012 reads
Testing BackBlaze Restores
The most important thing for a data guy is having a way to restore data. If security, performance, etc. are...
2018-07-13 (first published: 2018-07-05)
2,319 reads
Back to #SQLSat Louisville
Next week is SQL Saturday #729 – Lousiville and I’m making the trip. This will be my third or fourth trip...
2018-07-12
411 reads
Blogs
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...
T-SQL Tuesday #199: Roundup
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
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