The Best Database Engine - Why Did I Write This?
Why did I write this? I got challenged by Andy Warren
to write a bit about why I wrote something. I...
2008-10-07
364 reads
Blog Posts
The Call for Nominations to the SQL PASS Board of Directors is Now Open Until October 24, 2008
If you have ever considered taking a leadership role in PASS, you should seriously consider becoming a SQL PASS board...
2008-10-07
416 reads
Final Reminder - SQLSaturday #5 & #9 Coming Up on October 11, 2008
You can find details about these great free events at www.sqlsaturday.com. It's definitely been interesting watching them grow from afar...
2008-10-06
312 reads
IndyTechFest 2008
I spend the weekend in Indianapolis at the IndyTechFest 2008 and had a great time. It's a smaller, regional conference...
2008-10-06
316 reads
IndyTechFest A Great Success
Just got back from attending IndyTechFest in Indianapolis, IN, which was held on Saturday, October 4, 2008, and had nearly...
2008-10-06
706 reads
Notes on Went Well & What We Could Have Done Better - From SQLSaturday #8
As I mentioned yesterday things went pretty well, but always room for improvement. Here are some notes, if nothing else...
2008-10-06
295 reads
Social Hacks - Why Did I Write This?
Why did I write this? I got challenged by Andy Warren
to write a bit about why I wrote something. I...
2008-10-06
509 reads
SQL Server 2008 Books Online Have Been Updated
The version of SQL Server 2008 Books Online that was included with the RTM version has now been updated to...
2008-10-06
510 reads
Un-concatenating row values
/* Anith Sen's achievement, in his article 'Concatenating Row Values in Transact-SQL' has been to list and illustrate the many ways...
2008-10-06
1,752 reads
Shkurtesa ne SQL Server 2008
Pershendetje juve qe punoni vazhdimisht me SQL Server 2008!
Une sapo e instalove SQL Server 2008 RTM versionin e fundit edhe...
2008-10-05
537 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
Alamat kontak resmi BCA KCP Tebet Telp:0818751777
WhatsApp:0818-751-777 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, RT.1/RW.1,...
Stan Phone Number Australia +61-1800868603 Quick Help Guide
When things go wrong - like trouble signing in, videos pausing, unclear charges, or...
BCA KCP Pasar Minggu Center | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Jl. Lenteng Agung Raya No.26 E-F, RT.1/RW.4, Ps. Minggu, Kota Jakarta Selatan, Daerah...
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