Ola Hallengren’s solution on a network share using FTP
I use the Ola Hallengren’s maintenance solution for my SQL Servers instances. It happened to run the maintenance solution so that...
2016-03-31
1,007 reads
Blog Posts
The ‘In Recovery’ Mystery
Last week I received an email from one of our sysadmins asking why one of our databases kept showing as...
2016-03-31 (first published: 2016-03-22)
1,660 reads
Multiple Tagging of TFS Work Items Using Excel
In my article, TFS tools for managing SQL Server development, I covered several Team Foundation Server (TFS) client tools that can...
2016-03-30
1,019 reads
SQL Server 2016 Azure Virtual Machines
With the release candidates coming thick and fast for SQL Server 2016 downloading, uninstalling the previous version and installing the...
2016-03-30
1,399 reads
SQL Server Service Broker – Introduction
SQL Server Service Broker is a messaging technology that’s baked right into the SQL Server engine. It was first introduced...
2016-03-30 (first published: 2016-03-22)
2,300 reads
When should I test?
To test or not to test. That is the question. Or is it? Shouldn’t we always test? That was the...
2016-03-30
794 reads
Certain DBs in an AG not Backing Up
Last week, I received an alert that the percentage of transaction log in use on one of our production databases...
2016-03-29
997 reads
Do You Teach Azure Data Platform?
I offer instruction on the Azure Data Platform, and have for about six years, since shortly after it came out....
2016-03-29
823 reads
ETL Auditing
It happens far too often: Once an ETL process has been tested and executes successfully, there are no further checks...
2016-03-29 (first published: 2016-03-22)
2,294 reads
File Growths
I hinted at file growths in my previous posts about shrinking data and log files. Then I talked about growing log files in my post Database Log VLFs. However,...
2016-03-29
33 reads
Blogs
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Forums
Understanding Temp Tables and Table Variables in SQL Server
Comments posted to this topic are about the item Understanding Temp Tables and Table...
The Data API Builder MCP Server Tools
Comments posted to this topic are about the item The Data API Builder MCP...
Collecting Data Is Hard
Comments posted to this topic are about the item Collecting Data Is Hard
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers