Help Pick the 2011 Summit Topics and Speakers
Here’s your chance to give the program committee your thoughts on which sessions should be selected for the big show....
2011-05-11
553 reads
SQLAndy
My One Submitted Session for the PASS Summit
This year I received an invitation to compete for one of the spotlight sessions and I wanted the presentation with...
2011-05-10
634 reads
SQLRally Orlando Begins This Week!
It actually starts tomorrow for me (and many of you), I’ll be at the Marriott World Center around 1 pm...
2011-05-09
827 reads
SSC Editorial: Running as SysAdmin
My editorial about Running as Sysadmin ran in the SQLServerCentral newsletter yesterday and generated some good (and passionate!) responses. It’s...
2011-05-09
837 reads
SQLRally–Convince The Boss
This week the SQLRally team published some notes to help you convince the boss to send you to three days...
2011-03-10
1,557 reads
SQLSaturday in Hawaii, Portugal, and New Zealand
Just a quick post today for those you who haven’t visited www.sqlsaturday.com lately, we’ve got a lot of events coming...
2011-03-10
682 reads
Firefox and Reporting Services
Not everyone uses IE and that’s ok, but what’s strange is that by default if you point Firefox at a...
2011-03-08
862 reads
Speaking at Orlando Code Camp on March 26, 2011
I’ll be speaking at the upcoming Orlando Code Camp on March 26, 2011, at Seminole State College in Lake Mary....
2011-03-08
1,222 reads
SQLSaturday #77 in Pensacola–Call for Speakers
Karla Landrum just announced SQLSaturday #77, coming to Pensacola on June 4, 2011. Pensacola is a great weekend destination, hit...
2011-03-08
864 reads
Customizing Report Manager Should Be Easier
You might be reading this hoping that I have the magic answer on how to make the Report Manager portal...
2011-03-08
683 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