Sites anglophones


SQL Server: Avoiding a Sort with Merge Join Concatenation

Publié le 18 décembre 2017 sur sqlmag.com
 

There are cases when SQL Server doesn’t normally realize it can rely on index order, but you can make the platform realize it with some extra manipulation and creativity. This article is the first in a two-part series in which I describe such tas …

Open Source Software Is a 2017 Success Story

Publié le 18 décembre 2017 sur sqlmag.com
 

As 2017 draws to a close, we look at some of the reasons why the use of open source software is growing and will continue to grow in the year ahead.

Rebuilding Indexes Can Slow Queries Down

Publié le 18 décembre 2017 sur brentozar.com
 

Today, Jonathan Kehayias wrote about how fragmentation impacts execution plans. I’m really into performance tuning, so I read the post carefully, really interested to see how it impacted query runtime. You should read it too – it …

GDPR: Why We Stopped Selling Stuff to Europe

Publié le 18 décembre 2017 sur brentozar.com
 

The EU’s new General Data Protection Regulation (GDPR) is a set of rules that give consumers rights about how their data is stored, used, and deleted. This step-by-step GDPR guide for managers is a great place to start understanding it, or for so …

How to Troubleshoot a SQL Server 2016 Migration

Publié le 18 décembre 2017 sur sqlmag.com
 

Why is it important to note the distinction between Enterprise and Enterprise Core editions of SQL Server? Because server utilization depends on which one you install.

A Walk Around SQL Operations Studio

Publié le 18 décembre 2017 sur simple-talk.com
 

As a data person you’ve likely looked, with some envy, at the cool new multiplatform tools Microsoft has released for your developer coworkers. Visual Studio Code, or VS Code, is an open source application which will run on Windows, macOS, and Li …

SQL Server Machine Learning Services – Part 2: Python Data Frames

Publié le 18 décembre 2017 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 If you’ve spent any time with the R language in SQL Server R Services or Machine Learnin …

Redgate data governance survey reveals database DevOps is the key to GDPR compliance

Publié le 18 décembre 2017 sur sqlservercentral.com
 

A major new data governance survey from Redgate demonstrates there are important GDPR compliance issues that need to be addressed – and that a DevOps approach to database development can provide the answers.

Improve Productivity with Collaboration Tools

Publié le 18 décembre 2017 sur sqlservercentral.com
 

In order for your team to be productive, communication and collaboration are essential. Collaboration tools allow you to get the most out of your team members. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Tal …

SQL SERVER – List Users with System Admin (sysadmin) Rights

Publié le 18 décembre 2017 sur journey to sqlauthority
 

One of the pre-requesting of Comprehensive Database Performance Health Check is to check if user has necessary system admin rights or not. It is almost impossible to help customer with SQL Server Performance if they do have a DBA who has access to syst …

Query big data, stored in a csv or parquet files, from any stored procedure

Publié le 17 décembre 2017 sur sqlblog.com
 

Every cloud provider these days have a serverless interactive query service that uses standard SQL for data analysis. As for the biggest cloud providers, we have Azure Data Lake analytics, Google BigQuery and Amazon Athena. Due to the fact that my comp …

How to Kill Processes Idle for X Hours? – Interview Question of the Week #152

Publié le 17 décembre 2017 sur journey to sqlauthority
 

Question: How to Kill Processes Idle for X Hours? Answer: When I heard this question first time, my reaction to this question was why would you ever need to do this for? The answer, I received was that user had so many open connection due to bad . …

[Video] Office Hours 2017/12/13 (With Transcriptions)

Publié le 16 décembre 2017 sur brentozar.com
 

This week Tara, Erik, and Richie discuss virtualization, replication & mirroring, switching SQL service logins to an AD account, temporal tables, tempdb issues, migrating from SQL 2015, and Richie’s outdoor adventures in “Breath of the …

Google Cloud Migration Helps Etsy Tap Machine Learning

Publié le 16 décembre 2017 sur sqlmag.com
 

Etsy says its Google Cloud migration will help engineers focus on product, not on-premise system maintenance.

SQL SERVER – Fix Error – Restore Operation Failed for Database Due to Insufficient Memory in the Resource Pool ‘Default’

Publié le 16 décembre 2017 sur journey to sqlauthority
 

Recently I faced a strange error related to SQL Server, during Comprehensive Database Performance Health Check. The error indeed surprised me because as I have been doing performance tuning consulting for over 10 years, this is the first time I wa …


Pages :