Planning for Maintenance
On Monday, Microsoft released an out-of-band security patch to address the .LNK vulnerability. This affects Windows XP, including Windows XP...
2010-08-06
688 reads
Blog Posts
Simple Script to Determine Who To Kill (SPIDs)
I'm mostly working now supporting the building of SSIS packages for ETL. And on one particular project we've been making heavy...
2010-08-06
755 reads
SQL Saturday #28 Update
We are just about a week away from probably the biggest FREE training event to ever take place in Baton...
2010-08-06
553 reads
The Inteview is Done
I completed my interview for the PASS board election today. I don’t want to talk about what was in the...
2010-08-06
407 reads
Tiny Homes
Over the course of my life I’ve lived in a few different places; small home, apartment, pup tent, large tent,...
2010-08-06
535 reads
Windows Azure Platform One Month Pass
According to all of their public pronouncements and the flurry of recent activity, Microsoft seems extremely serious about Windows Azure...
2010-08-06
1,002 reads
GTD: Emergency Scanning versus Processing
Cross-posted from The Goal Keeping DBA blog.
I'm making an earnest effort to work through Getting Things Done in an effort...
2010-08-05
750 reads
Middle of the Pack
I noticed the scores for the first part of the PASS nomination process were posted recently. These were the aggregate...
2010-08-05
417 reads
Midlands PASS Meeting - August 10
Topic: Creating a SQL Server Utility Environment
Can SQL Server be offered as a service (SQLaaS)? Can SQL Server be treated like...
2010-08-05
775 reads
Notes on Mentoring
Being a good mentor is hard, perhaps harder than being a parent, because with children it’s fair to share with...
2010-08-05
390 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