Some people advocate we should count by twelve rather than ten. This is because you can easily count the twelve segments of your fingers by using your thumb as a pointer. With that method, you can count the number of…
Too often we end up in a conflict while trying to explain how a minimally impacting function has no true business impact. If you are too detailed, no one wants to listen to you and you are wasting their time. If…
tl;dr No release date was announced at Data Driven but it was announced on SQL Server Blog. SQL Server 2016 will be released for general availability on June 1st, 2016! Take a look at the feature breakdown by edition here….
Last time, I discussed how to limit data duplication between data centers as a cost-effective option with an Availability Group. In this post I will take cost reduction one step further by short-changing the disaster recovery site. Disaster recovery on the…
Last time, I discussed how to meet high-availability (HA) and disaster recovery (DR) using four stand-alone SQL Server instances in an Availability Group. In this post, I will add SQL Server Failover Cluster Instances to the mix and cut the…
Last time, I discussed the simplest Availability Group architecture, with only a single site. In this post I will expand upon the same architecture, adding in a second site to achieve more than just high-availability. Cross sub-net availability group In…
Availability groups offer us a variety of features. They offer high-availability (HA), they can give disaster recovery (DR), and they have connectivity and off-loading features but we have to decide how to use them. This is the first of a four-part…
Each month, on the first Tuesday of the month, the announcement for the blog party T-SQL Tuesday comes out. Those that are interested then post their blogs, on the subject selected, on the second Tuesday of the month. If you’ve…
Keeping up with new features of SQL Server can be a challenge. What is even more challenging, though, is keeping up with changes to existing features. Re-reading Microsoft books online is tedious and differences between versions are not always easy…
The standard backup strategy seems to always include backups running at midnight, hoping that they complete before anyone starts using the applications. There is value in performing maintenance on off-hours. However, many applications do not have off-hours or our databases grow…