Building a Better Litter Box
First, I know as I write this that my friend Kevin will be emailing me later today that I’ve jumped...
2013-08-30
1,438 reads
Blog Posts
Building a simple forecast solution on SQL Server
Pricing Forecast is a marketing function that requires a lot of data crunching. Normally there are some factors that the...
2013-08-30
1,532 reads
How to Become a Better DBA
Whether you’re just starting out or already a few years in the game, you’re probably wondering how you can become...
2013-08-30 (first published: 2013-08-26)
3,831 reads
Just Wow!! features
Over the years with each release I’m often impressed by some of the features contained in SQL server but every...
2013-08-30
1,326 reads
One for My SQL Sisters
Women, for the entire male half of the population, I apologize.
Those who know me well recognize, pretty easily, that I...
2013-08-30
1,787 reads
Professional Etiquette When Sending Mass Email – Use BCC:
<begin soap box rant>
Time and time again I find myself having to email people to remind them about how and...
2013-08-30
1,358 reads
Reblog: August 23 to August 29
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-08-30
1,367 reads
SQL in the City 2013 US Tour
It was a huge honor to be chosen for the 2013 US tour of SQL in the City. Red Gate...
2013-08-30
1,202 reads
Before Asking for Help...
I have a standard rule that I use before going and bugging a co-worker or posting via social media/message forum about...
2013-08-29
1,879 reads
Data Mining with Excel Q&A
Thank you to everyone who attended my free webinar on August 29, 2013 where I talked about using the Data...
2013-08-29
2,873 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