Sites anglophones


What you Need to Know to Successfully Monitor Your SQL Server

Publié le 2 août 2017 sur sqlmag.com
 

Sponsored by: Rapid 7 Date: Tuesday, September 12, 2017 at 12:00 PM EDT – Duration: 1 hour read more

Upgrading SQL Server–Day 1

Publié le 1 août 2017 sur sqlskills.com - glen berry
 

Today is the start of a new series of blog posts about upgrading and migrating to SQL Server 2016/2017 from an older version of SQL Server. It is also my birthday, so I figured it was a good time to start this series! For Day 1, lets talk about why you …

First Response Kit Release: Yukon Ho!

Publié le 1 août 2017 sur brentozar.com
 

We’re going to Alaska this month, so try not to find any bugs, okay? To celebrate, I’m channeling childhood nostalgia, and quoting a verse from one of my many Taco-Bell-dripping-stained Calvin and Hobbes tomes. We’ll never have to cle …

First Responder Kit Release: Yukon Ho!

Publié le 1 août 2017 sur brentozar.com
 

We’re going to Alaska this month, so try not to find any bugs, okay? To celebrate, I’m channeling childhood nostalgia, and quoting a verse from one of my many Taco-Bell-dripping-stained Calvin and Hobbes tomes. We’ll never have to cle …

Pseudonymization and the Inference Attack

Publié le 1 août 2017 sur simple-talk.com
 

Data about people and their activities is passed around for research purposes, and it is important to be able to mine information from this data, in a way that is appropriate and within the legal constraints of the custodianship of personal data. Many …

What is the biggest mistake you made in production?

Publié le 1 août 2017 sur brentozar.com
 

This has been blogged before by several people. One thing I’ve learned from Brent is to not let the fact that the topic has been blogged before stop you from blogging about it. With that out of the way… When you have sysadmin access, you a …

[Video] Last Season’s Performance Tuning Techniques

Publié le 1 août 2017 sur brentozar.com
 

You’re kinda-sorta comfortable doing performance tuning on SQL Server. You’ve read a few blogs, you monitor Page Life Expectancy, you rebuild your indexes, and you add an index here or there. However, you haven’t been to a day-long pe …

New function and the importance of variables in DAX #dax

Publié le 1 août 2017 sur sqlblog.com
 

I recently wrote a few articles about a new function in DAX and the use of variables. For those of you using Power BI or Azure Analysis Services, you always have access to the latest version of the language. Well, in reality I see that new features app …

Using SQL Server Query Hints with Entity Framework

Publié le 1 août 2017 sur simple-talk.com
 

Query Hints should be used carefully, because they restrict the possible optimizations during the query compilation, and they may, later, force the optimizer to use poor strategies when the data changes in size or distribution: There are, however, occa …

Azure DWH part 13: Load data using Data Platform Studio

Publié le 1 août 2017 sur sqlservercentral.com
 

In this article we will load data from a SQL Server on-premises to Azure SQL Data Warehouse

SQL SERVER – Automatic Startup Not Working for SQL Server Service

Publié le 1 août 2017 sur journey to sqlauthority
 

Sometimes some behaviors in SQL Server are unexpected and that’s the right time when an expert need to be engaged. In this blog post we will learn about how automatic startup sometimes does not work in SQL Server Services. One of my client told t …

AMD Ryzen Threadripper HEDT on August 10, 2017

Publié le 1 août 2017 sur sqlskills.com - glen berry
 

If you have been thinking about buying/building a new desktop development/testing machine that has enough resources to run multiple concurrent large virtual machines or a large SQL Server workload, you might want to consider an AMD Ryzen Threadripper-b …

The Basics of Good T-SQL Coding Style – Part 4: Performance

Publié le 31 juillet 2017 sur simple-talk.com
 

The series so far: The Basics of Good T-SQL Coding Style The Basics of Good T-SQL Coding Style – Part 2: Defining Database Objects The Basics of Good T-SQL Coding Style – Part 3: Querying and Manipulating Data The Basics of Good T-SQL Codin …

[Video] Office Hours 2017/07/29 (With Transcriptions)

Publié le 31 juillet 2017 sur brentozar.com
 

This week, Brent, Erik, Tara, and Richie discuss SQL Server performance monitoring, ASYNC_IO_COMPLETION, AWS SQL Server licensing and fees, rebuilding indexes, licensing model for Blitz scripts, stored procedures, using (or not using) primary key on a …

Microsoft Centralizes Online Product Documentation

Publié le 31 juillet 2017 sur sqlmag.com
 

Microsoft Centralizes their Online Product Documentation and Forums Microsoft Corporation has now provisioned a new portal for all their application/framework documentation and are also placing the ability to add to that content at your fingertips. The …


Pages :