I’m Speaking At PASS Summit 2012
With the release of the PASS Summit 2012 schedule, I’m pleased to announce that I have been selected to present...
2012-06-21
837 reads
Blog Posts
Live note-taking: Sean’s NCC-1701-DBA part 2
Note that THIS talk, and a ton more, is the subject of Sean’s precon at SQL Saturday #163 Dallas this...
2012-06-21
939 reads
PASS SQLSaturday - July Events
PASS SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please note that...
2012-06-21
761 reads
PASS Summit - November 2012
PASS Summit is the world's largest and most intensive technical training conference for Microsoft SQL Server community for the SQL...
2012-06-21
635 reads
PASS Virtual Chapter Events - July 2012
Date: Thursday, July 10
Time: 11:00 a.m. - 12:00 p.m. Central Time
Virtual Chapter: DBA Fundamentals
Event URL: http://www.livemeeting.com/cc/usergroups/join (Meeting ID TW8M35, Entry Code...
2012-06-21
763 reads
The Exceptional DBA Awards – 2012
Who will be the Exceptional DBA of 2012? I’ll be judging.
It’s hard to believe that it’s time for the Exceptional...
2012-06-21 (first published: 2012-06-11)
2,578 reads
Bug? Can’t Pass TVP to SQL Function Twice
I run into a bug recently with SQL Server 2012. I believe this exists in SQL Server 2008 as well....
2012-06-20
1,101 reads
Contracting – Your best clients are your current clients…
and your old clients too.
Before I started my contracting business five years ago I realised the importance of selling and...
2012-06-20
839 reads
Corrupt Model database
An interesting case arose at work the other day. SAN issues had caused SQL Server to shutdown and it was...
2012-06-20
761 reads
Get Your Ass to PASS!
This year there are to be no excuses, and I mean it.
You know what I’m talking about. There’s always some...
2012-06-20
825 reads
Blogs
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...
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...
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