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,916 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,388 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,129 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,454 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,735 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,082 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
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....
Forums
Execute as failure
Security has long been a problem for me. Every time I think I understand...
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...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers