Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tag Scripts Rss

   Items 1 to 12 of 12   

End to End Server Disk Space reporting within SQL Server

This procedure using OLE object calls to obtain server disk space values and writes them to a table. It then creates an HTML report based on the contents of the table and then , via a SQL Agent job, sends out colour coded emails relating to how much drive space is left... this is very handy!!!!  Read more...
Rating: |  Discuss |   Briefcase | 788 reads

Part 1 -- Restore a database to another instance...

A great script that I wrote some time ago to allow the last database backup to be restored across a linked server to another server, after running a remote sproc on the destination to kill off any users on the receiving side.  Read more...
By Haden Kingsland (theflyingdba) 2016/03/14 | Source: | Category: scripts
Rating: |  Discuss |   Briefcase | 597 reads

SQLCMD and Batch File magic

Execute scripts in a folder with a single click using SQLCMD and a batch file.  Read more...
By Manu Mohanan 2015/11/19 | Source: | Category: sqlcmd
Rating: |  Discuss |   Briefcase | 6,628 reads

Universal foreach aka sp_uforeach

This script is a universal foreach stored procedure. You can loop through everything with the help of if.  Read more...
By Robert Virag 2013/09/24 | Source: | Category: scripts
Rating: |  Discuss |   Briefcase | 1,711 reads

Do you regularly run queries and scripts in SSMS?

SQL Server Management Studio is where most SQL scripts and queries are run, and although it does a decent job, it doesn't provide much help storing, sharing and managing the scripts particularly in the context of a team. Red Gate is considering building functionality into SSMS to help its users consume and share queries and scripts. Please help us by completing this short survey to help us define the requirements.   Read more...
By Press Release 2013/04/12 | Source: Redgate | Category: scripts
Rating: (not yet rated)  Rate this |   Briefcase | 3,565 reads

Grouped Failover, a 2008R2 version of Availability Groups

One of the new cool features in SQL 2012 is the SQL Server Availability groups. In other words being able to failover a group of databases which are logically connected. i.e. SharePoint databases. Well, it is also possible to do that in SQL 2008 (R2). It’s called a Grouped Failover.  Read more...
By Remko de Boer 2013/01/24 | Source: | Category: scripts
Rating: |  Discuss |   Briefcase | 526 reads

Find data difference between two datasets

Find data difference between two datasets 
By Atif-ullah Sheikh 2010/10/04 | Source: | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 2,829 reads

SSRS Expressions Tips and Tricks

Some of the expressions and functions that have come in handy while developing reports in SSRS  Read more...
Rating: |  Discuss |   Briefcase | 20,551 reads

Tally Table - Character Date Validation

Tally (or numbers) tables are one of my favorite query writing tools.  Such a simple premise that can be applied...  Read more...
By Seth Phelabaum 2009/12/17 | Source: | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,566 reads

Review of SQLZip

Running short of disk space? One way to solve that is to keep fewer backups on disk, or write a routine that will compress them to conserve space. Or you could try SQLZip, an add in that creates compressed backups. Read the review, see if it's something you should consider!   Read more...
By Andy Warren 2002/04/16 | Source: | Category: product reviews
Rating: (not yet rated) |  Discuss |   Briefcase | 5,673 reads

Review of Data Compare v.151

In this product review Andy takes a look at Data Compare, the second of three products in the SQL Bundle available from Red-Gate software. It's a very handy program that lets you compare data between two tables and optionally generate sql statements to syncronize the data. An interesting alternative to replication!   Read more...
By Andy Warren 2001/10/31 | Source: | Category: replication
Rating: (not yet rated) |  Discuss |   Briefcase | 8,753 reads

BCP Data Dynamically

This tip will show you how to BCP data out of every table with one command.   Read more...
By Brian Knight 2001/06/15 | Source: | Category: advanced querying
Rating: |  Discuss |   Briefcase | 7,406 reads
   Items 1 to 12 of 12   
stored procedure (2)    
t-sql (2)    
advanced querying (1)    
backup (1)    
backup and restore (1)    
blogs (1)    
code (1)    
command line (1)    
date manipulation (1)    
disk space (1)    
drive space (1)    
expressions (1)    
foreach (1)    
function (1)    
grouped failover (1)    
instance (1)    
linked server (1)    
management studio (ssms) (1)    
miscellaneous (1)    
product reviews (1)    
replication (1)    
reporting services (ssrs) (1)    
restore (1)    
reviews (1)    
servers (1)    
sql server 2005 (1)    
sql server 7 (1)    
sqlcmd (1)    
tally table (1)    
tips and tricks (1)