New England Data Camp v2/SQL Saturdy #34 Update
The second annual New England Data Camp is shaping up to one excellent event. We’ve put together a great set...
2010-01-11
558 reads
Blog Posts
PASS Update #22 (Speaker Bureau – Call for Comments)
One of my big projects this year is to build a speaker bureau, so in this post I’m going to...
2010-01-11
754 reads
Permon Counters Missing Windows 64 Bit SQL Server 32 Bit
For reasons beyond the scope of this post I have an environment where I have Windows 2003 R2 64 bit...
2010-01-11
750 reads
That DARN TOMCAT
Here is a challenge that had me stumped for several days. Besides for working with Reporting Services on a day...
2010-01-11
1,252 reads
GodMode - in Windows 7
It's very interesting if you create new folder with name:
GodMode.{ED7BA470-8E54-465E-825C-99712043E01C}
Try it and you will find a lot of stuff there...
2010-01-10
515 reads
House of Commons Justice Committee Related to The European Union's Data Protection-Retention Directives
Just this past week on Tuesday afternoon (a link to video of Parliament online, please forward to about half way through),...
2010-01-10
2,215 reads
Implement a stack in SQL Server using stored procedures
In this article I will show you how to implement a stack. In programming, stacks are a great way to...
2010-01-10
8,168 reads
Professional Communications
This past week I had the opportunity to have lunch with a vendor at his clients’ site. As a part...
2010-01-10
519 reads
2010 Goals
It seems like every blog I read has a list of goals posted for the year. This seems like a...
2010-01-09
344 reads
New HTPC Build with 32nm Intel Core i3 530
Since Intel announced and released the new 32nm Core i3 processors and compatible H55 chipset, Socket 1156 motherboards this week,...
2010-01-09
2,977 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