SQL SERVER – Drop failed for Availability Group – Failed to Destroy the Windows Server Failover Clustering Group Corresponding to Availability Group
While working with one of the clients to recover from a disaster, I encountered an error. In this blog we would talk about error Drop failed for Availability Group. If you want any such assistance, you can hire me for quick consultation using On Demand …
SQL Server 2019 Standard Edition Licensing
As SQL Server 2019 gets closer to GA status sometime during 2019, I have an “ask” for the decision makers at Microsoft who do the final analysis and actually decide what the hardware-based license limits will be for SQL Server 2019 Standard …
Why DBAs Must Embrace DevOps
A good day for a database administrator (DBA) is a lot like a good airline flight. A lot of excitement in either situation is bad. In a perfect world, a DBA will be productive and not spending most of their time “putting out fires.” (And fi …
I’m coming to SQL Saturday Salt Lake City in August!
I’m coming to Salt Lake City in August for SQLSaturday #885. On Friday, I’ll be teaching a one-day pre-con: Performance Tuning in 21 Demos – You’re a developer or DBA who wants to tune indexes and queries to make your appli …
SQL SERVER – Installation Error: System.ArgumentNullException – Value Cannot be Null
One of my clients was trying to automate SQL deployment. While testing they were stuck with an interesting error and then they contacted me. In this blog, I would share my learning about an installation error: System.ArgumentNullException – Value …
A Self-Serve System that Allows Developers to Refresh Databases (Part 2)
In Part 1 of this series I shared an overview of a system that allows developers to restore production backups to test servers. In Part 2 of this series I will go into detail of the SQL side of the system. This system assumes you have a test DB server. …
The BI Journey: The Journey Begins
The series so far: The BI Journey: The Analyst The BI Journey: The Expert’s Advice – Part 1 The BI Journey: The Expert’s Advice – Part 2 The BI Journey: The Journey Begins Stephen, the sales manager, was impressed with the work …
Book Review: Learn T-SQL Querying by Pedro Lopes and Pam Lahoud
Learn T-SQL Querying by Lopes and Lahoud You’ve been writing queries for at least a year or two, and you’re curious about what’s happening under the hood when SQL Server runs a query. You want to know what you can do to improve your q …
SQL SERVER – How Do I Evaluate Monitoring Tools?
From last many years, I have been working with SQL Server focusing on Performance Tuning and Optimization. I often get asked what is my favorite monitoring tool. I have previously written about this subject on the blog and there are five part blog seri …
How to Build an Efficient Request Process for SQL Server DBAs
The post How to Build an Efficient Request Process for SQL Server DBAs appeared first on SQLServerCentral.
MDX (MultiDimensional Expressions) in 148 minutes
If you want to understand the fundamentals of MDX in less than 3 hours – this article can be helpful. I came to the conclusion that the best way of learning are video tutorials. 143 minutes of watching and 5 minutes of reading. Let’s get started. Some …
Developers: Azure SQL DB Serverless can save you money.
If you’ve got a database that doesn’t need to be on all the time, Azure SQL DB Serverless is in public preview now. It makes a lot of sense for those development databases you have to keep around, but don’t really want to pay for. If …
SQL SERVER – Script to Get Compiled Plan with Parameters From Cache
Lots of people often ask me as I share pretty everything on the blog – Do I have any Business Secrets. Actually, the answer is no, I never keep any secrets. I always share everything I know and I want my customers and readers learn along with me. …
Microsoft SQL Server: Current Identify Column Value in a Table
The post Microsoft SQL Server: Current Identify Column Value in a Table appeared first on SQLServerCentral.
Using Azure Data Studio with TFVC
Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I’ve written a few articles on how the tool works, shown here: Getting Started with Azure Data Studio Getting Comfortable Writing Code in Azure Data Studio Using Notebooks in Azu …