OPASS April Meeting Recap
Well, we had our April meeting on Tuesday the 13th. Let's just say it wasn't our most successful meeting, and...
2010-04-14
473 reads
Blog Posts
Should I Go? SQL Saturday plans for the year.
There have been quite a few more SQL Saturday announcements this week for new cities. I enjoy attending these events,...
2010-04-14
424 reads
SNESSUG 4/14/2010
Tonight’s Southern New England SQL Server Users group is sponsored by Idera. Our presenter is Scott Abrants of Iron Mountain....
2010-04-14
614 reads
SQLBits to be Held this Friday in London
Just as a reminder, if you have registered to attend SQLBits this Friday, April 16, at the Church House Conference...
2010-04-14
432 reads
The SQL Server Community
I attended, and spoke at, the inaugural meeting of the Seacoast SQL Server User’s group last night. There were about...
2010-04-14
915 reads
Why I Have Had a Hard Time Adopting PowerShell
PowerShell has been out for a while. When it first came out, I went and grabbed a copy and tinkered...
2010-04-14
4,284 reads
A DMV a Day – Day 13
The DMV for Day 13 is sys.dm_io_virtual_file_stats, which is described by BOL as:
Returns I/O statistics for data and log files....
2010-04-13
1,200 reads
Announcing SQLSaturday #46 in Raleigh
SQLSaturday #46 will be held in Raleigh, NC on September 18, 2010, under the direction of Brett Tomson and team...
2010-04-13
487 reads
BLOB Report T-SQL Tuesday #005- Reporting
This month for my second submission into T-SQL Tuesday, I decided to go with something that provides some insight into...
2010-04-13
1,151 reads
Hosting a User Group Meeting - Day of "Bare Bones" Checklist
This actually came as a response to a tweet from Mike Walsh (Twitter | Blog). But here is the barebones checklist I...
2010-04-13
594 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 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...
BCA KCP Pasar Minggu Center | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Jl. Lenteng Agung Raya No.26 E-F, RT.1/RW.4, Ps. Minggu, Kota Jakarta Selatan, Daerah...
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