create jobs script for 2000 2005 or 2008
will create jobs script for backup or DR purposes to install on another server.
2012-01-18 (first published: 2011-12-15)
2,169 reads
Scripts
poor mans archival of backup files and tran logs to alternate location
This script will backup your files that have changed only. old files will not be copied just newer ones.
2012-01-17 (first published: 2011-09-20)
719 reads
Create bank holidays table
Do you know what happens if a holiday falls on a weekend? This script will help you.
2012-01-16 (first published: 2011-12-14)
3,084 reads
Who did what?
This select will show the last sql statement for every open session plus many helpfull information.
2012-01-13 (first published: 2008-03-04)
4,219 reads
Display row value as a TABLE column using SQL select statement
Display row value as a TABLE column using SQL select statement
2012-01-12 (first published: 2007-10-26)
4,732 reads
2012-01-11 (first published: 2008-04-16)
5,174 reads
Script foreign keys
Using this script you can create a list of sql commands for foreign keys manipulation.
2012-01-10 (first published: 2007-11-02)
5,426 reads
2012-01-09 (first published: 2007-11-13)
4,914 reads
2012-01-06 (first published: 2008-02-15)
7,314 reads
2012-01-05 (first published: 2011-12-09)
2,572 reads
Blogs
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
SQL Server Security Hardening Guide Using the DoD STIG Checklist
Security on your SQL Server is important. That doesn’t need any explaining. But where...
EightKB 2026: Registration is Open!
It’s that time of year again! EightKB is back on August 20th at 13:00...
Forums
Are You Working More Hours?
Comments posted to this topic are about the item Are You Working More Hours?
Stairway to Reliable Database Deployments Level 6 – Managing Changesets Over Time
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
A Limited Startup
Comments posted to this topic are about the item A Limited Startup
Question of the Day
A Limited Startup
I add this parameter to SQL Server 2025 in the Configuration Manager:
-mDynamicsWhat does this do? See possible answers