Execution Plan Properties
I’ve watched several people recently go straight to XML when reading execution plans because they didn’t know about the execution plan properties in the first operator. Now, don’t get...
2022-03-14
37 reads
Execute SQL Scripts on Snowflake using Azure Data Factory
Azure Data Factory has a new activity introduced this week (around the 10th of March 2022 for you future readers): the Script activity! This is not to be confused...
2022-03-13
52 reads
Using Azure Blob Storage in Power Automate
In this video, Devin you will learn how to setup an Azure Blob Storage account and then use it in Power Automate. With Power Automate
2022-03-28 (first published: 2022-03-11)
580 reads
How to find tables with 0 records using space
This is a follow up post to the previous one about tables with no records using data space, with the idea coming from twitter of all places. Sometimes on...
2022-03-11
139 reads
Daily Coping 11 Mar 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-03-11
28 reads
Space Invaders on Kubernetes
A while ago I blogged about an awesome Chaos Engineering tools built by Eugenio Marzo (t) call KubeInvaders. Since then Eugenio has updated the repo to make it easier...
2022-03-25 (first published: 2022-03-10)
273 reads
Database Code Reviews
I’ll be honest, ever since I did a SQL Homework about doing code reviews I’ve wanted to do a blog ... Continue reading
2022-03-10
13 reads
Database Code Reviews
I’ll be honest, ever since I did a SQL Homework about doing code reviews I’ve wanted to do a blog ... Continue reading
2022-03-10
139 reads
Snowflake Integration to Azure AD
Azure Active Directory is Microsoft Azure’s identity and access management providing authentication and authorization mechanism for internal and external applications in Azure ecosystem. With AD(more...)
The post Snowflake Integration to...
2022-03-10
71 reads
ETL v ELT
This is part of a series on my preparation for the DP-900 exam. This is the Microsoft Azure Data Fundamentals, part of a number of certification paths. You can...
2022-03-09
64 reads
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 CILACAP Telp:08218154393
WA:08218154393 Jl. Jend. Ahmad Yani No.118, Sidakaya Dua, Sidakaya, Kec. Cilacap Sel., Kabupaten Cilacap,...
SSRS Reminded Me of the Time Microsoft Retired TMG
Comments posted to this topic are about the item SSRS Reminded Me of the...
Getting results from a Procedure to join to a query
I have a need to execute a stored procedure and return the results to...
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