Sites anglophones


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 …

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

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

Should You Enforce Foreign Key Relationships in the Database?

Publié le 1 septembre 2017 sur brentozar.com
 

It’s one of those fierce religious wars that divides families and tears loved ones apart. First, if two tables are related, should we tell SQL Server about it? If SQL Server knows that there’s a relationship, then it can make better decisio …

Learning designed for the data professional

Publié le 1 septembre 2017 sur sqlservercentral.com
 

– PASS Summit offers five educationally-packed days lead by highly-rated, experienced speakers and sessions focused on the way you work with data. Speaker highlights include Bob Ward, and Sunil Agarwal from the Microsoft Tiger Team. Join us Oct 31 to N …

SQL SERVER – How to Install SQL Server Management Studio (SSMS) From Command Line?

Publié le 1 septembre 2017 sur journey to sqlauthority
 

SQL Server Management Studio (SSMS) has been removed from the product release cycle. Now SSMS is shipped as a free tool and doesn’t need to have set up media to install. Earlier I wrote a blog which you can read below. SQL SERVER – Installi …

Upgrading SQL Server– Intel Xeon-W Family

Publié le 31 août 2017 sur sqlskills.com - glen berry
 

On August 30, 2017, Intel released their new Intel Xeon Processor W Family of one-socket workstation processors (hence the W) based on the Skylake-SP Xeon server processors. These processors are meant as a replacement for the older one-socket Intel Xeo …

Upgrading SQL Server– Database Experimentation Assistant

Publié le 31 août 2017 sur sqlskills.com - glen berry
 

Another useful, if somewhat complicated, free tool from Microsoft is the Database Experimentation Assistant (DEA). Microsoft released DEA version 2.1 on July 25, 2017, with many new improvements over the earlier preview versions as detailed here. Here …

First Responder Kit Release: Fully Hand Automated

Publié le 31 août 2017 sur brentozar.com
 

Did you know there are more issues closed in this FRK than there are planets in this solar system? Special thanks to Pluto for making that statement possible, and all the other planets that didn’t form. Also thanks to @mches for making …

SQL Code Smells

Publié le 31 août 2017 sur simple-talk.com
 

Table of Contents Introduction 1. Problems with Database Design 1.1. Packing lists, complex data, or other multivariate attributes into a table column 1.2. Using inappropriate data types 1.3. Storing the hierarchy structure in the same table as the ent …


Pages :