SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2012/11/27 to 2012/12/04

Free eBook: SQL Server Execution Plans, Second Edition

Get a free ebook from Red Gate Software and SQLServerCentral from MVP Grant Fritchey. Learn how to read and interpret execution plans.  Read more...
By Press Release 2012/12/04 | Source: SQLServerCentral.com | Category: books
Rating: (not yet rated)  Rate this |   Briefcase | 7,216 reads

Using SSIS to export data from a 64 bit server to Excel 2007

Instructions on how to set up the connection string and SSIS package to allow a 64 bit server to export to a 32 bit version of Excel  Read more...
Rating: |  Discuss |   Briefcase | 5,968 reads

Report Building 3.0: Adding Maps to Your Reports

With Report Builder and SSMS, there isn't much you can't do in the way of the common reports and visualisations. One of the more interesting visualisations uses maps, and that, combined with layers, makes for an impressive way of representing data.  Read more...
By Additional Articles 2012/12/04 | Source: SimpleTalk | Category: report builder
Rating:  Rate this |   Briefcase | 3,202 reads

How to Identify and Backup the Latest SQL Server Database in a Series

I have to support a third party application that periodically creates a new database on the fly. This obviously causes issues with our backup mechanisms. The databases have a particular pattern for naming, so I can identify the set of databases, however, I need to make sure I'm always backing up the newest one. Read this tip to ensure you are backing up your latest database in a series.  Read more...
By Additional Articles 2012/12/03 | Source: MSSQLTips.com | Category: backup
Rating: (not yet rated)  Rate this |   Briefcase | 1,995 reads

SQL Saturday #172 - Washington, D.C.

A free day of training in the US nation's capital. Come join in if you are nearby.  Read more...
By Press Release 2012/12/03 | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 1,444 reads

Tip: Resetting Identity Fields

How to reset an identity field to the next contiguous value, after deletions.  Read more...
By Banyardi Schmardi 2012/12/03 | Source: SQLServerCentral.com | Category: dbcc checkident
Rating: |  Discuss |   Briefcase | 8,442 reads

Stairway to Server-side Tracing - Level 10: Profiler versus Server-Side tracing

Compares and contrasts tracing using Profiler with server-side tracing, illustrating important performance differences so that one can choose the right tool for the task at hand.  Read more...
By Dan Guzman 2012/11/30 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 6,953 reads

Auditing SQL Server 2012 Server Roles

My organization is looking at SQL Server 2012 and I know that the ability to create roles at the server level is a new feature. Since this is new and impacts security, how do I handle them and how do I audit them?  Read more...
By Additional Articles 2012/11/30 | Source: SimpleTalk | Category: server roles
Rating: (not yet rated)  Rate this |   Briefcase | 2,121 reads

Database Deployment: The Bits - Getting Data In

Quite often, the database developer or tester is faced with having to load data into a newly created database. What could be simpler? Quite a lot of things, it seems.  Read more...
By Additional Articles 2012/11/29 | Source: SimpleTalk | Category: deployment
Rating:  Rate this |   Briefcase | 2,572 reads

Splitting Strings Based on Patterns

Splitting strings based on patterns supported by LIKE and PATINDEX can be an interesting way to address a wide variety of problems.  Read more...
By Dwain Camps 2014/09/12 (first published: 2012/11/29) | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 20,153 reads

Free eBook: The Red Gate Guide to SQL Server Team-based Development

Get a free ebook that discusses how you can better manage your team development.  Read more...
By Press Release 2012/11/29 | Source: SQLServerCentral.com | Category: books
Rating: (not yet rated)  Rate this |   Briefcase | 5,272 reads

What MAXDOP Setting Should be Used for SQL Server

I have a busy SQL Server and notice that several queries are running in parallel. I know I can set the max degree of parallelism setting, but what MAXDOP should I use?  Read more...
By Additional Articles 2012/11/28 | Source: MSSQLTips.com | Category: maxdop
Rating: (not yet rated)  Rate this |   Briefcase | 4,154 reads

Advanced Event Behavior – Level 10 of the Stairway to Integration Services

The tenth article of this series starts to look at more advanced events and how we can use those events to better control and enhance our packages.  Read more...
Rating: |  Discuss |   Briefcase | 9,211 reads

Understanding the SQL Server 2012 BI Semantic Model (BISM)

SQL Server 2012 introduced an unified BI Semantic Model (BISM) which is based on some of the existing as well as some new technologies. This model is intended to serve as one model for all end user experiences for reporting, analytics, scorecards, dashboards, etc. In this tip, I will talk in detail about the new BISM, how it differs from earlier the earlier Unified Dimensional Model (UDM) and how BISM lays down a foundation for future.   Read more...
By Additional Articles 2012/11/27 | Source: MSSQLTips.com | Category: bism
Rating: (not yet rated)  Rate this |   Briefcase | 3,337 reads

SQL Saturday #182 - Istanbul

SQL Saturday at the gateway between Europe and Asia. If you are nearby, come join in a free day of SQL Server training and presentations.  Read more...
By Press Release 2012/11/27 | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 1,345 reads

Back to Basics: Capturing Baselines on Production SQL Servers

If you have not been capturing baselines on your production servers, then today is the day you can start. This article provides scripts, valid for SQL Server 2005 and higher, which anyone can use to capture basic information about a SQL Server instance.  Read more...
By Erin Stellato 2017/02/20 (first published: 2012/11/27) | Source: SQLServerCentral.com | Category: baselines
Rating: |  Discuss |   Briefcase | 30,922 reads