SQL to APS Automation
This script was designed to help make importing data from any SQL2008+ database to an APS much easier.
2015-08-12 (first published: 2015-07-14)
1,128 reads
Scripts
2015-08-10 (first published: 2015-07-16)
1,558 reads
2015-08-06 (first published: 2010-11-02)
27,159 reads
2015-08-04 (first published: 2015-07-08)
715 reads
2015-08-03 (first published: 2015-07-12)
1,370 reads
2015-07-31 (first published: 2015-07-12)
1,453 reads
List Job Dependencies
A Stored Procedure that lists all Jobs that target a database and the job dependencies
2015-07-29 (first published: 2015-07-02)
2,308 reads
Function to count set bits in a signed integer
This function counts the number of 1's in the binary representation of an integer.
2015-07-28 (first published: 2014-02-24)
979 reads
Function to convert UserAccountControl number to details text
Function that converts AD UserAccountControl number to details text
2015-07-27 (first published: 2013-05-14)
2,777 reads
DB Integrity & Backup Report
This script returns the date for the most recent log/full backups and checks if a DBCC CHECKDB has ran within a week.
2015-07-23 (first published: 2015-06-23)
1,321 reads
Blogs
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
T-SQL Tuesday #199: Roundup
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
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...
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