Baton Rouge October SQL Server User Group
Last night I presented, Monitoring Disk Space using CLR, to the Baton Rouge Area SQL Server User Group. There were...
2009-10-09
730 reads
Blog Posts
New Dell PowerEdge R710 Database Server
My long awaited new database server arrived today! It has two, quad-core Xeon X5550 processors, 72GB of DDR3 RAM, and...
2009-10-09
1,800 reads
Next SQL Lunch - Deploying Report Builder 2.0 for Self-Service Reporting
Meeting URL: https://www.livemeeting.com/cc/usergroups/join?id=95MQQM&role=attend
Click Here to Add to Outlook Calendar
Click the above Meeting URL around 11:00 AM CST on 10/12/2009 to...
2009-10-09
633 reads
Performance Data Gathering
As a DBA, one of the things I struggled with was gathering all my important system information in one place,...
2009-10-09
773 reads
Reindex and Update stats.
Today I was reading blog by Ben Nevarez it is great... (I am impressed with ben now a days) that's...
2009-10-09
755 reads
Select count(*)
Today I was reading(I always read Paul Randal).
http://www.sqlskills.com/BLOGS/PAUL/post/Which-index-will-SQL-Server-use-to-count-all-rows.aspx
I learned that whenever you query select count(*) it will select the the...
2009-10-09
1,949 reads
SQL Server Announcements From Microsoft
Microsoft has announced the upcoming end of mainstream support for SQL Server 2005 SP2 on January 12, 2010, and for...
2009-10-09
901 reads
What a backed up Database Mirror looks like
One thing you need to be careful about with SQL Server 2005/2008 Database Mirroring is making sure that you don’t...
2009-10-09
1,319 reads
What I did on my vacation
I took a few days off recently to get a break from work. I've rarely taken time off since last...
2009-10-09
661 reads
A DBA’s Fantasy
I happened upon the screenshot below, showing a stress test in progress against a Windows machine with 64 quad-core CPUs...
2009-10-08
1,401 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
India’s Leading Inspection And Auditing Service at FARE Labs Pvt. Ltd.
Best Inspection and Auditing Services of India focus on precision, quality control, and compliance,It...
Alamat Kontak Bank BCA KCP Surabaya WA {08218154393}
WA:08218154393 Jl. Surabaya No.88 B-C, Ps. Baru, Kec. Medan Kota, Kota Medan, Sumatera Utara...
Alamat Kontak Bank BCA KCP Perak WA {08218154393}
WA:08218154393 Jl. Perak Bar. No.267, Perak Utara, Kec. Pabean Cantian, Surabaya, Jawa Timur 60165
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