A Study in SQL Server Ad hoc Query Plans
A Study in SQL Server Ad hoc Query Plans
We, (or maybe it’s just my dismissive attitude towards it), often think of ad hoc...
2023-09-23 (first published: 2023-09-22)
375 reads
Mission: SQL Homeostasis
Yet another kind of orphan users in SQL Server
Yet another kind of orphan users in SQL Server
Or YAOU for short. (This silly acronym, I just made it up so don’t try...
2023-09-25 (first published: 2023-09-02)
1,054 reads
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)
188 reads
Remotely Check Disks Space, Find Large Files and Remove Old Files - PowerShell
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
25 reads
Another option is coming to gain extended support for SQL 2012
Another option is coming to gain extended support for SQL 2012
If you still have SQL 2012 servers, you are probably aware that support...
2023-09-04 (first published: 2023-08-17)
270 reads
How to check if powershell is running as administrator with elevated privileges
How to check if powershell is running as administrator with elevated privileges
In case it's not clear from the title, I am referring to...
2023-09-06 (first published: 2023-08-14)
539 reads
Remotely Copy Files To Multiple Destinations Using PowerShell
Remotely Copy Files To Multiple Destinations Using PowerShell
Basic Copy-Item cmdletIf you have used some PowerShell, you are probably familiar with Copy-Item...
2023-08-13 (first published: 2023-08-12)
2,127 reads
Remotely Copy Files To Multiple Destinations Using PowerShell
Remotely Copy Files To Multiple Destinations Using PowerShell
Basic Copy-Item cmdletIf you have used some PowerShell, you are probably familiar with Copy-Item...
2023-08-12
30 reads
A Basic SQL Script to Monitor Long Running SQL Server Agent Jobs
A Basic SQL Script to Monitor Long Running SQL Server Agent Jobs
As a SQL Server DBA, especially Production/Operations DBA in a relatively large environment,...
2023-08-16 (first published: 2023-07-31)
918 reads
Tracking the Inaccurate Cardinality Estimates
Tracking the Inaccurate Cardinality Estimates
When it comes to query performance, lately the Cardinality Estimates seems to have been a hot topic with each new release of SQL...
2023-07-20 (first published: 2023-07-19)
380 reads
Blogs
The Benefits of Teaching
By Brian Kelley
Even preparing for a class or seminar with set materials takes a lot of...
Power BI, Excel, OneLake – Dreams Do Come True!
By DataOnWheels
I can’t believe it’s finally here! A way to have Excel live in OneDrive...
The Book of Redgate: What Our Staff Says
By Steve Jones
This image is from 2010, and it goes along with my last post of...
Forums
Website Stability 2025/12/05
All week we've had issues with the site being up and down. There's been...
403 Forbidden
I created a post (or tried) in the 2022 Admin forum. https://www.sqlservercentral.com/?post_type=topic&p=4694880 But it's...
Question of the Day
Fabric Mirroring
In which versions can I mirror a database from an on-premises SQL Server to a Fabric data warehouse?
See possible answers