Resetting an Azure SQL Database Admin Password
This is likely something that most people know, but it was a bit confusing for me. This post is really here to remind me and help cement this in...
2019-12-18 (first published: 2019-12-05)
2,981 reads
What's New In SQL 2019? at the Little Rock, AR SQL Server User Group
Thanks to everyone who joined the Little Rock SQL Server User Group for a night all about SQL Server 2019! We got off into tangents and use cases for...
2019-12-05
9 reads
My latest presentations
Just wanted to make everyone aware of my latest presentations that I recently uploaded. Details below. I also have a list of all my presentations with slide decks here. Azure...
2019-12-04
55 reads
PASS HA/DR Open Q&A Extravaganza Dec 10
As leader of the PASS High Availability and Disaster Recovery virtual chapter, I invite you to bring your questions for a mega open Q&A session on Tuesday, December 10th,...
2019-12-04
57 reads
The XML data type is not immutable
Immutability In many programming languages, strings of text are immutable, meaning they don’t change. When you modify a string, a new string is created in memory by copying the...
2019-12-04
122 reads
Introduction to the performance features on SQL Server on Linux
I’ve been tinkering with SQL Server on Linux lately and noted a few things in regards to performance I thought I would share with you. SQL Server 2019 on...
2019-12-04
312 reads
Better, faster, cheaper: SQL Server on Azure IaaS
GigaOm, an independent research firm that I highly respect, released a study today comparing performance and price between a SQL Server VM on Microsoft’s Azure platform and a SQL...
2019-12-19 (first published: 2019-12-04)
748 reads
Troubleshooting Resource Semaphore and Memory Grants
Memory grants, now here’s a fun thing that can pretty much take your SQL Server to its knees. The Symptoms The first thing that you’re going to notice is...
2019-12-03
311 reads
T-SQL Tuesday #121: Gifts received for this year
It is December again. 2019 has gone by in a flash. I have the honor of hosting the last TSQL Tuesday blog party of the year. This monthly blog...
2019-12-03
12 reads
Azure SQL vs Azure Table Storage
Watch this week's video on YouTube
A year ago I built an app to keep track of pickup volleyball game scores and payments. It works well, but after a year...
2019-12-03
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