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,150 reads
2015-08-04 (first published: 2015-07-08)
714 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
From SQL Saturday to Day of Data
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
PostgreSQL 18 Finally Makes BUFFERS the Default. Here Is Why That Matters
You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...
A New Word: La Guadière
By Steve Jones
la guadière – n. a glint of goodness you notice in something that you...
Forums
Converting Money
Comments posted to this topic are about the item Converting Money
non ascii columns in a utf-8 .txt file
hi, we couldnt get our upstream data source developers to supply what is sometimes...
PolyBase Trace Flags
Are there any good articles on all the trace flags that are enabled on...
Question of the Day
Converting Money
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers