Energy Update - Wind Power Picking Up
It must be picking up again, despite the lack of a sharp rise in energy prices, I am seeing more...
2009-12-13
453 reads
Blog Posts
oPASS Meeting Notes for December 2009
We started off our end of year meeting with our standard networking meet and greet. It’s going smoother, people are...
2009-12-13
561 reads
Where Should I Go From Here?
I’m closing in on vacation – finally – and one of the things I’ll have in the back of my head while...
2009-12-13
588 reads
Email: Getting My Attention, The Wrong Way
I was scrolling through my professional email as my wife drove me in to work (my car is being looked...
2009-12-11
659 reads
Load Windows 7 with a Thumb Drive
With the explosion of Netbooks, it has become important to find new ways to load operating systems. I recently picked...
2009-12-11
318 reads
Locking Scripts
Thanks to everyone who attended my TechNet Thrive! and Nashville SQL Server User Group presentations this week! I hope it...
2009-12-11
414 reads
Orlando Tiki Hut Roadshow Silverlight Edition
Assuming no major problems at work, I’m heading to the South side of town the afternoon of Dec 14, 2009...
2009-12-11
387 reads
Reporting Services Carriage Return
Often when designing a report you may find a need to concatenate values in an expression. For example, you want...
2009-12-11
1,388 reads
Running SSIS 32-bit drivers or tasks on a 64 bit machine
This is an answer to a forum question on www.bidn.com
Running SSIS on a 64-bit machine has several caveat that developers...
2009-12-11
4,749 reads
Running SSIS 32-bit drivers or tasks on a 64 bit machine
Running SSIS on a 64-bit machine has several caveat that developers need to be aware of. Tasks like the ActiveX...
2009-12-11
519 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