SQL University: Home-Grown, with Real Options!
There's the light, as this is the last class for Security week at SQL University. From the scenarios we specified...
2011-02-11
1,612 reads
Blog Posts
StreamInsight: A new way to think about analyzing data
Last night’s Oregon SQL user
group meeting was very enlightening. Mark Simms form the SQLCAT team came
down from Redmond to talk...
2011-02-11
1,089 reads
T-SQL Tuesday Topics – Feb 2011
I was looking for a static list of all the T-SQL Tuesday topics and couldn’t find one. The domain moves...
2011-02-11
899 reads
Un-SQL Friday #003: Show Some Love
Last week, I asked the Twitter hive-mind about its favorite tech companies: “Which SQL (or SQL-adjacent) tech companies are doing...
2011-02-11
508 reads
Windows Instant File Initialization and SQL Server
One Windows setting that I think is extremely important for SQL Server usage is the “Perform volume maintenance tasks” right,...
2011-02-11
1,785 reads
31 Days of SSIS Conclusion
31 Days of SSIS
Last month, I published the 31 Days of SSIS blog series. As a conclusion to that series,...
2011-02-10
781 reads
Corporate Culture
One of the things I enjoy about work is seeing the various cultures that evolve. Some companies are rigid, some...
2011-02-10
1,364 reads
Pragmatically Yours - Day 1, Guidance
This next week I’m launching a series of posts centered around how you could be a part of the leading...
2011-02-10
617 reads
Presenting at SQL Rally
I received notification earlier this week that my session “ETL Head-To-Head: T-SQL vs. SSIS” was selected by community vote for...
2011-02-10
568 reads
SQL Rally: The Votes Have Been Tallied
First and foremost, I would like to send a sincere thank you to everyone who voted for my Reporting Services...
2011-02-10
590 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