Sysinternals – A Swiss Army Knife for IT Pros

I’m at the Techno Security and Digital Forensics conference in Myrtle Beach again this year. I sat in on a presentation about performing malware analysis. The analyst began with...

To use ALTER DATABASE, the database must be in a writable state in which a checkpoint can be executed. – when moving files on an Availability Group secondary.

Here’s a little error that I stumbled across the other day when trying to migrate the data files of an Availability Group secondary node onto a nice new SAN....

Actual Emails: Will MSOLEDB work for connecting to an Availability Group?

Scenario:
We need to configure an existing legacy application from an external vendor to talk to our new SQL Server 2017 Availability Group, which spans multiple subnets. In the end,...

Free Webinar: Driven by the 9s

Driven by the 9s - A free Webinar to help you learn how to combine SQL availability features to deliver a highly available Microsoft Data Platform

Sign Up Here

Microsoft’s data...

Implicit Conversion Insights with XE

Seldom does a DBA have the opportunity to get out in front of infrequent or random errors such as implicit conversions. More often than not, it is the privilege...

Implicit Conversion Insights with XE

Seldom does a DBA have the opportunity to get out in front of infrequent or random errors such as implicit conversions. More often than not, it is the privilege...

Information Measurement with SQL Server Part 4.5: The Squared L2 Family of Distances

By Steve Bolton …………In the last two installments of this series of amateur self-tutorials (apart from the Fisher Information article, which I deliberately published out of order), I introduced...

Microsoft SQL Server Migration plan and steps

Migration is nothing but moving a databases from...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Pathways to Progress

One of the most significant and hardest challenges we face as data professionals (or generally anyone in IT) is how to keep up with learning. Most of us are...

“Ups…I have deleted some data. Can you put it back?” – dbatools for the rescue

Few days ago I received a request to restore a dozen of tables because someone have deleted more data than it was supposed. I immediately thought about dbatools for...