Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
<< Previous headlines | Later headlines >> Headlines from 2013/04/07 to 2013/04/14

dbWarden - A Free SQL Server Monitoring Package

dbWarden is a comprehensive monitoring and alerting solution for SQL Server 2005 or newer. It features an emailed Health Report and includes email and text notifications with customizable metrics for alerts such as Blocking, Long Running Queries and SQL Jobs, CPU %, Log file and TempDB growth.  Read more...
By Stevie Rounds, Michael Rounds 2013/04/12 | Source: | Category: monitoring
Rating: |  Discuss |   Briefcase | 18,400 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,651 reads

Comparing Multiple Rows Insert vs Single Row Insert with Three Data Load Methods

The performance of 'extract, transform, load' (ETL) processes for large quantities of data can always be improved by objective testing and experiment with alternative techniques. The cause of poor performance can sometimes be surprising.  Read more...
By Additional Articles 2013/04/12 | Source: SimpleTalk | Category: data loading
Rating:  Rate this |   Briefcase | 4,578 reads

Tracking Business Metrics

There can be more to managing a SQL Server instance than just examining the performance metrics. There are times when understanding how your system is performing for the application is important.  Read more...
By Steve Jones 2013/04/11 | Source: | Category: monitoring
Rating: |  Discuss |   Briefcase | 1,381 reads

Partitioning in SQL Server: Managing Sliding Window Scenario

The concept of a sliding window scenario is to manage and keep the same number of partitions on a partitioned table over time. Learn how in this step-by-step from Arshad Ali.  Read more...
By Additional Articles 2013/04/11 | Source: Database Journal | Category: partitioning
Rating: (not yet rated)  Rate this |   Briefcase | 2,490 reads

SSIS Deployments

Four ways to deploy SSIS packages are shown in this piece.  Read more...
By Koen Verbeeck 2015/09/25 (first published: 2013/04/11) | Source: | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 11,831 reads

New and Basic Result-set Paging functionality in SQL 2012 Version.

Overview of 2 very important clauses added to SELECT statement in SQL2012 to allow paging on result sets.  Read more...
By Eli Leiba 2013/04/10 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 595 reads

Using Policy Based Management for checking SQL Server database file extensions

We need to exclude SQL Server database files from Antivirus and Third Party Backup Software (to make sure that files are not accessed directly). How can we be sure that all of our SQL Server file extensions are using the standard file extensions for database files?  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,265 reads

SSIS Deployments

Four ways to deploy SSIS packages are shown in this piece.  Read more...
Rating: |  Discuss |   Briefcase | 8,948 reads

Tune SQL Server 2012 Databases Using Database Engine Tuning Advisor

Microsoft Database Engine Tuning Advisor (DTA) is a database performance tuning utility designed to analyze your SQL Server database and suggest actions to be taken in order for taking your query performance to the next level.   Read more...
Rating: |  Discuss |   Briefcase | 4,384 reads

Automating SQL Server Database Deployments: A Worked Example

Alex talks through a simple practical example of a database deployment, First creating a empty database and then upgrading it through three steps by writing T-SQL scripts, adjusting configuration files and the change log, before generating a full build script containing all schema objects.  Read more...
By Additional Articles 2013/04/09 | Source: SimpleTalk | Category: deployment
Rating: (not yet rated)  Rate this |   Briefcase | 3,551 reads

A Simple Formula to Calculate the ISO Week Number

He admits it wasn't his idea but his head sure wishes it was. SQL Server MVP Jeff Moden explains a wonderful, super simple, very high performance formula that will calculate ISO Week Numbers. If you're "stuck" with SQL Server 2005 or less, you're going to like this a whole lot!  Read more...
By Jeff Moden 2015/10/23 (first published: 2013/04/08) | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 12,568 reads

SQL Server JOIN Hints

You, as a SQL Server data professional, are looking for ways to improve your queries. You've done the usual - avoided cursors and loops, used locks effectively, examined execution plans - what else can you tweak? Check out this tip to learn more.  Read more...
By Additional Articles 2013/04/08 | Source: | Category: join
Rating: (not yet rated)  Rate this |   Briefcase | 6,316 reads

SQL Saturday #189 - Costa Rica

Join us at SQL Saturday Costa Rica on April 13, 2013 for a day of SQL Server Training and Networking.  Read more...
By Press Release 2013/04/08 | Source: | Category: sql saturday
Rating:  Rate this |   Briefcase | 1,460 reads