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

Content with tag Scripts Rss

   Items 1 to 10 of 10   

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,506 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,706 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,531 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 | 522 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,821 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,520 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,514 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,752 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,405 reads
   Items 1 to 10 of 10   
t-sql (2)    
advanced querying (1)    
backup and restore (1)    
blogs (1)    
code (1)    
command line (1)    
date manipulation (1)    
expressions (1)    
foreach (1)    
function (1)    
grouped failover (1)    
management studio (ssms) (1)    
miscellaneous (1)    
product reviews (1)    
replication (1)    
reporting services (ssrs) (1)    
reviews (1)    
sql server 2005 (1)    
sql server 7 (1)    
sqlcmd (1)    
stored procedure (1)    
tally table (1)    
tips and tricks (1)