New Cumulative Updates for SQL Server 2005 and SQL Server 2008 R2
Late Monday night (October 18, 2010), Microsoft released the latest Cumulative Updates for SQL Server 2005 and for SQL Server...
2010-10-20
922 reads
Glenn Berry
This is What Task Manager Looks Like When You Restart the SQL Server Service
This is what Task Manager looks like in Windows Server 2008 R2 when you restart the SQL Server Service. This...
2010-10-19
619 reads
Birds of a Feather Lunch at PASS 2010 Summit
The volunteers at PASS (especially Mike Walsh) have organized another “Birds of a Feather” lunch event on Tuesday, November 9...
2010-10-13
697 reads
What are Physical Sockets, Physical Cores, and Logical Cores and Why Does it matter?
I witnessed a confused conversation on Twitter today where someone was talking about how he uses the terms sockets and...
2010-10-09
12,714 reads
SQL Server Memory Related Queries
What is using all of my memory in SQL Server? If you ever believe that you are seeing signs of...
2010-10-08
2,745 reads
CPU-Z Support For Sandy Bridge Processors
The CPUID website has a screenshot of CPU-Z 1.55.2, showing its support for the upcoming 32nm Sandy Bridge processor, which...
2010-10-04
582 reads
Stupid Tech Support Tales
One of our desktop support technicians noticed the following error from a 3rd party vendor application in an error log:
"9/22/2010...
2010-09-30
1,480 reads
Geekbench 2.1.7 Released
If you read my blog or follow me on Twitter, you know that I have a strong interest in database...
2010-09-30
1,662 reads
A Small Selection of SQL Azure System Queries
I had a question come up during my “Getting Started with SQL Azure” presentation at SQLSaturday #52 in Denver last...
2010-09-29
1,595 reads
Windows Power Plans and CPU Performance
Back in February, 2010, I did some preliminary testing on the effects of various BIOS settings and Windows Power Plans...
2010-09-28
2,179 reads
Blogs
A Broken Copilot Query
By Steve Jones
I was testing the new SSMS (v22 Preview 3) with Copilot and ran into...
SQL Server Alerts
By Kevin3NF
Don’t Let Trouble Sneak Up on You Most SQL Servers run quietly. Until...
Prompt AI helping with Auditing
By Steve Jones
I had a conversation with a customer asking this question: how can I tell...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Building a RESTful API with FastAPI and PostgreSQL
Comments posted to this topic are about the item Building a RESTful API with...
The Journey to PostgreSQL (or anything)
Comments posted to this topic are about the item The Journey to PostgreSQL (or...
Question of the Day
A Common Split
What happens when I run this code:
DECLARE @s VARCHAR(1000) = 'apple, pear, peach' SELECT * FROM STRING_SPLIT(@s, ', ')See possible answers