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/27 to 2012/09/03

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,627 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,831 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,670 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,869 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,874 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,608 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,373 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,400 reads

Using nmap to scan for SQL Servers on a network

I need to try and find all SQL Servers, not just the ones in my domain. We know there are a couple of appliances that are potentially running SQL Server and we want to see them, too. What can I use to do this?  Read more...
By Additional Articles 2012/08/30 | Source: MSSQLTips.com | Category: nmap
Rating:  Rate this |   Briefcase | 2,689 reads

Creating a heat map in Reporting Services

Use custom assemblies to generate a heat map matrix in SQL Server Reporting Services  Read more...
By Andy Owl 2012/08/30 | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 8,639 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,924 reads

The Seven Sins against T-SQL Performance

There are seven common antipatterns in T-SQL coding that make code perform badly, and three good habits which will generally ensure that your code runs fast. If you learn nothing else from this list of great advice from Grant, just keep in mind that you should 'write for the optimizer'.  Read more...
By Additional Articles 2012/08/29 | Source: SimpleTalk | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 7,325 reads

Stairway to SQL PowerShell Level 3: Input and Output with PowerShell

This level will cover some of the Input/Output operations you can use with PowerShell.   Read more...
By Ben Miller 2013/10/23 (first published: 2012/08/29) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 12,667 reads

Export images from a SQL Server Table to a Folder with SSIS

Can I export images from SQL Server to a file in Windows? What SQL Server options are available to do so? Check out this tip to learn more.  Read more...
By Additional Articles 2012/08/28 | Source: MSSQLTips.com | Category: images
Rating:  Rate this |   Briefcase | 2,782 reads

AlwaysOn Availability Groups in SQL Server 2012

This article discusses and demonstrates AlwaysOn Availability groups in SQL Server 2012, a new feature for high availability.  Read more...
By Perry Whittle 2012/08/28 | Source: SQLServerCentral.com | Category: alwayson
Rating: |  Discuss |   Briefcase | 6,419 reads

SQL Saturday #167 - Columbus, GA

A free day of training in Columbus, GA. Come meet the local SQL professionals and spend a day talking SQL Server.  Read more...
By Press Release 2012/08/28 (first published: 2012/08/09) | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 1,944 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,771 reads

Practical PowerShell for SQL Server Developers and DBAs – Part 1

There is a lot of confusion amongst DBAs about using PowerShell due to existence the deprecated SQLPS mini-shell of SSMS and the newer SQLPS module. In a two-part article and wallchart, Michael Sorens explains how to install it, what it is, and some of the excellent things it has to offer.  Read more...
By Additional Articles 2012/08/27 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 3,183 reads

Stairway to Database Design Level 1: Data Elements

Before you start to think about your database schema or tables, you need to consider your data: the type of data it is, the scale you use for values. It needs to be unique, precise and unambiguous. Then you need to name it in such a way that it can be generally understood. Joe Celko explains...  Read more...
By Joe Celko 2013/07/03 (first published: 2010/04/27) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 30,681 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,732 reads