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

Archives: May 2011

Start All Your Meetings in Pole Position

Let’s face it, a lot of us don’t enjoy attending meetings and can often find them to be a bit of a struggle. They may even feel like a waste of time and sometimes dare I say it, they actually are!

It doesn’t have to be this way though and… Read more

2 comments, 763 reads

Posted in John Sansom - SQL Server DBA in the UK on 31 May 2011

Free SQL Exam cram sessions from Microsoft.

G’day,

I’m a big fan of maintaining and updating your technical skills, but sometimes its difficult to measure your ability at a task, especially if you don’t use that particular piece of a technology in your day job.

One good way of measuring these skills is to sit certifications and… Read more

2 comments, 1,468 reads

Posted in measure twice, cut once. on 31 May 2011

Available Online – SQL Server Training Videos

Interested in my various performance tuning and troubleshooting videos about SQL Server?  These videos feature my good buddies (and uber-SQL Server experts) Brent Ozar (blogtwitter) and Buck Woody (blogtwitter).  View these insight-packed training videos from our SQL Server training events originally presented… Read more

1 comments, 682 reads

Posted in Kevin E. Kline on 31 May 2011

Taking It to the Extreme: SQLCLR and Parallelism - a NYC event coming soon!

Here’s another awesome SQL event coming to New York City.  (Keep reading for your discount below!) It’s already getting hot here, so by the time July 14, 2011 rolls around, we’re going need something real cool to do.   It’s not your typical SQL Server intro or even… Read more

0 comments, 1,109 reads

Posted in Pearl Knows on 31 May 2011

An Unexpected Service Gotcha

Recently I was participating in a round of storage rearranging with a client (aka the storage dance) which consisted of temporarily moving the log files to a different drive and verifying the original drive was empty, then handing it over to the network team to remove that drive, add space… Read more

0 comments, 608 reads

Posted in SQLAndy on 31 May 2011

SQLSaturday #85 in Orlando!

It’s that time of year again, actually a little earlier than in previous years as we’ll be holding our fifth annual event this year on September, 24, 2011, at Seminole State College in Lake Mary, FL. We’re moving to a new building this year as well, the Partnership Center. It’s… Read more

2 comments, 576 reads

Posted in SQLAndy on 31 May 2011

Identity Reseeding

I love the identity property. I use it in many of my tables, mostly because it gives me a fairly reliable surrogate key that I can use in my tables, especially when testing something. I often do something like this:

CREATE TABLE MyIdentityTest
( id INT IDENTITY(1,

Read more

2 comments, 1,243 reads

Posted in The Voice of the DBA on 31 May 2011

What Encryption Algorithms Are You Using?

Security is an important consideration when designing a database application. Who can get access to what data? How much damage can someone do if they get at your data?

In SQL Server 2005 Microsoft implemented column-based encryption, and in SQL Server 2008 they added Transparent Data Encryption. Both solutions work… Read more

1 comments, 1,213 reads

Posted in Allen White on 31 May 2011

Using “NOT IN” in a query can provide mixed results

The topic came up at work awhile back with using various includes/excludes such as IN, NOT IN, and EXISTS.  A co-worker was working on an ETL process when he discovered that using “NOT IN” in a sub query with a data set that contained NULL values was giving him incorrect… Read more

0 comments, 563 reads

Posted in Tim Radney - Database Professional on 31 May 2011

Speaking at 24 Hours in the Cloud

On June 1st GITCA will run a 24 hour round-the-world virtual event focusing on Cloud Computing. Please visit http://sp.GITCA.org/sites/24Hours for more information. For a complete list of speakers click here. For the complete schedule click here.

We at Geniiius will be presenting two sessions:

Extreme Scaling with SQL… Read more

1 comments, 667 reads

Posted in SQL Server Notes from the Field on 31 May 2011

Use Connections Properly in an SSIS Script Task

There are lots of scenarios in SSIS where you'd want to use a connection within a Script Task.  Unfortunately, the closest help documentation - the comments inside the Script Task itself - give you exceptionally poor advice:
To use the connections collection use something like the following:
ConnectionManager cm =…

Read more

0 comments, 5,690 reads

Posted in Todd McDermid's Blog on 31 May 2011

How to protect code written in Stored Procedure or User Defined Function?

Introduction

We have always been wondering on how to protect/secure our t-sql code written in Stored Procedures and UDF in shared hosting environment from other people who might tweak our work. Here, I would discuss a few options I know to serve purpose.

As per my knowledge, MS SQL Server… Read more

0 comments, 3,871 reads

Posted in Juggling With SQL on 31 May 2011

Better Writing from Hemingway

These are five rules for writing from Ernest Hemingway, which I like and recommend for use in your communications. Definitely try to incorporate them into your writing, especially being short and positive.

(Cross posted from The Modern Resume)


Filed under: Blog Tagged: syndicated, writing

Read more

0 comments, 687 reads

Posted in The Voice of the DBA on 30 May 2011

SQL Query Run Time Estimation

A followup to a post about subqueries with an estimation for how long it would take for the query to run.

In a recent post about subqueries, I compared 4 queries and how they handled 4 million rows of data. The queries involved:

1) Joins with AND conditions.
2)… Read more

0 comments, 1,347 reads

Posted in Help With SQL on 30 May 2011

More Bloopers for Memorial Day

It’s Memorial Day, and as usual, I have a blooper reel for the editorial. However I couldn’t fit everything in there, so I’ve pulled out a few more items. Mostly body mistakes or movements and some speaking issues. Enjoy!

The editorial blooper reel is here: http://m.podshow.com/media/15351/episodes/282544/sqlservercentral-282544-05-26-2011.mp4


Filed under: Blog Tagged:…

Read more

0 comments, 644 reads

Posted in The Voice of the DBA on 30 May 2011

How to become an expert in your field

I have been compiling a list of what things a person can do to become an expert, or guru, in his chosen field, whether that be in specific fields like SQL Server, BI, .Net, or in a broad field like career advise or data architect.  While we can all argue… Read more

1 comments, 1,990 reads

Posted in James Serra's Blog on 30 May 2011

Optimizer Timeouts with XQuery

I was looking at performance of a database and I noticed a few of the plans were very large and timing out in the optimizer. This made me wonder, just how many of them were timing out?

This sounds like a job for XQuery!

There’s really nothing to it. Once… Read more

0 comments, 935 reads

Posted in The Scary DBA on 30 May 2011

Can Scrum work for the DBA?

Agile! Scrum! Development methodologies! Sprint!


If you have a manager who reads any web page about being a manager, then you have probably heard about Scrum. Scrum development is very attractive from a manager or stakeholder's point of view. You get short bursts of development and can see results quickly. Read more

6 comments, 2,193 reads

Posted in SQL Sandwiches on 29 May 2011

SqlHerts–26th May 2011

Thanks to those who turned out to see my presentation at SqlHerts on Thursday 26thMay.  Its a true pleasure to be able to speak at such events, and I hope the the attendees were all able to takeaway something new from the evening.  I myself learnt that the Style Bar… Read more

0 comments, 550 reads

Posted in Dave Ballantynes blog on 29 May 2011

Older posts