SKUUpgrade =1 in SQL 2005
One of the things on my todo list for this past week was to upgrade a SQL 2005 Standard Instance...
2009-10-13
745 reads
Blogging
Hi,
Yesterday while talking to my friend, he reviewed my blog and suggested that I was having so many spelling...
2009-10-13
442 reads
Operations Manager Feedback
If you’re involved with maintaining Microsoft Operations Manager, you probably have a few things you’d like to tell the developers,...
2009-10-13
521 reads
Table Variables Are Only in Memory: Fact or Myth
I keep seeing these concepts that have long been disproven, posted again and again on newsgroups as if they were valid information. The...
2009-10-13
674 reads
SQL Server Legend – Data Files and Threads
Someone was asking about using multiple data files recently to try and increase performance. I had answered that unless you...
2009-10-13
4,005 reads
SQLServerCentral Article on Database Space Capacity Planning
I wrote an article for SQLServerCentral entitled "Database Space Capacity Planning" that demonstrates a database and volume (disk) capacity planning solution...
2009-10-13
1,002 reads
PASS Update #15
We just had our October board meeting, this one ran the full hour and was a good discussion, catching up...
2009-10-12
231 reads
Afraid of Presenting? Try Toastmasters
I should be writing a technical post in the next day or so. I've been focusing more on the community...
2009-10-12
1,331 reads
SQL Server Lunch Milestone (100+ Attendees)
Today’s SQL Lunch was a huge success, even though we experienced a few technical difficulties. Tim Mitchell spoke on Deploying...
2009-10-12
777 reads
Generate Lots of Test Data with CROSS JOIN
“Joe Test”
“Joe Test2?
“Joe Test3?
“Arrgh! There has got to be a better way to create some test data!”
Ever had that conversation...
2009-10-12
3,368 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