Sites anglophones


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 …

The 2019 State of SQL Server Monitoring Report

Publié le 28 juin 2019 sur sqlservercentral.com
 

The post The 2019 State of SQL Server Monitoring Report appeared first on SQLServerCentral.

4 Ways to Move Data Into a Reporting Server

Publié le 27 juin 2019 sur brentozar.com
 

You’ve decided that you need to offload reports to a different SQL Server, and you’re willing to pay the costs. Here are the most common ways to move the data from production to a reporting server, arranged roughly from easiest-to-implement …

SQL SERVER – Different Size of COPY_ONLY Full Backup on Primary and Secondary Replica in Always On

Publié le 27 juin 2019 sur journey to sqlauthority
 

While preparing for a disaster recovery demo for my client, I observed an interesting behavior. In this blog, I would show a quick demo where you can learn how the full backup size can be different on the primary and secondary replica for an availabili …

How can we close the tech skills gap?

Publié le 27 juin 2019 sur sqlservercentral.com
 

The post How can we close the tech skills gap? appeared first on SQLServerCentral.

Improving Tech with Compassionate Code

Publié le 27 juin 2019 sur sqlservercentral.com
 

The post Improving Tech with Compassionate Code appeared first on SQLServerCentral.

What’s the Difference Between PERCENT_RANK and CUME_DIST?

Publié le 27 juin 2019 sur sqlservercentral.com
 

Remember those standardized tests you took in school? They compared how you performed to others in your region, the ranking, not the actual percentage of correct answers. Microsoft released several window function features with SQL Server 2012 includin …

SQL SERVER – SUSPENDED Sessions Waiting on PAGELATCH_UP and PAGELATCH_SH – Solution

Publié le 26 juin 2019 sur journey to sqlauthority
 

Today, I have interesting experience while working with a client on Comprehensive Database Performance Health Check. I was working with Sr. DBA on optimizing their SQL Server. While working on it, we realized there was an issue with how their file conf …

Data breach notifications don’t need to be scary

Publié le 26 juin 2019 sur sqlservercentral.com
 

The post Data breach notifications don’t need to be scary appeared first on SQLServerCentral.


Pages :