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 @ 6:00...
2011-02-08
825 reads
Blog Posts
Immersions Training
The last week of January 2011, I wrote a blog post entering a contest for free training at the hands of SQLSkills. Later that week an announcement was made...
2011-02-08
4 reads
Immersions Training
The last week of January 2011, I wrote a blog post entering a contest for free training at the hands...
2011-02-08
538 reads
Opportunity Cost versus Real Cost
One of the hardest lessons to learn and put into practice as a self-employed consultant is that of Real Cost...
2011-02-08
1,025 reads
SQL University: SQL Server Security Architecture - 3rd Party, No Options
Welcome back to day 2 of Security Week for this semester of SQL University. If you missed yesterday's introduction, you'll...
2011-02-08
2,473 reads
T-SQL Tuesday #15 – Automation
It’s that time of the month again, and this month Pat Wright and his SQL Asylum are hosting the T-SQL...
2011-02-08
1,020 reads
T-SQL Tuesday #15 Automation and the SSIS Dumper
This post is my contribution to T-SQL Tuesday, hosted this month by Pat Wright (blog | twitter).
In my previous post...
2011-02-08
1,059 reads
TSQL Tuesday #15–Automation in SQL Server
Automation is the separation point for the professional DBA from the amateur. That makes this a very important topic. Thanks...
2011-02-08
900 reads
What's OLD in SQL Server 11 aka Denali? - Deprecated Feature List
Well, we always see, hear, and read about the list of NEW features in the myriad of articles, columns and blogs...
2011-02-08
1,740 reads
You really like me?
And a bunch of other people who are really talented. My Zero to Cube session won the Summit Spotlight track...
2011-02-08
754 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