Sites anglophones

Stellar SQL Database Toolkit – review no 2

Publié le 30 mars 2016 sur

Hello SQL Folks. Being a MVP gives me the chance to freely use and test some fancy tools and this time I would like to share my thoughts about one of such.  Today I would like to bring your attention to the Stellar SQL Database Toolkit. What is St …

SQL Server 2016 Query Store: How to fix problems you face for slow running queries

Publié le 30 mars 2016 sur

This article allows us to focus on a new feature of SQL Server 2016 known as Query Store. We will talk about performance issues related to the query plan choice change and how the Query Store can help us to identify queries that have become slower. …

Announcing Biml Academy!

Publié le 30 mars 2016 sur

Announcing Enterprise Data & Analytics Biml Academy – 5 Days of Free Training – 9-13 May! Welcome to Biml Academy! Join me for a five-day online event and learn Biml now ! Biml Academy – Lesson 0 – SSIS Design Patterns …

The Recording for DILM with SSIS Catalog Compare is now Available

Publié le 30 mars 2016 sur

The recording for the (free!) Enterprise Data & Analytics webinar “ DILM with Catalog Compare ” is now available. Registration is required. Enjoy! :{>…(read more)

Indexes Helping Indexes

Publié le 30 mars 2016 sur

This post isn’t going to solve any problems for you It was just something I stumbled on that struck me as funny, while working on a demo for something else. Brent didn’t believe it at first, so I thought I’d share with the class. Blog …

Getting started with the SSIS Script Task

Publié le 30 mars 2016 sur

The SSIS Script Task allows you to add functionality to your SSIS package that does not already exist with the other predefined tasks. In this article, Daniel Calbimonte looks at how to get started using the SSIS Script Task with a few examples.

Stairway to Advanced T-SQL Level 2: Using the APPLY Operator

Publié le 30 mars 2016 sur

The APPLY operator allows you to join a record set with a function, and apply the function to every qualifying row of the table (or view). The APPLY operator takes on two formats: CROSS APPLY, or OUTER APPLY. This article will explain the differences b …

SQL SERVER – How to Query Active Directory Data Using ADSI / LDAP Linked Server

Publié le 30 mars 2016 sur journey to sqlauthority

There are situations when you need to integrate SQL Server with other product. Once of the classic example was seen during my last visit to a client. They wanted list of email addresses and phone numbers for all users in the company to be fetched by Ac …

Psst… Hey buddy, you want some E-Discovery?

Publié le 29 mars 2016 sur

One year ago today! Well, sort of one year ago. Who knows when this thing will get published? Only God and Brent. And part of the calendar year fell during a leap year, which was just plain cruel, like a two part Buffy episode where the second part is …

Introduction to Protecting SQL Server with Azure Site Recovery

Publié le 29 mars 2016 sur

Microsoft cloud platform allows you to provide resiliency for your on-premises SQL Server deployments. Marcin Policht describes this functionality, available as part of the Azure Site Recovery solution.

Two Things I Would Change in SSISDB Setup

Publié le 29 mars 2016 sur

I suggest these two changes to the SSISDB setup to prevent issues down the road. Free eBook – Performance Tuning with DMVsThis free eBook provides you with the core techniques and scripts to monitor your query execution, index usage, session and transa …

Webinar – Redgate DLM Demo (with TFS, TFS Build & Microsoft Release Management)

Publié le 29 mars 2016 sur

Redgate’s Arneh Eskandari and Microsoft SQL Server MVP, Steve Jones, will show you how Redgate’s DLM (Database Lifecycle Management) solution works to improve your database development and deployment processes. Today 12noon EDT

SQL SERVER – How to Add Multiple New Columns to Table with Default Values?

Publié le 29 mars 2016 sur journey to sqlauthority

This is a follow up blog post of my earlier blog post on the same subject. You can read my earlier blog post over here. I recently received an email where a user asked how to add more than one new column to an existing table with a default value. Very …

Announcing the SQL Server Theme Song Winners

Publié le 28 mars 2016 sur

We asked you to pick theme songs to play when SQL Server has issues, and holy cow, you sent in a ton of submissions. We couldn’t possibly pick just one in each category, so each of us picked our own winners – all of whom get a free tra …

Trigger Happy

Publié le 28 mars 2016 sur

This article looks at using triggers to audit and to prevent the performing of unintended actions.

Pages :