Sites anglophones


Impact of CHECKPOINT On Memory – SQL in Sixty Seconds #084

Publié le 3 juillet 2019 sur journey to sqlauthority
 

Some concepts are so good in SQL Server, they keep on coming back to me one way or another way. After reading my recent blog posts about CHECKPOINTS lots of people wanted to see the demonstration of the same. In this SQL in Sixty Seconds video, I will …

How to Provision a Set of Databases to Multiple Azure-based Servers

Publié le 3 juillet 2019 sur sqlservercentral.com
 

The post How to Provision a Set of Databases to Multiple Azure-based Servers appeared first on SQLServerCentral.

Yet Another Way Missing Index Requests are Misleading

Publié le 2 juillet 2019 sur brentozar.com
 

Graduates of my Mastering Index Tuning class will already be familiar with the handful of ways the missing index DMVs and plan suggestions are just utterly insane. Let’s add another oddity to the mix: the usage counts aren’t necessarily cor …

SQL Server Performance Tuning Practical Workshop – Discovery Phase – Online Training

Publié le 2 juillet 2019 sur journey to sqlauthority
 

Performance tuning is not as difficult as it once used to be but the challenge is the methodology of the performance tuning has changed quite a lot but many of the traditional training has so many limitations that I had went on my own journey to find t …

Database Delivery with Docker and SQL Change Automation

Publié le 2 juillet 2019 sur sqlservercentral.com
 

The post Database Delivery with Docker and SQL Change Automation appeared first on SQLServerCentral.

Filtering Object Explorer Detailed Information in SSMS

Publié le 2 juillet 2019 sur sqlservercentral.com
 

The post Filtering Object Explorer Detailed Information in SSMS appeared first on SQLServerCentral.

A Step by Step Guide to the Availability Group (AG) Listener

Publié le 2 juillet 2019 sur sqlservercentral.com
 

Availability databases hosted on SQL Server Always On Availability Groups (AG) can be connected using a unique Virtual Network Name (VNN), called the Availability Group Listener. When an Availability Group is enabled, clients can connect to databases i …

Poll: what’s in your development database?

Publié le 1 juillet 2019 sur brentozar.com
 

When the developers at your company are working on building an app, where do they work? Production, a development database restored from production, or a development database with made-up contents? One-question poll, and you can watch the live results. …

SQL Server Performance Tuning Practical Workshop – Discovery Phase – In Person Training

Publié le 1 juillet 2019 sur journey to sqlauthority
 

Everyone wants to learn SQL Server Performance Tuning Practical Workshop but the challenge is the methodology of the performance tuning has changed quite a lot but many of the traditional training is still prisoner with the older methods of SQL Server …

Glenn’s Tech Insights For June 30, 2019

Publié le 1 juillet 2019 sur sqlskills.com - glen berry
 

(Glenn’s Tech Insights… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can get more visibility. It covers interesting new hardware and software developments that are generally releva …

Password-less Authentication for Azure AD Guest Accounts with Azure SQL DB with Access Tokens

Publié le 1 juillet 2019 sur sqlservercentral.com
 

One of the greatest features of the Windows operating system is Active Directory. Password-less authentication usually « just works » for logins in an Active Directory configuration, and SQL Server takes full advantage of this feature. If you enable mixe …

A DBA’s Journey towards Database DevOps

Publié le 1 juillet 2019 sur sqlservercentral.com
 

The post A DBA’s Journey towards Database DevOps appeared first on SQLServerCentral.

What is Faster, SUM or COUNT? – Interview Question of the Week #231

Publié le 30 juin 2019 sur journey to sqlauthority
 

Question: What is Faster, SUM or COUNT?Answer: Both are the same. Let me prove it to you.I recently visited a big financial technology organization and while working on the day-long engagement on Comprehensive Database Performance Health Check in tunin …

SQL SERVER – Automatic Seeding of Availability Database ‘SQLAGDB’ in Availability Group ‘AG’ Failed With a Transient Error. The Operation Will be Retried

Publié le 29 juin 2019 sur journey to sqlauthority
 

Earlier I have written few blogs about automatic seeding feature. In this blog we would learn how to fix error: Automatic seeding of availability database ‘SQLAGDB’ in availability group ‘AG’ failed with a transient error.Here a …

SQL SERVER – Add Database to Availability Group Failure – This BACKUP or RESTORE Command is Not Supported on a Database Mirror or Secondary Replica

Publié le 28 juin 2019 sur journey to sqlauthority
 

I always recommend my client to go with the latest and great version of tools like SQL Server Management Studio (SSMS). In this blog, we would learn about a situation where an older version of SSMS was giving an error while adding a new database to exi …


Pages :