We had a case over the weekend where our automated restore process at client got hung up on this wait type, for a single database. What was the unique characteristic about this relatively medium (2-300 GB) database? It had a lot of filestream data–it seemed like the file count wasn’t that high, but my guess […]
Tag: sql server
Why You Shouldn’t Use Amazon RDS for your SQL Server Databases
Disclaimer: I’ve a Microsoft MVP and shareholder, but neither of these things affected my opinions in this post. Cloud vendors have built a rich array of platform as a service (PaaS) solutions on their platforms. They market these heavily, because they have higher degrees of stickyness compared to IaaS platforms (and in many cases they […]
Fixing SQL Server Database Corruption (when you get lucky)
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 […]
A Lesson in DR, Azure Site Recovery, and Troubleshooting
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, […]
Have You Patched For Spectre/Meltdown Yet? (And more on patches)
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 […]
How Much Do SQL Server Licenses Cost?
So I’m being a little bit of an SEO whore in this post because it took way to many google searches to get this data. SQL Server 2019 Enterprise Edition—Core Licensing Only–$27, 495/4 cores, $13, 747.50 per additional 2 core packs. SQL Server 2019 Standard Edition—Core licensing–$7171/4 cores, $3585.50 per additional 2 core packs, SQL […]
8 Things To Do After You Install SQL Server
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 […]