Sites anglophones


SQL Server Performance Tuning Practical Workshop – Relaunched

Publié le 7 janvier 2019 sur journey to sqlauthority
 

In the year 2017 just for an experiment, I decided to start a SQL Server Performance Tuning Practical Workshop. I had no idea, that I will be the biggest and most popular service delivered by SQLAuthority.com. Since the year 2017, I have been deli …

The 2019 Data Professional Salary Survey Results

Publié le 6 janvier 2019 sur brentozar.com
 

How much do database administrators, analysts, architects, developers, and data scientists make? We asked, and 882 of you from 46 countries answered this year. Y’all make a total of $84,114,940 USD per year! Hot diggety. (And at first glance, it …

When to Use sort_in_tempdb for Rebuilding Indexes? – Interview Question of the Week #207

Publié le 6 janvier 2019 sur journey to sqlauthority
 

Question: When to Use sort_in_tempdb for Rebuilding Indexes? Answer: This question was received during one of the recent Comprehensive Database Performance Health Check consulting engagement. One of the last thing which we did during the cons …

[Video] Office Hours 2019/1/2 (With Transcriptions)

Publié le 5 janvier 2019 sur brentozar.com
 

This week, Brent, Erik, Tara, and Richie discuss whether you need to premake a destination database in order to run sp_databaserestore, restoring production statistics on dev servers to simulate productions behavior, dealing with duplicate SPNs, tools …

SQL Saturday Pordenone is back! Discover the 2019 edition!

Publié le 5 janvier 2019 sur sqlblog.com
 

Another SQL Saturday has been scheduled in Pordenone (Italy), it will be the SQL Saturday #829, as last year it will be an international event with international speakers and some sessions in English language!SQL Saturday Pordenone 2019 will be on febr …

SQL SERVER – FIX: Cannot Connect to SQL in Azure Virtual Machine From Laptop

Publié le 5 janvier 2019 sur journey to sqlauthority
 

To keep up with the market trend, I have already done my hands-on with SQL in Azure Virtual Machine. In this blog, I would share my learning about a connectivity issue which I faced recently. Here were the steps I followed to get my server up and runni …

CPU Ready Impact on SOS_SCHEDULER_YIELD

Publié le 4 janvier 2019 sur sqlskills - jonathan kehayas
 

At the end of May 2017, Paul and I had a discussion about SOS_SCHEDULER_YIELD waits and whether or not they could become skewed in SQL Server as a result of hypervisor scheduling issues for a VM running SQL Server.  I did some initial testing of t …

Handling Dates in Query Store

Publié le 4 janvier 2019 sur SQLSkills.com - Erin Stellato
 

Query Store retains query performance data at the plan level.  This data is then broken out into intervals of time, determined by the INTERVAL_LENGTH_MINUTES setting.  The time intervals are found in the sys.query_store_runtime_stats_interval …

Understanding Peer-to-Peer Transactional Replication, Part 3

Publié le 4 janvier 2019 sur sqlservercentral.com
 

We’ve gone through the basics of Peer-to-Peer Transactional Replication (PPTR). Now, we will blow it up! We will then fix it and show you how you how to triage and repair PPTR. When you remain calm and take some easy steps, you can stabilize PPTR with …

« Surely this one will get a clustered index scan. »

Publié le 4 janvier 2019 sur sqlservercentral.com
 

In which SQL Server stubbornly insists on doing key lookups way, way past the tipping point.

SQL SERVER – Unable to Set Cloud Witness. Error: The Client and Server Cannot Communicate, Because They do Not Possess a Common Algorithm

Publié le 4 janvier 2019 sur journey to sqlauthority
 

Recently, I was trying to simulate a client’s environment for which I need to have windows cluster with cloud witness. It didn’t go well, and I encountered an error message. In this blog, I will share the solution of error – “Th …

Proactive SQL Server Performance Tuning

Publié le 3 janvier 2019 sur sqlmag.com
 

Date: Tuesday, January 29, 2019Time: 02:00 PM Eastern Standard TimeDuration: 1 hour Don’t wait for performance issues to become a problem. Be proactive by analyzing and addressing SQL Server performance issues before they ever happen. Ready to le …

From The Server To The SAN

Publié le 3 janvier 2019 sur brentozar.com
 

Enter SANdman When people buy SANs, it’s often quite a large investment. Whether it’s all SSD, all flash, or there are tiers of storage that different types of data live on, those disks aren’t cheap. When people visualize their SAN, i …

The Pleasure Of Presenting With Joe Obbish

Publié le 3 janvier 2019 sur brentozar.com
 

Grouple On At the December 2018 GroupBy I had the honor of co-presenting with one of the smartest guys around, Joe Obbish. Here’s the video of our session, “The Problems With Optional Operators”, and a link to the resources. Enjo …

Database Design Choices To Consider When You’re Worried About Scale

Publié le 3 janvier 2019 sur brentozar.com
 

Tipping the Kilter I’m intentionally avoiding physical/hardware choices in this post, like how much hardware to buy, and scaling out vs. scaling up. It’s not that I don’t care about those things — I do, and they’re importa …


Pages :