Prepping for Certification, Part 1 of ?
I thought it would be good to put my thoughts down on how to prepare for a certification. I don't know how many posts I will make on this,...
2025-09-26 (first published: 2025-09-04)
474 reads
I thought it would be good to put my thoughts down on how to prepare for a certification. I don't know how many posts I will make on this,...
2025-09-26 (first published: 2025-09-04)
474 reads
Today's reality is that cybercriminals are increasingly using AI to develop better attacks. This is just the latest reported technique, probably because it's starting to be used more often....
2025-09-12 (first published: 2025-08-21)
225 reads
If you're not having success in convincing your organization to send you to this year's PASS Data Community Summit, you could win a 3-day registration by submitting some basic...
2025-08-29 (first published: 2025-08-12)
132 reads
I refresh my test SQL Servers at least monthly with a fresh VM. Setting up directories, installing SQL Server, setting up security, and restoring databases all take time. And...
2025-08-28
49 reads
For those testing SQL Server 2025 before it officially releases, Microsoft has made the first release candidate available. There's a lengthy article on all the new features that are...
2025-08-26
54 reads
How long has AI been around in different domains? What was it called before we starting using the phrase, "Artificial Intelligence?" Is Clippy included in said history? Here is...
2025-08-22 (first published: 2025-08-05)
495 reads
If you are responsible for securing databases, SQL Servers and others, I would strongly urge you to read the following post by Andreas Wolter, former data security PM for...
2025-08-18 (first published: 2025-07-30)
505 reads
There are always bad actors who will seek to get access to and, likely, exfiltrate (exfil) the data. But they don't want to get caught; they don't want to...
2025-08-11
8 reads
On August 6, 2025, Microsoft announced a vulnerability with hybrid deployments because of a shared service principal between the Exchange on-premises deployment and Exchange Online. The vulnerability is found...
2025-08-07
34 reads
Back in June I blogged about pig butchering and the amount of reported losses we're seeing here in the United States of America. This type of cyber scam is...
2025-08-06
16 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