PASS Update #5 (Blogger's Please Read)
We'll be announcing this on the main www.sqlpass.org site and the PASS blog over the next day or two, but...
2009-02-10
1,219 reads
Blog Posts
SQL Pi
A mildly humorous title, spawned by a link my friend Jon sent me about calculating Pi using a batch file....
2009-02-10
785 reads
Things you know now...
This was the brainchild of Mike Walsh, who asked, "What do you wish you knew when you were starting?" I...
2009-02-10
1,279 reads
Frantic
I’m a little frantic this morning trying to get caught up on work, lots of stuff piled up, Tia leaving,...
2009-02-09
787 reads
Notes on the 2009 South Florida Code Camp
As I mentioned last week I drove to Miramar for the South Florida Code Camp, arriving in time for the...
2009-02-09
524 reads
SQL Server 2008 Enterprise Edition install - use the "right" version of the Microsoft .NET 3.5 SP1 install
This is something that bit us over the weekend as we attempted to install two new SQL Server 2008 Enterprise...
2009-02-09
1,802 reads
Reminder: MSDN Tiki Hut Roadshow Coming to Pensacola, Tallahassee, and More
Forwarding on a note from my local MS Developer Evangelist Joe Healy about his next series of free presentations coming...
2009-02-08
778 reads
Speaking at Community Events - More Thoughts
Last week I posted Speaking at Community Events - Time to Raise the Bar?, a first cut at talking about to...
2009-02-08
1,272 reads
Challenging the Tyranny of Third-Party Vendors: A DBA’s Manifesto
Over the years, I have dealt with a lot of third-party applications (and their vendors) that use SQL Server as...
2009-02-06
2,842 reads
Interested in Boosting the Performance of SQL Server 2008 Analysis Services?
Microsoft has published a white paper called SQL Server 2008 White Paper: Analysis Services Performance Guide that you might find...
2009-02-06
903 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