Daily Coping 18 Nov 2022
Today’s coping tip is to be creative, cook, draw, write, paint, make, or inspire. While I do play some guitar, I’m not much for painting. Certainly I write a...
2022-11-18
14 reads
PASS Summit 2022 - Day 2 In Pictures
Day 2 of Summit 2022 started earlier than usual with the "Breakfast with the Microsoft team: SQL Futures and Strategy" - the food was good and the conversations with...
2022-11-30 (first published: 2022-11-18)
226 reads
In SQL Server 2022, set your transaction log file autogrowth rate to 64 MB
A late-breaking change that arrived in SQL Server 2022 is an important one that could be a new line item in your health checks.
The basics:
Starting with SQL Server 2022,...
2022-11-30 (first published: 2022-11-17)
586 reads
2022 PASS Data Community Summit Recap: Power BI Meets Programmability – XMLA, TOM, C#
Thank you to everyone who made it out to PASS Data Community Summit! I have greatly enjoyed meeting so many fellow data nerds and have learned so much from...
2022-11-18 (first published: 2022-11-17)
22 reads
SQL Server 2022 is Here!
SQL Server 2022 becoming generally available was announced on Nov 16th 2022. This is the most Azure-enabled release of SQL Server yet, which is pretty exciting. A major Azure-enabled...
2022-11-17
29 reads
#PASSDataSummit – Keynote 2 Live Blogging
Happy to be chosen to live blog the keynote events out at the PASSDataSummit in Seattle, Washington this week. This page will be updated through the Keynotes, all you...
2022-11-17
16 reads
Daily Coping 17 Nov 2022
Today’s coping tip is to try out a new way of being physically active. My routine for physical activity is yoga 2-3 times a week, weight lifting a couple...
2022-11-17
22 reads
How to Install SQL Server 2022
SQL Server 2022 has been released! In this blog post, I’ll walk you through how you can install the latest version of SQL Server on your machine. I’ll be...
2022-11-28 (first published: 2022-11-17)
3,637 reads
T-SQL Tuesday #156 - Wrap Up
Foreword
Thank you everyone for participating! There is a total of 15 submissions and thanks to them, I’ve widened my perspective.
The order of the posts is chosen at random.
Greg Moore
Contribution|Blog|Twitter
Greg...
2022-11-17
25 reads
PASS Summit 2022 - Day 1 In Pictures
The first "full" day of PASS 2022 kicked off with a bang when Rohan Kumar (@RohanKData) stepped out on the keynote stage to announce SQL Server 2022 was GA...
2022-11-25 (first published: 2022-11-17)
233 reads
Blogs
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...
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Forums
Upgrade 2016 Standard to 2022 Express
Title pretty much says it all - can this be done? I've tried several...
BIT_COUNT II
Comments posted to this topic are about the item BIT_COUNT II
I Can't Make You Learn
Comments posted to this topic are about the item I Can't Make You Learn
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