Speaking at Live360 Orlando
Are you going to be in Florida in November? Me too. I’m privileged to say that I get to speak...
2017-08-28
440 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
Bad Parameter Sniffing Decision Flow Chart
Lots of people are confused by how to deal with bad parameter sniffing when it occurs. In an effort to...
2017-08-24 (first published: 2017-08-15)
2,359 reads
Redgate Hub LiveStream
Over at Redgate, we’ve been working on a new way to get information to you. It’s called the Redgate Hub....
2017-08-23
202 reads
Runtime Metrics In Execution Plans
Capturing query execution metrics is much easier now that you can see the runtime metrics in execution plans when you’re...
2017-08-22
252 reads
Responsibility to Learn
“I would educate myself, and that I would never stop educating myself. It was my responsibility to keep learning.” Who said that? Albert Einstein? Da Vinci? Stephen Hawking? None of the above. That statement came from the Demon of the rock band KISS, Gene Simmons. If a rock & roll legend knows that it’s on […]
2017-08-21
82 reads
Being a Positive Influencer
I read a lot of self-help and improvement information. I’m always trying to hack my brain or my attitude to...
2017-08-18 (first published: 2017-07-31)
1,912 reads
Bad Parameter Sniffing Decision Flow Chart
Lots of people are confused by how to deal with bad parameter sniffing when it occurs. In an effort to...
2017-08-15
203 reads
PASS Summit 2017
Don’t you want to go to the single largest collection of Microsoft Data Platform professionals and developers on the planet?...
2017-08-14
177 reads
PASS Summit 2017
Don’t you want to go to the single largest collection of Microsoft Data Platform professionals and developers on the planet?...
2017-08-14
468 reads
IT/Dev Connections 2017
I’m very honored to be able to announce that I am going to be speaking at IT/Dev Connections in San...
2017-08-09
332 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