Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2013/09/14 to 2013/09/21

SQL Server Reporting Services Report Manager Tips and Tricks

Dattatrey Sindol shares his tips and tricks on SQL Server Reporting Services Report Manager. He provides guidance on Customizing Report Manager Header/Title, Uploading Custom File Types to Report Manager, and Enable My Reports Feature.   Read more...
By Additional Articles 2013/09/20 | Source: MSSQLTips.com | Category: reporting services (ssrs)
Rating: (not yet rated)  Rate this |   Briefcase | 5,366 reads

Automate Your Backup and Restore Tasks

A new article that shows how you can automate a basic function that many environments need: the backup of a production database and the restore on a development system.  Read more...
By Philip Horan 2013/09/20 (first published: 2010/10/05) | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 15,913 reads

TribalSQL: 15 New Voices in SQL Server

MidnightDBA and Red Gate have joined together to produce a new book on SQL Server, written by 15 first-time authors. The resulting book, TribalSQL, includes everything you should know about SQL Server that isn’t taught in traditional training, they call it Tribal knowledge.   Read more...
By Press Release 2013/09/19 | Source: SQLServerCentral.com | Category: books
Rating: |  Discuss |   Briefcase | 1,673 reads

Blocking Chain (SQL Spackle)

Problems with blocking processes can be easy to identify with SQL Server DMV's.  Read more...
By Paul Lambert 2013/09/19 | Source: SQLServerCentral.com | Category: blocking
Rating: |  Discuss |   Briefcase | 6,120 reads

Databases and Dominoes

A Dominoes game of Texas 42 inspires Joe Celko to explore unusual uses for check constraints and views. Sometimes, the best way of discovering useful SQL techniques is to tackle the more unusual problems.  Read more...
By Additional Articles 2013/09/19 | Source: SimpleTalk | Category: puzzle
Rating:  Rate this |   Briefcase | 2,646 reads

SQL Saturday #190 Denver

Join us at SQL Saturday Denver on September 28. SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This SQL Saturday includes a number of options for pre-conference training in Denver, including a free session presented by Steve Jones.   Read more...
By Press Release 2013/09/18 | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated) |  Discuss |   Briefcase | 305 reads

Installing SQL Server 2014 CTP1

If you are interested in learning firsthand what new features are available, then you should download and install the new SQL Server bits. In this article Greg Larsen will walk you through preparing, downloading and the steps to install the SQL Server 2014 CTP1 release.   Read more...
By Additional Articles 2013/09/18 | Source: Database Journal | Category: sql server 2014
Rating: (not yet rated)  Rate this |   Briefcase | 2,311 reads

Stairway to Database Design Level 3: Building Tables

There are several types of tables, each with their special requirements for rules and integrity constraints. Whatever the requirement, table-level constraints will ensure that the rules are enforced and data integrity is maintained.  Read more...
By Joe Celko 2013/09/18 (first published: 2010/05/25) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 18,154 reads

Setting Different Colors for Connections in SSMS

Learn how to set colors for different connections in SSMS.  Read more...
By Peter Schott 2013/09/17 | Source: SQLServerCentral.com | Category: management studio (ssms)
Rating: |  Discuss |   Briefcase | 11,079 reads

New SQL Monitor Custom Metric: Percentage of Free Log Space

This metric measures the percentage of free space for transaction log files (LDF files). You’ll find this useful if your SQL Server has limited capacity, so you need to maximize existing disk space utilization by minimizing unused space. It will also alert you if the amount of free space drops below the specified thresholds.  Read more...
By Press Release 2013/09/17 | Source: Red-Gate | Category: sql monitor
Rating:  Rate this |   Briefcase | 2,883 reads

SQL Server Analysis Services (SSAS) 2012 Top and Bottom Functions

Scott Murray has used the Top and Bottom T-SQL functions in SQL Server and wonders, do the same functions exist in the SQL Server Analysis Services (SSAS) or MDX? If so, how do they work? Can you provide some examples? Check out this tip to learn more.  Read more...
By Additional Articles 2013/09/17 | Source: MSSQLTips.com | Category: analysis services (ssas)
Rating: (not yet rated)  Rate this |   Briefcase | 2,193 reads

Automate SQL Server Log Monitoring

Let SQL do the work and monitor your SQL Error Log files.  Read more...
By Willem Gossink 2013/09/16 | Source: SQLServerCentral.com | Category: sql server error log
Rating: |  Discuss |   Briefcase | 7,290 reads

SQL Saturday #228 Cambridge, UK

SQLSaturday #228 Cambridge is a training event for SQL Server professionals, Business Intelligence and SQL Server Developers and those just wanting to learn more about SQL Server. This event will consist of a pre-conference day on the 27th September and a free community day on the 28th September 2013.  Read more...
By Press Release 2013/09/16 | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated) |  Discuss |   Briefcase | 324 reads

Backup to the Cloud: The Silver Lining

Offsite backups are vital to data integrity, allowing for preservation and backup of data in catastrophic circumstances. Cloud backups have been around for a while, but are now really coming into their own. Tony Davis looks at how to get set up with cloud backups for restores and disaster recovery.  Read more...
By Additional Articles 2013/09/16 | Source: SimpleTalk | Category: backups
Rating:  Rate this |   Briefcase | 1,870 reads