More Nukes
One of the reasons that I did not vote for President Obama was his stance on our energy issues, specifically...
2010-02-01
326 reads
Blog Posts
Orlando Code Camp 2010 Announced
The fifth annual Orlando Code Camp will be held March 27, 2010, at the Lake Mary Campus of Seminole State...
2010-02-01
350 reads
Sending SSIS Errors to the Windows Event Log
In a previous post I explained how to trap for errors in your Script Task and Components and send the information to the SSIS...
2010-02-01
4,773 reads
Some BI Related Official Microsoft Related SQL Server Blogs
My other Microsoft blog list was more focused on relational database administration and development, so here is my list of...
2010-02-01
297 reads
Some BI Related Official Microsoft SQL Server Blogs
My other Microsoft blog list was more focused on relational database administration and development, so here is my list of...
2010-02-01
757 reads
Some Selected Official Microsoft SQL Server Blogs
Here is a list of a some of the official Microsoft SQL Server blogs that I have stumbled across. Some...
2010-02-01
336 reads
SQL Saturday #34 Wrap-up
Whew!
It’s over. New England Data Camp v2, aka, SQL Saturday #34, was completed on Saturday. Going in we had maxed...
2010-02-01
587 reads
Stored Procedure to Sequentially Run SQL Agent Jobs
Introduction
Here is another one of my utility scripts. Lately it seems like all I am blogging about is utility scripts,...
2010-02-01
2,573 reads
Teaching Two SQL Server 2008 Classes at University of Denver, University College in Spring Quarter
I’ll be teaching two SQL Server 2008 classes this spring at University of Denver, University College. The first one, which...
2010-02-01
778 reads
The Powershell V1 to V2 Conversion
This post is about my experience converting the CodePlex project, SQL Server Powershell Extensions (SQLPSX) Powershell V1 function libraries into PowerShell V2 Advanced...
2010-02-01
2,077 reads
Blogs
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...
Finally Cleaning Up Dropbox: Moving Almost a TB to Google Drive with rclone
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
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