SQLSaturday #362 – Austin, TX – Let’s Get Weird
I used to spend the 4th of July weekend (or week) in Austin with some buddy’s when we were in...
2015-01-20
925 reads
The Smiling DBA
PASS – Connect, Share and Learn
The Professional Association of SQL Server (PASS) has a slogan for what they do – CONNECT, SHARE and LEARN. So, what...
2014-12-18
624 reads
PASS Summit: Blogger Q&A with Board of Directors Executive Committee
On Thursday, I was invited as a blogger to attend an intimate conversation (Q&A) with the PASS Board of Directors:...
2014-11-07
784 reads
PASS Summit 2014
Well, it is that time of year again. The Professional Associations for SQL Server (PASS) annual summit. This year we...
2014-10-29
1,250 reads
Can’t Create A Timeline in Excel on Multidimensional Cube
Excel 2013 - We can’t create a Timeline for this report because it doesn’t have a field formatted as Date.
After getting...
2014-10-15
3,362 reads
PASS got it right
This morning I received an email (really 3 emails) about an extension for voting for the Board of Directors giving...
2014-09-27
775 reads
PASS Summit 2014 Announcements
In case you do not receive the PASS connector, here are some announcements for this year’s summit on Nov 3rd...
2014-09-03
815 reads
Upcoming PASS Virtual Chapter Webcast (FREE!!!)
As always, there are many free ways to learn more about SQL Server and the Professional Association of SQL Server...
2014-08-08
685 reads
PASS Data Arch VC presents SQL Server MVP Grant Fritchey - How to Build a Database Deployment Pipeline
Please come join the Data Architecture VC this Wednesday to get info from MVP Grant about Database Deployment something all...
2014-07-21
459 reads
Upcoming Free PASS VC Webcasts
Here is a list of upcoming webcast presented by various PASS Virtual Chapters that are always free. Some are recorded...
2014-07-08
599 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