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)
2,448 reads
Scripts
Database Mirroring Setup Procedure generator
A script that generates all the commands for installing a new database mirroring between two servers
2015-03-20 (first published: 2015-03-17)
949 reads
Database Mirroring Setup Procedure generator
A script that generates all the commands for installing a new database mirroring between two servers
2015-03-17
170 reads
Fastest way to split delimited string in SQL Server
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,843 reads
Enable Filestream on Instance and database
Enable Filestream on SQL instance and database with database name.
2015-03-16 (first published: 2013-08-12)
1,674 reads
Add user with DDL Trigger
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,620 reads
Script out/store all indexes on a server
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,963 reads
2015-03-10 (first published: 2015-02-16)
1,425 reads
List database restore COMPLETION datetime
This script shows the COMPLETION datetime of database restore.
2015-03-06 (first published: 2013-09-04)
1,260 reads
Restore Database with any number of Ndf files
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,896 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
BCA KCU DARMO Telp/Wa:0817.839.777
CSO BCA 0817839777 PPCR+MQ6, Jl. Raya Darmo No.5, Keputran, Kec. Tegalsari, Surabaya, Jawa Timur...
BCA KCU JEMBER Telp/Wa:0817.839.777
CSO, BCA. 0817839777 Jl. Gajah Mada No.14-18, Kelurahan Jember Kidu, Jember Kidul, Kec. Kaliwates,...
BCA KCU INDRAPURA Telp/Wa:0817839777
CSO BCA : 0817839777 Jl. Indrapura No.35, Kemayoran, Kec. Krembangan, Surabaya, Jawa Timur 60176
Question of the Day
Displaying Money
I want to get the currency sign displayed with my amount stored in a money type. Does this work?
DECLARE @Amount MONEY; SET @Amount = '?1500'; SELECT CAST( @Amount AS VARCHAR(30)) AS EurosSee possible answers