Free Training 24HOP
In my sessions, I always talk about how to build your skill set when you don’t have a budget for...
2018-04-18
536 reads
SQLEspresso
Template Explorer Gold Mine
Sometimes as a newbie to SQL Server using SQL Server Management Studio (SSMS) you don’t know about the little gold...
2018-03-27
502 reads
SQL Server Updates Tricked Me for Years
When applying a new SQL Server cumulative update, hot fix, or upgrade SQL Server doesn’t always apply all the fixes...
2018-02-21
1,245 reads
Bloggers Should Have Reach
One of my goals for 2018 is to expand the reach of my blog.
As a blogger starting out I had...
2018-02-14
319 reads
Expanding My Reach
I am so thrilled to have the opportunity to expand my writing with my first Simple-Talk article posted. Simple- Talk is technical journal and...
2018-02-07
314 reads
Can You Hear It Now?
Here is a quick blog to show you something I discovered that I didn’t know existed.
I was on a Skype...
2018-01-31
385 reads
Maintaining Balance
Last week, I got the chance to give my I’m It Survival Tips for the Lone DBA in a webcast for the first...
2018-02-09 (first published: 2018-01-24)
1,649 reads
How to get started with Always Encrypted for Beginners Part 3: One Two Punch
A few weeks ago, I wrote Part 1 and 2 of this series, which was a beginner’s guide to Always...
2018-01-17
782 reads
It’s All in the Name, Index Naming Conventions
Awhile back, if you are on Twitter, you can probably recall my ranting about the 949 indexes I was reviewing....
2018-01-10
1,711 reads
AHHH I need a Blog Topic!!!
One of the hardest things you can do as a blogger is to come up with a post topic. Do...
2017-12-20
342 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