The curious case of CHAR(0)

Over the years I’ve seen quite a few strange things with SQL Server. This one may not have been the ... Continue reading

Create a PowerShell Notebook for Azure Data Studio with PowerShell

The latest update to the ADSNotebook PowerShell module I blogged about here now enables the creation of PowerShell notebooks with PowerShell. You can install the module with or if...

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...

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...

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...

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...

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...

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...

Event Notifications Example

Event notifications are kinda like a trigger in the sense that they respond to specific event, specifically in response to DDL statements and SQL Trace events.

The major difference between...

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...