Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
<< Previous headlines | Later headlines >> Headlines from 2014/01/20 to 2014/01/27

Leveraging Constraint Evaluation Sequence in SQL Server

Constraints on a table in SQL Server are evaluated in a specific sequence. Knowing this sequence can help us leverage them to realize various business requirements.  Read more...
By Nakul Vachhrajani 2014/01/27 | Source: | Category: sql server
Rating: |  Discuss |   Briefcase | 2,574 reads

Managing SSIS Security with Database Roles

SQL Server 2012 introduced the new project deployment model for Integration Services. This tip will guide you through the process of setting up security for the SSIS 2012 catalog.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,005 reads

SQL Saturday #241 Cleveland, OH

SQL Saturday is coming to Cleveland on February 8, 2014. Join us for a free day of SQL Server Training and Networking. There will also be paid-for pre-conference sessions on Feb 7 featuring Argenis Fernandez and Allen White.   Read more...
By Press Release 2014/01/27 | Source: SQL Saturday | Category: sql saturday
Rating: (not yet rated) |  Discuss |   Briefcase | 276 reads

The SQL Server Sqliosim Utility

The sqliosim utility is provided with SQL Server to test the I/O stability and 'correctness' of a server. It is generally used before installing SQL Server in order to ensure that new hardware can handle your expected loads. Bob Sheldon explains what it is and how to use it.  Read more...
By Additional Articles 2014/01/24 | Source: SimpleTalk | Category: sqlio
Rating:  Rate this |   Briefcase | 2,937 reads

A Versioning system for SSRS

Use SSRS to be create its own lightweight report version control system  Read more...
By David K Bennett 2014/01/24 (first published: 2012/10/23) | Source: | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 16,201 reads

Skipping Columns (& other tricks) Using BCP Format Files (SQL Spackle)

BULK INSERT and BCP are powerful, high performance tools for importing text files. SQL Server MVP Jeff Moden gives us several nifty tips in this introduction to BULK INSERT and BCP Format Files including "Skipping Columns" and the sequestration of bad rows while still loading all the good data.  Read more...
By Jeff Moden 2014/01/23 | Source: | Category: bcp (bulk copy program)
Rating: |  Discuss |   Briefcase | 4,637 reads

Search multiple SQL Server Error Logs at the same time

The code in this tip will show how to use two system stored procedures to identify all iterations of a given string in the available SQL Server error logs since a specific point in time.  Read more...
By Additional Articles 2014/01/23 | Source: | Category: sql server error log
Rating: (not yet rated)  Rate this |   Briefcase | 2,252 reads

An Overview of Project Conversion - Level 14 of the Stairway to Integration Services

As we continue on with our look at Integration Services, this step talks about how to convert projects to the SSIS 2012 format.  Read more...
By Andy Leonard 2014/01/22 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,517 reads

Calculating the Median Value within a Partitioned Set Using T-SQL

It is ironic that one of the most essential of statistical aggregations, the median, has been so difficult in the past to calculate efficiently in SQL. Dwain Camps sets the candidates to work and identifies the winners and losers.   Read more...
By Additional Articles 2014/01/22 | Source: SimpleTalk | Category: median
Rating:  Rate this |   Briefcase | 2,328 reads

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.  Read more...
By Additional Articles 2014/03/19 (first published: 2013/08/21) | Source: Red-Gate | Category: performance tuning
Rating:  Rate this |   Briefcase | 16,466 reads

Mastering Dimensions of Time

A method to create and populate Date and Time dimension tables for a data warehouse project.  Read more...
By James Parker 2014/01/21 | Source: | Category: data warehouse
Rating: |  Discuss |   Briefcase | 7,007 reads

Free Online Business Analytics Training for Those Who Love Data

Spend a day with top experts from the world of business analytics and business intelligence on Feb. 5 and learn how to get the most from your data in a series of 12 free, live training webcasts with on-demand replay.  Read more...
By Press Release 2014/01/21 | Source: | Category: pass
Rating: (not yet rated) |  Discuss |   Briefcase | 2,728 reads

Migrating SQL Server Databases to Windows Azure by Leveraging BACPAC Files

Marcin Policht shows you how to migrate on-premise data that is already cloud-compliant to Windows Azure SQL Databases by converting it into a BACPAC formatted file.  Read more...
By Additional Articles 2014/01/21 | Source: Database Journal | Category: migration
Rating: (not yet rated)  Rate this |   Briefcase | 3,180 reads

The PoSh DBA - Reading and Filtering Errors

DBAs regularly need to keep an eye on the error logs of all their SQL Servers, and the event logs of the host servers as well. When server numbers get large, the traditional Windows GUI approach breaks down, and the PoSH DBA reaches for a PowerShell script to do the leg-work.   Read more...
By Additional Articles 2014/01/20 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 2,153 reads

Logging and Error Handling for SQL Stored Procedures

Learn how to develop and test a template for logging and error handling in a multi-step SQL stored procedure  Read more...
By Dwain Camps 2014/01/20 | Source: | Category: error handling
Rating: |  Discuss |   Briefcase | 8,658 reads