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/01/17 to 2013/01/24

T-SQL Restore Script Generator

A procedure that generates point in time restore database & log commands for your databases.  Read more...
By Paul Brewer 2013/01/24 | Source: SQLServerCentral.com | Category: restore database
Rating: |  Discuss |   Briefcase | 7,492 reads

Securing SQL Server 2012 Integration Services Packages using Digital Certificates

There are several different ways of restricting access to SSIS packages and confidential information they contain. However, preventing unauthorized users from running or viewing the content of your code is not the only security measure that you should take into consideration.   Read more...
By Additional Articles 2013/01/24 | Source: Database Journal | Category: sql server 2012
Rating: (not yet rated)  Rate this |   Briefcase | 1,779 reads

Free eBook: SQL Server Backup and Restore

You can download a free eBook from SQLServerCentral and Red Gate software on the most important task a SQL Server DBA or developer needs to understand.  Read more...
By Press Release 2013/01/25 (first published: 2012/10/23) | Source: SQLServerCentral.com | Category: backup / restore
Rating: (not yet rated)  Rate this |   Briefcase | 11,828 reads

Troubleshooting SQL Server RESOURCE_SEMAPHORE Waittype Memory Issues

This tip describes memory pressure issues that can arise from the RESOURCE_SEMAPHORE Waittype and how to find which query or transaction is causing the memory pressure.  Read more...
By Additional Articles 2013/01/23 | Source: MSSQLTips.com | Category: resource_semaphore
Rating:  Rate this |   Briefcase | 2,443 reads

Capturing Baselines on SQL Server: Where's My Space?

In this article, we'll tackle the topic of monitoring disk space usage. By tracking how much is in use and how much is still available, over time we'll have the data we need for better capacity planning, and can ensure that a database won't ever run out of disk space.  Read more...
By Erin Stellato 2013/01/23 | Source: SQLServerCentral.com | Category: baselines
Rating: |  Discuss |   Briefcase | 6,511 reads

SQLServerCentral Runs sp_Blitz - Performance Part 1

The third article that examines the output of the sp_Blitz script&trade; run against SQLServerCentral's database servers.  Read more...
By Steve Jones 2013/01/22 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 7,929 reads

Hypothetical Indexes on SQL Server

Sometimes, you have to test out alternative indexing strategies, but the task of creating the candidate indexes would just take too long. Is there another way? Well, yes, why not use the same method the DTA (Database Tuning Advisor) uses, and take the tedium out of the job.  Read more...
By Additional Articles 2013/01/22 | Source: SimpleTalk | Category: indexes
Rating:  Rate this |   Briefcase | 3,092 reads

Free Webinar: Statistics in Oracle and SQL Server

In their third live 'Oracle vs. SQL Server' discussion, Jonathan Lewis (Oracle Ace Director, OakTable Network) and Grant Fritchey (Microsoft SQL Server MVP) will look at statistics in Oracle and SQL Server. Expect a lively debate on Oracle vs. SQL Server from two leading RDBMS experts on Jan 23, 2013.  Read more...
By Press Release 2013/01/22 (first published: 2013/01/11) | Source: Red-Gate | Category: oracle
Rating: (not yet rated) |  Discuss |   Briefcase | 2,630 reads

SQL Saturday #185 - Trinidad

A free day of SQL Server training in a beautiful location on Jan 25.   Read more...
By Press Release 2013/01/21 | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 1,513 reads

VARCHAR (MAX), NVARCHAR (MAX) and NTEXT Data Types

Despite NTEXT and TEXT being deprecated in SQL Server for some time they are still both used in production systems. In this article, I will briefly demonstrate the difference between a VARCHAR (MAX), NVARCHAR (MAX) and the NTEXT data types, and the impact on performance from using NTEXT/TEXT.  Read more...
By Additional Articles 2013/01/21 | Source: SQL Server Performance | Category: t-sql
Rating:  Rate this |   Briefcase | 5,597 reads

Antipathy for Entity Attribute Value data models

EAV models have their uses but the costs are often hidden and if not hidden, more than anticipated.   Read more...
By David Poole 2013/01/21 | Source: SQLServerCentral.com | Category: data model
Rating: |  Discuss |   Briefcase | 5,400 reads

Working With Multi-Select Parameters for SSRS Reports

Multi-select parameters give your users control over their reports while reducing the number of reports they have to work with. This example demonstrates how to create a multi-select parameter list and pass the values to a stored procedure that will then populate the report.  Read more...
By Additional Articles 2013/01/18 | Source: MSSQLTips.com | Category: multi-select parameters
Rating: (not yet rated)  Rate this |   Briefcase | 3,646 reads

Data Everywhere - Level 3 in the Stairway to Reporting Services

In this article, MVP Jessica Moss talks about data sources and how to connect them to your report. Learn how to add the reusable data sets and data sources for your reporting projects.  Read more...
By Jessica M. Moss 2013/01/18 (first published: 2011/02/22) | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 25,038 reads

Free eBook: SQL Server Execution Plans

Every Database Administrator, developer, report writer, and anyone else who writes T-SQL to access SQL Server data, must understand how to read and interpret execution plans. This book leads you right from the basics of capturing plans, through how to interrupt them in their various forms, graphical or XML, and then how to use the information you find there to diagnose the most common causes of poor query performance, and so optimize your SQL queries, and improve your indexing strategy.  Read more...
By Press Release 2013/01/17 | Source: SQLServerCentral.com | Category: books
Rating: (not yet rated)  Rate this |   Briefcase | 6,782 reads

Fun with ACID

What is ACID and why should we care? A look at the principal that drives all database and DB management software design: A.C.I.D.  Read more...
By Brandie Tarvin 2013/01/17 | Source: SQLServerCentral.com | Category: acid
Rating: |  Discuss |   Briefcase | 4,460 reads

Handling Errors in SQL Server 2012

The error handling of SQL Server has always been somewhat mysterious. Now at last, the THROW statement has been included in SQL Server 2012 that, when combined with the TRY...CATCH block, makes error handling far easier. Robert Sheldon explains all.  Read more...
By Additional Articles 2013/01/17 | Category: error handling
Rating:  Rate this |   Briefcase | 7,773 reads