Sites anglophones


Checking Your SQL Server Instance for Spectre/Meltdown Patches

Publié le 18 janvier 2018 sur sqlskills.com - glen berry
 

If you are running SQL Server 2008 through SQL Server 2017, you should be thinking about what you should be doing to protect your systems from the Meltdown and Spectre vulnerabilities. Microsoft has a number of KB articles that address this issue from …

How Much Can One Row Change A Plan, Part 3

Publié le 18 janvier 2018 sur brentozar.com
 

All The Rage We’ve asked how much one column and even one row can change a plan before. The doctor says I’m not allowed to read blog comments anymore on account of my blood pressure, but the AI I wrote in PowerShell assures me the …

Finding code smells using SQL Prompt: old-style join syntax

Publié le 18 janvier 2018 sur sqlservercentral.com
 

SQL Prompt implements a static code analysis rule which will check code automatically for occurrences of non-ANSI standard JOIN syntax – here’s how it works.

Formatted ASCII Results from a SELECT

Publié le 18 janvier 2018 sur sqlservercentral.com
 

Generate aligned output from SELECT statement for code comments using a simple stored procedure.

SQL SERVER – Activity Monitor – Active Expensive Queries

Publié le 18 janvier 2018 sur journey to sqlauthority
 

Recently during Comprehensive Database Performance Health Check, I had a fascinating conversation. SQL Server has introduced Activity Monitor many version earlier. I think everybody is now pretty familiar with this tool and use it frequently. …

[Video] The Junior DBA Workout Plan

Publié le 17 janvier 2018 sur brentozar.com
 

Squat, deadlift, overhead press, and bench press. In the gym, it’s easy to figure out what you need to be doing to get stronger. When you show up to work, you’re overwhelmed by all the things happening on your server(s), and you can’t …

Stairway to MDX – Level 5: Members, and an Introduction to the MDX Members Functions

Publié le 17 janvier 2018 sur sqlservercentral.com
 

Bill explains what is meant by a ‘Member’ and ‘Member function’ in MDX. A member is an item in a dimension that include the ‘measures’ which are the values of the attributes that belong to a dimension. ‘Measures’ are themselves members of a dimension c …

SQL SERVER – Performance Observation of TRIM Function

Publié le 17 janvier 2018 sur journey to sqlauthority
 

Earlier I wrote a blog post about how to remove leading and trailing spaces with TRIM function. SQL SERVER – 2017 – How to Remove Leading and Trailing Spaces with TRIM Function? After writing this blog post lots of people asked me …

An Easier Way of Pivoting Data in SQL Server

Publié le 16 janvier 2018 sur simple-talk.com
 

The Pivot or Transpose Many developers just want to ’rotate’, pivot or transpose a result as if it were a matrix. This involves turning columns into rows by, in effect, transposing the two coordinates. There is, of course, a lot of differen …

SQL Server Machine Learning Services – Part 4: Finding Data Anomalies with Python

Publié le 16 janvier 2018 sur simple-talk.com
 

The series so far: SQL Server Machine Learning Services – Part 1: Python Basics SQL Server Machine Learning Services – Part 2: Python Data Frames SQL Server Machine Learning Services – Part 3: Plotting Data with Python SQL Server Mach …

When Does Index Size Change Index Choice?

Publié le 16 janvier 2018 sur brentozar.com
 

Size Matters? One thing I hear a lot is that the optimizer will take the size of an index into account when choosing which one to use. The tl;dr here is that it may make more of a difference when it comes to index width  (think the number of colum …

Step by Step Guide to Migrate SQL Server Data to SQL Server 2017

Publié le 16 janvier 2018 sur sqlservercentral.com
 

This step by step approach explains how to assess your SQL Server migration using DMA. Learn how to understand the behavior of your existing version and what changes need to be made to migrate to a newer version of SQL Server.

NEW – Create, protect and manage non-production databases with SQL Provision

Publié le 16 janvier 2018 sur sqlservercentral.com
 

Redgate’s newest offering helps address data privacy and protection concerns by creating copies of SQL Server databases that mask all sensitive data. SQL Provision serves as a gateway between production and non-production environments, to ensure the sa …

Disk Encryption and The Impact to DBAs

Publié le 16 janvier 2018 sur sqlservercentral.com
 

As security threats proliferate, the need for encryption will continue to rise. We who are the Guardians of the Data must be ready to make SQL Server respond and to manage the performance issues that are inherent in every data encryption solution.

SQL SERVER – Rule Cluster Remote Access Failed During Installation on SQL Failover Clustered Instance

Publié le 16 janvier 2018 sur journey to sqlauthority
 

Not every problem might have a solution, and we must use a workaround to move forward. This blog is also related to one such error message which I observed while installing a clustered instance of SQL Server. Here is the error in the UI Rule “Clu …


Pages :