I use this script to shrink the log files for development databases. The intention is keep the log files as small as possible when the database is not in use. By scheduling this script I can control when it happens as oppose to using auto shrink.
2005-07-08 (first published: 2005-06-29)
2,536 reads
forums question came up where someone needed to search every varchar/char field in the database, and find any table/field that had a specific value (ie ip address, email, servername) we all agree that a monster scan like this is bad, but bad or not, sometimes you need to do it.it returns results that look something […]
2005-07-07 (first published: 2005-06-29)
275 reads
Import database from source server using full and transaction log backups as recorded in msdb. Use it to import one or more databases to your development environment, to test your backups regularly or to move databases to a new server. To move to a new server, take a transaction log backup and put all in […]
2005-07-04 (first published: 2005-07-01)
238 reads
Full and Differential Backup of Select Databases with Calculating Disk Space and Checking if a Database is in Use With Selections
2005-06-28 (first published: 2005-05-27)
632 reads
This Stored Procedure gives you live information of the workload on the reportserver and information about who uses wich report and how often a report is startedA report based on this SP with a short refresh time gives you a live monitoring tool.
2005-06-24 (first published: 2005-06-01)
424 reads
This script will drop all of the foreign keys on user tables in the database it is executed in. This is useful as a pre-load process.
2005-06-22 (first published: 2005-05-23)
820 reads
procedure will create xls spreassheet file based on the query passed and put it into the designated folder
2005-06-21 (first published: 2005-05-24)
1,023 reads
Sorry fellas but Red-gate bought the site and now claims all copy-rights for its content, so I deleted this script. You can find it in other sites throughout the internet, such as http://education.sqlfarms.com/ShowForum.aspx?ForumID=20
2005-06-16
1,025 reads
In MS SQL, January 1 of any year defines the starting number for the week. The DATEPART(wk, 'Jan 1, xxxx') always return 1. However, a lot of reports Week No is actually based on ISO 8601 standard, that is January 1 of any year can be Week 53/52 or Week 1. (http://www.merlyn.demon.co.uk/weekinfo.htm#IDC)The Rule is as […]
2005-06-14 (first published: 2005-05-27)
310 reads
This script adds to others posted on this site by formatting and displaying text information about table and index space allocation.
2005-06-13
433 reads
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Most embedding pipelines on AWS have the same shape: a job reads rows out...
By Arun Sirpal
Transaction log issues are one of the quietest ways a healthy database turns into...
Hub,Via Wa:628218200203, Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, RT.4/RW.9, Kota Bambu Sel.,...
Comments posted to this topic are about the item Symmetric Key Encryption
Comments posted to this topic are about the item The “Successful Login” Dilemma: Why...
If I run this statement in SQL Server 2025, how is the password encrypted?
CREATE SYMMETRIC KEY MySymmetricKey WITH ALGORITHM = AES_256, KEY_SOURCE = 'My secret key source passphrase', IDENTITY_VALUE = 'My secret identity value' ENCRYPTION BY PASSWORD = 'S&perS#cretP@ssword7'; GOSee possible answers