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/08/31 to 2012/09/07

Red Gate Software announces speaker line up for US SQL in the City tour

SQL in the City is a free, full day training and networking event for database professionals. After the success of last year’s event, Red Gate has expanded the event to cover six cities from sea to shining sea, including: New York, Austin, San Francisco, Chicago, Boston, and Seattle.  Read more...
By Press Release 2012/09/14 (first published: 2012/08/21) | Source: Red-Gate | Category: red gate software
Rating: (not yet rated) |  Discuss |   Briefcase | 1,570 reads

Key Word Searches

This article from Todd Fifield shows a Way to avoid the dreaded LIKE operator in your queries and dramatically speed up keyword searches.  Read more...
By Todd Fifield 2012/09/07 (first published: 2011/02/28) | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 34,684 reads

Practical PowerShell for SQL Server Developers and DBAs – Part 2

Having shown just how useful PowerShell can be for DBAs in executing queries, Michael Sorens now takes us through navigating SQL Server space and finding meta-information - valuable information for anyone looking to be more productive in SQL Server.  Read more...
By Additional Articles 2012/09/07 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,678 reads

SQL Saturday #157 - San Diego

Southern California isn't all beach time. SQL Saturday comes to San Diego on Sept 15, 2012. Join fellow SQL Server pros for a day of learning.  Read more...
By Press Release 2012/09/07 (first published: 2012/08/15) | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 1,898 reads

SQL Saturday #162 - Cambridge, UK

Come to Cambridge in the UK for a free day of training on SQL Server. Steve won't be there, but plenty of other Red Gate'ers will be.  Read more...
By Press Release 2012/09/06 (first published: 2012/08/27) | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 2,745 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,940 reads

How to Find Outdated Statistics in SQL Server 2008

How can I find out which statistics are outdated in my SQL Server database?  Read more...
By Additional Articles 2012/09/06 | Source: MSSQLTips.com | Category: statistics
Rating: (not yet rated)  Rate this |   Briefcase | 2,964 reads

How to save results of a procedure with more than one result set

Sometimes a procedure returns more than 1 result set. The article describes how to save all result sets into new database tables  Read more...
By Pavel Sinkevich 2012/09/06 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 10,021 reads

SQLskills training goes online worldwide (and free in September!)

SQLskills is recording their knowledge in conjunction with Pluralsight for you to view from the time and place of your choosing. And it's free in September. Read more to find out how you can get access.  Read more...
By Additional Articles 2012/09/10 (first published: 2012/09/05) | Source: SQLskills | Category: training
Rating: (not yet rated)  Rate this |   Briefcase | 6,127 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,779 reads

Stairway to T-SQL DML Level 9: Adding Records to a table using INSERT Statement

Not all applications are limited to only retrieving data from a database. Your application might need to insert, update or delete data as well. In this article, I will be discussing various ways to insert data into a table using an INSERT statement.  Read more...
By Gregory Larsen 2012/09/05 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 7,465 reads

Upgrading SSIS Custom Components for SQL Server 2012

Having finally got around to upgrading my custom components to SQL Server 2012, I thought I’d share some notes on the process. One of the goals was minimal duplication, so the same code files are used to build the 2008 and 2012 components, I just have a separate project file.   Read more...
By Additional Articles 2012/09/05 | Source: sqlis.com | Category: integration services (ssis)
Rating: (not yet rated)  Rate this |   Briefcase | 1,575 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

SQL Server Data Type Precedence

I am executing a simple query/stored procedure from my application against a large table and it's taking a long time to execute. The column I'm using in my WHERE clause is indexed and it's very selective. The search column is not wrapped in a function so that's not the issue. What could be going wrong?  Read more...
By Additional Articles 2012/09/04 | Source: MSSQLTips.com | Category: data types
Rating: (not yet rated)  Rate this |   Briefcase | 2,179 reads

Combining AlwaysOn Groups With Failover Cluster Instances

This article discusses failover cluster instances and AlwaysOn groups  Read more...
By Perry Whittle 2012/09/04 | Source: SQLServerCentral.com | Category: fci
Rating: |  Discuss |   Briefcase | 6,487 reads

SQL Saturday #170 - Munich, Germany

Free SQL Server training comes to Germany. Join fellow SQL Server pros in Munich on Sept 15, 2012.  Read more...
By Press Release 2012/09/04 (first published: 2012/08/14) | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 1,806 reads

Cleaning Up SQL Server Deployment Scripts

Although, generally speaking, source control is the truth, a database doesn't quite conform to the ideal because the target schema can, for valid reasons, contain other conflicting truths that can't easily be captured in source control. Dave Ballantyne explains the problems and suggests a solution.  Read more...
By Additional Articles 2012/09/03 | Source: SimpleTalk | Category: deployment
Rating: (not yet rated)  Rate this |   Briefcase | 1,637 reads

Stairway to Server-side Tracing - Level 8: How to Automate Traces with SSIS

Level 8 of this stairway series looks at the automation of your tracing using Integration Services.  Read more...
By Dan Guzman 2012/09/03 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,891 reads

SQL Saturday #156 - Providence, RI

Come visit Rhode Island and meet fellow SQL Server professionals from all over New England as SQL Saturday comes on Sept 15, 2012.  Read more...
By Press Release 2012/09/03 (first published: 2012/08/13) | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 1,674 reads

SQL Saturday #154 | St.Louis, MO

Sept 15th, 2012 at the CAIT Campus of Washington University in St.Louis - 5 Jackson Avenue, Clayton, MO 63105 SQL Saturday #154 is the very first SQL Saturday event in the St.Louis area. It is a free one day event for SQL Server professionals and those wanting to learn about SQL Server. We are planning on a 4 track event with 200 attendees. We currently have several sessions aligned towards Database Administration, Application Development, Business Intelligence and professional Development Tracks. We also have several sessions focused on SQL Server 2012! Please visit our event website for more details and free registration.  Read more...
By Press Release 2012/09/03 (first published: 2012/09/03) | Source: PASS | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 1,878 reads

AlwaysOn Architecture Guide: Building a High Availability and Disaster Recovery Solution by Using AlwaysOn Availability Groups

SQL Server 2012 AlwaysOn Availability Groups provides a unified high availability and disaster recovery (HADR) solution that improves upon legacy functionality previously found across disparate features. Prior to SQL Server 2012, several customers used database mirroring to provide local high availability within a data center, and log shipping for disaster recovery across a remote data center. With SQL Server 2012, this common design pattern can be replaced with an architecture that uses availability groups for both high availability and disaster recovery. This paper details the key topology requirements of this specific design pattern, including quorum configuration considerations, steps required to build the environment, and a workflow that shows how to handle a disaster recovery event in the new topology.  Read more...
By Additional Articles 2012/08/31 | Source: Microsoft MSDN | Category: alwayson
Rating: (not yet rated)  Rate this |   Briefcase | 1,906 reads

Why is my transaction log full?

Why does the transaction log fill up? There are a variety of reasons, and MVP Gail Shaw walks you through the various things to check.  Read more...
By Gail Shaw 2012/08/31 (first published: 2011/02/21) | Source: SQLServerCentral.com | Category: transaction logs
Rating: |  Discuss |   Briefcase | 43,952 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,399 reads