Can deleting rows make a table…bigger?
Michael J. Swart posted an interesting question: he had a large table with 7.5 billion rows and 5 indexes. When he deleted 10 million rows, he noticed that the indexes were getting larger, not smaller. Here’s one way that deletes can cause a tabl …
Resumable Online Index Create and Rebuild Operations
Did you know that SQL Server supports pausing and resuming the index creation and rebuild processes? The resumable online index rebuild option is currently supported in Azure SQL Database and SQL Server 2017 With the introduction of the public preview …
Protecting Credit Card Data when Testing
Privacy regulations, ranging from GDPR to HIPAA, among many others, put strict compliance requirements on the storage and use of personal and sensitive data. In this article Grant Fritchey explains how the data masking technology in SQL Provision can h …
New Truncation Error Message in SQL Server 2019
A new error message in SQL Server 2019 will make your life much easier!? Learn more… 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 root ca …
SSIS: Read Event viewer with WMI Data reader
Access OS event viewer and read it from a SSIS package using WMI Data reader task
Price Increase Alert – SQL Server Performance Tuning Practical Workshop for EVERYONE – April 23, 2019
Just a quick note for everyone that if you have not signed up for my SQL Server Performance Tuning Practical Workshop for EVERYONE – April 23, 2019, so far, the price is going to be increased by USD 100 from March 1st. The price of the course inc …
[Video] Demoing SQL Server 2019’s new Accelerated Database Recovery
Wouldn’t it be nice if rollbacks just finished instantly? Wouldn’t you love for startup times to be near-zero even when SQL Server crashed just as someone in the middle of a transaction? How much would you pay for all this? (Well, I’m …
Transform your SQL Server permissions
SQL Census helps users understand who has access to their SQL Servers (including Active Directory groups) and simplify existing SQL Server permissions. A new feature reworks discrete user permissions into database roles, giving users the same effective …
Getting Started with Azure Data Studio
Azure Data Studio (ADS) is a cross platform query tool for SQL Server. Learn how to get started using ADS to work with your SQL Server instances.
SQL SERVER – FIX: Database Diagram Error 15517 – Cannot Execute as the Database Principal Because the Principal ‘dbo’ Does Not Exist
Today’s blog post is directly inspired by the conversation I had during my Comprehensive Database Performance Health Check. During the consulting engagement, one of the developers reported below error in the database while trying to open a d …
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 …