SQL Server Hardware Book
One reason (besides laziness) that I have been fairly light on my blogging lately is that I have been working...
2010-12-14
1,280 reads
Glenn Berry
SQL Server 2008 Diagnostic Information Queries (Dec 2010)
I have been quite the slacker (by my usual standards) for blogging over the past few weeks, but my excuse...
2010-12-14
675 reads
Presenting to the PASS Database Administration Virtual Chapter
I will be giving a presentation and demo to the PASS Database Administration Virtual Chapter on Wednesday, December 8 2010...
2010-12-02
853 reads
Dynamically Backing Up All User Databases in SQL Server
I recently had a request from a client to come up with a routine to do a full compressed database...
2010-11-16
1,417 reads
SQL Server 2008 Service Pack 2 Cumulative Update 1
Microsoft has released SQL Server 2008 Service Pack 2 Cumulative Update 1, which is Build 4266. I count 67 fixes...
2010-11-16
1,008 reads
Handy Hardware Assessment Tools For SQL Server
Here is a small selection of useful tools for getting some specific hardware information from any Windows based system you...
2010-11-16
2,255 reads
New Path to MCM in SQL Server 2008
Last week, during the first day of the PASS 2010 Summit, Microsoft’s Joe Sack announced the revamped testing program for...
2010-11-15
1,307 reads
SQL Server 2005 Diagnostic Information Queries (November 2010)
Here is the November 2010 version of my diagnostic information queries for SQL Server 2005. Many of these queries are...
2010-11-15
2,666 reads
My Conversation with Ted Kummert at the PASS 2010 Summit
For some mysterious reason, I was selected as one of the “official” bloggers/tweeters during the PASS Keynotes last week. This...
2010-11-15
614 reads
XBox 360 250GB and Kinect Bundle
I took the plunge and bought one of the new 250GB XBox 360 and Kinect bundles for $399 at Best...
2010-11-14
812 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