Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: May 2012

SQL Saturday #167 – Columbus GA

The Columbus GA SQL Users Group will be hosting their first ever SQL Saturday on September 8th 2012 at Columbus State University.  We currently have 5 classrooms reserved and have the ability to add a couple more if needed.  Each room holds over 40 people so our current capacity is… Read more

2 comments, 676 reads

Posted in Tim Radney - Database Professional on 31 May 2012

Cross Database Views and Schema Binding


One of the most interesting things I've found as a DBA is learning about features in other RDBMS platforms.  Sure we all work with and love SQL Server, but quite often there are features that you hear about that you learn about that make you go, "Wow, wouldn't that be…

Read more

1 comments, 726 reads

Posted in SQLBalls on 31 May 2012

Building a SQL Server Inventory – Part 2

Last time I went through my script to gather server information for my inventory. Today I’m going to go through my script to collect SQL Server instance data. So, I think I made it clear last time that I’m not a Powershell guru, and there are probably countless ways in… Read more

5 comments, 2,092 reads

Posted in Cleveland DBA on 31 May 2012

Turn on Instant File Initialization for SQL Server Performance – With Video Demo

Without Instant File Initialization turned on, each time a data file on SQL Server 2005 and above is created or has to grow in size, the file or portion of the file added must be zeroed out.  Depending on the size of the file this can be a very time… Read more

6 comments, 703 reads

Posted in Tim Radney - Database Professional on 31 May 2012

SSIS Project Connection Managers

With the new Project Deployment Model in SSIS developers are gaining the benefit of a new design time only feature called Project Connection Managers.  If you’ve developed in SSIS previously Connection Managers require no further detailing, but for those new this is how SSIS connections to data that’s used as… Read more

0 comments, 1,739 reads

Posted in Devin Knight on 31 May 2012

Denali – Day 31: Discontinue and Breaking/Behavior change features

Denali – Day 31: Discontinue and Breaking/Behavior change features Discontinue Features: As discussed about Deprecated will going to discontinue with that in Denali there are some features which has already discontinued. Means if you try to use those features they … Continue reading

Read more

0 comments, 741 reads

Posted in Vinay Thakur on 31 May 2012

Never, Ever Use Clustered Indexes

This whole concept of the clustered index as a foundational structure within SQL Server is just plain nuts. Sure, I get the concept that if a table has a clustered index, then that index actually becomes the table. When you create a clustered index on a table, the data is… Read more

10 comments, 1,246 reads

Posted in The Scary DBA on 31 May 2012

After August, I'm Done Traveling for the Year

I mentioned in a post over at my Goal Keeping DBA blog that I was not planning to attend the PASS Summit this year because of family time. Yesterday, my wife and I let the cat out of the bag: we're due to have a girl in mid-October. Usually, my family goes… Read more

How to Give your .NET application HA

By David Postlethwaite

I was at a meeting the other week when someone mentioned that you could specify two SQL Servers in a .NET connection string. I hadn’t heard of this before and did some investigation and found out a bit more.
 
In your SQL connection string you can… Read more

0 comments, 726 reads

Posted in The SQL DBA in the UK on 31 May 2012

Planning the Development, Testing, Staging, and Production Environments for SQL Server part 1 (Republished)


When asked about how to plan the ideal dev, test, staging and production SQL Server environments it’s easy to get carried away about the problems/possibilities about:



· How to get nightly restores from Production.

· How to solve the storage issues.

· How fast does the environment need to be,…

Read more

0 comments, 1,819 reads

Posted in SQL Development Wizard on 31 May 2012

How to synchronize the data from the Production environment to Development, Testing and Staging Environments for SQL Server? (Republished)


How to synchronize the data from the Production environment to Development, Testing and Staging Environments for SQL Server? (Republished)


One of the most common DBA task is to synchronize data to Development, Testing, and Staging environments. Normally this is a simple task of backup and restore or using a data…

Read more

0 comments, 1,406 reads

Posted in SQL Development Wizard on 31 May 2012

No More SQLRally In the US

I was disappointed to see the mention in the Connector today that there would be no SQLRally  2013 in the US. Reading the minutes from the May 2012 Board meeting (and you should read it to do your own interpretation) it feels like the decision was made largely on two… Read more

9 comments, 710 reads

Posted in SQLAndy on 31 May 2012

A new neat feature in SQL Server 2012 is THROW


In SQL Server 2005 we got the TRY…CATCH construct which was a big help for developers to effectively handle errors within their T-SQL code. Prior to that the developers had to use the @@ERROR in-built system function to check for errors and they had to check for error conditions after…

Read more

0 comments, 1,746 reads

Posted in SQL Development Wizard on 31 May 2012

Syncing your calendars

I have a desktop computer, a laptop, and a iPhone.  I frequently add meetings to my Outlook calender on my desktop computer, but sometimes enter them on my laptop.  And I frequently use my iPhone to alert me about upcoming meetings.  These leads to a major problem in keeping all… Read more

2 comments, 887 reads

Posted in James Serra's Blog on 30 May 2012

I’m Going on Tour

I’ve done quite a bit of speaking over the last few years, which has required a lot of travel. I had 15 events that I attended last year, only one of which was in Denver, so I spent quite a few days on a plane.

This year I’ve cut back… Read more

2 comments, 1,244 reads

Posted in The Voice of the DBA on 30 May 2012

Turn on Instant File Initialization for SQL Server Performance

Without Instant File Initialization turned on, each time a data file on SQL Server 2005 and above is created or has to grow in size, the file or portion of the file added must be zeroed out.  Depending on the size of the file this can be a very time… Read more

1 comments, 2,574 reads

Posted in Tim Radney - Database Professional on 30 May 2012

Denali – Day 30: Deprecated Features

Denali – Day 30: Deprecated Features Deprecated feature means these features are available in the current version of Sql server but it’s highly possible that would not be available in future version of sql server, so you should plan your … Continue reading

Read more

0 comments, 1,156 reads

Posted in Vinay Thakur on 30 May 2012

Learning Tree: SQL Server DBA Skills Upgrade

I’m very lucky in my work as freelance consultant and trainer I get to travel the world, and last week I was delivering Learning Tree course 2105 SQL Server 2012: DBA Skills Upgrade in Ottawa Canada. I’m not only a Learning Tree instructor for this course but I’m also the… Read more

2 comments, 960 reads

Posted in The SQL DBA in the UK on 30 May 2012

SQL Server IO handling mechanism can be severely affected by high CPU usage

Are you using SSD or SAN / NAS based storage solution and sporadically observe SQL Server experiencing high IO wait times or from time to time your DAS / HDD becomes very slow according to SQL Server statistics? Read on… I need your help to up vote my connect item… Read more

The Standing Desk Experiment

I’ve had a few friends using standing desks for sometime. I first heard about Greg Gonzalez (sqlSentry | Blog | @SQLSensei), fellow runner and one of the smartest SQL people using a treadmill desk. I saw it in his office at SQLSentry a few years ago, and was… Read more

6 comments, 885 reads

Posted in The Voice of the DBA on 29 May 2012

Older posts