Presenting at Jacksonville Code Camp
I’m leaving later today for the not too bad drive to Jacksonville for the sixth annual Code Camp. I’ve got...
2010-08-27
552 reads
Blog Posts
SSC Editorial – What Superhero Would You Be?
This was written for something fun on a Friday, but it’s still interesting for coffee talk anytime – what superhero would...
2010-08-27
617 reads
A Really Simple Data Dictionary
Last month I sat down with Blain Barton and TechNet Edge in an interview (Blain Barton Interviews Raymond James Chad...
2010-08-26
736 reads
Default to Yes
There are a lot of times when the decision matters less than who makes it. A common if simplified example...
2010-08-26
1,027 reads
Entering the Dark Side
If any of you follow me on SQLServerCentral.com, then you know I recently started a new job. Well, after two...
2010-08-26
1,695 reads
Generate Insert Query in SQL
Sometimes we need to generate the INSERT script in sql server. When, we need to insert bulk of data from...
2010-08-26
3,250 reads
Mission Accomplished – Well sort of …
Did you ever set a goal and then sort of … demolish it without realizing it? That has happened this year....
2010-08-26
342 reads
N Things Worth Knowing About CTEs
If you haven’t messed with them yet, you should know that CTEs (Common Table Expressions) - new in SQL Server 2005...
2010-08-26
1,295 reads
SQL Saturday #28 - Keynote
I was honored to be asked to do the keynote for SQL Saturday #28 in Baton Rouge recently. It’s taken...
2010-08-26
871 reads
SQL Saturday #28 - Slides and Impressions
I’m late, I suck, but here’s some things I started in Baton Rouge and am just now getting out.
First, I’ll...
2010-08-26
954 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