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,676 reads
Glenn Berry
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,492 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,605 reads
SQLSaturday #52 Report
I was lucky enough to present two sessions at SQLSaturday #52 in Denver on September 25, 2010. By my estimate,...
2010-09-28
544 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,286 reads
Project Phoenix For Unemployed and Underemployed Developers
SQL Server MVP Arnie Rowland (blog/twitter) has put a lot of effort into conceiving, organizing, and publicizing Project Phoenix over...
2010-09-27
670 reads
SQL Server Quiz 2010
SQL Sever MVP Jacob Sebastian (blog/twitter) has been working hard to organize the SQL Server Quiz 2010 event which will...
2010-09-27
1,117 reads
Microsoft Releases SQL Server 2008 SP1 Cumulative Update 10
On September 21, 2010, Microsoft released SQL Server 2008 SP1 Cumulative Update 10, which is Build 2799. I count 29...
2010-09-22
1,295 reads
Home Theater Upgrades
Back in late 2003, I had my basement finished,and as part of that effort, I put in a dedicated home...
2010-09-20
618 reads
What Do You Think Just Happened To This Database Server?
This is a screenshot of Task Manager for a database instance that is part of a synchronous database mirroring partnership...
2010-09-20
1,188 reads
Blogs
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database
By gbargsley
One of the first things I review when I inherit a new SQL Server...
AgentDBA vs Critical SQL Server
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
Forums
Increment a number in a SQL Query based on a value
I have an issue where I have a Bill of Material list of items...
Follow Your Hunch
Comments posted to this topic are about the item Follow Your Hunch
What Happens When You Ask a Local AI to Query Your Database?
Comments posted to this topic are about the item What Happens When You Ask...
Question of the Day
Detecting Characters
I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:
SELECT CustomerNameID,
CustomerName
FROM dbo.CustomerName
WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with:
CustomerNameID CustomerName 1 John Smith 2 Sarah Johnson 3 MICHAEL WILLIAMS 4 JENNIFER BROWN 5 david jones 6 emily davis 7 Robert Miller 8 LISA WILSON 9 christopher moore 10 Amanda TaylorHow many rows are returned? See possible answers