Join us on May 2nd, as we discuss preparing for DDoS attacks, building resiliency, overcoming obstacles and key preparations to make now before ransomware attacks.
In terms of actual, concrete, guidelines for naming SQL Server Indexes, I only have two pieces of what I would consider perfect advice:
Whatever you do, be consistent. You may have a great idea for a new index naming convention, but if y...
To me it still sometimes seems like SQL Server 2012 has only barely been out. In reality it's now been out longer than a year. Which means that Microsoft is not only obviously busy on the next version of SQL Server, but that they've actually...
Over the past few years, I’ve helped a number of clients migrate their SQL Server workloads from one server to another. In many cases (especially for SMBs, i.e. small to medium businesses) this has involved migrating databases, logins, settings...
In my session today on SQL Server Essentials for Non-DBAs I tried to provide a very high-level overview of key concepts and concerns that ‘reluctant’ or ‘accidental’ DBAs should know about in a very short amount of time...
Glenn Berry (blog | twitter) recently posted about SQL Server Standard 2012 Edition Licensing Limits. In his post he did two things really well:
Called out that that SQL Server 2008 R2 and SQL Server 2012 Standard Edition are both limit...
Every once in a while, one of my SQL Server Consulting clients asks me for my opinions about running Anti-Virus on production SQL Servers. And, amazingly enough, I actually (personally feel and) argue that anti-virus really shouldn’t be run ...
If a picture is worth a thousand words, then the words associated with the following picture would probably involve a decent amount of muttering and cursing about the the DREADED ‘Failed to notify via email’ error message that you might see...