Join me at the PASS Summit
It seems just yesterday that we were all in Seattle together, getting a crash course in what’s new and exciting...
2012-06-25
429 reads
Blog Posts
JSON and the NoSQL “advantage” over SQL Server
First what is JSON?
JSON: JavaScript Object Notation.
JSON is syntax for storing and exchanging text information, similar to XML.
JSON is smaller...
2012-06-25 (first published: 2012-06-14)
18,271 reads
Killing me softly with Service Broker…
A few days ago, I found a very interesting behavior regarding Service Broker on a
customer system. The main thing is...
2012-06-25
3,458 reads
Maintenance Plan Owner
We all inherit things from time to time through our profession. Sometimes we inherit some good things, sometimes we inherit some things that are not so good. Other times...
2012-06-25
14 reads
Speaking at PASS Summit 2012
It’s about that time again, PASS Summit 2012 is right around the corner in Seattle, WA. It will be held...
2012-06-25
959 reads
SQLRally 2012 Eval Scores
I was just browsing the results of the presentations at SQLRally 2012. I ended up with a evaluation average of...
2012-06-25
643 reads
Unable to activate a Windows 2003 VM on Hyper-V behind a proxy
Ok, so this is not strictly a post about SQL itself (and it's about a fairly old OS), but I...
2012-06-25
2,732 reads
Excellent SSIS 2012 Upgrade Video
This presentation gives an excellent overview of the process of upgrading SQL Server 2008 SSIS packages to work with SQL...
2012-06-24
1,311 reads
Using SQL Server 2012 FileTables
SQL Server 2012 allows you to store file/directories in a special table called FileTable that builds on top of SQL...
2012-06-24
13,768 reads
Inspirational Database Administration Requirements
Just as a society’s civilization is mostly nurtured by its culture, I believe that DBA work quality is mostly determined...
2012-06-23
930 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