Call for Speakers for DevTeach/SQLTeach Vancouver to End February 10th
If you are interested in speaking at DevTeach/SQLTeach in Vancouver, BC this June 8-12, you have until February 10, 2008...
2009-02-03
471 reads
Blog Posts
Making Ginger Ale
Probably further off topic than usual, but you may find interesting anyway. I'm a fan of Alton Brown on Good...
2009-02-03
434 reads
SQL Server 2008 Books Online (January 2009 Update) Available for Download
Microsoft has just released the SQL Server 2008 Books Online (January 2009) update.
To download the 144 MB file so you...
2009-02-03
1,009 reads
[Off Topic] Get Fit in February Developer Challenge
I’m on Day Two of the Get Fit in February Developer Challenge. This month-long competition boasts around 200 participants who...
2009-02-02
651 reads
Software East - Building a Software Business
While in Cambridge, I went to watch a panel talk about building a software business. Neil Davidson, CEO of Red...
2009-02-02
876 reads
Getting into the biz, Part 1
I’ve seen a good deal of coverage recently that is geared toward those who have recently begun a career as...
2009-02-01
854 reads
Speaking at Community Events - Time to Raise the Bar?
If you're organizing a first time community event like SQLSaturday finding speakers is one of about a hundred tasks, so...
2009-02-01
1,097 reads
Waiting for a SmartPhone
I’ve got a Sidekick 3 right now that works OK for me, lets me check some basic email, get texts,...
2009-01-30
1,517 reads
What are the Necessary Ingredients for Writing a Successful Book for New SQL Server Developers?
A number of book publishers regularly send me books, hoping that I will write a good review for them. Most...
2009-01-30
1,954 reads
Attend the European PASS Conference 2009 in Neuss Germany
The European PASS Conference will be held in Neuss Germany (near Düsseldorf) from April 22-24, 2009. It will include 36...
2009-01-29
1,569 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
ALAMAT BCA KCU HR MUHAMMAD TLP/WA 0817839777
Bantuan Cs 0817839777 Jl. Mayjen HR. Muhammad No.17, Putat Gede, Kec. Sukomanunggal, Surabaya, Jawa...
BCA KCU BUKIT DARMO BOULEVARD Tlp:0817839777
Telp / Wa 0817839777 Jl. Mayjend. Jonosewojo No.14, Pradahkalikendal, Kec. Dukuhpakis, Surabaya, Jawa Timur...
ALAMAT KANTOR BCA KCU SIDOARJO TLP/WA 0817839777
Cs: 0817839777 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo, Jawa...
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