Speaking at SQL Saturday Boston 2023
I’m heading to Boston next week for SQL Saturday Boston 2023. I went to this event last year and I’m glad to be going again. It’s a great event,...
2023-10-03
21 reads
Blog Posts
Common Mistakes in SQL Server – Part 3
Last week we discussed advantages of recompilation in Common Mistakes in SQL Server – Part 2. This week in this article Common Mistakes in SQL Server - Part 3 I...
2023-10-02
44 reads
Decimal Display in Power Query
Introduction
Power Query is a versatile tool found in both Power BI and Excel, facilitating data transformation and manipulation. Despite its efficiency in numerous data tasks, managing decimal values can...
2023-10-02 (first published: 2023-09-07)
527 reads
How to curb aggressive parallelism in Microsoft SQL Server
Microsoft SQL Server, like most modern database systems, can convert a query into a set of parallel instructions to improve efficiency. This is map-reduce before map-reduce was a popular...
2023-10-02 (first published: 2023-09-06)
469 reads
How to Fix Some Common MySQL Database Import Errors: A Comprehensive Guide
While working with WordPress and MySQL databases, users might occasionally encounter import errors during site migration. These errors may compromise the integrity of the database and disrupt the site’s...
2023-10-02
239 reads
Speaking at SQL Saturday Boston 2023
I’m happy to announce that I will be speaking at SQL Saturday Boston on October 14th, 2023. This year’s session is Answering the Auditor’s Call with Automation
As DBAs, we’re...
2023-10-02
22 reads
A New Word: Ghough
ghough – n. a hollow place in your psyche that can never be filled; a bottomless hunger for more food, more praise, more attention, more affection, more job, more...
2023-09-29
56 reads
Friday Flyway Tips: More Config Options
Working with various Flyway configuration options used to be a pain since they were either CLI parameters or in a text files. We’ve made editing these easier in Flyway...
2023-09-29 (first published: 2023-08-25)
143 reads
Temporal Table Data Fixes
I found myself in a situation where I needed to modify temporal tables. We do this outside business hours because we don’t want clients changing data while versioning is...
2023-09-29 (first published: 2023-09-05)
609 reads
T-SQL Tuesday: Encryption and Data Protection
I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any doubt that’s for October 2023, I’m posting this invitation a little early as I got...
2023-09-29
35 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Want to look at cloud reporting but not sure what the costs will be?
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
ALAMAT BCA KCP Saharjo Tlp,Cs:0821-8154-393
WA:08218154393 Jl. Dr. Saharjo No.149 G-H, RT.5/RW.4, Manggarai Sel., Kec. Tebet, Kota Jakarta Selatan,...
BCA KCU BLOK A CIPETE Tlp,Cs:0821-8154-393
WA:08218154393 Jl. RS. Fatmawati Raya No.6 A, RT.1/RW.5, Cipete Sel., Kec. Cilandak, Kota Jakarta...
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers