My journey finally ends at the SQLPASS 2012 Summit
Yesterday SQLPASS revealed the sessions that were selected for the upcoming SQLPASS
summit in Seattle from November 6 – 9. I'm very...
2012-06-20
797 reads
Blog Posts
SQL Server 2012 CU2 – Have a little fun (#AppliedSQL)
SQL Server 2012 Cumulative Update (CU) 2 is out! If you’re like Me-from-10-years-ago, you couldn’t care less!
But there are actually...
2012-06-20
1,293 reads
SQLBits X videos online
All the videos for this popular conference are online or will be soon (69 of them). Take a look at the...
2012-06-20
1,131 reads
Vacation Notes
I wrote this over the course of 10 days, so it’s a bit rambling, but maybe you’ll find a good...
2012-06-20
801 reads
Enumerating Index Fragmentation with Powershell and SMO
I wish I could say that this was a simple task, but as I dove into SMO and some of...
2012-06-19
2,741 reads
Jacksonville IT Pro Camp 2012 Presentation
Presentation and scripts from my Integrating SQL Server PBM with SCOM session at Jacksonville IT Pro Camp 2012.
2012-06-19
1,172 reads
PASS Summit 2012
I sure hope you’re planning on attending the PASS Summit this year. If you’re not, you might want to reconsider....
2012-06-19
787 reads
Speaking at PASS Summit 2012
Today I’m thrilled and humbled to announce that I will be speaking 3 times at PASS Summit in November 6-9! ...
2012-06-19
1,002 reads
SQL Server 2012 RTM Cumulative Update 2
Last night, Microsoft released SQL Server 2012 RTM Cumulative Update 2, which is Build 11.0.2325.0. It has 37 fixes in...
2012-06-19
1,790 reads
Status Column in SSISDB Catalog Database
I occasionally review the search terms people use to get to this blog and secretly celebrate knowing my post helped...
2012-06-19
1,222 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