Sites anglophones

Driving up database coding standards using SQL Prompt

Publié le 29 mars 2018 sur

This article will demonstrate how a team can use SQL Prompt to establish and share coding standards, through code analysis rules, formatting styles and code snippets.

Avoiding Database Downtime via Replication – SharePlex

Publié le 29 mars 2018 sur journey to sqlauthority

The scariest word for any DBA is – Database Downtime. Every DBA who is going off duty for the day or going away on vacation for a month is always worried about Database Downtime. I totally sympathize with everyone who is constantly worried a …

Office Hours Guest Instructor Month

Publié le 28 mars 2018 sur

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

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

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

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

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

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

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

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

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

Monitoring and Troubleshooting Deadlocks with SQL Monitor

Publié le 26 mars 2018 sur

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 …

Pages :