Where in the World is…
You may or may not have noticed that over the past several months I have been somewhat absent from my blog. Very few articles if any have been produced....
2012-07-18
4 reads
Blog Posts
Windows Cluster : Understanding the Quorum settings
In my earlier post, I have explained about the windows cluster and how Sql server works on cluster environment. In...
2012-07-18
4,000 reads
A Trio of EachDB
When administering a larger database environment, sometimes one needs to perform repetitive tasks. Performing repetitive tasks becomes more and more...
2012-07-17
1,559 reads
A Trio of EachDB
When administering a larger database environment, sometimes one needs to perform repetitive tasks. Performing repetitive tasks becomes more and more painful (maybe even demoralizing) with the larger the number...
2012-07-17
14 reads
Attending SQLSaturday #164 in Cleveland
I’ll be back on the road again in August, heading up to Cleveland for SQLSaturday #164. It’s my first time...
2012-07-17
625 reads
Excel 2013 Will Impact BI Users
As noted in that great text, The Hitchhiker’s Guide to the Galaxy, “Don’t panic!” Excel 2013 will make even more...
2012-07-17
817 reads
Office 2013 and SharePoint 2013 Beta
If you follow anything outside the regular SQL Server world coming from Microsoft it should be Office and more importantly...
2012-07-17
1,336 reads
PowerPivot for Excel 2013
The preview for Office 2013 is live!! You can hop over to the Microsoft website and grab it here: http://www.microsoft.com/office/preview/en/try-office-preview. Naturally...
2012-07-17
5,295 reads
PowerPivot for Excel Now 2012 Only
I’m not exactly sure when this happened, but it looks like Microsoft has moved past the PowerPivot 2008R2 and PowerPivot...
2012-07-17
870 reads
Puzzling TVFunctions
I had the opportunity to tune a highly-used function the other day, and was most puzzled by the difference between...
2012-07-17
916 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