SQL Server 2008 and R2 Diagnostic Information Queries
It has been a couple of months since I have posted an update to my “SQL Server 2008 and R2...
2010-08-16
1,698 reads
Glenn Berry
Using the Windows Experience Index as a Shopping Tool
One easy to use and useful tool that you can use to compare relative performance between different machines that are...
2010-08-11
1,521 reads
Speaking at 24 Hours of PASS on September 15, 2010
I will be one of the presenters for the 3rd installment of the 24 Hours of PASS: Summit Preview, which...
2010-08-11
780 reads
Windows Azure Platform One Month Pass
According to all of their public pronouncements and the flurry of recent activity, Microsoft seems extremely serious about Windows Azure...
2010-08-06
1,002 reads
Testing Native Backup Compression in Combination with SQL Server 2008 R2 Data Compression
SQL Server 2008 introduced native backup compression and data compression as features that were only available in the Enterprise Edition...
2010-08-04
3,831 reads
SSWUG Ultimate Virtual Conference October 20-22, 2010
I will be presenting four sessions for the SSWUG Ultimate Virtual Conference that will be held online October 20-22, 2010....
2010-08-02
789 reads
A Small Collection of DBCC Commands
There are a number of pretty useful DBCC Commands that have nothing to do with checking the consistency of a...
2010-08-02
1,989 reads
SQL Saturday #51 in Nashville
I just found out today that I will be one of the speakers at SQL Saturday #51 in Nashville, Tennessee...
2010-07-27
868 reads
New Laptop Time
I’ve been looking for a new “thin and light” laptop to use for teaching, and for presentations and demonstrations at...
2010-07-26
820 reads
Project Houston For SQL Azure
Microsoft has released CTP1 of Project Houston for SQL Azure. Project Houston is a Silverlight web based database management tool...
2010-07-22
665 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