New Objects, Columns, and Messages in SQL Server 2019 CTP 2.3
Sure, there’s official documentation on what’s new in SQL Server 2019, but Microsoft’s notorious for slipping undocumented stuff in. Sometimes these new features become officially documented in subsequent preview builds, like CTP 2.2 …
SQL Server 2019 Result Set Caching?
Friday’s new CTP 2.3 added a few new fields to sys.databases: But the highlighted one has me all tingly inside, kinda like the first time I heard Winona Ryders use the word “chainsaw” in a sentence. (Bonus points for readers who get t …
What is Clean Buffer in DBCC DROPCLEANBUFFERS? – Interview Question of the Week #215
Question: What is Clean Buffer in DBCC DROPCLEANBUFFERS? Answer: I must give a big credit to the guy who actually asked me this question as in my over 20 years of the journey no one has ever asked me this question. Though the answer to this q …
SQL SERVER – FIX: The specified instance of SQL Server is hosted by a system that is not a Windows Server Failover Cluster(WSFC) Node.
Sometimes if the sequence is not followed correctly, we might see some weird errors. In this blog, we would learn how to fix always on an error while adding new replica “The specified instance of SQL Server is hosted by a system that is not a Win …
Calling all Oracle Database users
We’re excited to announce that Redgate is doubling its efforts on Oracle and committed to aligning its DevOps solution across both SQL Server and Oracle. Please take a few minutes to complete this short survey to stay up-to-date on our Oracle dev …
Unit Testing with SQL Server
Learn how to begin unit testing with tSQLt and SQL Server.
Getting Started with Power BI – Part 1
In this tip we will show how Power BI works and how to create a simple report from scratch and the options available for creating reports.
SQL SERVER – SQL Server Configuration Manager Missing from Start Menu
Earlier I wrote a blog on the same topic and today I found another way to do the same thing. In this blog, we would discuss the steps you can take to open SQL Server Configuration Manager when its missing from Start Menu in the Windows operating system …
What was the first SQL Server concept that stumped you?
What’s the first thing you remember struggling with on SQL Server? Your first memory of, “Dang, I just can’t figure this out,” and then you had a Eureka moment later when it was so much more clear?” I asked folks on Twitte …
Improve the Performance of Your Azure SQL Database (and Save Money!) with Automatic Tuning
Organizations may have many concerns about performance when migrating databases to Azure. Fortunately, Microsoft provides some great tools to help improve performance and save money. In this article, Monica Rathbun explains how to take advantage of the …
Index Column Order – Be Happy!
Ever wonder about index column order; this piece should give some insight.
SQL Provision Makes Light Work of Compliance
With SQL Provision it takes seconds to spin up database copies for dev and test, with whatever level of protection you need – masked data, unmasked data, or synthetic data sets. This means you can meet the needs of DevOps while ensuring your data …
SQL SERVER – How to Drop All the Hypothetical Indexes of Database?
Earlier I wrote a blog post SQL SERVER – Say No To Database Engine Tuning Advisor and I got an email from my existing client where I frequently engage for Comprehensive Database Performance Health Check. They wanted me to help them remove all the …
PREEMPTIVE_OS_FLUSHFILEBUFFERS waits on Linux
Last week I blogged about Using the Wait Statistics Report in Azure Data Studio, using a Linux VM in Azure as an example host. As that was my first time running wait stats analysis on a Linux host, I found that the PREEMPTIVE_OS_FLUSHFILEBUFFERS wait w …
Where do I file bugs and feature requests for Microsoft Data Platform products?
It’s not just you: it’s hard for all of us to figure out where to go when we find a bug or want to add a feature. Here’s a quick rundown: Azure Data Studio – open an issue in the Github repo. While you open an issue, Github …