Decoding Helm Secrets
Helm is a great tool for deploying applications to Kubernetes. We can bundle up all our yaml files for deployments, services etc. and deploy them to a cluster with...
2020-08-19 (first published: 2020-08-10)
476 reads
Blog Posts
Finally, PASS is a proper association now
For the longest time PASS was known as the Professional Association for SQL Server, and made all of its money from a single event each year, the PASS Summit. If...
2020-08-19
41 reads
My First Hand-built AWS CodePipeline
I’ve just completed my first, successful, AWS CodePipeline. I’m sorry to say it took me weeks to figure out just how simple this was. Frankly, it’s embarrassing. I already...
2020-08-19 (first published: 2020-08-10)
323 reads
Take off with the new Flight Simulator
On August 18th 2020, Microsoft launched the newest version of the most successful flight simulator ever developed. The program was first released in 1982 and is the longest-running, best-known,...
2020-08-19
123 reads
Take off with the new Flight Simulator
On August 18th 2020, Microsoft launched the newest version of the most successful flight simulator ever developed. The program was first released in 1982 and is the longest-running, best-known,...
2020-08-19
21 reads
Creating a SQL Clone Agent and a First Image
In a previous post, I set up the SQL Clone server. This is really a metadata store and web front end, but it does no real work. The Agent...
2020-08-18 (first published: 2020-08-06)
228 reads
Daily Coping 18 Aug 2020
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-08-18
11 reads
Thinking About the 2021 PASS Summit
I know that we don’t yet know how the 2020 Summit will turn out, but I’ll make some guesses: A lot of people like it for the lower cost,...
2020-08-18 (first published: 2020-08-05)
741 reads
Availability Group issues fixed with Alerts
Learn how to use the SQL Server Agent Alerting system to capture Availability Group related errors and to respond to them by running jobs.
The post Availability Group issues fixed...
2020-08-17 (first published: 2020-08-06)
917 reads
Azure Data Engineer Certification Preparation
This week i got my new Azure Certification badge (Azure Data Engineer) and today i am writing this article to share all of the resources i collected it during...
2020-08-17
56 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