Sites anglophones


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 …

Why Do Some Indexes Create Faster Than Others?

Publié le 3 janvier 2019 sur brentozar.com
 

To warn you ahead of time, this post is an exploration without an answer (yet). There’s some interesting stuff in here, but no conclusions. If that’s not your kind of post, feel free to skip it. If it is, well, here goes nothin’ …

An Idea For Improving DBCC CHECKDB

Publié le 3 janvier 2019 sur brentozar.com
 

Hard Enough At this point, we’ve all probably got a database that’s a terabyte or more in size. If you’re anything like I was, you’ve got a ton of multi-terabyte databases, and the SAN admin has a special folder for your emails. …

Fast Food Code

Publié le 3 janvier 2019 sur brentozar.com
 

Cheap and Easy We’ve all done it. We all know what and where it is, because we’ve probably left a comment for ourselves to go fix it later. It wasn’t me, I swear to myself. Either it was expedient, it seemed to work locally, it was fa …

Erik and Tara Are Heading Out

Publié le 3 janvier 2019 sur brentozar.com
 

The rock stars. About two years ago, I realized I didn’t have the skills to grow the consulting part of the company to become a 10-employee firm, so I laid off Angie, Doug, and Jessica. This year, I made the tough decision to close the consulting …

Workplace Encounter: Effects of TLS 1.2

Publié le 3 janvier 2019 sur sqlservercentral.com
 

In this article we share a recent experience we had with implementing TLS 1.2 ONLY support on our databases and particularly with respect to its effect on Transaction Log Shipping sessions.

Working with SQL Server Stored Procedures and .NET

Publié le 3 janvier 2019 sur sqlservercentral.com
 

Learn how to build a simple .NET application that uses SQL Server stored procedures to retrieve and update data from a database.

SQL SERVER – FIX: Msg 41105: Failed to Create the Windows Server Failover Clustering (WSFC) Resource With Name and Type ‘SQL Server Availability Group’

Publié le 3 janvier 2019 sur journey to sqlauthority
 

Sometimes there are errors which give us the solution to the problem and I love to discover other ways to fix it. In this blog, we would learn how to fix Failed to create the Windows Server Failover Clustering (WSFC) resource with name and type ‘ …

How Azure SQL DB Hyperscale Works

Publié le 2 janvier 2019 sur brentozar.com
 

Microsoft is starting to talk about the internals for Azure SQL DB Hyperscale, their competitor to Amazon Aurora. Aurora took the open source MySQL and PostgreSQL front ends and hooked them up to much more powerful cloud-first storage engines on the ba …


Pages :