Speaker workshop
Andy Warren made a trip to St. Louis this past weekend to put on a speaker workshop for our user...
2008-08-19
1,321 reads
Blog Posts
What every DBA that manages a large number of SQL Servers should know about SQL 2008!!
Error when importing RegServer list from SQL 2005 to SQL 2008
I discovered the already known bug in SQL 2008 that...
2008-08-19
3,087 reads
Building a Security Philosophy Posted on SQLServerCentral.com
This was actually posted about a week ago, fell behind a little during travelling. Building a Security Philosophy was written...
2008-08-18
1,497 reads
How do I automatically respond to mirrored database failovers?
Automatic Failover - an incomplete solution
Automatic failover with Database Mirroring is great, but what about all of the other things that...
2008-08-18
2,096 reads
IndyTechFest Update - Aug 18, 2008
Just had a note from John Magnabosco, the schedule for the event on Oct 4, 2008 has been published. I'll...
2008-08-18
632 reads
Show off your company
I was looking for editorial content and ran across The Planet Blog, from The Planet, a hosting company. I was...
2008-08-18
903 reads
SQLSaturday #9 in Greenville, SC on Oct 11, 2008
Paul Waters and team from the SQL Server Innovators Guild have decided to host a SQLSaturday at ECPI Greenville, SC...
2008-08-18
465 reads
Database administration culture
"Culture", according to Merriam-Webster Dictionary http://www.merriam-webster.com/dictionary/culture, has one definition as
"the set of shared attitudes, values, goals, and practices that characterizes an...
2008-08-16
1,835 reads
August Charlotte SQL Server User Group Meeting Announcement
The Charlotte SQL Server User Group meeting will be held online on August 20th at 12 Noon (EDT). They'll have...
2008-08-15
647 reads
TechEd Online
I'm glad I'm not this slow, or maybe it's timed for the SQL Server release, but my TechEd Online panel,...
2008-08-15
814 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