Building Better Test Data on the Redgate Hub
I have a new piece published over at the Redgate Hub: Building Better Test Data with SQL Provision. Part of...
2018-07-03
847 reads
Blog Posts
Code You Would Hate To Live Without (T-SQL Tuesday #104 Invitation)
The recent news about Microsoft acquiring GitHub has me thinking about how amazing it is for us to be part of today's online code community.
Before modern online programming communities,...
2018-07-03
2 reads
Code You Would Hate To Live Without (T-SQL Tuesday #104 Invitation)
The recent news about Microsoft acquiring GitHub has me thinking about how amazing it is for us to be part...
2018-07-03
265 reads
Code You Would Hate To Live Without (T-SQL Tuesday #104 Invitation)
The recent news about Microsoft acquiring GitHub has me thinking about how amazing it is for us to be part of today's online code community.
Before modern online programming communities,...
2018-07-03
6 reads
Half-year round-up
So, to do the name “blog” justice, I should post something every now and then. Alright, here you go, let...
2018-07-03
281 reads
Mastering Index Tuning–Day 3
This is a short series of posts on the courses I took with Brent Ozar. I actually completed the courses...
2018-07-03
959 reads
Power BI Custom Visuals Class (Module 109 – as Timeline)
In this module you will learn how to use the as Timeline visual. The as Timeline is a Gantt chart...
2018-07-03 (first published: 2018-06-28)
2,868 reads
Saving disk space by choosing the correct data type
"Database is almost 4 TB in size, user is complaining on long times for DEV data refresh and high storage...
2018-07-03
1,743 reads
Congrats to DCAC Staff on MVP Renewals
July 1st is a day all Microsoft Most Valuable Professionals (MVP) wait patiently at their computers hitting F5 over and...
2018-07-02
332 reads
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
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