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.
Using Triggers to Replace Scalar UDFs on Computed Columns
Using Triggers to Replace Scalar UDFs with Brent Ozar.
Presenting the Facts about Data Breaches
If you're faced by an investigation team, after a data breach, it is no use putting on your 'Mr. Sincerity' face and making vague statements. They want documented facts.
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.
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.
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.
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 […]
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
Alamat Kantor Bank BCA KCU KEDIRI Telp:08218154393
WA:08218154393 Jl. Brawijaya No.8, Pocanan, Kec. Kota, Kota Kediri, Jawa Timur 64123
Alamat Kantor Bank BCA KCU MALANG Telp:08218154393
WA:08218154393 Jl. Jenderal Basuki Rahmat No.70-74, Klojen, Kec. Klojen, Kota Malang, Jawa Timur 65111
SSRS Reminded Me of the Time Microsoft Retired TMG
Comments posted to this topic are about the item SSRS Reminded Me of the...
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers