Microsoft Ignite Announcements Oct 2022
Announced at Microsoft Ignite were some new product features related to data platform and AI. Below are the ones I found most interesting: Azure Cosmos DB adds distributed PostgreSQL...
2022-10-18
28 reads
Blog Posts
Daily Coping 17 Oct 2022
Today’s coping tip is to make progress on a project or task you have been avoiding Most of the things I do for work are spent looking in the...
2022-10-17
15 reads
New Blog Space
I've decided to move my blog here. You'll see some old content being uploaded in the next few days. Look around, I hope you find some tidbits of information.
Older...
2022-10-17
30 reads
Restore HEADERONLY and FILELISTONLY
Good day reader. This post is coming to you from a busy week in Texas, where the heat is starting to subside. The week’s topic will cover two options...
2022-10-17 (first published: 2022-10-04)
928 reads
Tales From The Field Weekly Wrap Up
Hello Dear Reader!
It's been a while. I've been busy working with a few colleagues on our show Tales from the Field. This has been a learning experience.
I've had to...
2022-10-17 (first published: 2022-10-07)
158 reads
Tales From The Field Weekly Wrap Up for the Week of 10-10-2020
Hello Dear Reader! We had a big week on Tales From The Field! We've got some great stuff planned for you this week, but before we get to the...
2022-10-17
29 reads
Pre-Conference Workshop and Sessions at PASS Summit
I’m pleased to announce that I will be presenting at this year’s PASS Summit. PASS Data Community Summit 2022 is the year’s largest gathering of data platform professionals in...
2022-10-16
45 reads
Daily Coping 14 Oct 2022
Today’s coping tip is to look for the good in people around you today. I’m working remotely today in New York. I flew up last night to be with...
2022-10-14
26 reads
DevOps From Redgate
In a few weeks at the PASS Data Community Summit, I’ll be joining several other Redgaters to put on an all-day precon where we take you on a database...
2022-10-14 (first published: 2022-10-04)
116 reads
How to Calculate Compound Rate in Power BI
Recently I had an interesting use case where I had to a compound calculation in Power BI. You can compound an interest rate for example, where you get a...
2022-10-14 (first published: 2022-09-29)
295 reads
Blogs
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...
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...
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