The New Phone Book Is Here!
I can’t help it. I get really terribly excited when I publish a book. Maybe it should be old hat....
2012-06-27
1,607 reads
Blog Posts
The report execution has expired or cannot be found. [rsExecutionNotFound]
I ran across the following error in SQL Reporting Services 2008 R2 a few weeks ago:
The report execution has expired or...
2012-06-27
12,391 reads
Using a Symmetric Key
In my Encryption Primer talk, I do demo on symmetric key use, and wanted to document it here. Encryption is...
2012-06-27
2,984 reads
5 Second Rule Doesn’t Apply to Dropped Databases or Does It?
5 Second Rule Doesn’t Apply to Dropped Databases or Does It?
5 Second Rule Doesn't Apply to Dropped Databases or Does...
2012-06-26 (first published: 2012-06-22)
4,285 reads
A Fire Drill and Voter Registration
I avoid politics here, a discussion best done in other places, but hope you’ll enjoy some thoughts about a recent...
2012-06-26
793 reads
Down and Dark
I came back from vacation to find the home DSL line bouncing up and down a bit. I wasn’t overly...
2012-06-26
1,564 reads
Locking Behavior – Foreign Keys
With Snapshot (read committed snapshot and snapshot isolation level) enabled, when data reading on a table takes place, if any...
2012-06-26
2,753 reads
Preach The Gospel Always, If Necessary Use Words
I’ll be honest, I contemplated a lot about whether to write this blog or not for fear that it may...
2012-06-26
274 reads
Problems with my new book
First off, I apologize. As if writing a book wasn’t hard enough, now we get new problems because of on-demand...
2012-06-26
835 reads
SQL Rally 2012 Nordic
The Nordic SQL Server event of the year is getting closer and closer. YES it is SQL Rally Nordic that...
2012-06-26
887 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