New Windows Vista Security Blog
If you're keeping up with Windows Vista and you're interested in the
security aspects of it, there's a new blog, with...
2006-07-29
1,394 reads
Blog Posts
Haidong Ji blogs on a tip for learning Perl
Haidong Ji, co-author of Professional SQL Server 2005 Integration Services, blogged on Learning Perl using the Perl Debugger. Haidong posts...
2006-07-27
1,599 reads
Interview with Craig Mundie on Channel 9
Channel 9 has posted a 25 minute interview with Craig Mundie, Chief Research and Strategy Officer for Microsoft. You can...
2006-07-27
1,652 reads
New SQL Server 2005 Books Online download available
As reported in several other places... there is a new Books Online (July 2006) for SQL Server 2005. You can...
2006-07-25
1,916 reads
Before you submit that incident to Microsoft...
Check out this post:
Things to consider before submitting an incident to Microsoft
Getting the information together before you make that phone...
2006-07-20
2,349 reads
Presenting at Columbia, SC DotNet User Group
I'll be presenting at the DotNet Columbia SC User Group on August 8th.
My presentation is tentatively titled, "Something old, something...
2006-07-20
1,641 reads
The Plumbing Behind MSDN 2
There is a very interesting article about how MSDN 2 utilizes SQL
Server 2005 technologies, specifically Service Broker and CLR
integration. The...
2006-07-20
1,517 reads
Free Data Models
I saw this on a Channel 9 forum thread:
Library of Free Data Models
There are quite a few starter data models...
2006-07-19
1,918 reads
Get a Better Understanding of How Queries Execute
I was catching up on my blog reading (unfortunately, in some cases I'm
a month behind) and came across a link...
2006-07-14
1,456 reads
New KB Article on SQL Server 2005 File Growth Bug
There is are two new KB articles on how the file growth value can become abnormally large. You can find...
2006-07-13
1,620 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