SSIS: Read Event viewer with WMI Data reader
Access OS event viewer and read it from a SSIS package using WMI Data reader task
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 …
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 …
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.
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 …
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 …