The Usefulness of Database Features
The features we want and get in a database platform can make our job easier or harder. Steve has a few thoughts on how they should work.
Frustrated with your database monitoring challenges?
Find out how 2500+ of your database professional peers are meeting current and upcoming challenges in our free reports. We cover the Cloud, Security, Growing Environments and the value of monitoring for the entire organization.
Sentiment Analysis with Python
Python is a modern general-purpose programming language that's very useful for analytics. Sanil Mhatre demonstrates sentiment analysis with Python.
A Real World Security Reminder
A reminder today that security in the physical world can affect the digital world.
Using Azure File and Blob Storage with Azure VMs – Step by Step
Learn how to use Azure File and Blob storage with your applications.
Getting started with MySQL
The first step when getting started with MySQL is to get it installed and running. In this article, Robert Sheldon explains how to install it on Windows and create the first database and table.
Moving from ‘Chaotic’ to ‘Managed’ Database Development using Flyway
This article describes a route to adopting Flyway in order to bring management and control to a chaotic database development process. It is based on use of Flyway migrations to update a database from version to version, while maintaining object-level source scripts for tracking changes between versions.
Backup Architecture
Continuous backup in Cosmos DB doesn't quite work as Steve would expect. He has a few comments on why it is important you know how your backup and restore system works.
How to Compare Tables in Azure Data Studio
Learn about the Schema Compare feature in Azure Data Studio.
Build SQL Server CLR Triggers
In this article we look at how to create SQL Server triggers using Common Runtime Language (CLR) along with examples and a step-by-step guide.
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