Using SQL Agent Job Categories to Automate SQL Agent Job Enabling with Database Mirroring
Microsoft’s Kevin Cox (from SQLCAT) and I co-authored a blog post titled Using SQL Agent Job Categories to Automate SQL...
2010-04-01
927 reads
Glenn Berry
Intel Xeon 7500 Series aka Nehalem-EX
Intel has finally released the long awaited (at least by me) 45nm Xeon 7500 series processor. This beast has eight...
2010-03-31
2,010 reads
SQL Server 2008 Database Mirroring: It takes a licking but it keeps on ticking!
With apologies to Timex, I just wanted to relate a minor incident that happened with one of my mirrored databases...
2010-03-30
6,182 reads
To Get Certified or Not Get Certified
I have noticed quite a bit of discussion recently about the merits of Microsoft certification. Some people (like me) think...
2010-03-29
932 reads
Using Custom Connection Colors in SSMS
One of the new features that was added to SQL Server Management Studio (SSMS) in SQL Server 2008, which was...
2010-03-29
3,973 reads
Recovery Models and Backup Strategies for SQL Server 2008
I had a question via e-mail from one of my new students at University of Denver, University College this morning,...
2010-03-25
3,066 reads
Creating SQL Server 2008 Databases with T-SQL
Imagine you need to create a database on a customer’s machine, but you don’t know how they have their file...
2010-03-24
1,399 reads
SSWUG Ultimate vConference Discount Code
The SSWUG Ultimate Virtual Conference is coming up on April 7, 8, and 9th. This is three days of very...
2010-03-22
833 reads
Why UniqueIdentifier is a Bad Choice for a Clustered Index in SQL Server
I had a question today about why it was “bad” to use a UniqueIdentifier as the data type for a...
2010-03-22
9,355 reads
The Coming Upgrade Tidal Wave
Microsoft is poised to release new versions of several different products and technologies that have the potential to have a...
2010-03-18
722 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