Calendar Table by Interval Minutes
Populate a calendar table with user set interval start and end datetime values.
2015-03-24 (first published: 2014-02-21)
1,888 reads
Populate a calendar table with user set interval start and end datetime values.
2015-03-24 (first published: 2014-02-21)
1,888 reads
A script that generates all the commands for installing a new database mirroring between two servers
2015-03-20 (first published: 2015-03-17)
929 reads
A script that generates all the commands for installing a new database mirroring between two servers
2015-03-17
155 reads
Getting rid of R-BAR to split a delimited string. This method is popular for it's simplicity, speed and zero reads.
2015-03-17 (first published: 2013-07-29)
4,787 reads
Enable Filestream on SQL instance and database with database name.
2015-03-16 (first published: 2013-08-12)
1,535 reads
DDL trigger will add a user to a newly created database and assign db_owner role. It can be modified for what role is required.
2015-03-12 (first published: 2013-08-22)
1,360 reads
This script will store all index definitions into a table that you can use to "re-create" the indexes at a later date.
2015-03-11 (first published: 2013-08-26)
2,267 reads
2015-03-10 (first published: 2015-02-16)
1,293 reads
This script shows the COMPLETION datetime of database restore.
2015-03-06 (first published: 2013-09-04)
1,228 reads
Execute the code after passing database name on which you want to restore and the path where your backup file being located.
e.g exec sp_restoredb N'mydatabase',N'D:\mydatabase.bak'
2015-03-05 (first published: 2013-09-22)
1,776 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