SQL Server Samples on CodePlex
Like many other SQL Server focus area, SQL Server Samples has its own blog. A recent post there indicates that...
2007-04-06
1,417 reads
Blog Posts
The Data Warehouse Lifecycle Toolkit
On a recommendation, I picked up this book by Ralph Kimball. I remember it coming out years ago and I...
2007-04-06
1,418 reads
Thoughts from The Cuckoo's Egg
The Cuckoo's Egg by Clifford Stoll has been around for a while, having been published in 1989. It details how...
2007-04-06
1,655 reads
Hot Fixes
I wrote about Hot Fixes being inclusive of previous hot fixes. Someone questioned this and so I went back to...
2007-04-03
1,416 reads
Post Timeouts
Well one problem was solved. Or at least identified.
We've had an issue for a few years where you'd hit the...
2007-03-31
1,422 reads
Late Projects
I was talking with Andy Warren, my partner and fellow partner here, today about the Code Camp in Orlando last...
2007-03-27
1,444 reads
Ambition
I was always someone that was ambitious as a kid. For whatever reason, I've been driven most of my life...
2007-03-22
1,442 reads
Updated Website
I've taken some time to update my website. In particular I have updated:
ArticlesReading ListChess Reading List
Nothing fancy or special, but...
2007-03-20
1,343 reads
Whitepaper on ESX Server 3.0 and SAN-attached Storage
First saw this at Blade Watch. VMWare has released a white paper on using SANs with VMWare ESX Server 3.0....
2007-03-20
1,492 reads
SQL Server 2005 Security Best Practices Whitepaper Released
Saw this first here: SQL Server 2005 Security Best Practices. It's on the blog for Microsoft UK's SQL Server Premier...
2007-03-19
1,873 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
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,...
Stan Phone Number Australia +61-1800868603 Quick Help Guide
When things go wrong - like trouble signing in, videos pausing, unclear charges, or...
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