Sites anglophones


SQL Clone on your Laptop

Publié le 25 juin 2019 sur sqlservercentral.com
 

The post SQL Clone on your Laptop appeared first on SQLServerCentral.

All flash vs adaptive flash storage – which is right for my organisation?

Publié le 25 juin 2019 sur sqlservercentral.com
 

In the last few years, flash storage technology has made significant strides towards becoming a widely accessible mainstream option for IT administrators from companies of all sizes. Once considered an expensive niche option limited to elite-performanc …

Displaying the Object Explorer Details Pane in SQL Server Management Studio

Publié le 25 juin 2019 sur sqlservercentral.com
 

The post Displaying the Object Explorer Details Pane in SQL Server Management Studio appeared first on SQLServerCentral.

Brace Yourself for These 9 Database Horror Stories

Publié le 24 juin 2019 sur brentozar.com
 

Last week, I asked for your worst database horror stories. Hoowee, did you deliver. Make yourself a nice cup of cocoa, gather around the campfire, and listen up for these terrible tales. Illustrations courtesy of Swear Trek (not safe for work.) The mis …

SQL Saturday Prague 2019 – Pre-Con: 21 Essential Scripts: Performance Tuning for EVERYONE

Publié le 24 juin 2019 sur journey to sqlauthority
 

I will be visiting SQL Saturday Prague 2019 and will be presenting my most popular pre-conference on September 20, 2019, at 9:00. The topic of the pre-conference is 21 Essential Scripts: Performance Tuning for EVERYONE.If you are in Europe and have nev …

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.


Pages :