How to Resolve a BIDS 2005 and SQL Server 2008 Compatibility Issue
Caught in between upgrades, new author Mohan Jumar has an interesting article. Using Visual Studio 2005 to save packages in an SSIS 2008 package store.
Sin City SQL
Join Steve Jones and a few of the SQLServerCentral community in Las Vegas this fall at the SQL Connections conference.
Adding Multiple Columns to a Table With a Single T-SQL Statement
You know, I believe the old saying, “If you don’t use it you will lose it”. Well, I write a...
Auto alert for SQL Agent jobs when they are enabled or disabled
It is often the case in large DBA teams where multiple DBAs can administer the same SQL Servers and it is not apparent to one DBA the importance of some of the jobs to another DBA. In this tip I show how you can be alerted of these changes.
Sin City SQL
Join Steve Jones and a few of the SQLServerCentral community in Las Vegas this fall at the SQL Connections conference.
Sin City SQL
Join Steve Jones and a few of the SQLServerCentral community in Las Vegas this fall at the SQL Connections conference.
Sin City SQL
Join Steve Jones and a few of the SQLServerCentral community in Las Vegas this fall at the SQL Connections conference.
Using Transfer SQL Server Objects Task and Execute SQL Tasks in SSIS
The Transfer SQL Server Objects Tasks is a very useful tool in SQL Server 2005 to move objects between SQL Server Instances.
BNF Basics
Learn about the basics of Backus–Naur Form. If you've never heard of this, Tom Fischer explores this way of structuring technical information.
Networking for Your Career
It's hard to actually put a specific value on networking, and I've been skeptical of it in the past. However...
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