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 2012/09/16 to 2012/09/23

Grant’s video warning – backup verification

Grant takes a humorous (but completely serious) look at why you should be regularly verifying your backups. Get top tips for backup and recovery, and protect yourself when disaster strikes. Watch the video  Read more...
By Additional Articles 2012/09/21 | Source: Red-Gate | Category: backup / recovery
Rating:  Rate this |   Briefcase | 2,381 reads

Power View Infrastructure Configuration and Installation: Step-by-Step and Scripts

This document contains step-by-step instructions for installing and testing the Microsoft Business Intelligence infrastructure based on SQL Server 2012 and SharePoint 2010, focused on SQL Server 2012 Reporting Services with Power View. This document describes how to completely install the following scenarios: a standalone instance of SharePoint and Power View with all required components; a new SharePoint farm with the Power View infrastructure; a server with the Power View infrastructure joined to an existing SharePoint farm; installation on a separate computer of client tools; installation of a tabular instance of Analysis Services on a separate instance; and configuration of single sign-on access for double-hop scenarios with and without Kerberos. Scripts are provided for all/most scenarios.  Read more...
By Additional Articles 2012/09/21 | Source: Microsoft MSDN | Category: powerview
Rating:  Rate this |   Briefcase | 1,938 reads

How to receive Deadlock information automatically via email

Receive Deadlock info from the SQL Error Log every time a deadlock occurs.  Read more...
By Geoff Albin 2014/01/03 (first published: 2010/12/13) | Source: SQLServerCentral.com | Category: deadlock
Rating: |  Discuss |   Briefcase | 46,136 reads

SQL in the City - Boston 2012

A free day of training in Boston on Oct 8, 2012. Come join Grant Fritchey, Steve Jones and more to talk about SQL Server and how you can work more efficiently.  Read more...
By Press Release 2012/09/21 (first published: 2012/09/11) | Source: SQLServerCentral.com | Category: sql in the city
Rating: (not yet rated)  Rate this |   Briefcase | 3,400 reads

Report Builder 3.0: Formatting the Elements in your Report

here is a lot that can be done to make basic tabular reports more readable, using Microsoft's free Report Builder. Rob Sheldon continues his exploration of the power of this tool by showing how to format various elements within reports.  Read more...
By Additional Articles 2012/09/20 | Source: SimpleTalk | Category: report builder
Rating:  Rate this |   Briefcase | 2,374 reads

SQLServerCentral Webinar Series #21 - Forgotten Rings & Other Monitoring Stories

Most common monitoring metrics are important and useful, especially over time, but they can fall short. How do you gather information to determine, for example, if you have buffer cache pressure? Register now for the free webinar. Wednesday, October 17 2012 4:00pm - 5:00pm BST  Read more...
By Press Release 2012/10/15 (first published: 2012/09/20) | Source: Red-Gate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 5,109 reads

Stairway to XML: Level 1 - Introduction to XML

In this level, Rob Sheldon explains what XML is, and describes the components of an XML document, Elements and Attributes. He explains the basics of tags, entity references, enclosed text, comments and declarations  Read more...
By Rob Sheldon 2014/03/26 (first published: 2012/09/20) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 29,580 reads

SQL in the City - Chicago 2012

A free day of training in Chicago on Oct 5, 2012. Join Grant Fritchey, Steve Jones and more to discuss, debate, ask questions, and learn about how to better run your organizations SQL Servers.  Read more...
By Press Release 2012/09/20 (first published: 2012/08/30) | Source: SQLServerCentral.com | Category: sql in the city
Rating:  Rate this |   Briefcase | 3,423 reads

Improve Your Database Unit Testing Skills and Win Free Stuff

As the SQL Developer community grows to embrace the benefits of test-driven development for databases, so the importance of learning to do it properly increases. One way of learning effective TDD is by the use of code kata – short practice sessions that encourage test-first development in baby steps. I have a limited number of licences for SQL Test to give away free – just for practicing a bit of TDD and telling me about it.  Read more...
By Additional Articles 2012/10/10 (first published: 2012/09/19) | Source: Other | Category: test-driven development
Rating:  Rate this |   Briefcase | 5,500 reads

SQL in the City - San Francisco 2012

The city by the bay welcomes Steve Jones, Grant Fritchey and more for a day of debate, discussion and learning about SQL Server. It's free. Just register and join us.  Read more...
By Press Release 2012/09/19 (first published: 2012/08/29) | Source: SQLServerCentral.com | Category: sql in the city
Rating: (not yet rated)  Rate this |   Briefcase | 2,944 reads

Stairway to T-SQL DML Level 11: How to Delete Rows from a Table

You may have data in a database that was inserted into a table by mistake, or you may have data in your tables that is no longer of value. In either case, when you have unwanted data in a table you need a way to remove it. The DELETE statement can be used to eliminate data in a table that is no longer needed. In this article you will see the different ways to use the DELETE statement to identify and remove unwanted data from your SQL Server tables.  Read more...
By Gregory Larsen 2012/09/19 | Category: stairway series
Rating: |  Discuss |   Briefcase | 9,901 reads

Fuzzy-String Search: Find misspelled information with T-SQL

An optimized Damerau-Levenshtein Distance (DLD) algorithm for "fuzzy" string matching in Transact-SQL 2000-2008  Read more...
By Thomas Keller 2014/01/10 (first published: 2012/09/18) | Source: SQLServerCentral.com | Category: fuzzy match
Rating: |  Discuss |   Briefcase | 23,508 reads

Run an Oracle package from SQL Server Integration Services

If you want to run an Oracle Package and then execute a web service, copy files or folders, a sequence of tasks, you may need to use SQL Server Integration Services (SSIS).  Read more...
By Additional Articles 2012/09/18 | Source: MSSQLTips.com | Category: oracle
Rating: (not yet rated)  Rate this |   Briefcase | 1,748 reads

SQL Server 2012: Migrating BLOBs to FILETABLEs

Learn about this new feature in SQL Server 2012 and how to move your binary data.  Read more...
By Additional Articles 2012/09/18 | Source: MSDN Communities | Category: filetable
Rating: (not yet rated)  Rate this |   Briefcase | 2,354 reads

SQL in the City - Austin 2012

A free day of training in Austin, TX with Grant Fritchey, Steve Jones and a few others. Join us to learn about SQL Server and how you can more efficiently work in your job every day.  Read more...
By Press Release 2012/09/18 (first published: 2012/08/27) | Source: SQLServerCentral.com | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 2,782 reads

TSQL Challenge 82 - Find elements that uniquely make up a group

The challenge is to find the Tax Code based on Price. Each sales amount is uniquely made up by the sum of one or more prices. Based on this you should assign the tax code to each price.   Read more...
By Jacob Sebastian 2012/09/17 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: |  Discuss |   Briefcase | 1,175 reads

Never update systems tables directly - a study in Agent job scheduling

It is often recommended that system tables should not be updated directly. Presenting a case in point built around nightly job configuration in order to demonstrate the possible issues with updating system tables directly.  Read more...
By Nakul Vachhrajani 2012/09/17 | Source: SQLServerCentral.com | Category: sql server agent
Rating: |  Discuss |   Briefcase | 4,284 reads

SQL in the City - New York 2012

Come join Grant Fritchey, Steve Jones and others for a free day of training in New York City on Sept 28, 2012.  Read more...
By Press Release 2012/09/17 (first published: 2012/08/23) | Source: SQLServerCentral.com | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 2,765 reads

Distributed Computing - Hybrid Systems Considerations

When the Cloud was new, it was often presented as an 'all or nothing' solution. Nowadays, the canny Systems Architect will exploit the best advantages of 'cloud' distributed computing in the right place, and use in-house services where most appropriate. So what are the issues that govern these architectural decisions?  Read more...
By Additional Articles 2012/09/17 | Source: SimpleTalk | Category: cloud computing
Rating:  Rate this |   Briefcase | 1,504 reads