Confessions of a DBA - Part 1
Couple of year's back I brought the SQL Server down to its pathetic knees by using a HINT. Yes, with...
2011-04-08
1,497 reads
Blog Posts
Find Table Heaps Using Policy-Based Management
This is just a quick post in regards to a conversation I just had via Twitter. If you don’t already...
2011-04-08
1,020 reads
For Your Friday Enrichment: Get Alifeatoll
I have made something for your pleasure and entertainment, and placed it on the MidnightDBA YouTube Channel. Please to enjoy...
2011-04-08
514 reads
Hostettler & the Bottleneckers
A bit of fun !
A long long time ago before the dawn of 2010, somewhere to the South of the...
2011-04-08
616 reads
Notes for Moving BizTalk’s Databases
Yesterday, I was tasked with helping a team move their BizTalk databases to another server. These are my notes for...
2011-04-08
1,435 reads
Powershell Day 8
Day 8 Event Viewver Event log is a very important trace and diagnose the activity on the system. Using Event...
2011-04-08
220 reads
SQL Server, Storage and You
Just a note that I will start my three part webcast, SQL Server, Storage and You next week April 13th...
2011-04-08
1,011 reads
Upcoming Events
If live in Central/South Florida or are planning a trip, we’ve got several IT community events worth checking out…
May
SQLRally in...
2011-04-08
555 reads
A SQL Server Hardware Nugget A Day – Day 7
For Day 7 of this series, I will talk about the incredibly useful CPU-Z utility, which is available for free...
2011-04-07
1,317 reads
I Got Registered!
I’m going to SQL Rally! Are you going to SQL Rally? Have you heard of SQL Rally?
What’s SQL Rally?
I’m glad...
2011-04-07
423 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