Bridging the Divide between Data Management and DevOps
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-16
Articles
Using Triggers to Replace Scalar UDFs on Computed Columns
Using Triggers to Replace Scalar UDFs with Brent Ozar.
2020-11-16
A Quick Start to Running Python Code in SQL Server
With the addition of Python to Machine Learning Services in SQL Server 2017, you can now execute your Python code inside of SQL Server.
2020-11-13 (first published: 2019-04-18)
35,919 reads
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
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
21,899 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
Blogs
Have a Plan for Your Personal Downtime
By Brian Kelley
Most of us know that spending a lot of time on social media and...
Monday Monitor Tips: Lots of Postgres Options
By Steve Jones
Redgate Monitor is growing to include more than just Microsoft SQL Server monitoring. We...
Advice I Like: Experience and Aptitude
By Steve Jones
Experience is overrated. Most breakthrough accomplishments were done by people doing them for the...
Forums
Issues with SQL Server 2022 Server
Hello, At my work place I recently migrated our test environment to SQL Server...
Remote query is taking 99% cost of local sp execution
So we have local sp in which remote table is udpated.this remote query part...
Question of the Day
Data API Builder APIs
What formats of API endpoints can the Data API Builder present to clients when exposing the database?
See possible answers