Sites anglophones


Personal Technology – Blinking or Flashing Yellow Light in Alexa – Solution

Publié le 22 juin 2019 sur journey to sqlauthority
 

Last week, I have posted on the Saturday blog post which was not related to SQL Server but technology challenge I faced in my daily life. You can read the blog post here: Personal Technology – Bluetooth Volume Problem with Windows Volume Control. …

The End of SQL Server 2008 and 2008 R2 Extended Support

Publié le 21 juin 2019 sur simple-talk.com
 

If you are not already aware, SQL Server 2008 and SQL Server 2008 R2’s extended support will end on 9 July 2019. Microsoft has communicated this end date for a while now, including this announcement with resources on how to migrate from these two …

What the Arrow Sizes in Query Plans Really Mean

Publié le 21 juin 2019 sur brentozar.com
 

Precisely 80.3% of you are going to learn something in this post. Earlier this week, I asked what you thought the arrows in estimated and actual query plans meant. I asked you to just guess without doing any research, and here’s what you answered …

Important Query Store Fixes – Summer 2019

Publié le 21 juin 2019 sur SQLSkills.com - Erin Stellato
 

In January I blogged about important Query Store fixes that were available in current CUs.? Check my January post for fixes through SQL Server 2016 SP2 CU5 and SQL Server 2017 CU13.I’m using this post to track Query Store fixes/enhancements since …

SQL SERVER – DROP Multiple Temp Tables Using Cursors on Azure

Publié le 21 juin 2019 sur journey to sqlauthority
 

Today’s blog post is written based on the comment of SQL Server Expert Ahliana Byrd on the blog post SQL SERVER – How to DROP Multiple Tables Using Single DROP Statement? I request you to read the original blog post to get the context of th …

10 steps you can take to be compliant worldwide – free whitepaper

Publié le 21 juin 2019 sur sqlservercentral.com
 

The post 10 steps you can take to be compliant worldwide – free whitepaper appeared first on SQLServerCentral.

A MongoDB to SQL Server Migration: Data Typing and Un-nesting

Publié le 20 juin 2019 sur simple-talk.com
 

When recently assigned a project to migrate data from MongoDB to SQL Server, my initial concern was my lack of expertise with MongoDB itself. I can say now after completing the project, MongoDB was the absolute least of my worries and certainly not a c …

Troubleshooting a Change in Query Performance

Publié le 20 juin 2019 sur SQLSkills.com - Erin Stellato
 

This is tale of troubleshooting…When you unexpectedly or intermittently encounter a change in query performance, it can be extremely frustrating and troublesome for a DBA or developer. If you’re not using Query Store, a third-party applica …

Techorama Netherlands 2019 – 0 (Zero) to Hero: 21 Essential Performance Scripts for Every DBA #TechoramaNL

Publié le 20 juin 2019 sur journey to sqlauthority
 

I will be visiting Techorama Netherlands and will be presenting my most popular pre-conference on September 30, 2019, at 9:00. The topic of the pre-conference is 0 (Zero) to Hero: 21 Essential Performance Scripts for Every DBA.If you are in Europe and …

Using VMware VMDKs for SQL Server Database Cloning

Publié le 20 juin 2019 sur sqlservercentral.com
 

We live in a virtualized world, and VMware VMDKs are common for hosting SQL Server in many organizations.   Accessing databases in a VMDK, however, to support clonable SQL Server database images is not well documented.   A relativel …

How to provision realistic and compliant data to dev – free whitepaper

Publié le 20 juin 2019 sur sqlservercentral.com
 

The post How to provision realistic and compliant data to dev – free whitepaper appeared first on SQLServerCentral.

SQL SERVER – 5 Performance Optimizations Must Do for TempDB

Publié le 19 juin 2019 sur journey to sqlauthority
 

Today’s post is is build from my 10 minutes conversation with my client while working on Comprehensive Database Performance Health Check. The client had an amazing hardware configuration but their performance was extremely bad. After carefully in …

SandDance in Azure Data Studio

Publié le 19 juin 2019 sur sqlservercentral.com
 

The post SandDance in Azure Data Studio appeared first on SQLServerCentral.

Poll: What Do You Think The Arrow Sizes in Query Plans Mean?

Publié le 18 juin 2019 sur brentozar.com
 

Don’t read the documentation – just guess. What do you think the arrow sizes in query plans mean in SSMS 17/18? After you take the poll – just guess – then you can see what other people think. Friday, I’ll share a demo you …

SQL SERVER – Increasing Speed of CHECKPOINT and Best Practices

Publié le 18 juin 2019 sur journey to sqlauthority
 

I must accept that I would not ask this question to anyone (particularly in the interview), however, I  received this question as a follow up of my earlier blog post which I wrote about SQL SERVER – Impact of CHECKPOINT and DBCC DROPCLEANBUF …


Pages :