Last week one of my team members was supposed to create a SQL Authenticated ID on a SQL Server 2005 instance. This was as per the request of the Application team who would be using it for an Application.
2014-08-20 (first published: 2014-08-13)
1,923 reads
2014-08-18 (first published: 2014-07-28)
1,278 reads
2014-08-15 (first published: 2014-07-16)
1,567 reads
Restore script for moving databases from prod to dev with different path / logical name etc.
2014-08-14 (first published: 2014-05-30)
5,945 reads
If you have any requirement where you want to find out all the SPIDs running on a database along with the program/application name of the SPID and the login details. You can run the procedure to get the details very easily.
2014-08-12 (first published: 2014-06-30)
4,133 reads
2014-08-11 (first published: 2014-05-28)
1,810 reads
This script was published originally on http://humakhurshid.blog.com/2011/07/14/script_out_fulltext_catalog/
The author has tweaked it little bit to improve it.
2014-08-07 (first published: 2014-07-02)
5,832 reads
The script below executes on the first of every month and moves files from source to destination location.
2014-07-24 (first published: 2014-06-16)
970 reads
2014-07-23 (first published: 2014-06-17)
1,781 reads
2014-07-22 (first published: 2014-05-16)
2,024 reads
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
You can find the slides and SQL scripts for my session “Spice up your...
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Wa:083849450961 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, RT.1/RW.1,...
Wa:083849450961 Jl. Komp. Rs. Fatmawati No.1, RT.1/RW.9, Cilandak Bar., Kec. Cilandak, Kota Jakarta Selatan,...
Comments posted to this topic are about the item Risk Vs Reward, The never...
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers