Giving Computers Ethics
There is a need to ensure we decide what ethics a computer system ought to have.
Introduction to Attribute Relationships in SSAS
In this article, you will learn how you can set the attribute relationships between dimensions in SSAS.
Storage 101: The Language of Storage
Robert Sheldon continues his series on storage. This article covers some of the basics of performance metrics, HDDs, and SSDs.
Personal Power
Because of my job with Redgate (which I love and will never leave even after I’m dead), I spend a lot of time learning about compliance and all the new laws and regulations coming out of things like the GDPR and the CCPA (they changed the name evidently). However, I’m a nerd. I’m not a […]
Incremental Package Deployment – A SSIS 2016 Feature
This article provides step by step instructions to deploy individual SSIS packages in a project deployment model.
Changing SET options in a Procedure or Trigger leads to Recompilation (PE012)
Phil Factor delves into SQL Prompt's performance rule, PE012, which will advise you if it detects the use of the SET statements within a stored procedure or trigger, which might cause unnecessary recompilations, though the issue extends to other types of batches.
Performance Tuning Means 3 Things
Brent Ozar discusses performance tuning and how From the outside it looks more complicated than it is, but at the end of the day, it always comes back to just 3 knobs and knowing which ones you can turn.
Introduction to PIVOT operator in SQL
Learn how to use the PIVOT operator in SQL in a step-by-step manner.
Efficient Solutions to Gaps and Islands Challenges
Window functions are useful for solving many SQL queries. In this article, Ed Pollack demonstrates how they can be used to analyse baseball winning streaks.
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
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...
BCA KCU SOLO SLAMET RIYADI Tlp:0817839777
WhatsApp: 0817839777 Jl. Brigjen Jl. Slamet Riyadi No.3, Kauman, Kec. Ps. Kliwon, Kota Surakarta,...
Alamat BCA KCU PURWOKERTO Telp:0817839777
WhatsApp: 0817839777 Jl. Jend. Sudirman No.391 A, Brubahan, Purwanegara, Kec. Purwokerto Tim., Kabupaten Banyumas,...
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