31 Days of SSIS – The Introduction
31 Days of SSIS
Last year, Glenn Berry (Blog | @GlennAlanBerry) wrote a series of posts that he called A DMV A...
2011-01-01
2,305 reads
Blog Posts
Easy CDC part 2: Automating a Quick Initial Load, and Some Gotchas
Introduction
A couple of weeks ago I made this post about quickly building a CDC system against a vendor ERP database....
2011-01-01
1,337 reads
January Question: As a DBA, how do you manage your disk space?
Managing disk space is an important responsibility of the DBA, and there are many ways to perform this task. In...
2011-01-01
2,516 reads
MVP Award for 2011
I just received notification from the Microsoft MVP Award Program that I’ve received the MVP award for SQL Server for...
2011-01-01
749 reads
Re-Awarded MVP for 2011
I received my notice that I was renewed as a MIcrosoft MVP for SQL Server for 2011. It's a nice...
2011-01-01
784 reads
TPC-E Benchmark Analysis by CPU Type
As an experiment, I decided to import the current official TPC-E results spreadsheet into a SQL Server 2008 R2 database,...
2011-01-01
1,285 reads
2010 - A Year without Specific Goals
In previous years I had set goals and even if I didn't fully achieve them, they were helpful in giving...
2010-12-31
2,106 reads
2010 Goals Review
I started the year with 10 Goals for 2010 and now I'll end it by looking at how many of...
2010-12-31
1,595 reads
Blogging on Blogging
So I must confess that my blogging efforts to date have been on the impersonal side
– perhaps even a bit...
2010-12-31
1,459 reads
Happy New Year
Well it’s Friday again and another big day.
Hopefully you all had a great Christmas and as we move to...
2010-12-31
1,498 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
SSRS Reminded Me of the Time Microsoft Retired TMG
Comments posted to this topic are about the item SSRS Reminded Me of the...
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,...
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