Getting Started with SQL Server Azure Container Instances ACI
Learn how to quickly deploy a new SQL Server instance on Azure using Azure Container Instances ACI.
SQL Compare 14 now available on Linux
The latest version of SQL Compare now offers a Command Line Interface on Linux for the first time. Now teams can benefit from the industry standard tool for comparing and deploying SQL Server databases, whether they choose to work on Windows, Linux, or both.
A Spectacular Case of 100% CPU Caused by Online Reindexing
An investigation of a serious performance issue during online re-indexing on a production server leads us to
interesting discoveries and solutions.
Very Hot Patches
Azure SQL Database can be patched without stopping the sqlsrvr.exe process. Quite a feat of engineering.
Implementing SQL Server Integration Services with Azure Data Factory
Azure SQL Database, unlike its on-premises counterparts, restricted its integration capabilities to those implemented directly by the database engine. To remediate this shortcoming, Microsoft provided equivalent functionality by relying on integration runtime of Azure Data Factory. In this article, you get an overview of this Azure-based SSIS offering.
Integrating SQL Server Tools into SQL Change Automation Deployments
Phil Factor shows how to integrate use of SQL Change Automation, SSMS registered servers, SMO, and BCP to automatically build or update a database on all servers in a group.
6 steps to a more secure SQL database
Security is often something people think about only after they have had a problem. Given that the average cost of a data breach is $3.92 million (SecurityIntelligence 2019) and ransomware attacks have increased 97% over the past 2 years (PhishMe 2019), the "if it's not broke, don't fix it" approach can clearly be catastrophic. Here […]
T-SQL Context Switching
Being a standards advocate, Steve has a few thoughts on team code structure.
DevOps Self-Service for Databases with SQL Clone
Phil Factor describes the freedom of being able to "self-serve" databases, during testing and development, and explains how it works with SQL Clone.
How to Use Parameters in PowerShell
Every DBA should have basic PowerShell skills. In this article, Greg Moore explains how to write a PowerShell script that takes parameters.
Blogs
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers