Can You Dig It? – Plan Cache Series
She can dig it!
D Sharon PruittA few PASS Summit’s ago, I became interested in the information available in the...
2011-02-18
588 reads
StrateSQL
Writing A Month Long Blog Series
You might wake up one day soon and think, “Hey, wouldn’t it be cool to write a month long blog...
2011-02-14
607 reads
CHD Awareness Week
Do you know about congenital heard defects (CHD)? Did you know that February 7-14 is the week dedicated to making...
2011-02-14
471 reads
February PASSMN Meeting This Week
PASSMN meeting is this week on Tuesday. Without further ado…
Meeting Details
Here are the details on the meeting location and time:
Date:February...
2011-02-14
528 reads
Can You Dig It? – Find Estimated Cost
She can dig it!
D Sharon PruittIt’s the eighth post in the plan cache series. I hadn’t expect to take as...
2011-02-11
903 reads
Iowa PASS Presentation Materials
Driving to the User Group
This past Wednesday I took a drive down to the Iowa SQL Server Users Group meeting. ...
2011-02-11
480 reads
31 Days of SSIS Conclusion
31 Days of SSIS
Last month, I published the 31 Days of SSIS blog series. As a conclusion to that series,...
2011-02-10
781 reads
SQL Server MVP Daily Paper
A while back, I started a twitterlist of SQL Server MVPs. I wasn’t really sure why, but I just thought...
2011-02-10
544 reads
February PASSMN Meeting Announced
If you are looking for a change to get together with other SQL Sever professionals in February to talk about...
2011-02-07
720 reads
PowerShell: Download List of SQL Server MVPs
Turtle Shell?!
This weekend, I was working on something that I will blog about later this week. As part of that,...
2011-02-07
758 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