Audit Index Changes
This article shows a method to audit for index changes. The weak link in a solution such as this really boils down to the requirement that the solution needs...
2019-12-26
21 reads
Blog Posts
Azure Synapse Analytics & Power BI performance
With two new relational database features (Result-set caching and Materialized Views) just GA’d in Azure Synapse Analytics (formally called Azure SQL Data Warehouse), it makes for some very compelling reporting...
2019-12-26 (first published: 2019-12-12)
3,403 reads
Reflection on Talking at SQLSaturday Charlotte About Mental Health
On December 7, I did a session on mental illness and mental health problems being more common in IT than you think. Before the event the PASS WIT Virtual...
2019-12-26 (first published: 2019-12-11)
247 reads
Find Index Create Date
This article shows a quick script to help determine indexes that were created recently. This script will help you out of rough spot and help reduce the chance of...
2019-12-25
407 reads
Find Index Create Date
This article shows a quick script to help determine indexes that were created recently. This script will help you out of rough spot and help reduce the chance of...
2019-12-25
13 reads
Temporal Tables, and how to deal with computed columns
Long time readers will know I’m a big fan of Temporal Tables since their introduction in SQL Server 2016. Thanks to my friend Erik Darling (blog | Twitter), I...
2019-12-25
327 reads
A Quick Look at Travel
I was experimenting with visualizations the other day, and started playing with SandDance, a tool from Microsoft that you can use in Power BI or Azure Data Studio. I’ll...
2019-12-24 (first published: 2019-12-02)
299 reads
2019-12-24
26 reads
T-SQL Tuesday #121: Gifts received for this year
It’s T-SQL Tuesday time again! This edition is hosted by Malathi (blog|twitter) and the subject is looking back at the past year. So what do I have to be...
2019-12-24 (first published: 2019-12-10)
252 reads
A gift. T-SQL Tuesday #121
My good friend Malathi Mahadevan (blog|twitter) is hosting T-SQL Tuesday this month and wants us to talk about Gifts received ... Continue reading
2019-12-23 (first published: 2019-12-10)
297 reads
Blogs
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Keeping Track of my ConEmu CLIs
By Steve Jones
I use ConEmu for my terminal interface. I’m still on Windows 10 at home,...
10 Decisions to Make Before You Create A Fabric Workspace
Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...
Forums
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Hyperscale Replicas III
Comments posted to this topic are about the item Hyperscale Replicas III
Development Is Fun
Comments posted to this topic are about the item Development Is Fun
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers