Two Very Important Configuration Settings For SQL Server 2005/2008
Two settings that I always enable when I install SQL Server 2005 or 2008 on an x64 production database server...
2009-11-01
5,914 reads
Blog Posts
Blogging From the 2009 PASS Community Summit
Like a lot of other SQL Server bloggers, this week I will attempt to write regular blog entries each day,...
2009-10-31
1,387 reads
Not Attending/Presenting at SQL Connections
Given everything that has happened in the last couple of weeks, this is not surprising to those who have kept...
2009-10-31
1,386 reads
PASS Officers for 2010-2011 Announced
Posted yesterday at http://www.sqlpass.org/Community/PASSBlog/articleType/ArticleView/articleId/118.aspx, Rushabh Mehta is the incoming President, Bill Graziano is the VP Finance, and Rick Heiges is...
2009-10-31
1,424 reads
SQL Server 2008 cluster install and slipstreaming!
I was asked to set up a SQL Server 2008 cluster on Windows 2008 R2 this past week. One interesting...
2009-10-31
2,127 reads
The Gift Count
I went by Best Buy this afternoon, with my updated budget, to grab 2 last gifts and blow out the...
2009-10-31
1,453 reads
When Technical Support Fails You – UPDATE and Answers!
As promised and update on what has happened so far. A correction needs to be made. the P800 is a...
2009-10-31
1,733 reads
Consider this while doing any UPDATE
Trigger:
When you create trigger for insert and delete we will get two reference table as “inserted” and “deleted” respectively now...
2009-10-30
1,497 reads
Fun in Seattle
I know there are a number of people heading to Seattle this weekend for the PASS Summit next week. I...
2009-10-30
1,624 reads
Happy Halloween to the DBA - Pumpkin Carving as a Team Building Exercise
The past couple of days we have had some fun with a TeamBuilding exercise by means of designing our Pumpkin...
2009-10-30
2,079 reads
Blogs
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Forums
Why SQL Server Database Attach fails and how to repair it
Comments posted to this topic are about the item Why SQL Server Database Attach...
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers