Sites anglophones


Introduction to the Cosmos DB Emulator

Publié le 21 mai 2019 sur sqlservercentral.com
 

The post Introduction to the Cosmos DB Emulator appeared first on SQLServerCentral.

DBA Walkthrough – Adding space on IBM AIX Power Machines

Publié le 21 mai 2019 sur sqlservercentral.com
 

Editor’s Note: While this doesn’t mention SQL Server, as we can now run the platform on Linux, we thought this might be an interesting look at the process of adding disk space on a Unix platform. SQL Server does not run on Unix, but Linux is similar to …

Bringing certainty to the uncertainty of Brexit

Publié le 21 mai 2019 sur sqlservercentral.com
 

The post Bringing certainty to the uncertainty of Brexit appeared first on SQLServerCentral.

Does the Rowmodctr Update for Non-Updating Updates?

Publié le 20 mai 2019 sur brentozar.com
 

Get Notebook – FAQ Okay, look, it’s a mouthful of a blog post title, and there are only gonna be maybe six of us in the world who get excited enough to check this kind of thing, but if you’re in that intimate group, then the title …

SQL SERVER – Fix Error – Login failed for user. Reason: Server is in script upgrade mode. Only administrator can connect at this time. (Microsoft SQL Server, Error: 18401)

Publié le 20 mai 2019 sur journey to sqlauthority
 

I recently had a very simple and interesting error received while I was working with Docker and Persistence Storage for my upcoming SQL Server Performance Tuning Practical Workshop. The error was related to script upgrade mode and the fix was extremely …

Testing Databases: What’s Required?

Publié le 20 mai 2019 sur sqlservercentral.com
 

The post Testing Databases: What’s Required? appeared first on SQLServerCentral.

Creating Aliases for Docker Commands in Linux

Publié le 20 mai 2019 sur sqlservercentral.com
 

Introduction There are situations when we need to execute the same command line instruction over and over again,  it becomes worse if the command in question has arguments, furthermore if we are forced to modify the output to make it readable. Mos …

When Was SQL Server Last Restarted? – Interview Question of the Week #225

Publié le 19 mai 2019 sur journey to sqlauthority
 

Question: When Was SQL Server Last Restarted?Answer: This is the first question I always ask during my Comprehensive Database Performance Health Check. The system restart date is very important to know but even more so, I always want to know when was S …

Docker – Running SQL Server Image Without Running Pull Command

Publié le 18 mai 2019 sur journey to sqlauthority
 

I have been using Docker for a while to run the latest CTP of SQL Server 2019 and it has been so far amazing ride to use the product. Every time when new CTP is released, I learn something new with Docker. This time I learn that I can just run SQL Serv …

SQL Server Diagnostic Information Queries for May 2019

Publié le 17 mai 2019 sur sqlskills.com - glen berry
 

This month, I have just made some minor improvements to most of the query sets, mainly in the comments and documentation. I have also been working on the Azure SQL Database version of the queries lately.I have a T-SQL script that you can use to check w …

Streamlining a Power BI Solution

Publié le 17 mai 2019 sur simple-talk.com
 

Self-service business intelligence is everywhere these days. It helps organizations or departments get started with business intelligence quickly. All they need is a data dump in an Excel file, and a tool that would create magic out of it. And there yo …

SQL SERVER – Download and Install SQL Server Sample Database (Updated Post for 2019)

Publié le 17 mai 2019 sur journey to sqlauthority
 

My primary task is to do consultation for SQL Server Performance Tuning. I help people to tune their SQL Server. If you have any Performance Tuning problem, I would have seen it in the past and most probably I know the solution as well. While doing the …

Azure SQL Elastic Pools and SQL Monitor

Publié le 17 mai 2019 sur sqlservercentral.com
 

The post Azure SQL Elastic Pools and SQL Monitor appeared first on SQLServerCentral.

The Curious Case of… does SQL Server use a read/write thread per LUN?

Publié le 16 mai 2019 sur sqlskills.com - paul randall
 

(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working …

Building SQL ConstantCare®: Letting You Mute Recommendations

Publié le 16 mai 2019 sur brentozar.com
 

When we first launched SQL ConstantCare®, I saw it as a mentoring service, not a monitoring service. I wanted to give you advice that I’d learned the hard way across managing lots of systems. With that in mind, I told users as they came onboa …


Pages :