Getting list of protocols enabled in a SQL Server instance
protocols enabled in a SQL Server instance
There are number of ways you can find out what protocols are enable in a SQL Server...
2023-09-01 (first published: 2023-08-31)
175 reads
protocols enabled in a SQL Server instance
There are number of ways you can find out what protocols are enable in a SQL Server...
2023-09-01 (first published: 2023-08-31)
175 reads
As I have mentioned in prior blog posts, I have been writing a data architecture book, which I started last November. The title of the book is “Deciphering Data...
2023-09-01
35 reads
Three batch jobs that run all night.Seven for the DBAs to maintain and protect.Nine quick little jobs run by the ... Continue reading
2023-09-01
27 reads
I saw this article on using AI to help that included a few prompts. I decided to try one. This is part of a series of experiments with the...
2023-08-31
867 reads
This is a question that’s come up twice this morning, firstly where can we find a history of database snapshots and secondly where can we find a history of...
2023-08-30 (first published: 2023-08-14)
201 reads
A customer had a question about restoring with standby, so I wrote a quick post to explain how this works. Another post for me that is simple and hopefully...
2023-08-30
24 reads
I’ve been thinking about starting a newsletter for a while now. I want to focus on summaries and what stood out for me from among the many cool talks...
2023-08-30 (first published: 2023-08-14)
164 reads
I’m heading to Chicago today for the Redgate Database DevOps in a Day workshops. This is the first of many on the US tour. I’ll be at 5 of...
2023-08-29
8 reads
Remotely Check Disks Space, Find Large Files and Remove Old Files - PowerShell
For a very important client, I currently manage over 200 SQL...
2023-08-29
17 reads
Lately, I’ve been having to create items in Power BI, that I haven’t had to do for a while, this week it was a Time table. Of course, I...
2023-08-28 (first published: 2023-08-11)
450 reads
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth,...
# Load ImportExcel module Import-Module ImportExcel -ErrorAction Stop # File paths $outFile = "C:\Reports\SQLReport.xlsx"...
Hi we run 2019 standard. Our warehouse's ssis based etl is klunky but so...
Comments posted to this topic are about the item Unlocking High-Concurrency Inserts in SQL...
The new Vector datatype in SQL Server 2025 is a binary type that has a few parameters. What parameters are required?
See possible answers