Using Azure Blueprints to deploy Azure SQL Server and Database with Key Vault Secrets
The post Using Azure Blueprints to deploy Azure SQL Server and Database with Key Vault Secrets appeared first on SQLServerCentral.
Configure SQL Server on Ubuntu 16.04 to use Active Directory Authentication
In this article, we will review how to join a Ubuntu 16.04 server to a Microsoft Active Directory Domain, install SQL Server, and configure the SQL Server on Ubuntu 16.04 to use Microsoft Active Directory Authentication. The following are the step …
The Curious Case of… almost online index rebuilds
(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 …
Nonclustered Primary Key – SQL in Sixty Seconds #119
One of my clients of Comprehensive Database Performance Health Check recently faced a very interesting situation. I will describe the situation in detail a bit later on during this blog post. Today we are going to learn that it is possible to have a no …
Introduction to Analyzing Waits using SQL Monitor
The post Introduction to Analyzing Waits using SQL Monitor appeared first on SQLServerCentral.
How to Use Parameters in PowerShell Part II
The post How to Use Parameters in PowerShell Part II appeared first on SQLServerCentral.
Downloading a CSV File from an API Using Azure Data Factory
Azure Data Factory has two different connectors that can copy data from APIs. Originally, there was only the HTTP connector. The REST connector was added later. Although there are situations where either connector would work for copying data, there are …
When was Stored Procedure Last Compiled? – Interview Question of the Week #292
Question: When was Stored Procedure Last Compiled?Answer: Honestly, it is difficult to figure out when was the stored procedure last compiled. As a matter of fact, SQL Server does not keep this information out in the public, that is why I understand. H …
Recent Execution of Stored Procedure – SQL in Sixty Seconds #118
What I enjoy the most is working with different clients on Comprehensive Database Performance Health Check. Every client is different and what I learn from every organization is different. Recently, I had a very interesting experience with a clie …
Full-Screen Execution Plan – SQL in Sixty Seconds #117
I spend my most of time in a day helping client improve their SQL Server Performance at Comprehensive Database Performance Health Check. The biggest performance improvement we often get by tuning the server configuration, and database deployment. Howev …
Transfer data from SQL Server to MySQL
The post Transfer data from SQL Server to MySQL appeared first on SQLServerCentral.
[Video] Office Hours: Open Q&A About SQL Server
Office Hours Podcast For those of you who miss our old Office Hours webcasts and feel lonely during the quarantines, I’m doing my part to help with free weekend webcasts. For the next couple of Saturday & Sunday mornings from 6AM-8AM Pacific …
Recover Crashed Query in SSMS – SQL in Sixty Seconds #116
Has it ever happened to you when you are working on a large SQL Server query and suddenly your SQL Server Management Studio (SSMS) crashes? Honestly, it has happened to me quite many times and it is indeed frustrating. Today we will learn about how we …
Installing PostgreSQL 11 on Windows with Step-by-step Instructions
PostgreSQL is a free database management system (DBMS). PostgreSQL 11 is the new version of this DBMS. We will take a look at how to install PostgreSQL 11 on Windows. This article covers where to download PostgreSQL 11, how the installation proces …
How do You Identify Object Dependencies in SQL Server
The post How do You Identify Object Dependencies in SQL Server appeared first on SQLServerCentral.