Speaking at MagicPASS on February 22, 2012
Next Wednesday I’ll be returning to MagicPASS to do a presentation on SQL security for developers. It’s an interesting topic,...
2012-02-17
682 reads
SQLAndy
Sarasota IT Pro Camp
The first Sarasota IT Pro Camp is being held on Saturday, February 18th 2012 from 9:00 am to 5:00 pm...
2012-02-13
626 reads
Battery Life–The Hidden Cost of Keeping a Laptop
I’ve had my Dell E6500 for about 3-1/2 years now. I’ve recently upgraded the original (back when a SSD was...
2012-02-13
851 reads
PASS Chapter Tools–My Wish List
I’m hoping this year will be the year that PASS makes a substantial investment in tools – the online kind – for...
2012-02-11
982 reads
Review: I Done This
IDoneThis is a simple web site for tracking accomplishments. The premise is that you get a checkbox on the calendar...
2012-02-10
822 reads
Notes from the February Space Coast SQL Meeting
I drove over to Melbourne last night to the new home of Space Coast SQL at the Harris Institute for...
2012-02-10
727 reads
Stages of the Game?
Saw this post by Seth Godin on Stages of the Game. Interesting, I identified with it – I’m competitive, and competing...
2012-02-09
835 reads
An Unclassy Error
I saw this on a TV while walking through a store. More than a but amusing, but not too helpful...
2012-02-08
625 reads
Opt In/Out of Personalized Microsoft Ads
Nice to have the option, you can opt-out (default is in) of having personalized ads. I turned it off, the...
2012-02-07
821 reads
Kindle Fire Update
We’ve had two of them since right after the launch and overall I’m pleased. They get used quite a bit...
2012-02-06
576 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