Sites anglophones


How Much Can One Column Change A Query Plan? Part 1

Publié le 5 septembre 2017 sur brentozar.com
 

Beyond Key Lookups I’m going to show you two queries, and two query plans. The two queries are only different by one selected column, but the two query plans are wildly different. Unless I’ve talked to you in the last few days, these may su …

Introduction to Azure Cosmos DB

Publié le 5 septembre 2017 sur sqlservercentral.com
 

Azure Cosmos DB is the latest data service offering from Microsoft. Azure Cosmos DB is a super set of DocumentDB and provides a new set of capabilities. These capabilities make Azure Cosmos DB stand out from other members in the NoSQL database family.

Azure DWH part 15: PolyBase and Azure Data Lake

Publié le 5 septembre 2017 sur sqlservercentral.com
 

In this article, we will learn how to query a csv file stored in the Data Lake using PolyBase.

SQL SERVER – Different Methods to Know COMPATIBILITY LEVEL of a Database

Publié le 5 septembre 2017 sur journey to sqlauthority
 

COMPATIBILITY LEVEL in SQL Server indicates the version of SQL Server with which the database is to be made compatible. Whenever you create a new database, compatibility level is set to that database. Sometimes you may need to change this so that some …

SQL Server Diagnostic Information Queries for September 2017

Publié le 4 septembre 2017 sur sqlskills.com - glen berry
 

On September 1, 2017, Dropbox turned off the sharing feature that I was previously using to host these scripts, which broke hundreds of existing links on my blog. I will be switching to their new sharing method, at least temporarily, until I decide wha …

Protecting production data in non-production environments

Publié le 4 septembre 2017 sur sqlservercentral.com
 

In this article, Grant Fritchey looks at the need to ‘shift left’ the database and associated database testing, while keeping sensitive data secure when it is outside the production environment.

SQL SERVER – Alternative to DBCC INPUTBUFFER – sys.dm_exec_input_buffer

Publié le 4 septembre 2017 sur journey to sqlauthority
 

DBCC INPUTBUFFER has been one of the most popular commands to display the last statement sent from a client to an instance of Microsoft SQL Server. We all have been using it for quite a while. However, this DBCC command showed very little information a …

The 2017 Company Retreat in Photos: Alaska

Publié le 3 septembre 2017 sur brentozar.com
 

For our annual company retreat, we flew to Seattle, boarded the Ruby Princess, and visited Juneau, Skagway, Ketchikan, and Victoria. No stories or explanations – just photos. Enjoy! Ruby Princess in Alaska After kayaking in Chilkoot Lake Lots of …

What does Keyword STATS Indicates in Backup Scripts in SQL Server? – Interview Question of the Week #138

Publié le 3 septembre 2017 sur journey to sqlauthority
 

Question: What does Keyword STATS Indicates in Backup Scripts in SQL Server? Answer: This is a very interesting question. I have seen many DBA using the backup scripts and using the keywords STATS but when I ask them if they really know why they a …

Connect Logic Apps to Data Lake Store using a service principal

Publié le 2 septembre 2017 sur sqlblog.com
 

You can read this blog post at this link: https://jorgklein.com/2017/08/31/connect-logic-apps-to-data-lake-store-using-a-service-principal This blog has moved to www.jorgklein.com There will be no further posts on sqlblog.com. Please update your feeds …

Blog moved!

Publié le 2 septembre 2017 sur sqlblog.com
 

This blog has moved to www.jorgklein.com There will be no further posts on sqlblog.com. Please update your feeds accordingly. For a limited time I will continue to keep sqlblog.com updated by posting a link when I publish new posts on jorgklein.com You …

Using AT TIME ZONE to manipulate and convert time zones

Publié le 2 septembre 2017 sur sqlblog.com
 

I have a series of blogs about temporal tables in SQL Server 2016, which you can see here . However, one thing I never had mentioned was that the Temporal Row Start and End Times are always stored in UTC times (which is generally inconvenient to work w …

SQL SERVER – How to Rename Extention of MDF File? – A Simple Tutorial

Publié le 2 septembre 2017 sur journey to sqlauthority
 

The other day while working with a customer during SQL Server Performance Tuning Practical Workshop, I noticed an MDF file with very strange extensions. When I asked the DBA why they have such a large data file with extension PDF (instead of commo …

Best Practices for SQL Server Backup and Disaster Recovery

Publié le 2 septembre 2017 sur sqlmag.com
 

Sponsored by: IDERA Date: Thursday, September 28, 2017 at 2:00 PM EDT – Duration: 1 hour read more

Troubleshooting SQL Server Performance Problems

Publié le 2 septembre 2017 sur sqlmag.com
 

Sponsored by: IDERA Date: Thursday, October 26, 2017 – Time: 02:00 PM Eastern Daylight Time – Duration: 1 hour read more


Pages :