Data Cleansing with the SSIS Data Flow
A webinar from MVP Brian Knight and Pragmatic Works this week will help you learn how to clean up data and apply business rules in your data flows.
Electronic Health Records – What’s the Big Deal? (Part 1)
Last week, I had lunch with an old friend who is, by his own definition, technologically ignorant. While we caught up, he asked me to explain in terms he could understand what I do for a living. I went through one of my spiels (the one usually..
Using The Transfer Jobs Task in SQL Server Integration Services
Database Administrators can use the Transfer Jobs Task to transfer one or more SQL Server Agent Jobs between different SQL Server instances
Being Around Smart People is Exciting
Steve Jones has attended a lot of conferences, including one recently in Austin. With the PASS Summit and SQL Connections coming up soon, he shares some reasons why a conference can be a great way to spend your training money.
Being Around Smart People is Exciting
Steve Jones has attended a lot of conferences, including one recently in Austin. With the PASS Summit and SQL Connections coming up soon, he shares some reasons why a conference can be a great way to spend your training money.
Being Around Smart People is Exciting
Steve Jones has attended a lot of conferences, including one recently in Austin. With the PASS Summit and SQL Connections coming up soon, he shares some reasons why a conference can be a great way to spend your training money.
Being Around Smart People is Exciting
Steve Jones has attended a lot of conferences, including one recently in Austin. With the PASS Summit and SQL Connections coming up soon, he shares some reasons why a conference can be a great way to spend your training money.
Kimball University: Six Key Decisions for ETL Architectures
Best-practice advice on software vs. coding, where to integrate, how to capture changed data, when to stage data, where to correct data and what latency levels to shoot for.
SQL Server Consolidation
In the crusade to cut expenses, Data Centres (and IT Infrastructure) are now coming under scrutiny as a possible source of savings. Half-informed executives now rally behind the cry of "Virtualization!", but virtualization is only part of the story - The tip of the consolidation iceberg - and it might not actually save you as much as you think. Thomas LaRock takes us deeper.
SQL Server Legend – Data Files and Threads
Someone was asking about using multiple data files recently to try and increase performance. I had answered that unless you...
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