Building a SQL Server Inventory – Part 1
Ok folks, you asked for it. Well, a few of you did, anyway. So today I’m going to share with...
2012-05-31 (first published: 2012-05-29)
5,940 reads
Colleen M. Morrow
Building a SQL Server Inventory – Part 2
Last time I went through my script to gather server information for my inventory. Today I’m going to go through...
2012-05-31
4,175 reads
SQLSaturday #119 Chicago – In the Books
As I write this, I’m enjoying a margherita pizza and a Miller High Life in my room. The SQLSaturday #119...
2012-05-21
749 reads
SQL Saturday #119 – One week to go
One week from today I’ll be boarding a plane for my very first visit to Chicago* (airports not included).
One week...
2012-05-11
727 reads
Blogging Tools: BlogDesk Review
As a blogger, you have several options available to you when it comes to writing posts. You can write them...
2012-04-30
2,214 reads
Slacking Off: Totally TED
Lately I’ve taken to watching TED talks in the evening. They’re thought-provoking, usually entertaining, and, best of all when watching...
2012-04-27
953 reads
The Importance of a SQL Server Inventory
Pop quiz!
It’s time to true-up with Microsoft, what are your current license counts?Operations needs to schedule maintenance on ServerY, what...
2012-04-23
2,720 reads
Temporary Post Used For Theme Detection (a2bb2736-7786-4122-aa80-2ea5c4a91819 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
This is a temporary post that was not deleted. Please delete this manually. (a9a8917a-7430-47c6-8534-f96e3e4e0618 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
2012-04-21
771 reads
Custom TDS Endpoints: Listening on multiple ports
Last time, I talked about how clients communicate with SQL Server through TDS endpoints and how to disable endpoints to...
2012-04-18
2,172 reads
Better Living Thru Powershell: Update Statistics in Parallel
As part of a project I’m currently involved with, we’re migrating a database to SQL Server 2008 and performing some...
2012-04-17 (first published: 2012-04-12)
2,838 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