Sites anglophones


Scripting Objects with PowerShell

Publié le 3 mai 2018 sur sqlservercentral.com
 

In the third installment of this series, Steve Jones uses PowerShell to source control code. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the r …

150 SQL Code Smells

Publié le 3 mai 2018 sur sqlservercentral.com
 

Some time ago, Phil Factor wrote his booklet ‘SQL Code Smells’, collecting together a whole range of SQL Coding practices that could be considered to indicate the need for a review of the code. It was published as 119 code smells, even though there wer …

SQL SERVER – Fix Error: Invalid object name ‘STRING_SPLIT’

Publié le 3 mai 2018 sur journey to sqlauthority
 

Just the other day one of the readers sent me following email after reading my earlier blog post: STRING_SPLIT Function Performance Comparison. He really liked the new feature of SQL Server 2016 and decided to start using this new feature. However, as …

SQL Server Diagnostic Information Queries for May 2018

Publié le 2 mai 2018 sur sqlskills.com - glen berry
 

This month, there are more minor updates to the SQL Server 2012 and newer versions of the queries, primarily in the comments and documentation. I have added some additional columns to many existing queries, and tried to get the newer versions uniformly …

Book Review: Inside SQL Server 6.5

Publié le 2 mai 2018 sur brentozar.com
 

Books Offline 30 years ago, back in 1988, Microsoft, Ashton-Tate, and Sybase got together to start building SQL Server 1.0 for OS/2. I wanted to take a trip down memory lane to celebrate, but I didn’t wanna go back quite that far. I wanted t …

Preventing Invalid Data Early In An ETL Flow

Publié le 2 mai 2018 sur sqlservercentral.com
 

In this post, Tim Smith will look at some of the considerations for both data rules and logic to prevent invalid data early in the ETRL process.

Installing Machine Learning Services – Level 1 of the Stairway to ML Services

Publié le 2 mai 2018 sur sqlservercentral.com
 

This first installment of the Stairway to Machine Learning Services explains the installation process for this subsystem in SQL Server. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis expl …

21 Essential Scripts: Jump-Start Performance Tuning for Accidental DBAs – PASS Pre-Con 2018

Publié le 2 mai 2018 sur journey to sqlauthority
 

Today, I am going to talk about my the most anticipated pre-conference 21 Essential Scripts: Jump-Start Performance Tuning for Accidental DBAs scheduled at PASS Summit 2018. This session is going to be amazing fun and very unique. It is full …

I’m speaking at SQL Saturday NYC

Publié le 1 mai 2018 sur brentozar.com
 

No, Not Brent Just me. And a few dozen other people, on May 19 (2018). I have sessions on the query optimizer, and all the stuff I think is cool in SQL Server 2017. Away Days You know, I get it. The weather is just finally getting nice in these parts. …

Random Word Generation for Data Scrubbing

Publié le 1 mai 2018 sur sqlservercentral.com
 

With HIPAA and GDPR requiring your careful scrubbing of data for lower environments, random word generation promises to be a huge helper. Read here how to do it.

Introduction to Azure SQL Managed Instance

Publié le 1 mai 2018 sur sqlservercentral.com
 

Microsoft currently offers two built-in methods of running production SQL Server databases in Azure. The first relies on the ability of Infrastructure-as-a-Service (IaaS) Azure virtual machines to host a variety of on-premises workloads, including SQL …

SQL SERVER – How to Get SQL Server Agent Properties?

Publié le 1 mai 2018 sur journey to sqlauthority
 

During Comprehensive Database Performance Health Check we always go over various SQL Server properties. Lots of people do not know that there are quite a few SQL Server settings which can help us improve our SQL Server performance many folds. …

First Responder Kit Release: Darn May Showers

Publié le 30 avril 2018 sur brentozar.com
 

There’s usually something that I think is funny in this space. Instead, I’m going to extend my already extensive day of civic duty by letting you know something interesting about jury duty.   Sometimes, if you show up when they ask you …

24 Hours of PASS (April 2018): Recordings now available!

Publié le 30 avril 2018 sur sqlblog.com
 

The Sessions of the event 24 Hours of PASS « Cross-Platform SQL Server Management » edition (held this April on 25 and 26) were recorded and now they are available for online streaming!If you have missed one session or the entire event, you can view or r …

SQL Server Graph Databases – Part 5: Importing Relational Data into a Graph Database

Publié le 30 avril 2018 sur simple-talk.com
 

The series so far: SQL Server Graph Databases – Part 1: Introduction SQL Server Graph Databases – Part 2: Querying Data in a Graph Database SQL Server Graph Databases – Part 3: Modifying Data in a Graph Database SQL Server Graph Databases – Part 4: Wor …


Pages :