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
56 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
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
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
406 reads
2019-12-24
24 reads
Fritchey Family Christmas Movies
MERRY CHRISTMAS! HAPPY YULETIDE! HAPPY HANUKKUH! Instead of something technical, let’s take a moment to just kick back and enjoy a few great Christmas movies. Now, let’s be clear....
2019-12-23
22 reads
Backwards Compatible Symmetric Keys in SQL Server 2017+
I discovered recently that there was a change made in SQL Server 2017 to the way that symmetric key passphrases are hashed. There’s a KB article that notes the...
2020-01-06 (first published: 2019-12-23)
412 reads
Last Week Reading (2019-12-22)
Hello. It’s been a while since the last post of this series appeared. I will do my best to keep this going. So, without unnecessary introductions – let’s move...
2019-12-22
10 reads
Last Week Reading (2019-12-22)
Hello. It’s been a while since the last post of this series appeared. I will do my best to keep this going. So, without unnecessary introductions – let’s move...
2019-12-22
16 reads
Using the JOIN Function in Reporting Services
The JOIN() function in SQL Server Reporting Services is a handy tool that allows you to turn a list into a delimited string value. This function accepts two parameters,...
2019-12-22
15 reads
Blogs
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Forums
Moving Beyond the Reboot: Finding the Culprit Behind Memory Pressure
Comments posted to this topic are about the item Moving Beyond the Reboot: Finding...
Reserved Words I
Comments posted to this topic are about the item Reserved Words I