Hacked
Boy that was fun. Getting a bunch of emails that we had been hacked and tracking down someone updating all...
2007-02-22
1,523 reads
SP2
Mentioned by Tim Mitchell, but SP2 is out.
Seems more like enhancements to make things smoother and lots of changes in...
2007-02-20
1,463 reads
SQL Server SP2 released
Today, Microsoft released Service Pack 2 for SQL Server 2005. Though mostly a series of fixes for minor issues, there...
2007-02-19
1,427 reads
Microsoft SQL Server certification
A few weeks ago I was engaged in a useful discussion about the merits of getting certified on Microsoft SQL...
2007-02-18
1,918 reads
Daylight Saving Time and SQL Server
If you're in the United States, chances are you've already heard about Daylight Saving Time (DST) occurring 3 weeks early...
2007-02-13
2,672 reads
Midlands PASS Site Online
I have put the Midlands PASS site online temporarily at Truth Solutions. You can reach it here:
http://www.truthsolutions.com/MidlandsPASS/
The slides from Paul...
2007-02-12
1,615 reads
Guest Editorial Week
I've been writing the editorials for over two years now and it's become an almost daily part of my life....
2007-02-11
1,452 reads
Midlands PASS February Meeting Postponed
We are postponing
due to the weather. Training Concepts has shut down for the day due to the wintry
mix....
2007-02-01
1,290 reads
Tools: ApexSQL Edit wins SQL Server Editor's Choice award
I meant to blog on this last month but work has been just a touch short of insane. I like...
2007-01-31
1,505 reads
For those just starting out with SSIS
Having cut my teeth on SQL Server 2000, I had some (but not a lot) of DTS experience. Recently I...
2007-01-30
1,382 reads
Blogs
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Forums
ALAMAT KANTOR BCA KCU KISARAN TLP/WA 08218200174
Telp Cso: (0821)8200174 Jl. Cokro Aminoto No.28, Kisaran Kota, Kec. Kota Kisaran Barat, Kabupaten...
ALAMAT BCA KCU PEMATANG SIANTAR TLP/WA 08218200174
Telp Cso: (0821)8200174 Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar, Sumatera...
ALAMAT KANTOR BCA KCU ASIA TLP/WA 08218200174
Telp Cso: (0821)8200174 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