SQL Tact

SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press.  This book is far more than a quick update. W...

One of the few good, safe uses for the local SSD volume of an Azure VM is for SQL Server tempdb data and log files.  Note: this blog post ha...

If you've tried doing Backup to URL with SQL Server using a Shared Access Signature (SAS) certificate and received this error: Error...

SQL Server 2019 Administration Inside Out Honored again to be leading the talented SQL Server 2019 Administration Inside Out author team...

Scenario: We need to configure an existing legacy application from an external vendor to talk to our new SQL Server 2017 Availability Gr...

We get requests to move data between custom systems regularly, even within systems. I was advising a client on something fairly simple — a c...

It starts with "I'm a developer... "... with no RDP access, how can I tell if the SQL Server Agent service is running?"...

Awesome crowd this morning for my SQL Admin Best Practices with DMV's presentation at Houston TechFest 2014 , thanks very much for atten...

Microsoft SQL Server is a mature and broad technology platform that supports a diverse set of careers - this blog post is an attempt to prov...

I've been going back and forth with this question for a few days now. If one instance in a multiserver query presents an error, no res...

I recently had the challenge of migrating an installation of Microsoft Team Foundation Server 2010 from a shared SQL Server 2008 R2 Enterpri...

There's an issue with some characters in T-SQL when validating numeric values out of raw varchar fields, and it can be easily solved wi...

One of my favorite groups to speak for (aside from the Baton Rouge SQL Server User Group) is the Hammond .NET User Group at Southeastern Lou...

We had a cooperative relational database design exercise at the office last week as part of our regular department "Lunch and Learn...

Right next to my batarang and bat-zip-line-hook-shooter-gun on my utility belt is my SQL Server DBA Tool Kit, full of scripts I've picke...

Check out this link for a feature story on SQL Saturday Baton Rouge from local radio station WRKF: http://www.wrkf.org/batonrouge&news...

Here's the link to the Lightning Round presentation I made to the Baton Rouge IT Professionals User Group on August 31.  The end was a ...

Had to set up back up a SQL Express 2005 database.  Why some vendors insist on creating software dependent on SQL Express, and then not givi...

I've do a lot of DB Pro solutions and DBA code reviews at my office and on client sites. This free sidekick add-on for Visual Studio has...

One of my assignments as a consultant DBA for a local Fortune 500 company is to support development of a large project. I was in a meeting ...