My Conversation with Ted Kummert at the PASS 2010 Summit
For some mysterious reason, I was selected as one of the “official” bloggers/tweeters during the PASS Keynotes last week. This...
2010-11-15
614 reads
Glenn Berry
New Path to MCM in SQL Server 2008
Last week, during the first day of the PASS 2010 Summit, Microsoft’s Joe Sack announced the revamped testing program for...
2010-11-15
1,307 reads
SQL Server 2005 Diagnostic Information Queries (November 2010)
Here is the November 2010 version of my diagnostic information queries for SQL Server 2005. Many of these queries are...
2010-11-15
2,666 reads
XBox 360 250GB and Kinect Bundle
I took the plunge and bought one of the new 250GB XBox 360 and Kinect bundles for $399 at Best...
2010-11-14
812 reads
Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance
I will be presenting my session on hardware selection and sizing today at 10:15AM in Room 608 at the PASS...
2010-11-11
646 reads
Full-Text Search Enhancements in SQL Server Denali
Since Microsoft announced the existence of CTP1 of SQL Server Denali during Ted Kummert’s keynote address at PASS 2010 yesterday,...
2010-11-10
837 reads
Why is SQLSaturday Such a Big Secret?
One of the small mysteries of the universe that I have been pondering lately is the fact that so many...
2010-11-10
422 reads
Day 1 at SQLPASS Keynote Address
Microsoft announced the RTM of SQL Server 2008 R2 Parallel Data Warehouse, which will be available as an appliance in...
2010-11-09
466 reads
November 2010 Version of SQL Server 2008 Diagnostic Information Queries
Apparently, when I posted this a few days ago, the Windows Live Writer plug-in that I used mangled the T-SQL...
2010-11-09
1,297 reads
Official Blogger at 2010 PASS Summit
I will be one of the “official” bloggers during the 2010 PASS Summit, which means that I get to sit...
2010-11-09
482 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