Sites anglophones


How Redgate helped define a truly automated database deployment process

Publié le 18 mai 2017 sur sqlservercentral.com
 

At the end of 2016, Redgate interviewed Bob Walker, a Lead Application Developer, to find out how he went about setting up automated database deployments using Redgate tools, and also to find out what lessons he learned during the process – the highlig …

SQL SERVER – FIX: Msg 35250, Level 16, State 7 – The Connection to the Primary Replica is Not Active. The Command Cannot be Processed

Publié le 18 mai 2017 sur journey to sqlauthority
 

Along with my performance consulting, I also assist many clients in fixing some quick issue. You can refer for various consulting services which I provide. This blog is an outcome of one such engagement where the client has deployed standalone SQL …

BI Beginner: Simple X-Y Plot

Publié le 17 mai 2017 sur sqlblog.com
 

When I worked for Microsoft giving presentations on data platform products, it was a common occurrence to have people tell me that they didn’t know how to use Power BI. This is the first in a series of posts showing how to do simple, useful tasks …

New class: Immersion Event on Clustering and Availability Groups

Publié le 17 mai 2017 sur sqlskills.com - paul randall
 

We have a third exciting new class debuting this October in Chicago: Immersion Event on Clustering and Availability Groups. It’s a 2-day class, taught by Jonathan Kehayias, our resident expert on all things AlwaysOn. We’ve seen a huge surge …

SQLskills SQL101: Why is restore slower than backup

Publié le 17 mai 2017 sur sqlskills.com - paul randall
 

As Kimberly blogged about recently, SQLskills is embarking on a new initiative to blog about basic topics, which we’re calling SQL101. We’ll all be blogging about things that we often see done incorrectly, technologies used t …

Presenting Use Biml to Automate SSIS Design Patterns at SQL Saturday Dublin 17 Jun!

Publié le 17 mai 2017 sur sqlblog.com
 

I am honored to present Use Biml to Automate SSIS Design Patterns at SQL Saturday 620 – Dublin 17 Jun! Abstract Perhaps you’ve heard the buzz about Business Intelligence Markup Language (Biml) and wondered, “Why is everyone so excited …

Adaptive Joins And Scalar Valued Functions

Publié le 17 mai 2017 sur brentozar.com
 

I know, I know Here we are in 2017, which means we’re about two years away from the next Ska revival effort, if my watch is correct. I hope it isn’t, but since Brent sent it to me with a note that says “please stop blogging” and …

The Road to Database CI

Publié le 17 mai 2017 sur sqlservercentral.com
 

One firm’s journey on the road to mastering (or at least attempting) continuous database integration.

Cardinality Estimation for a Predicate on a COUNT Expression

Publié le 17 mai 2017 sur sqlservercentral.com
 

Paul White takes you on an optimizer journey, exploring how SQL Server comes up with cardinality estimates for COUNT queries.

Do you use Visual Studio Code?

Publié le 17 mai 2017 sur sqlservercentral.com
 

Visual Studio Code is rapidly gaining in popularity, but is it all it could be, or is there room for improvement? Redgate is embarking on some research to better understand how you are using this lightweight editor, and where it can be improved. Have y …

My Journey to CrossFit Level 2 Trainer (CF-L2) Credential – Level Up

Publié le 17 mai 2017 sur journey to sqlauthority
 

Yes, it is true! I Earned CrossFit Level 2 Trainer (CF-L2) Credential. As I mentioned in my earlier post My Journey to CrossFit Level 1 Trainer (CF-L1) Credential, fitness is a journey and can’t be a destination. Just like every other j …

In The Cloud: The Importance of Being Organized

Publié le 16 mai 2017 sur sqlblog.com
 

People often ask me about learning how to use Azure SQL Database as well as many other Azure products. If you want to learn, you’ve got to have an Azure account. Get one for free or use your personal or corporate MSDN account. Where I see people …

Guidance for WannaCrypt/WannaCry Attacks

Publié le 16 mai 2017 sur sqlskills.com - glen berry
 

There has been quite a bit of media coverage about the WannaCrypt/WannaCry ransomware over the past several days. Microsoft has a new page with information about this particular issue and steps that can be taken to protect your systems. I have also col …

Presenting A Day of Intelligent Data Integration Precon at SQL Saturday Dublin!

Publié le 16 mai 2017 sur sqlblog.com
 

I am honored to present my day-long precon titled SSIS Design Patterns and Biml: A Day of Intelligent Data Integration at SQL Saturday 620 – Dublin 15 Jun 2017! Description What is Intelligent Data Integration? SSIS packages developed using tried …

SQL Server 2017: Interleaved MSTVFs Vs Inline Table Valued Functions

Publié le 16 mai 2017 sur brentozar.com
 

But is it faster? Now, I know. There are very few “always” things out there in SQL Server. This is also true for functions. A lot of the time — I might even say most of the time, inline table valued functions are going to be faster th …


Pages :