Sites anglophones


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 …

In Search of Elasticity

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

An Evaluation of the Azure SQL Database Ecosystem.

SQL SERVER – Error 17113, Severity: 16 – Error Occurred While Opening File ‘master.mdf’ to Obtain Configuration Information at Startup

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

While playing with my SQL Server startup parameter, I made some mistakes and came to a situation where SQL Server was not getting started. In this blog post, let us learn about error 17113. Whenever you have a situation where SQL is not getting started …

Fixing the Query Optimizer Cost Model

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

The model for the cost of operations used by the SQL Server query optimizer to produce an execution plan is rather simple. It has been largely unchanged since SQL Server version 7, RTM in 1998. Back then, SQL Server had not yet achieved tier 1 status w …

It’s now easier to read the BrentOzar.com archives by category.

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

With fifteen years of blog posts, we’d accumulated a lot of junk around here. “Did I really write a blog post about buying pantyhose for turtles?” Recently we cleaned out a lot of the trash – old personal posts about boring stuf …

Creating SSIS Packages with the SQL Server Import and Export Wizard

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

This material was originally posted on the Linchpin People blog . In this post, I demonstrate how to use the SQL Server 2012 Import and Export Wizard to create a SQL Server 2012 Integration Services (SSIS 2012) package. The demo is created on a virtual …

[Video] Office Hours 2017/02/15 (With Transcriptions)

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

This week, Erik, Tara, and Richie discuss tempdb etiquette for developers, elastic search vs full-text search, server CPU spiking issues, source control in a database project, querying transaction logs, and more. Here’s the video on YouTube: You …

New CREATE OR ALTER statement in SQL Server 2016 SP1

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

Ahmad Yaseen explains what SQL Server 2016 SP1’s new CREATE OR ALTER statement does, and how to use it. 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 an …


Pages :