Focusing on Business Value
This was a fun talk with David Atkinson at Redgate. We talk satellites, finance, and more. Including some early history of the company. We are talking about how to...
2019-11-14 (first published: 2019-11-08)
238 reads
Blog Posts
Transaction log Information gathering
Here are the different ways to know the tlog file related information sys.dm_db_log_stats – Provide summary of tlog information SELECT * FROM sys.dm_db_log_stats(db_id()) sys.dm_db_log_info -DMV function for VLF information...
2019-11-14
111 reads
What's New in SQL 2019? at BRSSUG
Thanks to everyone who joined the BRSSUG for a night all about SQL Server 2019! We got off into tangents and use cases for Big Data Clusters, columnstore, graph...
2019-11-14
55 reads
Data Lake Architecture using Delta Lake, Databricks and ADLS Gen2 Part 3
This is the third post in a series about modern Data Lake Architecture
where I cover how we can build high quality data lakes using Delta Lake,
Databricks and...
2019-11-13
12 reads
Data Lake Architecture using Delta Lake, Databricks and ADLS Gen2 Part 3
This is the third post in a series about modern Data Lake Architecture
where I cover how we can build high quality data lakes using Delta Lake,
Databricks and...
2019-11-13
92 reads
Did you know we have another SQL Server book coming out?
SQL Server 2017 Administration Inside Out was the first technical book I contributed to, and all its authors were very happy with how it turned out. All the content...
2019-11-13
39 reads
Microsoft Ignite Announcements
Microsoft Ignite has always announced many new products and new product features, and this year was no exception. Many exciting announcements, and below I list the major data platform...
2019-11-13 (first published: 2019-11-06)
719 reads
MS Ignite Day #2 Recap
Day 2 was my opportunity to be focused and dive into a few technologies that were really peaking my interest, namely Azure Synapse Analytics and SQL Server 2019. Since...
2019-11-13 (first published: 2019-11-06)
297 reads
PASS Summit 2019 Takeaways
I attended my 16th PASS Summit this November 6th, 2019 at Seattle. It was a wonderful week of learning and networking. Below are my takeaways for key days. The...
2019-11-13
6 reads
SQLpassion Online Training about Intelligent Query Processing
(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...
2019-11-13
3 reads
Blogs
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Forums
Windows logins for users migrated from DomainA to DomainB
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers