3 Weeks to the PASS Summit
The PASS Summit is only three weeks away and I’m getting awfully excited. It’s not too late to register. Heck,...
2009-10-10
643 reads
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,803 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
756 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
903 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,322 reads
Adventures in SQL CLR and C#
I’ve toyed with the CLR in SQL Sever 2005 off and on since the first Yukon beta had it enabled....
2009-10-09
2,842 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,951 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
790 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
636 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
664 reads
Blogs
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Accessing the Data API Builder MCP Server from VS Code
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
From DBA or Data Engineer to AI Engineer: A Realistic Path
If you spend your days tuning queries, managing pipelines, or keeping a production database...
Forums
BIT_COUNT() V
Comments posted to this topic are about the item BIT_COUNT() V
How We Reduced SQL Server Infrastructure Costs by 33% on AWS: Lessons From a Database Operations Manager
Comments posted to this topic are about the item How We Reduced SQL Server...
An Eventual Consistency Scam
Comments posted to this topic are about the item An Eventual Consistency Scam
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers