I Can’t Go To Space
If I could win the DBA In Space contest, I’d be all over it like white on rice. But I...
2011-10-24
1,464 reads
Blog Posts
It’s Your Career
It’s your career. It’s something you have to take ownership of and work on. I know that life is busy,...
2011-10-24
1,189 reads
PASS Update #66 (All Good Things)
Last week I emailed the Board of Directors my resignation effective December 31st of this year, ending my current term...
2011-10-24
642 reads
SET ARITHABORT ON
When completing an installation I saw the following error – which stopped the installation .
The error occurred during the creation of...
2011-10-24
1,908 reads
SQL Server 2012 Developers Training Kit
Microsoft has recently released the SQL Server Developer Training kit for SQL Server 2012. The developers kit includes fantastic resources...
2011-10-24
1,798 reads
SSIS 2012: Project Reference
One of the less advertised enhancements of SSIS in SQL Server 2012 is the Project Reference type available when using...
2011-10-24
3,243 reads
What is Microsoft TAP and RDP?
Technology Adoption Program (TAP) and Rapid Deployment Program (RDP) are ways for Microsoft to get early feedback on new products or product...
2011-10-24
2,246 reads
Gaining SQL Server SysAdmin Access
I’ve seen this come a few times at work and I’m sure most you have experienced something similar.
Someone or an...
2011-10-22
4,238 reads
Giving back–Colorado GiveCamp has started (#CoGiveCamp)
The Colorado GiveCamp is underway with 40 volunteers and 5 charities. Gabe Villa ( blog | twitter ), Kevin Krueger ( blog | twitter ), Jason...
2011-10-22
1,063 reads
Fun Pix
Various photo uploads from the past year.
Filed under: Blog Tagged: Humor, pictures, syndicated
2011-10-21
963 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