Equivalent Oracle's INSTR Function in SQL server
Oracle Built in Function INSTR is a great function if you wish to locate a string or a subset of string in the nth place.
2016-11-17 (first published: 2016-11-04)
1,480 reads
Scripts
Converting values into Rows
Script describe one of the way to divide values into rows by using any specified dividing value.
2016-11-15 (first published: 2016-11-04)
859 reads
2016-11-14 (first published: 2016-11-06)
739 reads
Function - Word count in a sentence
The function (Inline function) is used to determine the word count in a textual/string input.
* Compatible from SQL Server 2012 and up.
2016-11-11 (first published: 2016-11-04)
526 reads
Automatic restore database to different server from backup file
if you get bunch of back up files ( full backup and transaction log backup, you need restore those database to different server, you can use my stored procedure to genereate the restore command
2016-11-10 (first published: 2014-12-17)
2,577 reads
Build restore scripts dynamically
This script will build restore scripts with the most recent full backup and all t-log backups since, for each user database in the SQL instance.
2016-11-09 (first published: 2016-11-01)
1,392 reads
Monitor your website or any URL from SQL Server
You can monitor your web application by given its url and by creating the job in sql server 2005 which will send you the mail when ever your website is down.
2016-11-07 (first published: 2009-06-17)
11,962 reads
2016-11-03 (first published: 2014-10-07)
2,626 reads
Script All Logins / Users / and Roles
This Script Generates A script to Create all Logins, Server Roles, DB Users and DB roles on a SQL Server.
2016-11-02 (first published: 2013-10-31)
33,469 reads
View for Ola Hallengren CommandLog
Add 3 columns, duration in seconds,Pagecount and fragmentation. For people like me who don't enjoy querying XML.
2016-10-31 (first published: 2015-11-12)
3,443 reads
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
How have you encouraged communication at work?
I do have a question. At work, some groups of people have an inordinate...
Alamat Telp BCA KCP Cipanas Cs 0823-7497-7784
Wa:082374977784 Jl. Raya Cipanas, Gadog, Kec. Pacet, Kabupaten Cianjur, Jawa Barat 43253
Alamat dan Kontak J&T Cargo Makassar
•Nama Mitra: J&T Cargo UPG013A •Alamat: jl. Kerung kerung no 7 A •Kota Makassar...
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers