Came across a great script from Ken Kaufman on copying backups using xp_cmdshell. Thought I'd contribute a script I wrote that builds on that to restore the latest production backup to a testing or development server. In this case I routinely create all my production backups to a network share and then use that source […]
2002-12-16
650 reads
This script will backup all databases that are online and have a recovery property of 'SIMPLE' AND already have a full backup. This script is set to run Monday thru Saturday at our site.
2002-12-12
215 reads
This script will do a full backup of any new database(s) on the server that does not have a backup already. This script runs Monday thru Saturday at our site.
2002-12-12
235 reads
This UDF will validate a credit card number using Luhn's formula.For example 49927398716 will return 1:print dbo.luhn('49927398716')print dbo.luhn(49927398716)11based on:Credit cards, validation and the Luhn formulabyEduardo Chaveshttp://www.webdevelopersjournal.com/articles/validation.htmlAlgorithm converted to TSQL by Joseph Gama
2002-12-12
535 reads
This script will backup all databases that are online (sql 2000). So if a new database is added you will get a backup. This is setup as a weekly job at our site (Sunday night).
2002-12-12
360 reads
ASCII table and UNICODE tableYou can easily change the font of "SQL Query Analyzer":TOOLS/OPTIONS/FONTS
2002-12-11
499 reads
This SP will create an Access database from TSQL using ADOX.Instead of Access, the Provider can be changed so that it will create *any* kind of database from DBase 3, Oracle, Excel, etc...
2002-12-11
347 reads
This stored procedure takes four parameters1)file to ftp2)server name or IP3)ftp login4)ftp passwordSP will ensure that local file exists before continuing,it will create and execute a batch file in order to push the file to the remote FTP server.--exec exampleEXEC dbo.up_FTPPushFile 'c:\temp\test.txt', 'server', 'user', 'password'
2002-12-09
4,858 reads
There are times when you have a limited range of ids and these have to be re-used as they become available.The script lists the first missing id in a table.Note that this script works best for a table with a limited number of rows, say sub 100,000I tested this on a PIII 500MHz 256Mb RAM […]
2002-12-09
262 reads
This script is designed to backup the database, and copy it over the network to our backup server. The requirement for this particular database is 7 days of data kept on the LAN. The share on the backup server is mapped to the Y:\ drive. The datename function is used over the datepart function for […]
2002-12-08
364 reads
By Steve Jones
One of the language changes in SQL Server 2025 that I’ve seen a lot...
By Steve Jones
I hosted this month, but I decided to put my own entry in as...
By Chris Yates
I get asked a lot about why or how I began working with databases...
Recently stood up a 2022 Enterprise server. Have 8 publications with subscriptions on a...
Hey, I've not done a cube for many years but I find myself supporting...
Comments posted to this topic are about the item Implementing PostgreSQL with Python for...
I get a new SQL Server instance from my build team. How can I tell if the instance was installed using a slipstream installation later?
See possible answers