Do Be a Gatekeeper
I read this fascinating blog post called “Don’t Be a Gatekeeper” by Julie Zhuo. Please read that first.
It really resonated...
2013-10-18 (first published: 2013-10-09)
2,729 reads
Grant Fritchey
- Twitter: @https://twitter.com/gfritchey
- Website: https://scarydba.com
- LinkedIn: https://www.linkedin.com/in/grant-fritchey/
- Bluesky: https://bsky.app/profile/gfritchey.bsky.social
PASS Summit 2013 Day 2 Key Note
KILT DAY!
Today we have to eat our vegetables and then get lots and lots of sweet desert.
Or.
Today we hear about...
2013-10-17
887 reads
PASS Summit 2013: Women In Technology Luncheon
This year I was invited to attend the Women In Technology luncheon as a blogger. So I’ll be live-blogging it...
2013-10-17
853 reads
PASS Summit 2013 Day 1 Keynote
I am liveblogging the keynote from the bloggers table at the PASS Summit again this year. Just keep scrolling.
Watching the...
2013-10-16
799 reads
Speaker of the Month, October 2013
This month I saw several good speakers talking on a variety of topics. Making this choice was hard. I’m really...
2013-10-09 (first published: 2013-10-04)
1,146 reads
Azure Account and Spending Limits
If you’ve been working with Azure for a while you probably signed up before they had the ability to create...
2013-10-08
809 reads
An Experiment Concludes
That was hard work
You may or may not have noticed, but every single week day for the month of September,...
2013-09-30
1,596 reads
Azure Offerings Continue to Expand
We just received word of a bunch of new functionality over at Scott Guthrie’s blog. Not a lot of stuff...
2013-09-27
1,323 reads
PASS Votes
I’ve already made my own intentions clear. I’m casting one of my votes for Allen Kinsel. But, I get three...
2013-09-26
751 reads
AdventureWorks2012 Bug on Azure
While I have production databases in Azure, I can’t exactly experiment with them at will. Further, while they mostly have...
2013-09-25
1,317 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
Increment a number in a SQL Query based on a value
I have an issue where I have a Bill of Material list of items...
BCA KCU THAMRIN | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, RT.1/RW.5, Menteng, Kec. Menteng, Kota...
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,...
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