Tables, Columns and Defaults Oh My!
The joys of inheriting a new database and being thrown into the fire to quickly assimilate as much information about the database as possible can be troublesome. This script...
2015-08-19
7 reads
Tables, Columns and Defaults Oh My!
Picture this if you could. You inherit a new database either through the change of a job, or finding a...
2015-08-31 (first published: 2015-08-19)
2,021 reads
Power BI Tip: Use a Scatter Chart to Create a Calendar Report
The Scatter Chart in Power BI and Excel is very useful chart for visualizing three different metrics in tandem. But...
2015-08-28 (first published: 2015-08-19)
3,542 reads
Time to Change
I recently spent two days consulting with a company on their database development and deployment processes. They are a small, capable, team...
2015-08-19
756 reads
Getting Started With Power BI Desktop: Getting Data
Now that the Power BI Desktop is installed, let’s get some data. As of this writing, Power BI can get...
2015-09-01 (first published: 2015-08-19)
2,647 reads
SSMS’s Clipboard Manager
The other day Richie Rump (b/t) mentioned something called a clipboard manager on twitter. I’ll admit I had to ask...
2015-08-28 (first published: 2015-08-19)
2,823 reads
Live Query Statistics
The objective of this post is to introduce the new feature in SQL Server 2016 called Live Query Statistics. This option...
2015-08-27 (first published: 2015-08-19)
2,730 reads
Why You Should Care About Microsoft APS and Azure SQL Data Warehouse
Last week, I gave a presentation about SQL Server’s data warehouse capabilities, and specifically about APS (Analytics Platform System) and...
2015-08-19
1,138 reads
I don't use the Visual Studio SSDT Publish
I see questions pretty regularly on stack overflow and the ssdt msdn forum that is some variation on "I am...
2015-08-19
879 reads
I dont use the Visual Studio SSDT Publish
I see questions pretty regularly on stack overflow and the ssdt msdn forum that is some variation on “I am...
2015-08-19
45 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Forums
It's Never Just One Thing
Comments posted to this topic are about the item It's Never Just One Thing
Calculating Min-Max Normalization in PowerBI
Comments posted to this topic are about the item Calculating Min-Max Normalization in PowerBI
Checking the Error Log III
Comments posted to this topic are about the item Checking the Error Log III
Question of the Day
Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers