Securing Secrets in Azure DevOps
Azure DevOps tasks often contain sensitive credentials and secrets that need to be appropriately secured and in this article I demonstrate how to implement different options.
2020-11-13
Articles
SQL Monitor 11.0: Monitor SQL Servers hosted on Amazon RDS
We’ve just released SQL Monitor 11.0, and for this latest version we partnered with Amazon AWS to let you monitor SQL Severs hosted on Amazon RDS. You can monitor these alongside your on-premises and other cloud-based servers, instances, and databases, giving you visibility in a single pane of glass. Version 11.0 also introduces new advanced tempdb monitoring metrics, and significant performance improvements.
2020-11-13
How to simulate Case statement in Azure Data Factory (ADF) compared with SSIS?
This post will describe how you use a CASE statement in Azure Data Factory (ADF). If you are coming from SSIS background, you know a piece of SQL statement will do the task. However let's see how do it in SSIS and the very same thing can be achieved in ADF. Problem statement For my […]
2020-11-12
22,472 reads
Checking the pulse of Kubernetes
In this article, Michael Sorens describes the many ways that you can monitor Kubernetes.
2020-11-12
Creating a SQL Code Snippet in SQL Prompt and SSMS
Phil Factor's "getting started" guide for turning all your trusted and most frequently used queries into SQL code snippets.
2020-11-12
Bridging the divide between Data Management and DevOps
The speed, flexibility and collaboration of DevOps can be difficult to achieve against the rigid schemas, manual processes, and silos in the world of data management. Join Microsoft Data Platform MVP, Grant Fritchey to discover the key strategies you can implement to bridge the divide between data management and DevOps in your organization.
2020-11-11
Free eBook: Understanding SQL Server Concurrency
When you can’t get to your data because another application has it locked, a thorough knowledge of SQL Server concurrency will give you the confidence to decide what to do.
2020-11-11 (first published: 2013-07-17)
106,148 reads
SQL Server Clustered Index Fragmentation on GUID Columns
In this article we take a look at using GUID columns in your SQL Server database tables and the impact GUID columns may have on indexing.
2020-11-11
Block user objects from being created in a master database
Introduction The Master database. Just in case that you are not familiar with this database, the Master database is used in SQL Server to store all the system information, instance-level settings, logon information, database file locations, etc. SQL Server can't run without access to a fully functional master database. It's highly recommended not to use […]
2020-11-10
4,060 reads
Storage 101: Monitoring storage metrics
Well tuned storage is essential for SQL Server performance. In this article, Robert Sheldon explains the metrics that are important to watch.
2020-11-10
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Foreach Loop still executes after process and delete all the folders
I have two challenges XML source control not displaying the XML file parent node...
Which 'Where' statement conditional upon a variable
Thanks in advance for any clues on this. I am trying to write a...
Backup to Immutable Storage
Comments posted to this topic are about the item Backup to Immutable Storage
Question of the Day
Backup to Immutable Storage
In SQL Server 2025, a backup can be made on Azure Immutable Storage. What changes in how the backup is created?
See possible answers