2019 State of Database DevOps – Take the survey!
Database development practices are more integral than ever to DevOps success. How are we saving time, automating processes, deploying more frequently, all whilst keeping business critical data secure? Take part in the survey for an advanced copy of the …
Datatypes and the Default Mask with Dynamic Data Masking
This article digs deeper into the ways that Dynamic Data Masking works with different data types.
Unused Indexes – Are they really unused or have they just not been used YET?
Tara explains when index DMVs gets reset by telling a story from her dark past.
SQL SERVER – The Older Way to Find Size of Index Using Deprecated sysindexes
Earlier this month, I wrote a blog post about How to Find Size of the Index for Tables? – Interview Question of the Week #198, in this I had explained the way to find the size of the index for the table. However, while I was writing the blog …
PASS Summit 2018 Keynote Day 2: Live Blog
Today is the second day of the 2018 PASS Summit, the largest annual gathering of Microsoft data professionals. Yesterday, we got the marketing keynote that caught attendees up with the current state of SQL Server 2019 and Azure services. The atten …
T-SQL Decommenter Part I
Introduction to a T-SQL query that remove comments from T-SQL code
Help Redgate improve Data Masker for SQL Server?
Redgate are looking for people to help them get a deep understanding of compliance and SQL Server data masking requirements in order to ensure they can provide a world class solution. In return for your feedback you’ll have early access to new re …
Azure EA Financial Reporting and Granular Access to Data Through the Enterprise
With the billing data from your Azure Enterprise Agreement collected into one database, it is still necessary to break down the costs and provide access to the correct departments and individuals. This is important for chargeback and further analysis. …
SQL SERVER – AlwaysOn – Queries Waiting for HADR_AR_CRITICAL_SECTION_ENTRY
In the past few days, I am being contacted by clients for AlwaysOn related issue. I have been writing a blog about them. In this blog, we would learn about how to fix wait for HADR_AR_CRITICAL_SECTION_ENTRY. THE SITUATION My client was using SQL Server …
PASS Summit 2018 Keynote Day 1: Live Blog
Today is the opening day of the 2018 PASS Summit, the largest annual gathering of Microsoft data professionals. Every year, thousands of us gather at the Seattle Convention Center to connect, learn, and share. On this first day of the conference, all t …
What’s New in SQL Server 2019 CTP 2.1: Faster Functions
A while back, we talked you through a public whitepaper about how Microsoft was working on making user-defined functions go faster. Now that the next preview (CTP2.1) of SQL Server 2019 is out, you can start getting your hands on Froid, the performance …
Simple way to Import XML Data into SQL Server with T-SQL
In this tip we look at a simple way to import a simple XML document into a SQL Server table. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the r …
SQL SERVER – Cluster Resource ‘AGName’ of type ‘SQL Server Availability Group’ in Clustered Role ‘AGName’ Failed
I never leave my customers alone when they are having an issue with something which I helped them. Typically, I help customers in creating POC and deploying AlwaysOn Availability Groups. Just the other day while doing the Comprehensive Database Pe …
Query Store Performance Overhead: What you need to know
“What is the performance overhead of enabling Query Store?”I get asked this question almost every time I present on a topic related to Query Store. What people are really asking is “Does enabling Query Store affect the performan …
Caution about Restoring via SSMS v17
A default value has changed in the SSMS v7 restore wizard, and the consequences can be severe.