Using Azure Data Studio with Git
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 …
Setup SSIS Catalog Retention Policy and Partial Cleanup Strategy
SQL Server Integration Services (SSIS) is a great tool for building ETL processes. On SQL Server, we can configure an Integration Services Catalog to deploy and configure all the SSIS packages. When using this service, there is also a catalog dat …
SQL For Cosmos DB – Handling Complex JSON Structures
The series so far: Introduction to SQL for Cosmos DB SQL For Cosmos DB – Tips and Tricks SQL For Cosmos DB – Handling Complex JSON Structures JSON allows for nested nodes, arrays and arrays of objects, and Cosmos DB SQL can handle all of th …
Samsung Portable SSD X5 Review
If you have a fairly recent PC or Mac with a Thunderbolt 3 port, and you want/need some very high performance external storage, one of your best choices will be an external Thunderbolt 3 drive, especially one that uses an M.2 NVMe NAND flash drive with …
Creating Your First SQL Server Docker Container in macOS
It is not surprising that macOS has become the platform of choice when designing, creating or developing new SQL Server solutions. Microsoft has invested important time and resources to create a set of very powerful cross platform (Windows, Linux, macO …
SQL SERVER – Getting Started with Accelerated Database Recovery – Instant Rollback
There are many reasons to envy my job as SQL Server Performance Tuning Expert Consultant but the most important reason is that I get to work on quite often the latest version of SQL Server. Just the other day I had an early adopter customer who was usi …
Join DBAle’s data privacy competition!
The post Join DBAle’s data privacy competition! appeared first on SQLServerCentral.
October IEPTO1 and IEAzure classes open for registration
We thought we were only going to present in-person classes in Spring this year, but as IEPTO1 and IEAzure both sold out and had long wait lists, we’ve added new deliveries of those classes in October! Our classes in October will be in C …
How to Execute Query Without Using F5 or Query Toolbar in SSMS? – Interview Question of the Week #224
Question: How to Execute Query Without Using F5 or Query Toolbar in SSMS?Answer: I had an interesting situation where I was presenting a private training for an organization and during the presentation one of the attendees asked me if I know a unique w …
SQL SERVER – Get Last Known Actual Execution Plan for a Previously Cached Query Plan
This feature works with SQL Server 2019 and onwards. If you are using an earlier version of SQL Server this feature will not work and will give you an error. One of the most common questions I receive during Comprehensive Database Performance Health Ch …
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 …