Sites anglophones


BrentOzar.com is Turning 17 Years Old.

Publié le 24 avril 2019 sur brentozar.com
 

I registered it before then, and it used to be a static HTML site, but I consider the birthday to be the first published blog post from May 7, 2002. A few fun stats: 2002 Brent: at home with a Thinkpad with a webcam module on top, reading HAL-PC Magazi …

SQL Server Monitoring Week – SQL Monitor

Publié le 24 avril 2019 sur journey to sqlauthority
 

Today I am starting a week-long series where I will be discussing various SQL Server Monitoring Tools. My primary aim is to help people with my consulting workshop Comprehensive Database Performance Health Check. While I help customers with their vario …

SQL Server Database Users to Roles Mapping Report

Publié le 24 avril 2019 sur sqlservercentral.com
 

The post SQL Server Database Users to Roles Mapping Report appeared first on SQLServerCentral.

5 reasons why backup and restore doesn’t cut it in dev and test

Publié le 24 avril 2019 sur sqlservercentral.com
 

The post 5 reasons why backup and restore doesn’t cut it in dev and test appeared first on SQLServerCentral.

Fixing Performance By Throwing Cloud At It

Publié le 23 avril 2019 sur brentozar.com
 

Your databases are hosted in the cloud – either in VMs or in a database-as-a-service – and you’re having a performance emergency that’s lasted for more than a day. Queries are slow, customers are getting frustrated, and you …

SQL Server Monitoring Week – SQL Diagnostic Manager

Publié le 23 avril 2019 sur journey to sqlauthority
 

Today I am starting a week-long series where I will be discussing various SQL Server Monitoring Tools. My primary aim is to help people with my consulting workshop Comprehensive Database Performance Health Check. While I help customers with their vario …

Its time to accelerate the State of DevOps

Publié le 23 avril 2019 sur sqlservercentral.com
 

The post Its time to accelerate the State of DevOps appeared first on SQLServerCentral.

Compressed Microsoft SQL Server Backups by Default

Publié le 23 avril 2019 sur sqlservercentral.com
 

The post Compressed Microsoft SQL Server Backups by Default appeared first on SQLServerCentral.

Free SQL Server Load Testing Tools

Publié le 22 avril 2019 sur brentozar.com
 

So you wanna run a load test against SQL Server. One thing I need you to understand first: you have to provide the database and the queries. Almost all of the tools in this post, except the last one, are designed to help you run queries, but they don …

SQL Server Monitoring Week – Database Performance Analyzer

Publié le 22 avril 2019 sur journey to sqlauthority
 

Today I am starting a week-long series where I will be discussing various SQL Server Monitoring Tools. My primary aim is to help people with my consulting workshop Comprehensive Database Performance Health Check. While I help customers with their vario …

Service Broker Part 2: Why Service Broker

Publié le 22 avril 2019 sur sqlservercentral.com
 

In the previous article in this series I introduced Service Broker to you. You learned the core concepts of SQL Server Service Broker. You learned how to write simple Service Broker applications that are composed of message types, contracts, queues, an …

Easing the transition from shared to dedicated database development

Publié le 22 avril 2019 sur sqlservercentral.com
 

The post Easing the transition from shared to dedicated database development appeared first on SQLServerCentral.

How to check the ANSI Compatibility of SQL Server Queries? – Interview Question of the Week #221

Publié le 21 avril 2019 sur journey to sqlauthority
 

Question: How to check the ANSI Compatibility of SQL Server queries?Answer: I was totally blown away by this question. I had received this question in my recent Comprehensive Database Performance Health Check, this was indeed extremely unique question …

SQL SERVER – Docker Volume and Persistent Storage

Publié le 20 avril 2019 sur journey to sqlauthority
 

I have received some rave reviews of my article on SQL SERVER – How to Get Started with Docker Containers with Latest SQL Server?. It was amazing to hear that people really get started after reading my article on docker. One of the most popular q …

SQL SERVER – Audit Script to Get CPU and Memory Information with MAXDOP Guidelines

Publié le 19 avril 2019 sur journey to sqlauthority
 

If you are reading this blog regularly the name of Dominic Wirth may not be new for you. He has in the past sent some very interesting scripts for audit for our blog and I am including his new script in this blog which is about how to Get CPU and …


Pages :