Office Hours Guest Instructor Month
Andy Leonard In our weekly Office Hours, we hang out and answer questions from you, dear reader. In April, we’re trying something new: guest hosts. If you’ve got a topical question or something you want to ask a specific person, now’s …
Stairway to U-SQL Level 21: Exporting Data with Azure Data Factory
Learn how you can move data from your Data Lake to Azure SQL Database with Azure Data Factory. 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 …
How does GDPR impact your SQL Server Recovery Plans
With GDPR on the imminent horizon, there are many things that Data Platform engineers need to consider with regards to the rights of data subjects. Primary among these is understanding the impact of requests to be forgotten and updates to a person’s da …
Practical Real World Performance Tuning – Frequently Asked Questions
Earlier this month, I announced my very first online live training course Practical Real World Performance Tuning along with Brent Ozar. As soon as the course was announced we received your overwhelming response. I am truly thankfu …
Missing Index Impact and Join Type
Just Another Way No matter how you delve into missing index requests — whether it’s the plan level, DMV analysis, or (forgive me for saying it), DTA, the requests will generally be the same. They’ll prioritize equality predicates, the …
SQL Server 2016 Availability Group – Automatic Seeding with SSMS 17.x
In SQL Server 2016 the availability group automatic seeding functionality is implemented. This article will detail the steps to use of SSMS with automatic seeding and its limitations.
How to Send a TDE Encrypted Backup to Someone Outside Your Organization
Once you enable your database to be encrypted with Transparent Data Encryption (TDE), the physical database files, and the database backups are encrypted. If your database and database backup are encrypted, then how can you send the encrypted backup to …
MySQL – Connection Error – [MySQL][ODBC 5.3(w) Driver]Host ‘IP’ is Not Allowed to Connect to this MySQL Server
One of my clients contacted me for a linked server issue between SQL Server and MySQL Server. Since I mostly work with SQL Server, it was a fun installing and connecting MySQL Server. While I was trying to simulate the issue and I wanted to create a li …
Getting Started with Veeam Explorer for Microsoft SQL Server
Veeam Explorer for Microsoft SQL Server allows application-specific restores of SQL databases, as well as contents of tables, objects such as stored procedures, views and more. Additionally, you can restore the databases to a specific transaction.
Building SQL ConstantCare®: Product, Packaging, and Pricing
Our new SQL ConstantCare® is our first paid online service – it tells you what you should do next on your SQL Servers. I’ve written about the vision and the architecture design, and this week I’m continuing to share the …
SQL Server 2017 for Linux first impression
Microsoft has released a version of SQL Server 2017 for Linux.
Monitoring and Troubleshooting Deadlocks with SQL Monitor
This article will discuss why deadlocks occur, why they require immediate investigation by the DBA, and the diagnostic data required to troubleshoot them.
SQL SERVER – AlwaysOn Automatic Seeding – Database Stuck in Restoring State
As a part of my consulting, I observed that there is a lot of interest in using AlwaysOn availability group. I have deployed many AlwaysOn solutions from start-to-finish. Recently I encountered an issue and in this blog, we would discuss reason of an a …
[Video] Office Hours 2018/3/21 (With Transcriptions)
This week, Brent, Richie, and Erik talk replication, SQL Source Control with Git, installing service packs in cumulative updates in SQL Server, query tuning, write errors, log backups, Azure managed instances, 3-rd party backup software, and DBA porn. …
Which is Better for Performance – SELECT or SET? – Interview Question of the Week #166
Question: Which is Better for Performance – SELECT or SET? Answer: Some questions never get old. This is one of such question. Remember that SELECT is designed to return data whereas SET is designed to assign values to lo …