Presentations: Slides and Demos
Over the past couple of weeks I have given several presentations. At each presentation I have promised to post the...
2011-02-09
666 reads
Blog Posts
Service Pack 1 for Windows Server 2008 R2 and Windows 7
Microsoft’s Brandon LeBlanc announced the upcoming availability of Service Pack 1 for Windows Server 2008 R2 and Windows 7 on...
2011-02-09
1,647 reads
SQL University: SQL Server Security Architecture - 3rd Party, Some Options
Day 3 of Security Week at SQL University is now in session. You're implementing a third party solution and you...
2011-02-09
4,156 reads
T-SQL Tuesday #15 DBA Automaton
Often, we hear about DBA's automating everything under the sun. Why? It simplifies the job and creates time to work on other projects.
Related Posts:
Automating like an Enterprise DBA January...
2011-02-09
8 reads
T-SQL Tuesday #15 DBA Automaton
I have been incognito for the last couple of weeks and nearly missed TSQL Tuesday this month. If it weren’t...
2011-02-09
822 reads
Work Goals for 2011-Part 2
It’s been a few weeks since I wrote my early thoughts on my goals for this year, and you can...
2011-02-09
794 reads
10 Things Every DBA Should Do
Recently I spoke about how The Best Database Administrators Automate Everything, as well as Document Everything and this got me...
2011-02-08
2,307 reads
Book #2 - Dynasty in the making?
Ok so dynasty might be a bit strong, but check out this
newest volume from the folks @ Pragmatic Works. We...
2011-02-08
626 reads
Conquering Kilimanjaro & Cancer !
Day 1 – Leaving for Africa
After almost 12 months of fundraising, training, walking up various mountains, sleepless nights and plenty of...
2011-02-08
467 reads
February OPASS Meeting
Don’t forget to join us tonight for the OPASS meeting sponsored by RedGate and Signature Consultants.
Event Date/Time: Tuesday February 8th...
2011-02-08
6 reads
Blogs
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...
Finally Cleaning Up Dropbox: Moving Almost a TB to Google Drive with rclone
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
Forums
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...
Detecting Characters
Comments posted to this topic are about the item Detecting Characters
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