Sites anglophones


New course: Understanding and Using Azure SQL Database

Publié le 20 avril 2017 sur sqlskills.com - paul randall
 

And to coincide with our new training class on Azure, we’ve just published a new Pluralsight course on Azure too! Tim’s latest Pluralsight course – SQL Server: Understanding and Using Azure SQL Database – and …

Top SQL Server Database Management Challenges

Publié le 20 avril 2017 sur sqlmag.com
 

Sponsored by: Pure Storage Date: Tuesday, May 23, 2017 at 12:00 PM EDT – Duration: 1 hour read more

Is it ever worth adding indexes to table variables?

Publié le 20 avril 2017 sur brentozar.com
 

Disclaimer I found this totally by accident, and it even surprised me. You can probably guess the TL;DR on this is yes, huh? Dude, where’s my table variable? I was trying to come up with a demo for something totally different. Don’t ask. Se …

Performance Tuning Using Extended Events: Part 1

Publié le 20 avril 2017 sur sqlservercentral.com
 

In this article, learn how to identify performance tuning opportunities using Extended Events.

The right way to approach a legacy code base

Publié le 20 avril 2017 sur sqlservercentral.com
 

Andrea Angella shares what he learned from attending Michael Feather’s workshop on working effectively with legacy code.

SQL SERVER – FIX: The SQL Server Failed to Initialize VIA Support Library [QLVipl.dll]

Publié le 20 avril 2017 sur journey to sqlauthority
 

My every interaction with client teaches me something new. Recently someone contacted me through email and informed that they have issues with SQL Server Startup. When we checked ERRORLOG, we found below messages at the end of the ERRORLOG where Via Su …

New class: Immersion Event on Upgrading SQL Server

Publié le 20 avril 2017 sur sqlskills.com - paul randall
 

We have a second exciting new class debuting this October in Chicago: Immersion Event on Upgrading SQL Server. It’s a 3-day class, taught by Glenn Berry and Tim Radney. We’ve seen a huge surge in clients upgrading from out-of-support v …

New class: Immersion Event on Azure SQL Database and Azure VMs

Publié le 20 avril 2017 sur sqlskills.com - paul randall
 

We have a really cool new class debuting this October in Chicago: Immersion Event on Azure SQL Database and Azure VMs. It’s a 2-day class, taught by Tim Radney. Azure is getting more and more popular, and we’re seeing many cl …

SQL Server 2017–all sessions from Microsoft Data Amp are online! Complete list of links!!!

Publié le 20 avril 2017 sur sqlblog.com
 

Hello I have just gathered all sessions (deep dive ones) that you might have seen live on 4/19. Look how many sessions are there!!!! Security on Linux with Tommy Mullaney – http://bit.ly/2onopRi Build globally-scaled mobile apps in minutes with Kirill …

What’s new in SQL Server 2017 CTP 2.0 for Analysis Services

Publié le 19 avril 2017 sur sqlblog.com
 

Today is a great day. I have been able to take part in the #MSDataAmp conference. While listening to Scott Guthrie I found that SQL Server 2017 CTP 2.0 is available for download I like to way Microsoft changes the Analysis Services engine over the time …

Wanna speak at the PASS Summit? Here’s how.

Publié le 19 avril 2017 sur brentozar.com
 

The PASS Summit is the biggest SQL Server community event, and a lot of us speakers have “present at PASS” on their bucket list. Getting in is legendarily difficult because competition is fierce. Many sessions are submitted for ea …

Using and optimizing DirectQuery in #powerbi and #ssas #tabular

Publié le 19 avril 2017 sur sqlblog.com
 

More than one year ago, I and Alberto Ferrari started to work on DirectQuery, exploring the new implementation appeared in Analysis Services 2016 for the Tabular models, which uses the same engine of Power BI. The previous version of DirectQuery appear …

Package Parts – First Impressions

Publié le 19 avril 2017 sur sqlservercentral.com
 

This article gives an overview of some good and not-so-good features of SSIS package parts.

SQL SERVER – Msg 3035, Level 16 – Cannot Perform a Differential Backup for Database “SQLAuthority”, Because a Current Database Backup Does not Exist

Publié le 19 avril 2017 sur journey to sqlauthority
 

If we look at the error in the subject line, it is very clear that a full backup is needed so that the differential backup chain can be initiated. If this happens to a newly created database, then it makes sense and there is no need for me to write a b …

Speaking at the Nashville SQL Server User’s Group on April 28th.

Publié le 19 avril 2017 sur sqlblog.com
 

And they say you can’t go home again.. On the 28th of April I will be returning back to my old home of Nashville to speak at the Nashville SQL Server User’s Group. (And where I moved to was very near the home I lived in when I was in high school.) The …


Pages :