Exam Prep 70-463: Just the facts, ma’am
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2014-12-02 (first published: 2014-11-24)
7,986 reads
Colleen M. Morrow
Exam Prep 70-463: More about Dimensions
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2014-11-26 (first published: 2014-11-20)
7,024 reads
Exam Prep 70-463: Tables and Schemas
Well, the PASS Summit has come and gone and it was *awesome*. What a difference from my first Summit experience,...
2014-11-25 (first published: 2014-11-17)
8,749 reads
PASS Summit 2014: WIT Luncheon with Kimberly Bryant
Kimberly Bryant, founder of Black Girls Code
When Kimberly Bryant began studying programming at college, she found that there were few...
2014-11-10 (first published: 2014-11-06)
4,182 reads
Summit and something new…
Let me just say, I’m excited.
First of all, can you believe that the PASS Summit is next week? Next. Week.
Are...
2014-10-31
888 reads
PASS Summit 2014 – I’m speaking!
On June 25, 2012, I set a goalfor myself. It was this:
In the next 3 years, I want to present...
2014-06-25
688 reads
What does “challenging” really mean?
I had lunch with an old friend last week. We hadn’t spoken in a while and we were catching up...
2014-01-27
843 reads
SQL Server 2014 – Delayed Durability
Pop quiz: What does ACID stand for?
That should be a pretty easy question for database professionals:
AtomicityConsistencyIsolationDurabilityIt’s that last property, durability,...
2014-01-21 (first published: 2014-01-13)
2,919 reads
SQL Server 2014 – Buffer Pool Extension
Wanted: more RAM
In an ideal world (well, a DBA’s ideal world, anyway) all database servers would have enough memory to...
2014-01-20
1,375 reads
Cleveland rocks in February!
Heading to SQLSaturday #241
It’s a brand new year, so start it off right. Cleveland is hosting its third SQLSaturday on...
2014-01-10 (first published: 2014-01-06)
1,213 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