Four faces of an Employee
Whoever starts their career in any domain/technology, initially they will have two faces.
First face of an employee is to take...
2011-10-31
1,736 reads
Blog Posts
Haunting a Database Near You
Today, we have a special Halloween edition. For me, Halloween and computer geek go quite well together. And thinking about it, I wanted to try to better understand if...
2011-10-31
2 reads
Haunting a Database Near You
Today, we have a special Halloween edition. For me, Halloween and computer geek go quite well together. And thinking about...
2011-10-31
1,918 reads
Managing SQL Server in a Virtual World (rough) Notes, Thanks to Quest Presenter Jason Hall
Managing SQL Server in a Virtual World Notes (View Complete Slide Show)
Hosted by MVP Kevin Kline, Quest Software
Guest presenter...
2011-10-31
2,758 reads
Miss SQLBits 9? No problem, all videos are online
All the videos for this popular conference are online or will be soon (48 of them). Take a look at the...
2011-10-31
2,271 reads
PASS Board Of Elections: Rob Farley
Be Part Of The Solution, Not The Problem
<disclaimer >
Now that BoD season is in full swing and I’m not running for...
2011-10-31
2,071 reads
PASS Summit 2012
Yes, I know you just got back from the 2011 Summit. Kinda like I just got back from vacation. But...
2011-10-31
1,461 reads
Tales from the Query Processor
http://www.flickr.com/photos/socal_jim/2070088596/Hello Dear Reader! I've been a bit behind on the blogging but wanted to give you a bit of a...
2011-10-31
1,505 reads
The Showdown
Today we have a guest post from Steve Jones.
I survived SQL in the City in LA, and thanks to everyone...
2011-10-31
1,555 reads
Two of a Kind
Here’s one that I haven’t run into before. A colleague scheduled a meeting with someone else in the organization to...
2011-10-31
1,672 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