Introduction to the Cosmos DB Emulator
The post Introduction to the Cosmos DB Emulator appeared first on SQLServerCentral.
DBA Walkthrough – Adding space on IBM AIX Power Machines
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
The post Bringing certainty to the uncertainty of Brexit appeared first on SQLServerCentral.
Does the Rowmodctr Update for Non-Updating Updates?
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)
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?
The post Testing Databases: What’s Required? appeared first on SQLServerCentral.
Creating Aliases for Docker Commands in Linux
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
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
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
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
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)
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
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?
(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
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 …