Determine Easter Sunday
Determine what day easter sunday will be based upon the year you pass the function
2016-04-25 (first published: 2016-03-30)
425 reads
Determine what day easter sunday will be based upon the year you pass the function
2016-04-25 (first published: 2016-03-30)
425 reads
If you have job that opens a transaction and hangs too long causing a Prod issue this will be a big help to let you know.
2016-04-22 (first published: 2016-03-30)
640 reads
This is an version independent stored procedure to get the backup date from a backup file.
It's tested for SQL 2005, 2008(R2), 2012 and 2014.
Consider it a template to which you can add more output parameters from the headerinfo to meet your requirements.
2016-04-21 (first published: 2016-03-31)
338 reads
A stored procedure to generate database file moves along with Robocopy script and the attach / detach scripts
2016-04-20 (first published: 2016-04-04)
561 reads
This stored procedure will show all possible datetime formats when used with the style argument in the CONVERT() function. It also shows sample output from the date part arguments.
2016-04-13 (first published: 2014-10-10)
2,469 reads
2016-04-12 (first published: 2014-03-12)
2,313 reads
Generates Scripts to move DB files from one location to another SQL and powershell scripts
2016-04-11 (first published: 2014-03-19)
3,616 reads
This can be used for data warehouses as well as truncating table with foreign key constraints.
2016-04-08 (first published: 2014-07-07)
2,602 reads
Sometimes you want to copy all the alerts that you've got set up on one server to add them to another
2016-04-06 (first published: 2014-05-13)
4,806 reads
New set-based T-SQL solution for Sudoku puzzle using binary data and bitwise operations.
2016-04-05 (first published: 2015-06-08)
1,881 reads
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers