Database Superhero Adventures, July 2018
Sorry readers, I was having some many adventures there was no June edition. In May, I had SQLSaturday Dallas where...
2018-07-02
62 reads
Blog Posts
Introduction to Docker and Docker Toolbox
The article gives some knowledge about getting started and utilizing Docker containers. The focus is all about understanding Docker and...
2018-07-02
499 reads
Mastering Index Tuning–Day 2
This is a short series of posts on the courses I took with Brent Ozar. I actually completed the courses...
2018-07-02
947 reads
Microsoft Azure – Enable Geo replication of data – Cosmos DB Part 2
In this article, we will learn how to replicate the data to any Azure region globally. Global Distribution Azure Cosmos...
2018-07-02
376 reads
Microsoft Most Valuable Professional – Data Platform for 2018-2019
Today, I’m proud to announce that I have been renewed as an Microsoft MVP – Data Platform for the 2018-2019 award year, my second MVP award. This is an truly an honor and...
2018-07-02
10 reads
Microsoft Most Valuable Professional – Data Platform for 2018-2019
Today, I’m proud to announce that I have been renewed as an Microsoft MVP – Data Platform for the 2018-2019 award year, my second...
2018-07-02
341 reads
New at Simple-Talk: Principles of Data Protection
My latest article, Principles of Data Protection, has been published at Simple-Talk! I address the basic problem and how we...
2018-07-02
362 reads
SSMS reset window layout (Day 37)
SSMS is a wonderful tool. You can drag Windows around, grouped with others, split, docked, undocked, hidden… it seems endless...
2018-07-02 (first published: 2018-06-20)
4,672 reads
Strings vs Identifiers
A common mistake, and one I make frequently myself is to use a string in place of an identifier, or...
2018-07-02 (first published: 2018-06-20)
3,390 reads
DevOps Debugs the Demo
I had my 24 Hours of Pass session today, Database DevOps to Ensure Compliance, and my demo broke. At least,...
2018-06-29 (first published: 2018-06-12)
2,147 reads
Blogs
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
T-SQL Tuesday #199: Roundup
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
Forums
Increment a number in a SQL Query based on a value
I have an issue where I have a Bill of Material list of items...
Follow Your Hunch
Comments posted to this topic are about the item Follow Your Hunch
What Happens When You Ask a Local AI to Query Your Database?
Comments posted to this topic are about the item What Happens When You Ask...
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