What’s next?
As I’m sure a fair number of you already know I was told my position had been eliminated. They are ... Continue reading
2022-06-21
347 reads
Scary Scalar Functions - Part One: Parallelism
Foreword
I’m still surprised many people don’t realise how lousy Scalar functions (aka User Defined Functions aka UDFs) are. So because it’s my current focus in work and this Stack...
2022-06-21
42 reads
How to Reset the SA Password When Locked Out
Getting locked out of a SQL Server instance can happen due to a number of situations. The most common scenario I’ve encountered is when a SQL Server is moved...
2022-06-21
29 reads
Including reference data into a database deployment process or passing lookup tables to Production
(2022-Jun-20) As it takes a village to raise a child, it also takes a team to develop a good SQL Server database project. Previous efforts to maintain manual or custom SQL...
2022-07-13 (first published: 2022-06-20)
1,186 reads
Daily Coping 20 Jun 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-06-20
44 reads
New in SQL Server 2022 – Generate_Series
One of the new language features added in SQL Server 2022 is the GENERATE_SERIES function. This allows you to generate a SELECT * FROM GENERATE_SERIES(start=1, stop=7) This gives me...
2022-06-20
517 reads
T-SQL Tuesday 151 Round up: Coding Standards
I received a great collection of blog posts in response to my T-SQL Tuesday 151 – asking people to write on T-SQL Coding Standards. Rob Farley (t|b) is of...
2022-07-04 (first published: 2022-06-17)
660 reads
Daily Coping 17 Jun 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-06-17
49 reads
Power BI Field Parameters and Slowly Changing Dimensions
Power BI field parameters are a new feature in Power BI Desktop, and it’s one of the best of the past months. In short, Power BI field parameters allow...
2022-06-17
133 reads
VS Live Slides and Code
Thanks to everyone that came to my talk at VS Live today. I’ve uploaded the slides to the blog. Here are the two decks: Using CI To Prevent Database...
2022-06-16
37 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 MALANG WA {08218154393}
WA:08218154393 Jl. Jenderal Basuki Rahmat No.70-74, Klojen, Kec. Klojen, Kota Malang, Jawa Timur 65111
Alamat Kontak Bank BCA KCP Bantul WA {08218154393}
WA:08218154393 JL. JENDRAL SUDIRMAN NO. 18A RT.007 RW.000, BANTUL WARUNG, DESA. KEL. BANTUL, KEC....
Alamat Kantor BCA KCP Bantul WA(082144477715)
WhatsApp:0821-4447-7715 JL. JENDRAL SUDIRMAN NO. 18A RT.007 RW.000, BANTUL WARUNG, DESA. KEL. BANTUL, KEC....
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