Sites anglophones

What’s New in SQL Server 2016 Integration Services

Publié le 26 août 2016 sur

With all of the other new features in SQL Server 2016, it’s easy to overlook the enhancements that Microsoft has made to SQL Server Integration Services (SSIS). First introduced with SQL Server 2005, SSIS replaced the earlier Data Transformation …

SQL Server 2014 Service Pack 2 CU1 is Available

Publié le 26 août 2016 sur - glen berry

On August 25, 2016, Microsoft released SQL Server 2014 Service Pack 2 CU1, which is build 12.0.5511.0. This cumulative update has 45 hotfixes in the public fix list. If you are running SQL Server 2014, this is the branch and build that you should try t …

Using Index Operational Stats to Drill Into High Latch and Lock Waits

Publié le 26 août 2016 sur

Part Two of a series on dm_db_index_operational_stats If analysis of your SQL Server’s wait stats shows high levels of latch or lock waits how do you know which indexes are to blame so you can zero-in on troubleshooting and tuning? read more

Import data from Azure SQL to Tabular Databases

Publié le 26 août 2016 sur

Daniel Calbimonte shows how to create an Azure SQL Database with the AdventureworksLT data, and how to import the information into a SQL Server Analysis Services Tabular Model Database.

Query Performance Tuning – A Methodical Approach

Publié le 26 août 2016 sur

Learn how to approach performance tuning in this piece from SQL Server MCM and MVP, Gail Shaw.

Restore or Attach Database Without Log File – SQL in Sixty Seconds #082

Publié le 26 août 2016 sur journey to sqlauthority

One of the most common question I get on blog is – how do I attach database without log file. I have previously blogged about it over here. I request you to read this blog post if you want a solution where you can learn how to attach database to …

Predicates With Subqueries

Publié le 25 août 2016 sur

You’ve probably read that SQL is a language based on sets and predicates. Well, that sounds impressive but what does it really mean? It means that we ought to have some predicates that use sets as their operands. And we do; but a lot of them are …

Bad Idea Jeans Week: Dynamically Generating 999 Indexes on a Table

Publié le 25 août 2016 sur

Let’s say, just theoretically, you wanted to demo a query that takes SQL Server a long time to compile. And in order to make SQL Server’s job tougher, you wanted to create the maximum number of indexes possible on a table. You might do some …

SQL Server for Linux

Publié le 25 août 2016 sur

On March 7, 2016, Microsoft announced that it was bringing SQL Server to Linux, the operating system they once disparaged but which over the years has proven too big a thorn for Microsoft to ignore. This isn’t the first time that Microsoft h …

SQL Server Access Control: The Basics

Publié le 25 août 2016 sur

No technology yet invented can in any way allow us to neglect the task of ensuring the security of the database by controlling access. Security must be applied in depth, and the database is designed provide a system that will thwart even the most deter …

Using Microsoft R in Enterprise Environments

Publié le 25 août 2016 sur

This article talks about using the the positive aspects of setting up R in enterprise environment and give instructions on first steps how to do it.

SQL SERVER – Fix Error – Cannot use the backup file because it was originally formatted with sector size 4096 and is now on a device with sector size 512

Publié le 25 août 2016 sur journey to sqlauthority

Here is a recent email which I received from Madhu. He is a beginner in the SQL Server and when he tried to take a backup from SSMS (SQL Server Management Studio), he got error related to backup file. As soon as he sent me an email I knew what was the …

Data Tales #10: A Matter of Existence

Publié le 24 août 2016 sur

Hi Folks, I’ve been continuing with my Data Tales series up at This time I’ve written about a pet hate: seeing code that counts rows when all it needs to do is to check for existence. However, all is not as bad as it seems becau …

DATA TALES #10: It’s a Matter of Existence

Publié le 24 août 2016 sur

I regularly see code that calculates a count of a set of rows then makes a decision that’s based on the count, but only on whether or not the count is zero. Consider this (slightly contrived) example based on AdventureWorks: Note the query plan t …

Bad Idea Jeans Week: Dynamically Generating Long Queries

Publié le 24 août 2016 sur

As part of an experiment, I needed to build a really long query. (Don’t ask.) From another recent experiment, I know that SQL Server won’t let a query return more than 65,535 columns. I set about writing a one-line query that would ret …

Pages :