SQL Server Automatic Tuning in the Real-World
In SQL Server 2016 we saw Query Store. Query Store was a game changer to help database administrators identify troublesome...
2018-09-19 (first published: 2018-09-10)
2,959 reads
Blog Posts
Three skills to look for in a technology partner
SQL Treeo’s founder and CEO, Danny Riebeek, reflects on his 20+ years in the IT industry. Q: What prompted you...
2018-09-19
285 reads
What is Projectsv13 in SQL Change Automation?
I got this question recently from someone that was evaluating the SQL Change Automation client in Visual Studio. After setting...
2018-09-19
1,719 reads
Why Customers Are Looking At Azure
As a Principal Consultant with Pragmatic Works, I have many conversations with customers about moving to Azure. As a Consulting...
2018-09-19
318 reads
Announcing the 5th Edition of SQL Server 2017 Query Performance Tuning
I am quite excited to announce that the latest, most up to date, and by far the largest, copy of...
2018-09-18
332 reads
Are scalar functions really a bad thing?
I’ve read a lot of things lately pointing to scalar functions as if they were the devil. In this blog...
2018-09-18 (first published: 2018-09-10)
4,021 reads
Calculating Quartiles with DAX and Power BI
Like many of my blog posts, this post is inspired by some work I was doing with a customer who...
2018-09-18 (first published: 2018-08-31)
4,123 reads
Check if any database has auditing configured
Here is a DMV script to check whether a or any database has the auditing configured and running, along with...
2018-09-18
749 reads
ExpressRoute and VPNs in Azure
In this edition of Azure Every Day, I’d like to discuss networking and interacting between your data center and Azure....
2018-09-18
243 reads
Extracting JSON Values Longer Than 4000 Characters
Watch this week's video on YouTube
A while back I built an automated process that parses JSON strings into a relational format.
Up until recently this process had been working great:...
2018-09-18
9 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 BCA KCU BENGKULU TLP/WA 08218154374
Hub Cs:08218154374 Jl. S. Parman No.66, Kebun Kenanga, Kec. Ratu Agung, Kota Bengkulu, Bengkulu...
ALAMAT BCA KCU BUKITTINGGI TLP/WA 08218154374
Hub Cs:08218154374 Jl. Sudirman No.59, Bukit Cangang Kayu Ramang, Kec. Guguk Panjang, Kota Bukittinggi,...
ALAMAT KANTOR BCA KCU PADANG TLP/WA 08218154374
Hub Cs:08218154374 Jl. H. Agus Salim No.10 A, Sawahan, Kec. Padang Tim., Kota Padang,...
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