SQL Server 2017 Cumulative Update 6
On April 17, 2018, Microsoft released SQL Server 2017 CU6, which is Build 14.0.3025.34 I count 39 fixes or improvements in the public fix list. Remember, there are not going to be any Service Packs for SQL Server 2017. We are still in the monthly relea …
So You Wanna Debug SQL Server Part 2
Birth Control Debugging, and, heck, even learning about debugging, is a time-consuming and often unhelpful process when it comes to tracking down issues in SQL Server. It is arduous and tedious, and yields little chance of making you any friends. So wh …
5 challenges to scaling DevOps at enterprise level
Many large enterprises launch small DevOps initiatives within certain departments, but subsequently find that scaling DevOps across the organization faces a number of challenges that must be overcome.
Do you check your backups?
Backups. Are you confident you can restore? Do you have a process that ensures you can recover your systems? Learn how one system works in the cloud. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor T …
SQL SERVER – Unable to Start SQL After Patching – Database SSISDB is Enabled for Database Mirroring
I do apply patches to my SQL instances as and when they are released by Microsoft. This is important because I always feel keeping the bits up-to-date is essential because I don’t want to get infected as I travel quite a bit. Since I play a lot w …
Index Key Column Order And Supporting Sorts
Whatever Man When tuning queries that need to sort large amounts of data, sometimes it makes sense to stick the ordering elements as the leading key column(s) in your index. This allows SQL Server to easily sort your data by that column, and then acces …
Stairway to Columnstore Indexes Level 5: Adding New Data To Columnstore Indexes
Earlier levels have shown how Columnstore Indexes work effectively with static data. In most tables however, data is hardly ever static. We are constantly inserting new rows, and updating or deleting existing rows. If you think about what this means fo …
SQL SERVER – Steps to Deploy Distributed Availability Group – Windows Clusters in Different Domains
In the current era where companies’ mergers and take over is a common phenomenon, it is possible to run into a situation where there are two domains which are connected but not trusted. I was engaged in consulting for a client who had a similar m …
Read committed doesn’t guarantee much…
A while back I was involved in an email thread where people were wondering about some ‘weird’ behavior from SQL Server. The problem was occurring on SQL Server 2016 and used the default isolation level of read committed. The scenario w …
Parking Garages And Predicates
Hotels on Wheels Parking garages and predicates have a “lot” in common. GET IT? No no but seriously. They do. If you’ve ever lost your ticket, forgotten where you’ve parked, or just driven around hopelessly waiting to see an emp …
Effective Database Testing with SQL Test and SQL Cover
A well-established technique for improving application code quality, during software development, is to run unit tests, in conjunction with a code coverage tool. The aim is not only to test that your software components behave as you would expect, but …
Fixing system database corruption with setup.exe
Corruption of the system databases is a serious matter. Setup.exe is a brute force method of replacing them.
SQL SERVER – Event ID 1069 – Unable to Failover Clustered Instance to Another Node. Resource is not Loaded
While playing with my lab cluster, I ran into a situation. In this blog, we would learn about a situation where failover was not working from one node to another node. Everything used to work fine on Node1. Let us fix the error related to failover clus …
Provisioning SQL Server Instances with Docker
We DBAs tend to make a meal out of provisioning SQL Server instances. We just aren’t used to the idea of being able to get a SQL Server instance up and running without a lengthy setup and the installation of all those prerequisites. However, our …
Building SQL ConstantCare®: The Database
I bet, dear reader, that this is the post you’ve been really curious about in my behind-the-scenes posts. Back in the post about the data we collect, you may remember that our initial goal was to analyze high-priority issues like missing backups …