Using WGS 84 shape maps in Power BI
(2018-Dec-31) Back in July of 2018, Ontario provincial government of Canada decided to decrease the number of Toronto city wards from 47...
2018-12-31
1,412 reads
Blog Posts
Visualizing Merge Join Internals And Understanding Their Implications
This post is part 2 in a series about physical join operators (be sure to check out part 1 – nested...
2018-12-31 (first published: 2018-12-18)
2,996 reads
…and where’s the second half gone?
I mean, it can’t be that my calendar shows December and the year is almost over? Alright, I see I...
2018-12-30
196 reads
A Better Way to Clean Up the SSIS Catalog Database
Earlier this week, I blogged about the automatic cleanup process that purges old data from the SSIS catalog logging tables. This nightly process removes data for operations that are...
2018-12-30
10 reads
A Better Way to Clean Up the SSIS Catalog Database
Earlier this week, I blogged about the automatic cleanup process that purges old data from the SSIS catalog logging tables....
2018-12-30
353 reads
SQLs Black Box Recorder – sp_server_diagnostics
The diagnostics process will trap various server related health (diagnostics) information related to the SQL Server instance in an effort to try and detect potential failures and errors.
Related Posts:
SQL Servers...
2018-12-30
120 reads
SQLs Black Box Recorder – sp_server_diagnostics
Yesterday i shared the first article in a three part series about the SQL Black Box Recorder, that you can...
2018-12-30
333 reads
Adding a database running in a docker container to SQLTest
in my previous post I wrote about how easy it is to add the tSQLt unit test framework to your...
2018-12-29
451 reads
How to install the tSQLt unit test framework to start unit testing your database code
This blog post describes how easy it is to install the tSQLt framework.
Don’t know much about tSQLt? If you are...
2018-12-29
505 reads
How to use tSQLt unit test framework with a SQL Server database in a docker container
This blog post describes how to add the tSQLt unit testing framework to a database running in a docker container....
2018-12-29
1,455 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 BANK BCA KCU PEMATANG SIANTAR TLP/WA 08218200233
Telp Cs: 08218200233 Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar, Sumatera...
ALAMAT KANTOR BCA KCU ASIA TLP/WA 08218200233
Telp Cs: 08218200233 Jl. Asia, Simpang, Jl. Bakaran Batu No.1 C, Sei Rengas II,...
ALAMAT KANTOR BCA KCU WISMA ASIA TLP/WA 08218200233
Telp Cs: 08218200233 Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, RT.4/RW.9, Kota Bambu...
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