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
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
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...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers