Training and tips to get certified with Microsoft (Part 4 and last)
In the previous posts I posted some questions that I usually get when we talk about getting certified with SQL Server also listed some resources you can use to...
2017-08-21
8 reads
Blog Posts
Database Issue: The transaction log for database ‘db_name’ is full due to ‘ACTIVE_BACKUP_OR_RESTORE’.
Today, I was called in the early hours because the transaction log of one of the SQL Server 2016 database was full. I logged onto the SQL server instance...
2017-08-20
15 reads
Database Issue: The transaction log for database ‘db_name’ is full due to ‘ACTIVE_BACKUP_OR_RESTORE’.
Today, I was called in the early hours because the transaction log of one of the SQL Server 2016 database...
2017-08-20
495 reads
Query Store functionality in earlier versions of SQL Server
One of the best features introduced in SQL Server 2016 was the Query Store. Having the ability to see which...
2017-08-19
546 reads
31 Days of Disaster Recovery Revisited
A few years ago, I did a blog post series dedicated to disaster recovery (backups, restores, corruption, etc). 31 blog...
2017-08-18
476 reads
Being a Positive Influencer
I read a lot of self-help and improvement information. I’m always trying to hack my brain or my attitude to...
2017-08-18 (first published: 2017-07-31)
1,912 reads
Fixing You’ll need a new app to open this ms-word
It should come as no surprise that we rely heavily on SharePoint for sharing documents at Microsoft. For the most...
2017-08-18
887 reads
Fixing You’ll need a new app to open this ms-word
It should come as no surprise that we rely heavily on SharePoint for sharing documents at Microsoft. For the most part it is a great solution with few issues....
2017-08-18
237 reads
Friday Reading 2017-08-18
Cool week, I’ve been selected to present at SQL Saturday Holland & SQL Saturday Denmark this year. September and October are...
2017-08-18
375 reads
Learning through gaming a SQL Server tale
I’ve been teaching my 17 yr old SQL Server and other various topics. I have quite a bit of experience...
2017-08-18 (first published: 2017-07-31)
2,428 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