#Python101 with Dominika
Take a look into first article about Python prepared by Dominika. You can find it here.
2019-02-03
60 reads
Blog Posts
Last Week Reading (2019-02-03)
Press Webinar Follow-Up: Top 4 Data Technology Trends for DBAs in 2019 Very interesting discussion panel led by Kevin Kline...
2019-02-03
170 reads
SQLServerCentral SSAS Tabular Series: 5th Article Cleaning Up Dimensions
The fifth article in the SQL Server Analysis Services Tabular Model has been released on SQLServerCentral.com. Please start at the beginning article before reading this one in order to...
2019-02-03
39 reads
SQLServerCentral SSAS Tabular Series: 5th Article Cleaning Up Dimensions
The fifth article in the SQL Server Analysis Services Tabular Model has been released on SQLServerCentral.com. Please start at the...
2019-02-03
181 reads
SQL Server Monitoring: What queries should you monitor?
I previously wrote about measuring wait statistics. This matters a lot, because you can track historically what wait statistics are...
2019-02-02
370 reads
"A connection timeout has occurred on a previously established connection to availability replica"
I previously spent some time troubleshooting this issue at one client, and then having encountered it twice more this year, I figured I'd include it in a blog post....
2019-02-01
6,270 reads
Miscellaneous Notes On System Architecture and Design
When I first joined the programming team at my previous job in an aerospace company, the first observation I made...
2019-02-01 (first published: 2019-01-18)
2,105 reads
Starting a Proof of Concept with SQL Change Automation
One of the ways that you can more easily perform database development tasks is with SQL Change Automation (SCA). This...
2019-02-01 (first published: 2019-01-22)
2,049 reads
Azure Notebooks – a nice little tool.
Gday,
I’ve been playing with Azure notebooks lately and have found them invaluable as
A teaching aidA test sandboxI’ve been using Python...
2019-01-31
1,100 reads
Getting Parameters Out From a Stored Procedure–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2019-01-31 (first published: 2019-01-16)
3,758 reads
Blogs
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Forums
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
Why Your SQL Permissions Disappeared
Comments posted to this topic are about the item Why Your SQL Permissions Disappeared
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