Sites anglophones


Managing the SQL Server Estate

Publié le 31 octobre 2018 sur sqlservercentral.com
 

Everyone has their own ideas for what makes for an ideal monitoring solution for their SQL Server estates. Here Rodney Landrum outlines some of his ideas for how a monitoring tool can help monitor, analyze and predict resource usage, across a growing a …

SQL SERVER – Disable IntelliSense in SQL Server Management Studio

Publié le 31 octobre 2018 sur journey to sqlauthority
 

Just another day, I received an email from a user who has over 350 thousand tables in a single database. He was my earlier customer of Comprehensive Database Performance Health Check. He was facing indeed a very strange issue where his metada …

SUM, AVG, and arithmetic overflow

Publié le 30 octobre 2018 sur brentozar.com
 

You Shoulda Brought A Bigger Int Sometimes you run a query, and everything goes fine. For a while. For example, if I run this query in the 2010 copy of Stack Overflow, it finishes pretty quickly, and without error.SELECT u.Id, u.DisplayName, SUM(p.Scor …

SSIS Basics: Data cleansing using derived columns

Publié le 30 octobre 2018 sur sqlservercentral.com
 

On this article I will show you how to perform a basic data cleansing using the derived column data transformation

SQL Server 2019 is Here

Publié le 30 octobre 2018 sur sqlservercentral.com
 

On Monday, Sep 24, 2018, at the Ignite 2018 conference, Microsoft announced the first public preview of SQL Server 2019 (community technical preview (CTP) release of SQL Server 2.0).This new release of SQL Server is packed with many new features to imp …

Redgate acknowledged as a representative vendor in Gartner’s 2018 Market Guide for Data Masking

Publié le 30 octobre 2018 sur sqlservercentral.com
 

Data masking really has come of age. Gartner’s 2018 Market Guide for Data Masking has just been published and predicts that the global enterprise use of data masking (DM) or similar de-identification techniques will rise to 40%, an increase from …

SQL SERVER – XML Document Could Not be Created Because Server Memory is Low. Use sp_xml_removedocument to release XML documents

Publié le 30 octobre 2018 sur journey to sqlauthority
 

Most of my earnings come from my role as SQL Server Performance Tuning and Optimization consultant. Every single day I work with few customers so that I can maintain the quality of my work with each of them. As you can imagine, I face new challeng …

Automatic Plan Correction is Enterprise Edition Only Feature in SQL Server 2017

Publié le 29 octobre 2018 sur sqlskills.com - glen berry
 

One interesting and useful new feature in SQL Server 2017 is Automatic plan correction. This feature, which relies on having Query Store enabled for your database, will look for query plan choice regressions where there has been a significant regressio …

Compare SQL Server, MySQL and PostgreSQL Features

Publié le 29 octobre 2018 sur sqlblog.com
 

Have you ever wondered how MySQL and PostgreSQL are different? Take a look at the mapping that I have made for myself: https://www.mssqltips.com/sqlservertip/5745/compare-sql-server-mysql-and-postgresql-features/ I would be happy to see comments posted …

What Is SQLPSX?

Publié le 29 octobre 2018 sur simple-talk.com
 

I was and still am a big fan of SQLPSX (SQL PowerShell Extensions). It´s is a complete PowerShell library for SQL Server written by Chad Miller and Mike Shepard, and I was one of the developers on some of the modules. It’s composed of 13 mo …

You read reviews before you buy training, right?

Publié le 29 octobre 2018 sur brentozar.com
 

Confession time: I love buying stuff. It’s not so much the buying as it is the comparing. I go to The Wirecutter, I read every review on Amazon, and I make little Excel spreadsheets to show differences between products. So what about when you buy …

Get the Error Column Name in SSIS

Publié le 29 octobre 2018 sur sqlservercentral.com
 

This article will show how you can get the column name for error rows in an SSIS 2016 Data Flow task. 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 …

5th annual “Seattle Freecon”

Publié le 29 octobre 2018 sur sqlservercentral.com
 

On Monday, November 5th, 2018, the 5th annual “Seattle Freecon” (a FreeCon in Seattle for those that might not be attending a pre-con before the PASS Summit) will be held. Put on by Jason Brimhall and Wayne Sheffield, there’s a set of …

The future of SQL Census

Publié le 29 octobre 2018 sur sqlservercentral.com
 

Find out what plans Redgate has for SQL Census and leave your comments to have your own input in the future of the tool. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by-st …

SQL SERVER – Parallelism for Heap Scan

Publié le 29 octobre 2018 sur journey to sqlauthority
 

Every consulting engagement is different and I enjoy interacting with different people while I am working with different experts. Earlier this week, here is what I heard during one of the  Comprehensive Database Performance Health Check  …


Pages :