SQL Server and AKS
Following on from my last post after creating AKS, I now want to work with SQL server. First step, load up Azure cloud shell. Run the following commands Here...
2021-07-29
52 reads
Blog Posts
SQL Server on Linux Storage Secrets on Microsoft Channel 9
I’m thrilled to have recently released a video with Microsoft’s Data Exposed on Channel 9 where I discuss setting up Linux storage appropriate for on-demand disk expansion for your...
2021-07-29
94 reads
Thoughts on Unique Resource Names in Azure
Each resource type in Azure has a naming scope within which the resource name must be unique. For PaaS resources such as Azure SQL Server (server for Azure SQL...
2021-07-29
55 reads
Accessibility in your PowerPoint slide deck
This post is part of the series I kicked off here. You can read my post about captions here. Let’s talk about slides! Many of us are familiar with...
2021-07-28
20 reads
Building a Basic Desktop Flow with Power Automate Desktop
In this video Devin covers the the beginning design of a Power Automate Desktop Flow that will be used over the course of the next
2021-07-28 (first published: 2021-07-15)
563 reads
Daily Coping 28 Jul 2021
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...
2021-07-28
37 reads
Nonclustered index leaf records always contain a null bitmap – since SQL 2012
While testing a script that involved calculating index record size recently I was getting some confusing results depending on server version, and after some digging it appears there was...
2021-07-28
10 reads
Nonclustered index leaf records always contain a null bitmap – since SQL 2012
While testing a script that involved calculating index record size recently I was getting some confusing results depending on server version, and after some digging it appears there was...
2021-07-28
69 reads
T-SQL Tuesday #140 Wrap up: What have you been up to with containers?
I want to start by saying thank you to all who submitted, and an amazing collection of people submitted some fantastic content. Also, thanks to Steve for asking me...
2021-07-28 (first published: 2021-07-17)
414 reads
Using Framing for a Running Total–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I’ve been writing about window functions, which I...
2021-07-28
43 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat Kantor BCA KCU KUDUS Telp:0817839777
WhatsApp: 0817839777 Jl. Jend. Ahmad Yani No.91, Magersari, Panjunan, Kec. Kota Kudus, Kabupaten Kudus,...
Alamat Kantor BCA KCU SEMARANG Telp:0817839777
WhatsApp: 0817839777 Jl. Pemuda No.90-92, Kembangsari, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50133
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers