Speaker of the Month: April 2016
THIS IS NOT AN APRIL FOOL POST!
Seriously.
My Speaker of the Month for April 2016 is Keith Tate (b|t) and his...
2016-04-01
493 reads
Grant Fritchey
- Twitter: @https://twitter.com/gfritchey
- Website: https://scarydba.com
- LinkedIn: https://www.linkedin.com/in/grant-fritchey/
- Bluesky: https://bsky.app/profile/gfritchey.bsky.social
Do You Teach Azure Data Platform?
I offer instruction on the Azure Data Platform, and have for about six years, since shortly after it came out....
2016-03-29
821 reads
Cross Database Query in Azure SQL Database
You can’t query across databases in Azure SQL Database… or can you?
Let’s check. I’ve created two new databases on an...
2016-03-28 (first published: 2016-03-21)
3,128 reads
Happy Dance!
I’m all like:
Because I saw this on an eval:
I’ve been trying to ramp up to take advantage of my MSDN...
2016-03-25
1,115 reads
PASS Board 2016: Update #2
Time flies. I didn’t notice that I hadn’t posted an update in February.
There’s been a lot going on since I...
2016-03-24
432 reads
Leadership Lessons
Not for you, for me.
I’m sure you’ve heard the statement: Praise in public. Criticize in private.
I agree with this approach....
2016-03-18 (first published: 2016-03-14)
1,736 reads
Opportunities To Talk
It’s weird being an introvert who likes to talk to people, but what can I do. I like talking to...
2016-03-17
467 reads
2016-03-14
111 reads
SQL Server Backups Are A Business Decision
Blog post #3 in support of Tim Ford’s (b|t) #iwanttohelp, #entrylevel
Read more about Tim’s challenge here.
It’s very easy to think of...
2016-03-10 (first published: 2016-03-07)
1,809 reads
Wait Statistics in Azure SQL Database
You need to be aware that you’re going to see differences when you’re working with Azure SQL Database when it...
2016-03-07 (first published: 2016-02-29)
1,905 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