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/02/04 to 2013/02/11

Move all SQL Server indexed views to a new filegroup

As databases grow, it often becomes necessary to add new I/O paths to accommodate the growing space. Even without growth that requires this scale, it can still be useful to utilize multiple I/O devices to spread out the load. One way that you can make optimal use of new drives is to add a filegroup to the database and move certain objects (say, all of your indexed views) to the new filegroup.  Read more...
By Additional Articles 2013/02/11 | Source: MSSQLTips.com | Category: filegroups
Rating: (not yet rated)  Rate this |   Briefcase | 2,853 reads

SQL Saturday #198 - Vancouver

SQL Saturday comes back to Vancouver, BC on Feb 16, 2013. Come join in if you can.  Read more...
By Press Release 2013/02/11 | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 1,967 reads

Moving Database Files in SQL Server

A short article that talks about the isues with moving SQL Server database files around on your storage subsystem.  Read more...
By Perry Whittle 2013/02/11 | Source: SQLServerCentral.com | Category: files and filegroups
Rating: |  Discuss |   Briefcase | 7,741 reads

Windows Server 2012 Deduplication – Should you use it with SQL Server Backups?

Windows Server 2012 introduces native deduplication functionality. While this is a promising new Windows feature for other file types and characteristics, there are some potential pitfalls that you need to be aware of when it comes to deduplication specifically for SQL Server backup files.   Read more...
By Joe Sack 2013/02/08 | Source: SQLServerCentral.com | Category: backups
Rating: |  Discuss |   Briefcase | 4,531 reads

Interviewing Tips for a Database Position

Interviewing for a database position is a careful game of give and take. Knowing what to expect and how to prepare for your interview is important, but it's only half the battle. You'll also need to ask questions to see if the job, and the company, is a good fit for you.   Read more...
By Additional Articles 2013/02/08 | Source: SimpleTalk | Category: career
Rating:  Rate this |   Briefcase | 4,749 reads

Mastering the Art of Conversation and Making Business Contacts

In NYC on Feb 21 at 6:30, Don Gabor has a short seminar to help with your networking. Whether you are chatting in small groups or one-on-one at a networking event, IT conference or after-hours party, your ability to master the art of conversation will help you find and connect with business contacts.  Read more...
By Press Release 2013/02/08 | Source: SQLServerCentral.com | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 2,797 reads

Evaluating Policies on Multiple SQL Server Instances using Central Management Server

you have created a SQL Server Policy to check database recovery models. Now you need to check the databases on all of your SQL Server instances. In this tip we will show how you can evaluate a SQL Server policy against multiple instances.   Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,158 reads

Exploring the Varbinary Type

A brief look at the Varbinary data type and its uses in SQL Server for beginners.  Read more...
By Timothy A Wiseman 2013/02/07 | Source: SQLServerCentral.com | Category: data types
Rating: |  Discuss |   Briefcase | 5,895 reads

Free eBook: Inside the SQL Server Query Optimizer

This free ebook from Red Gate Software will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the Execution Engine, and guide you through the inner workings of the Query Optimization process, and throws in a pragmatic look at Parameterization and Hints along the way.  Read more...
By Press Release 2013/02/07 (first published: 2012/12/11) | Source: SQLServerCentral.com | Category: books
Rating:  Rate this |   Briefcase | 11,181 reads

Precision Indexing: Basics of Selective XML Indexes in SQL Server 2012

Seldom has a SQL Server Service pack had such an effect on database development as when SQL Server 2012 SP1 introduced selective XML indexes. These transform the practicality of querying large amounts of XML data. Seth Delconte demonstrates how and why this feature makes all the difference.   Read more...
By Additional Articles 2013/02/06 | Source: SimpleTalk | Category: indexing
Rating: (not yet rated)  Rate this |   Briefcase | 1,997 reads

Advanced Logging - Level 12 of the Stairway to Integration Services

In this level, Andy Leonard goes into advanced logging techniques for your packages.  Read more...
Rating: |  Discuss |   Briefcase | 6,010 reads

SQL Bits XI

The popular UK conference heads to Nottingham from May 2-4, 2013. Both Grant Fritchey and Steve Jones will be speaking, along with lots of talented SQL Server professionals. Register today.  Read more...
By Press Release 2013/03/11 (first published: 2013/02/06) | Source: SQLServerCentral.com | Category: sql bits
Rating:  Rate this |   Briefcase | 4,198 reads

SQL Intersection in Las Vegas This Spring

Come join Steve Jones, Grant Fritchey and an amazing lineup of speakers at the spring SQL Intersection conference in Las Vegas, April 8-11, 2013. Register now and you get a Surface RT tablet.  Read more...
By Press Release 2013/02/05 (first published: 2013/02/01) | Source: SQLServerCentral.com | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 2,854 reads

Partitioning in SQL Server - Part 3

Arshad Ali provides a step-by-step guide to create a partitioned table/index.  Read more...
By Additional Articles 2013/02/05 | Source: Database Journal | Category: partitioning
Rating: (not yet rated)  Rate this |   Briefcase | 2,676 reads

T-SQL insert using SSIS Data Pump

This article describes a T-SQL procedure to insert data using the SSIS Data Pump  Read more...
By Federico Iori 2013/02/05 | Source: SQLServerCentral.com | Category: bulk insert
Rating: |  Discuss |   Briefcase | 7,353 reads

SQL Saturday #183 - Albuquerque

A free day of training in Albuquerque, New Mexico on Feb 9, 2013.  Read more...
By Press Release 2013/02/04 | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 1,417 reads

Using the Data Profiling SQL Server Integration Services SSIS task

Have you ever had to write a bunch of TSQL to do some data analysis on the table data in your database. If you have you'll know that this can become a fairly time consuming and tedious task? SQL Server 2012 Integration Services has a feature called the Data Profiling task that can help you perform this analysis much easier and faster (this feature is also available in SQL Server 2008). This task can help you find potential issues with your existing data as well as help you become more familiar with the data in a database that you have just started managing.   Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,401 reads

Capturing Baselines on SQL Server: Wait Statistics

By capturing baseline data, a well-prepared DBA should get a good idea of what potential issues they will face. In this article Erin Stellato looks at Wait Statistics and what they can tell you about your databases.  Read more...
By Erin Stellato 2013/02/04 | Source: SQLServerCentral.com | Category: baselines
Rating: |  Discuss |   Briefcase | 8,493 reads