The Data Platform has expanded – so too should our approach in using it….
In recent years we as data professionals have moved from dealing with SQL Server databases with SQL Server Reporting Server...
2018-02-26
491 reads
Blog Posts
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
81 reads
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,787 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
449 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,009 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,389 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
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Identities and Sequences III
Comments posted to this topic are about the item Identities and Sequences III
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers