Stop Worrying About Index Fragmentation and Manage Your Statistics
I see a lot of posts online about rebuilding indexes in a scheduled maintenance task, this is a pretty intensive...
2018-02-25
83 reads
Blog Posts
Guide for Set Up of Telegraf for Monitoring SQL Server xPlat
Problem
We need a way to collect performance metrics for all our SQL Servers (Windows and Linux) into one system and...
2018-02-24
4,817 reads
If your Surface Book loses it’s keyboard and trackpad – try removing KB4074588 update
My Surface Book (gen 1) recently did updates and then a day or so later the keyboard and trackpad mysteriously...
2018-02-24
455 reads
Hobbies, stress relief, and meeting management: T-SQL Tuesday #99
It’s T-SQL Tuesday again! And in fact it’s the 99th one! Given that T-SQL Tuesday runs once a month that...
2018-02-23 (first published: 2018-02-13)
2,010 reads
How I Used Pragmatic Works Training to Pass the Power BI 70-778 Certification
Recently I took and passed the Microsoft certification exam 70-778 for Power BI called Analyzing and Visualizing Data with Microsoft...
2018-02-23 (first published: 2018-02-12)
2,351 reads
SQL Server 2017 in a Docker Container running on a Mac – Tips and Tricks
I started using a MacBook Pro at work, and the very first thing I did was configure SQL Server 2017 running on a docker container, and run it locally...
2018-02-23
10 reads
SQL Server 2017 in a Docker Container running on a Mac – Tips and Tricks
I started using a MacBook Pro at work, and the very first thing I did was configure SQL Server 2017...
2018-02-23
529 reads
SQLCLR vs. SQL Server 2012 & 2014 & 2016, Part 7: “CLR strict security” – The Problem Continues … in the Past (Wait, What?!?)
If the new “CLR strict security” Server-level configuration option in SQL Server 2017 hasn’t caused enough confusion and pain, then,...
2018-02-23
1,396 reads
Using YouTube Captions & Transcript to Find Content in a Long Video
This week, I was pretty pumped to see that PASS published Erin Stellato (twitter) and Dejan Krakovic’s (linked in) excellent session on Query Store to the public. I attended...
2018-02-23
8 reads
Activate Conference 2018: Presentation info
A special hello if you're visiting this blog post during or after my workshops on Thursday afternoon, February 22 at...
2018-02-22
317 reads
Blogs
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
Forums
Backup Availability Group
Please I am hoping for some feedback Specifications: Windows Server 2022 SQL Server 2022...
How Do the Experts Become Experts?
Comments posted to this topic are about the item How Do the Experts Become...
Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
Question of the Day
Secure Communications
As of June 2026, what is the best version of TLS to use with SQL Server?
See possible answers