First things first–if you are reading this, and not regularly running consistency checks on your SQL Server databases, you should drop everything you are doing and go do that. What do I mean by regularly? In my opinion, based on years of experience, you should run DBCC CHECKDB at least as frequently as you take […]
Tag: sql server
I need to blog more. Stupid being busy. Anyway, last week, we were doing a small scale test for a customer, and it didn’t work the way we were expecting, and for one of the dumbest reasons I’ve ever seen. If you aren’t familiar with Azure Site Recovery it provides disk level replication for VMs, […]
It’s security week here at DCAC (you can join us on Friday January 19th, 2018 at 2PM in a webcast to talk more about security) and I wanted to focus on patches. I wrote a couple of weeks ago about the impact of Spectre and Meltdown to SQL Server (and just about every other thing […]
Scripts to come.. Script file for the run once script to do all of this is here. The script to do the installation and the ini file to drive it, is here.
I have the good fortune to be presenting at upcoming events in Philadelphia, Boston, and Orlando. This weekend at SQL Saturday #69 I will be presenting the following: 10:00 AM Building your first SQL Cluster 12:30 PM (Along with Mark Kromer from Microsoft) Migrate SQL Server Apps to SQL Azure Cloud DB 3:45 PM Deploying […]