Sites anglophones


Office Hours Guest Instructor Month

Publié le 28 mars 2018 sur brentozar.com
 

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

Publié le 28 mars 2018 sur sqlservercentral.com
 

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

Publié le 28 mars 2018 sur sqlservercentral.com
 

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

Publié le 28 mars 2018 sur journey to sqlauthority
 

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

Publié le 27 mars 2018 sur brentozar.com
 

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

Publié le 27 mars 2018 sur sqlservercentral.com
 

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

Publié le 27 mars 2018 sur sqlservercentral.com
 

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

Publié le 27 mars 2018 sur journey to sqlauthority
 

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

Publié le 27 mars 2018 sur sqlmag.com
 

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

Publié le 26 mars 2018 sur brentozar.com
 

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

Publié le 26 mars 2018 sur sqlservercentral.com
 

Microsoft has released a version of SQL Server 2017 for Linux.

Monitoring and Troubleshooting Deadlocks with SQL Monitor

Publié le 26 mars 2018 sur sqlservercentral.com
 

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

Publié le 26 mars 2018 sur journey to sqlauthority
 

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)

Publié le 25 mars 2018 sur brentozar.com
 

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

Publié le 25 mars 2018 sur journey to sqlauthority
 

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 …


Pages :