Sites anglophones


Exporting Stored Procedure Results to a Table

Publié le 24 juin 2019 sur sqlservercentral.com
 

BlitzWho, oh how I love thee!  This stored procedure is, by far, my favorite way of figuring out who is doing what on my servers (so that I can ask why). I recently needed a little bit more out of it, though.  I was working with a vendor who …

Free Webinar: The State of SQL Server Monitoring 2019

Publié le 24 juin 2019 sur sqlservercentral.com
 

The post Free Webinar: The State of SQL Server Monitoring 2019 appeared first on SQLServerCentral.

Database provisioning and containers – can you help?

Publié le 24 juin 2019 sur sqlservercentral.com
 

The post Database provisioning and containers – can you help? appeared first on SQLServerCentral.

What are the Different Types of SQL Server CHECKPOINT? – Interview Question of the Week #230

Publié le 23 juin 2019 sur journey to sqlauthority
 

Question: What are the Different Types of SQL Server CHECKPOINT?Answer: There are four different kinds of checkpoints in SQL Server.CHECKPOINT is the process where the SQL Server engine takes the in-memory dirty pages (the pages which are modified from …

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.


Pages :