Sites anglophones

SQL SERVER – How to Enable Backup Compression On by Default

Publié le 30 septembre 2017 sur journey to sqlauthority

In this blog post we will discuss how to Enable Backup Compression on by default. SQL Server 2008 had introduced compressed backup features and nowadays I see quite often enabled at most of my customers where I go for consulting. When we install SQL Se …

First Responder Kit Release: Still Totally Lacking A Servicing Model

Publié le 29 septembre 2017 sur

A lot of people would think we’re crazy for releasing a FRK update a few days before a new version of SQL Server drops, but we’ve been adding 2017 compatible features for months Also none of you are on 2017 Most of you won’t live to b …

New Servicing Model for SQL Server

Publié le 29 septembre 2017 sur

  Microsoft just announced a new serving model for SQL Server starting with SQL 2017. The link below goes into much more detail so I won’t duplicate that here. However in a nutshell this means that there will be no more service packs, only C …

Adaptive Blog Posts

Publié le 29 septembre 2017 sur

It turns out I can be dumb In a previous blog post about Adaptive Joins, I thought that EXISTS wasn’t supported by the new feature. It turns out that EXISTS is totally 100% supported, as long as your indexes support EXISTS. To show this, I need t …

Implementing SQL Server Failover Clustering in Azure

Publié le 29 septembre 2017 sur

Deploying IaaS solutions in Microsoft Azure offers benefits that leverage agility, resiliency, and scalability built into the underlying platform. However, when dealing with business-critical workloads, customers typically want to also provide high-ava …

A whole new way to see differences in SQL Compare

Publié le 29 septembre 2017 sur

In the latest release of SQL Compare, Redgate have added a brand new way to examine the differences between two objects in your database. Jamie Wallis provides the details. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new articl …

SQL SERVER – Document Your Databases with Data Dictionary and Diagrams

Publié le 29 septembre 2017 sur journey to sqlauthority

A couple of months ago I told you about the new interesting tool I found for documenting existing database schemas – Dataedo. For those who don’t remember, this is a desktop tool that enables you to describe database schema elements and cre …

SQL Server 2017 Showplan Schema Is Available

Publié le 28 septembre 2017 sur

File this under… Things probably only I care about. But the Showplan Schema for SQL Server 2017 popped up… well, I caught it last night. I probably could have written this sooner, huh? So what’s new? Well, if I compare the 2016 SP1 …

Modern SQL Server Servicing Model

Publié le 28 septembre 2017 sur - glen berry

Microsoft has announced a pretty big change for how they are going to service SQL Server, starting with SQL Server 2017. I am very much in favor of the changes in this new model.   Background Historically, Microsoft has used a combination of gener …

How to Hire a Junior DBA

Publié le 28 septembre 2017 sur

When you’re hiring a Junior DBA, ask yourself a few questions: “What job did they have before this?” Someone who’s currently employed as a Junior DBA isn’t looking for another Junior DBA job: they’re looking for a Se …

Representing a simple hierarchical list in SQL Server with JSON, YAML, XML and HTML

Publié le 28 septembre 2017 sur

How difficult can it be to produce a simple hierarchical list in JSON, YAML, XML and HTML from a SQL Server table that represents a simple hierarchy within an organisation. Well once you know, it is easy and William Brewer is on a mission to tell you h …

Guide to Create a SQL Central Management Server

Publié le 28 septembre 2017 sur

This post is going to walk you through the process of creating an SQL Management Server.

SQL SERVER – What Are Ghost Records and How to Clean Them Up?

Publié le 28 septembre 2017 sur journey to sqlauthority

What are Ghost Records and How to Clean Them Up? I loved this question when I received it last week in my SQL Server Performance Tuning Practical Workshop. Well, in simple possible words – Ghost records are those records which are deleted lo …

I’m Leaving on a Jet Plane

Publié le 28 septembre 2017 sur - kalen delanay

I’m taking off tomorrow for Holland, UK, Denmark, Germany and Israel: You can read the post from DB Best, linked to above, or follow individual links to my public events from here: September. …

Which sp_configure Options Clear the Plan Cache?

Publié le 27 septembre 2017 sur

When you change MAXDOP and run RECONFIGURE, SQL Server clears the plan cache. (It’s documented, by the way, as is the rest of the behavior I’m about to show you, but sometimes I like to learn the hard way by running experiments.) Here …

Pages :