Some SQL Server 2005/2008 Monitoring Stored Procedures
Here is a collection of five stored procedures that are very useful for monitoring the overall health of a SQL...
2009-12-11
1,157 reads
Blog Posts
SQL Lunch # 5 – Looping Logic in SSIS
SQL Lunch # 5 – Looping Logic in SSIS
Speaker:Tim Mitchell
Topic:Looping Logic in SSIS
Meeting URL:JOIN MEETING
ADD TO OUTLOOK CALENDAR
Description:
Software developers have long taken...
2009-12-11
999 reads
Using a SSRS Report to run SQL Agent Jobs part 2
In part one of this post I showed how you can use a report to run SQL Server Agent Jobs by...
2009-12-11
1,879 reads
"You told me it's wrong...
"... but you won't tell me how to fix it." I remember that quote coming out of my mouth when I was...
2009-12-10
794 reads
A Day Off
I'm having a day off tomorrow, got some nice things planned including a trip to the beach with the puppies....
2009-12-10
488 reads
Book Review: Eisenhower The President (Vol 2)
I continue to read biographies without a real direction, stumbling across an interesting event in one and following that to...
2009-12-10
319 reads
Do You Use Projects/Solutions in SSMS?
When SQL Server 2005 was released Microsoft made a major change to the client tools provided with SQL Server, moving...
2009-12-10
1,775 reads
SSIS Package Credentials - Featured article on SSC.com
Today, on SQLServerCentral.com, SSIS Package Credentials, is the featured article on the site.
I originally drafted this article as a blog post, and...
2009-12-10
690 reads
Best of SQLServerCentral.com Volume 7 Available for Download
It’s a compilation of the best articles over the past year or so, all pushed into a nice PDF that...
2009-12-09
396 reads
Microsoft Creates Server and Cloud Division
Microsoft announced today that they are reorganizing and combining the existing Windows Server and Solutions Group and the Windows Azure...
2009-12-09
735 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