Sites anglophones


SQL Server Trace Flags – Complete list

Publié le 23 février 2017 sur sqlservercentral.com
 

Article in markdown format: https://github.com/ktaranov/sqlserver-kit/blob/master/SQL%20Server%20Trace%20Flag.md

Performance Surprises and Assumptions : GROUP BY vs. DISTINCT

Publié le 23 février 2017 sur sqlservercentral.com
 

Aaron Bertrand acknowledges that DISTINCT and GROUP BY are usually interchangeable, but shows there are cases where one performs better than the other.

SQL SERVER – Improve Application Performance on Cloud While Reducing Bandwidth Cost

Publié le 23 février 2017 sur journey to sqlauthority
 

It is very common for people to move databases now a days to the cloud. The very first question I often hear from them is – How to Improve Application Performance on Cloud While Reducing Bandwidth Cost? However, once the data is moved to any …

Let’s Corrupt a SQL Server Database Together, Part 1: Clustered Indexes

Publié le 22 février 2017 sur brentozar.com
 

Hold my beer. CREATE DATABASE [50Ways]; GO ALTER DATABASE [50Ways] SET PAGE_VERIFY NONE; /* Normally a bad idea */ GO USE [50Ways]; GO CREATE TABLE [dbo].[ToLeaveYourLover]([Way] VARCHAR(50)); GO INSERT INTO [dbo].[ToLeaveYourLover]([Way]) VALUES (‘Sli …

Latest SQL Server 2014 CU Updates

Publié le 22 février 2017 sur sqlblog.com
 

  Microsoft released a few more Cumulative Updates for SQL Server 2014 as listed below. There are a number of interesting fixes so I highly recommend if you have SQL Server 2014 to take a look at the list of hotfixes included in each update. SQL 2 …

Presenting Use Biml to Automate SSIS Design Patterns at SQL Saturday–Richmond!

Publié le 22 février 2017 sur sqlblog.com
 

I’m honored to present Use Biml to Automate SSIS Design Patterns at SQL Saturday – Richmond 18 Mar 2017! The Biml Express Metadata Framework is the sample code for this presentation. It’s part of the DILM Suite . I hope to see you in …

Questions About the Use of PowerShell That you were Too Shy to Ask

Publié le 22 février 2017 sur sqlservercentral.com
 

Let’s forget the actual PowerShell code for a moment: Why is PowerShell important? Why should I use it? Where did it come from? Why did it take so long to arrive? These and many other basic questions are answered in William Brewer’s latest addition to …

Stairway to Exploring Database Metadata Level 7: Extended Properties

Publié le 22 février 2017 sur sqlservercentral.com
 

In this level, I’ll introduce Extended Properties. As with the previous levels, I want to illustrate as much as possible with practical and immediately useful code.

Apache Zeppelin 0.7 for SQL Server

Publié le 22 février 2017 sur sqlblog.com
 

During the weekend I’ve updated my SQL Server interpreter for the amazing Apache Zeppelin to be compatible with the latest version — 0.7— that has been released just couple of days ago: Apache Zeppelin Release 0.7.0 This new release h …

My Journey to CrossFit Level 1 Trainer (CF-L1) Credential

Publié le 22 février 2017 sur journey to sqlauthority
 

Yes, it is true! I Earned CrossFit Level 1 Trainer (CF-L1) Credential. Fitness is a journey and can’t be a destination. Just like every other journey, milestones are very important in the journey of the fitness as well. They help us to dwell …

Mark as Date table in Power BI #dax #powerbi

Publié le 22 février 2017 sur sqlblog.com
 

One year ago I wrote an article describing how the time intelligence DAX functions work in Power BI. In a recent event in Sydney I observed a strange (or at least unexpected) behavior of Power BI during a demo, and I think it is interesting to sha …

SQL Server 2014 Service Pack 2 Cumulative Update 4

Publié le 22 février 2017 sur sqlskills.com - glen berry
 

Microsoft has released SQL Server 2014 Service Pack 2 Cumulative Update 4, which is Build 12.0.5540.0. There are 30 hotfixes in the public fix list. In my opinion, you should be on the SP2 branch by now. If you have not made that move, you should be ma …

Crappy Missing Index Requests

Publié le 21 février 2017 sur brentozar.com
 

When you’re tuning queries It’s sort of a relief when the first time you get your hands on it, you get the plan and there’s a missing index request. Even if it’s not a super high-value one, something in there is crying for help. …

Presenting Use Biml to Automate SSIS Design Patterns at SQL Saturday–Raleigh!

Publié le 21 février 2017 sur sqlblog.com
 

I’m honored to present Use Biml to Automate SSIS Design Patterns at SQL Saturday – Raleigh 11 Mar 2017! You can download the sample code for this presentation at the DILM Suite website here . I hope to see you in Raleigh! :{> Learn More: …

Getting Started with Azure SQL Data Warehouse – Part 1

Publié le 21 février 2017 sur sqlservercentral.com
 

As the demand for data analytics grows so does the need for a technology or platform to process large amounts of different types of data in timely manner. Azure SQL Data Warehouse is a new enterprise-class, elastic petabyte-scale, data warehouse servic …


Pages :