Sites anglophones

The SQL Server Features that Time Forgot

Publié le 23 août 2017 sur

SQL Server has been, if nothing else, an evolving data platform, full of features that come and go like celebrity headlines. With each release, components get added, removed, enhanced, forgotten. Many shine bright and stay that way. Others burn out lon …

Installing SQL Server Agent on SUSE Linux

Publié le 23 août 2017 sur

Manvendra Singh explains how to install SQL Server Agent on SUSE Linux server, so that you can create SQL Server Jobs to schedule repetitive work.

SQL SERVER – Learning DATEDIFF_BIG Function in SQL Server 2016

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

One of the T-SQL functions introduced in SQL Server 2016 is DATEDIFF_BIG function. In older versions there is a limit on the return value of DATEDIFF function. The return datatype of INT and the maximum it can have the value 2147483647. It will not ret …

PASS Summit is back! Discover the edition 2017!

Publié le 22 août 2017 sur

The PASS Summit is back! The most important event around the world on Microsoft Data Platform will be held again in Seattle (WA) from October 31 to November 3, 2017 and it will be preceded from two « pre-conference » at October 30th and 31th.Every y …

Upgrading SQL Server– SQL Server Support Dates

Publié le 22 août 2017 sur - glen berry

One valid argument for considering a SQL Server upgrade sooner rather than later is the fact that the version(s) of SQL Server you are using in Production may be out of mainstream or even extended support. But what does that mean exactly? It does NOT m …

Register Now for Next Friday’s Free GroupBy Conference

Publié le 22 août 2017 sur

It’s that time again! Register for free now to attend next Friday, September 1. Here’s the lineup: 8AM Eastern – Why Defragmenting Your Indexes Isn’t Helping – Brent Ozar (@BrentO – 10AM – How to …

How to Find Out Which Database Object Got Deleted

Publié le 22 août 2017 sur

Greg Larsen shows you how to use the Transaction ID value to identify the object_id for a deleted table.

Load Extended Events via Powershell

Publié le 22 août 2017 sur

Learn how you can load Extended Events with PowerShell, nice and fast.

SQL Authority News – Community Hub by Redgate

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

It is not possible that readers of are not aware of the amazing tools built by Redgate. We all know that Redgate builds tool which makes SQL DBA and Developer’s life easier. We can eliminate human errors and improve our …

Upgrading SQL Server– Database Compatibility Levels

Publié le 21 août 2017 sur - glen berry

One important factor to contemplate during an upgrade and migration effort are your database compatibility levels, which control certain database behaviors to be compatible with a particular version of SQL Server. Unlike the database file version (whic …

SQL 101 Learn SQL. Not too much. Mostly online.

Publié le 21 août 2017 sur

I’ve had people ask me how to learn SQL without installing a database. This past Sunday afternoon I saw a packed class of current and aspiring data scientists learn SQL in a great class taught by Ted Petrou . You can indeed learn SQL for free wit …

SQL Server 2017: Potentially Interesting New Extended Events

Publié le 21 août 2017 sur

You still won’t use them And I predict that Extended Events will remain as niche-only use for specific troubleshooting scenarios. Very few monitoring tools use them, and the ones that do still rely on traces and DMV queries for the bulk of their …

Extending DevOps practices to SQL Server databases with Redgate, Git & Jenkins

Publié le 21 août 2017 sur

Join Microsoft Data Platform MVP, Grant Fritchey, for our next Database DevOps demo webinar. He’ll be plugging Redgate’s tools into Git and Jenkins to show you how Redgate’s Database DevOps solution helps you build, test and deploy your dat …

Azure DWH part 14: PolyBase to access to non structured data

Publié le 21 août 2017 sur

In this article, we will learn how to work with PolyBase using Azure SQL DWH.

SQL Server Management Studio – New Feature – Object Explorer Query Tracking

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

A few days ago, I wrote a blog about a new feature in SSMS and I got few emails asking me to share such quick and fresh information. You can read my earlier blog here SQL Download – SQL Server Management Studio (SSMS) – Performance Das …

Pages :