SQL Saturday, Southern Tour
Things have worked out where I'll be able to hit a SQL Saturday for this month and each of the next...
2010-08-09
600 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
Free SQL Server Training for the Week of August 9, 2010
Monday
SQL Lunch - SSIS Design Patterns 1a: Introduction to SSIS Design Patterns - Andy Leonard
Tuesday
PASS Application Development Virtual Chapter - Where the bl**dy...
2010-08-06
1,219 reads
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
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
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
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
Free SQL Server Training for the Week of August 2, 2010
Tuesday
PASS Performance Virtual Chapter - Parallelism and Performance - Are You Getting Full Return on Your CPU Investment? - Adam Machanic
Thursday
SQL Lunch - Analysis...
2010-07-30
1,577 reads
Free SQL Server Training for the Week of July 26, 2010
Tuesday
Pragmatic Works - SSIS Management for the DBA - 11 AM EDT - Brian Knight
PASS Application Development VC - The Benefits of SQL Azure...
2010-07-23
811 reads
For SQL Server 2005/2008, Consider SecurityAdmin = SysAdmin
In a recent thread here on SQL Server Central, it was pointed out that a member of the securityadmin fixed...
2010-07-23
5,025 reads
Free SQL Server Training for the Week of July 19, 2010
This will start a new trend on my blog. Every Friday morning I'll have a blog post covering the free SQL...
2010-07-15
747 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
BCA KCU THAMRIN | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, RT.1/RW.5, Menteng, Kec. Menteng, Kota...
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...
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