Speaker Eval Form, Part 2
My friend Mike Antonovich was kind enough to really go through my draft and provided some great feedback which I've...
2008-02-12
978 reads
Blog Posts
Init from Backup Published on SSC
This article shows how to initialize a subscriber from a backup in SQL 2005. It's a niche technique, but it...
2008-02-11
341 reads
Kalen Delaney SQL Server Internals DVD
I did end up pre-ordering the first DVD on SQL Server internals by SQL Server MVP and SQL Server internals...
2008-02-11
1,364 reads
Making Sponsorship Work at Community Events & User Groups (My Wish List)
This topic came up during the speaker reception at the South Florida Code Camp and while I've posted here and...
2008-02-11
797 reads
Next oPASS Meeting is Feb 12
For those of you in Orlando our next meeting will be held on Feb 12 from 6-8 pm at the...
2008-02-11
509 reads
SQLSaturday Tampa 2008 is This Weekend (Feb 16)
The Tampa crew of Wes Dumey and Pam Shaw and many volunteers have been working on this for the past...
2008-02-11
561 reads
The Right Font
I was doing some development on my laptop tonight and I was getting fed up with the default font, Courier...
2008-02-09
3,631 reads
Do It My Way
Actually more it's "our way" as mentioned in Andy's post, and less my way than by committee these days with...
2008-02-08
807 reads
Thoughts on HTTP EndPoints, Schemas, and other niche features
Part of a conversation I had at the South Florida Code Camp was what I thought about various features that...
2008-02-07
450 reads
And then there was one
Windows 2008 RTM'd this week, which means that in a few weeks, at the February Launch event, there will be...
2008-02-06
776 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