(This post comes from one of our Junior DBAs – @SQLDork) I’m learning how to use dbatools. Today’s command: Backup-DbaDatabase I’m using the 64-bit PowerShell ISE (running as administrator),...
2021-04-26 (first published: 2020-04-27)
550 reads
In my last post I showed some shortcomings of Extended Events, however, it is possible to use Live Data with Azure. Let’s explore exactly how that works. To get...
2021-04-26
37 reads
I’ll admit it, sometimes I’m wrong. Recently I blogged about the usefulness of a newer feature that was enhanced with the release of SQL Server 2019. Resumable Indexes operations...
2021-04-23 (first published: 2020-01-17)
1,318 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-04-23
17 reads
I hosted the blog party this month, with the invite to write about notebooks. These are a neat technology, and I’ve written about them at SQLServerCentral. This post is...
2021-04-23
37 reads
When I launched The Noncluttered Index last year, it was with the intention of writing at least twice a week. For a while, that was very doable. Then, work...
2021-04-23 (first published: 2020-01-14)
619 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-04-22
24 reads
Knowledge of how your system behaves is vital to better control, maintain, and grow the system. While Azure provides all sorts of wonderful assistance within Azure SQL Database, you’re...
2021-04-22 (first published: 2021-04-19)
214 reads
The other day I got a note from Ben Weissman the other day that he was running a new event, http://dativerse.io/. Not much information, but I liked this list...
2021-04-22 (first published: 2021-04-19)
184 reads
One of the technical books that sit on my work desk (or dining table, whichever is the case because I work from home full time now) at arm’s length...
2021-04-21 (first published: 2021-04-15)
431 reads
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Comments posted to this topic are about the item Checking the Error Log II
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Comments posted to this topic are about the item Designing for Teams
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers