Event Driven SSIS with Synchronous Processing and Dynamic Subscriptions
I know the title of this post is a little cryptic and something that only a techie would like but...
2011-10-12
1,865 reads
Blog Posts
From The Bloggers Table Day 1
COMMUNITY!
It is a packed house again this year. If you were here on Tuesday night and you were a first...
2011-10-12
939 reads
Liveblog for Day 1 Keynote at SQL PASS 2011
It is hard to live tweet or live blog when the Wi-Fi is not working reliably. The keynote starts out...
2011-10-12
616 reads
PASS Summit 2011 Day #1 Post #1
Hello again. The PASS Organization has once more allowed me to sit at the bloggers table for the key note....
2011-10-12
988 reads
PASS Summit 2011 Day 1 – Keynote Live Blog
Welcome to PASS Summit 2011 Day 1!! Be sure to get your very own copy of the hot-off-the-presses MVP Deep Dives...
2011-10-12
1,422 reads
Practicing for DR
One of the sayings that I’ve heard a few times from professional atheletics is this:
“Amateurs practice until they get it...
2011-10-12
811 reads
Reach for the Select *s
Do you have your head in the clouds? Have you wanted to take flight? Have you been called “Space Case” If you are a DB Professional, then all of...
2011-10-12
5 reads
Reach for the Select *s
Do you have your head in the clouds?
Have you wanted to take flight?
Have you been called “Space Case”
If you are...
2011-10-12
725 reads
Second Day of Summit
The second day of the Summit was full of even more pre-con’s. Word on the street last night is that...
2011-10-12
952 reads
SQL PASS 2011 Keynote, Day 1
It’s that time of the year again – the SQL PASS summit 2011 is underway! Today I’m participating in the blogger...
2011-10-12
1,332 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