Sites anglophones


Azure DWH part 16: BCP to import and export data

Publié le 26 septembre 2017 sur sqlservercentral.com
 

In Azure SQL Data Warehouse we can use BCP to export or import the data. In this article, we will show how to do it.

SQL SERVER – Select Unique Data From a Column Exist in Two Different Table

Publié le 26 septembre 2017 sur journey to sqlauthority
 

If you have not understood what I am going to talk in this blog post by just reading the title, I think you are a normal human like me. Just the other day I received an email from a blog reader with subject line as “Select Unique Data From a Colu …

First Look at Azure Data Factory V2 Preview

Publié le 25 septembre 2017 sur sqlmag.com
 

This week at Ignite 2017 in Orlando, Microsoft announced Azure Data Factory V2 with new features including Control Flow, VNET support, On-Demand Spark execution and SSIS in the cloud. This is a first look at ADF V2. This week at Ignite 2017 in Orlando, …

#PASSSummit Expert Performance Tuning Pre-Con: Stretch Goals

Publié le 25 septembre 2017 sur brentozar.com
 

Sure, they look trustworthy Eric and I are doing a PASS Summit pre-con class called Expert Performance Tuning for SQL Server 2016 & 2017. To encourage signups, we’re giving every attendee a free Enterprise/Everything Bundle, plus some other s …

[Video] Office Hours 2017/09/20 (With Transcriptions)

Publié le 25 septembre 2017 sur brentozar.com
 

This week, Brent, Tara, Richie, and Erik discuss a most excepted solution for SA and securing an instance, how many VLFs should a database have, merge replication issues, query tuning tips, database restores, and Larry Ellison’s self-driving data …

Announcing More Online SQL Server Classes

Publié le 25 septembre 2017 sur brentozar.com
 

Our recent class lineup did pretty well, so now we’ve got a new round: Always On Availability Groups: The Senior DBA’s Field Guide with Edwin Sarmiento – December 20-22, $2,995 – Learn clustering, design, topologies, readab …

When sp_HelpText is not so helpful!

Publié le 25 septembre 2017 sur sqlservercentral.com
 

A note of caution on the use of sp_helptext to script out objects.

SQL SERVER – Simple Explanation of AT TIME ZONE Feature

Publié le 25 septembre 2017 sur journey to sqlauthority
 

Recently I received a simple question about AT TIME ZONE feature. This is the new feature which is introduced in SQL Server 2016 and later version of the SQL Server. As this is a relatively new feature the adoption of this feature is also a bit sl …

The Guide to Learning PowerShell

Publié le 24 septembre 2017 sur sqlmag.com
 

Learn how to start using PowerShell with this ebook. It covers almost any question you may have regarding PowerShell and its applications. This guide to learning PowerShell presents a wide range of topics which will leave you with an abundance of knowl …

How to Kill User Sessions (SPID) in SQL Server? – Interview Question of the Week #140

Publié le 24 septembre 2017 sur journey to sqlauthority
 

Question: How to Kill User Sessions (SPID) in SQL Server? Answer: Before I answer this question, I need to ask one more question – “Why do you want to kill all of the user sessions in your SQL Server?” Honestly, I do not see any …

SQL Saturday Parma is back! #sqlsat675

Publié le 24 septembre 2017 sur sqlblog.com
 

Another SQL Saturday has been scheduled in Parma (Italy), it’s the SQL Saturday #675 and this year it will be more international than the previous editions because there will be six sessions completely in English (= 1 « virtual » track in English). …

SQL SERVER – The Operating System Returned the Error 21(The Device is Not Ready.) While Attempting ‘GetDiskFreeSpace’ on ‘A:’

Publié le 23 septembre 2017 sur journey to sqlauthority
 

I always try to keep myself up-to-date with new released of SQL Server. This blog is part of my learning, while using SQL Server 2017, which I always share with my blog readers. This is the error related to Error 21 about a device not ready. Note: I am …

Key Lookups and ColumnStore Indexes

Publié le 22 septembre 2017 sur brentozar.com
 

Beavis v. Butthead I was a bit surprised that this was a possibility with ColumnStore indexes, since “keys” aren’t really their strong point, but since we’re now able to have both clustered ColumnStore indexes alongside row stor …

SQL SERVER – New DMV in SQL Server 2017 – sys.dm_os_enumerate_fixed_drives. A Replacement of xp_fixeddrives

Publié le 22 septembre 2017 sur journey to sqlauthority
 

Looking at the way SQL has evolved, there are changes coming up in SQL Server 2017 which would help it run on Windows and Linux platforms. Let us learn about dm_os_enumerate_fixed_drives. There are some new learnings which I have as I played with …

Answering Questions For Fun And No Profit

Publié le 21 septembre 2017 sur brentozar.com
 

I love answering questions about SQL My forum of choice is dba.stackexchange.com because I find the voting and point system with badges for being a decent internet person addictive. If you like more traditional forums, SQLServerCentral.com has a lot of …


Pages :