Sites anglophones


DBA Training Plan 20: Planning Your Next Server

Publié le 12 septembre 2019 sur brentozar.com
 

When the business decides it’s time to give up fixing the old server because it’s not fast enough or reliable enough, stop. The worst thing you can do is jump directly to the hardware vendor’s site, check a few boxes, and order a new …

SQL SERVER Management Studio 18 – Enable Dark Theme

Publié le 12 septembre 2019 sur journey to sqlauthority
 

We are all techies and we love to use a dark theme in our IDEs. I get quite often a question about how to enable dark theme in SQL Server Management Studio during Comprehensive Database Performance Health Check. Let us see how we can change the theme a …

Goodbye to the Microsoft Professional Program

Publié le 12 septembre 2019 sur sqlservercentral.com
 

The post Goodbye to the Microsoft Professional Program appeared first on SQLServerCentral.

Optimize Your SQL by Reformulating the Spec

Publié le 12 septembre 2019 sur sqlservercentral.com
 

Introduction As SQL developers, we try to implement the most concise and well-performing SQL code that conforms to the specification we are given. We also tend to think of performance tuning in terms of crafting the best table indices, avoiding scalar …

Neglecting to Use, or Misusing, the RETURN Keyword (BP016)

Publié le 12 septembre 2019 sur sqlservercentral.com
 

The post Neglecting to Use, or Misusing, the RETURN Keyword (BP016) appeared first on SQLServerCentral.

The Data-Philes Team Meet the Time Traveler

Publié le 11 septembre 2019 sur simple-talk.com
 

The year is 1999, somewhere in Cambridge, UK. Kathi, a member of the Data-Philes team, is reading a memo sent from her manager. The memo talks about someone who disrupted a project management meeting in London. He claims he is from 20 years in the futu …

How to Set Up Your Own Mastering Class VM

Publié le 11 septembre 2019 sur brentozar.com
 

When you buy one of my Live Class Season Passes, you can save a lot of money this week by building your own VM to follow along with the labs. Or, you might just wanna re-run the labs later to see if you can do a better job, or if you’re still mas …

Why You Need Query Store, Part II: Plan forcing

Publié le 11 septembre 2019 sur SQLSkills.com - Erin Stellato
 

We hear a lot about all the data that Query Store captures, but it is tempting to argue that the best part of Query Store is the ability to force a specific plan for a query.  Arguably, if the data didn’t exist, we would have a harder time f …

SQL Server 2019 Graph Database and SHORTEST_PATH

Publié le 11 septembre 2019 sur simple-talk.com
 

My crystal ball seems to be working again: The new addition to SQL Server 2019, shortest_path, was the subject of many of the technical sessions I delivered as one of the missing features of SQL Server Graph Database. I will use an example that is simi …

Understanding State of SQL Server Monitoring 2019 Report

Publié le 11 septembre 2019 sur journey to sqlauthority
 

In 2018, Redgate launched the industry’s first-ever report into the state of SQL Server monitoring. It contained responses from over 600 SQL Server professionals giving them a unique insight into how they monitor their estates, the technologies t …

Self-service and Delegation with SQL Clone 4 Teams

Publié le 11 septembre 2019 sur sqlservercentral.com
 

The post Self-service and Delegation with SQL Clone 4 Teams appeared first on SQLServerCentral.

T-SQL Tuesday #118 My Fantasy SQL Server Feature

Publié le 11 septembre 2019 sur sqlskills.com - glen berry
 

This post is a response to this month’s T-SQL Tuesday #118 prompt by Kevin Chant.  T-SQL Tuesday is a way for the SQL Server Community to share ideas about different database and professional topics every month. This month’s topic asks …

Why You Need Query Store, Part I: Historical Performance Data

Publié le 10 septembre 2019 sur SQLSkills.com - Erin Stellato
 

The Query Store feature previewed in Azure SQL Database in summer 2015, was made generally available that fall, and was part of the SQL Server 2016 release the following summer.  Over the past four years (has it really been that long?!) I have dev …

Introduction to DevOps: Security, Privacy, and Compliance

Publié le 10 septembre 2019 sur simple-talk.com
 

The series so far: Introduction to DevOps: The Evolving World of Application Delivery Introduction to DevOps: The Application Delivery Pipeline Introduction to DevOps: DevOps and the Database Introduction to DevOps: Security, Privacy, and Compliance A …

#TSQL2sday: I Just Wish SQL Server Could Restore a Single Object from Backup.

Publié le 10 septembre 2019 sur brentozar.com
 

For this month’s T-SQL Tuesday, Kevin Chant asked us to dream up our fantasy SQL Server feature. I’m sure people are gonna ask for flying cars and gene splicing, and that’s awesome. I’m excited to hear the kinds of things they d …


Pages :