On the Fifth Day…
Today we will have a quick change of pace. This will be less about maintenance and more about internals.
Today’s topic...
2012-12-17
1,082 reads
Jason Brimhall
On the Fifth Day…
Today we will have a quick change of pace. This will be less about maintenance and more about internals. Today’s topic is one of particular interest to me as...
2012-12-17
3 reads
On the Fourth Day…
We have come to the fourth day in this mini-series. So far I have laid down some under-carriage maintenance for...
2012-12-16
889 reads
On the Fourth Day…
We have come to the fourth day in this mini-series. So far I have laid down some under-carriage maintenance for one of our favorite databases. That database being the...
2012-12-16
6 reads
On the Third Day…
Mais Oui!
But of course, we must have some french hens for today! Today we have the third day of pre-Christmas....
2012-12-15
878 reads
On the Third Day…
Mais Oui! But of course, we must have some french hens for today! Today we have the third day of pre-Christmas. And as was mentioned we have more undercarriage...
2012-12-15
6 reads
On the Second Day…
Yesterday, I introduced the 12 Days of pre-Christmas. In that first article, I gave you a gift to help maintain...
2012-12-14
1,191 reads
On the Second Day…
Yesterday, I introduced the 12 Days of pre-Christmas. In that first article, I gave you a gift to help maintain your msdb undercarriage. Today I want to continue...
2012-12-14
11 reads
On the First Day…
Many of us have heard the song “The Twelve Days of Christmas.” Some are familiar with how that song has...
2012-12-13
838 reads
On the First Day…
Many of us have heard the song “The Twelve Days of Christmas.” Some are familiar with how that song has some connection with the Holiday season for Christians. Fewer...
2012-12-13
16 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