Sites anglophones


New HP Spectre x360 Laptop

Publié le 25 avril 2019 sur sqlskills.com - glen berry
 

IntroductionEarlier this week, I bought a new HP Spectre x360 13-AP0023DX convertible laptop at Best Buy. I have often criticized Best Buy as a bad place to buy a computer, but in this case I ignored my own advice for some good reasons. First, this was …

SSMS v18 and Azure Data Studio: The Golden Age of SQL Server Tooling

Publié le 25 avril 2019 sur brentozar.com
 

Yesterday, SQL Server Management Studio 18.0 shipped. Here’s the official announcement, the download page, and the release notes. Yes, it’s still free, and yes, they’re still adding features. Yes, they removed database diagrams and th …

SQL Server Monitoring Week – Spotlight Cloud

Publié le 25 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 …

Tracking the number of active sessions on a database using SQL Monitor

Publié le 25 avril 2019 sur sqlservercentral.com
 

The post Tracking the number of active sessions on a database using SQL Monitor appeared first on SQLServerCentral.

Using Backup Encryption with an External Certificate

Publié le 25 avril 2019 sur sqlservercentral.com
 

As security becomes more and more important to data professionals, one of the more basic things a DBA or sysadmin must do is protect the backup files for their databases. SQL Server provides a few ways to encrypt backups, and there are numerous third p …

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 …


Pages :