Changes to PASS Voting Eligibility
There was a blurb in the Connector today about an eligibility change for voting. The “change” is a requirement to...
2014-01-08
390 reads
SQLAndy
Reporting Services Parameter Assumptions
Ran into a new-to-me quirk this week while putting together a couple of reports. I have a summary report (essentially...
2014-01-08
521 reads
Reminder: Orlando Code Camp on March 22, 2014
Ninth annual!
Yes, Orlando Code Camp #9 this year, being held at Seminole State College on March 22, 2014. I’ve submitted...
2014-01-07
362 reads
Picking The Next Cell Phone
Cell phones are incredibly useful tools. Even a bad one is better than not having one, but a bad phone...
2014-01-07
474 reads
Looking Back At the Droid Razr Maxx
It’s been 18 or 19 months since I upgraded from the Droid X to the Maxx. The X was a...
2014-01-06
380 reads
South Alabama Day of .Net
Just received an email from my friend Ryan Duclos announcing the South Alabama Day of .Net in Mobile, Alabama, on...
2014-01-06
341 reads
Throwing Spaghetti At The Wall Isn’t The Worst Plan
I get a lot of email about job opportunities, almost none of which interest me enough to call back about...
2014-01-03
285 reads
Some Thoughts on the Target Breach
Possibly as many as forty million credit cards used at Target were compromised. A staggering breach and a cautionary tale...
2014-01-02
960 reads
Welcome To 2014
A quiet and rainy day here in Orlando today. Not my favorite weather, but good for thinking, mostly about what...
2014-01-02
319 reads
Review of Change to PASS Bylaws
As required, the Board has posted proposed changes to the bylaws for review by the members. The changes are fairly...
2013-12-26
529 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