2010 Scripting Games
Since I've decided it's time for me to learn Powershell, naturally the best way to learn it is to dive...
2010-04-21
764 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
Thoughts on the SQL Server 2008 R2 Press Conference
If you weren't aware, Microsoft held a BI telelconference today which announced the release to manufacturing (RTM) of SQL Server...
2010-04-21
1,194 reads
PowerShell 2.0 on Windows XP SP3 - Can It Be Upgraded?
In my last blog post I indicated that I would be adding learning PowerShell to my list of goals. I...
2010-04-15
5,038 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
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
Cloud Computing - Will Data Breaches Cost More?
That's the main point from the following article:
Video: Data breaches to cost more in the cloud
The cost was calculated per...
2010-04-09
1,040 reads
A Good Expansion on the Topic of Plagiarism
In a previous post I gave some links which help explain what plagiarism is and how to generally avoid it....
2010-04-08
668 reads
SQL University Starting Back Up
Jorge Segarra's ( @SQLChicken) excellent community idea, SQL University, is starting back up next week. This is effectively free training on...
2010-04-08
743 reads
New MSSQLTips Article: Nesting Database Roles in SQL Server
I'm still way behind on my writing for the year, thanks to fighting off stronger than usual migraines and now...
2010-04-07
1,671 reads
What I Do to Prep a Technical Presentation
This was a question asked on Twitter the other day, "How do folks prepare for a presentation?" Here are some...
2010-04-06
801 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