Rules to Live By: Do the Hard Things First
I can’t say I stick to this one 100 percent of the time, but it’s definitely a deeply held belief....
2010-04-23
512 reads
Blog Posts
Script of the week
Every week I will scour the internet for useful SQL scripts and post my favorite on here.
This weeks comes from...
2010-04-23
393 reads
SQL Server 2008 R2 Road Show Recap
This past week I had the opportunity to speak at three SQL Server R2 Launch events.I spoke in three cities...
2010-04-23
401 reads
A DMV a Day – Day 22
The DMV for Day 22 is sys.dm_exec_query_memory_grants, which is described by BOL as:
Returns information about the queries that have acquired...
2010-04-22
1,754 reads
An Introduction to SQL Server 2008 Change Data Capture
This is an excerpt from my free eBook, Brad’s Sure Guide to SQL Server 2008, which can be downloaded here.
As...
2010-04-22
2,123 reads
Consulting and the MBA
The year is 1991. Nirvana’s Smells like teen spirit is the must-have album of the year. And everyone who is...
2010-04-22
551 reads
e-Ink Improvements
I saw this article on the improvements from E-ink that are coming. There are two videos, one of a better...
2010-04-22
715 reads
I’m on TV at the Tweet-up
I was listening to the announcement of SQL Server 2008 R2 yesterday on a call from Microsoft. It was released...
2010-04-22
731 reads
Index Stats Duplication
I came across a recent posting about seeing multiple entries in sys.dm_db_index_usage_stats for the same index. This kind of behavior...
2010-04-22
2,100 reads
OPASS is pleased to announce - SQLSaturday #49 - Orlando October 16th. Get it on your calendar now.
SQLSaturday #49 - Orlando is now live on the SQLSaturday web site. It will be held on October 16th at Seminole...
2010-04-22
405 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