SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: July 2010

Like a Phoenix rising from the ashes ...

NOTE: At least one project will be selected every week for the remainder of 2010. Like the Phoenix rising from the ashes, over the next five months, twenty-four (24) unemployed or underemployed developers will be selected because of their non-profit project...(read more)

Read more

1 comments, 1,414 reads

Posted in SQLSequel on 31 July 2010

MDX Puzzle #4 - Solution

This puzzle may not have been much of a challenge, but it introduced two new MDX concepts.  I have to admit, one of my colleagues and I chatted about this puzzle, and I realized that my requirements were a little unrealistic.  As a result, I changed the requirements a little.… Read more

0 comments, 1,528 reads

Posted in SQLDownSouth on 30 July 2010

Making a Career Change of My Own

Making a Career Change of My Own

I commented about a month ago on the high profile career changes that seemed to be going on (see The Trade Deadline Must be Drawing Near). Back then, I had no plans to make a move of my own, but I was… Read more

Presenting to the West Michigan SQL Server User Group / SQL PASS Chapter (Rescheduled)

Presenting to the West Michigan SQL Server User Group / SQL PASS Chapter (Rescheduled)

My presentation scheduled for earlier this week to the West Michigan SQL Server User Group / SQL PASS Chapter was rescheduled due to technical difficulties on my end. the microphone on my laptop simply refused to… Read more

DevLINK, Music City’s Own Technical Conference

To many, August represents the lazy dog days of summer when it’s too hot to even think about going outside. To others, this time of year conjures up thoughts of going back to school, either for us or for our kids. Still others, think of bacon.

But for the technical… Read more

0 comments, 1,443 reads

Posted in Joe Webb on 30 July 2010

Personal or Professional Ethics

Steve Jones had an interesting blog post the other day, Do as I Say, Not as I Do, and I as I read it I thought about the situation I am in now and a situation I went through just over 4 years ago.

Steve talks about how he… Read more

3 comments, 1,513 reads

Posted in Wise Man or Wise Guy on 30 July 2010

SQL University – Other Capacity Issues

This is the final lecture this week at SQL University. We are covering the topic of capacity planning this week for SQL Servers. In the first lecture we looked at an overview of capacity planning and some general considerations for DBAs. Our second lecture dove deeper into disk capacity… Read more

0 comments, 2,620 reads

Posted in The Voice of the DBA on 30 July 2010

Schedule Announced for SQLSaturday #49 in Orlando

Our schedule for this year has 47 one hour sessions plus another 6 “mini” fifteen minute presentations, plus a separate sponsor track. Sorted through more than 80 presentations to try to figure out the mix. That took some time and no easy decisions, but I think it’s a well rounded… Read more

0 comments, 1,352 reads

Posted in SQLAndy on 30 July 2010

SSC Editorial: Becoming Highly Productive

This editorial is about the idea of being highly productive more than how to actually accomplish it. Most of us tend to do the work put in front of us in the way that we know how to do it, certainly not the worst approach. The problem is that unless… Read more

0 comments, 1,371 reads

Posted in SQLAndy on 30 July 2010

Schedule Published for SQLSaturday #51 in Nashville

Just released, http://www.sqlsaturday.com/51/schedule.aspx?sat=51. Five tracks, lots of good speakers, but I see a few new names too. Looks like a good mix. The PASS Board is meeting in Nashville on the Thursday/Friday prior to the event, so a good number of us will be attending (though we probably would… Read more

0 comments, 1,350 reads

Posted in SQLAndy on 29 July 2010

Poor Little Misunderstood Views

Some people love ‘em, some people hate ‘em. But, one thing I have found to be nearly universal is that most people misunderstand how Views are used in SQL Server.

The Backdrop

A View is merely a pre-defined query that can be treated in many ways as a table. This… Read more

9 comments, 43,770 reads

Posted in SQL Coach on 29 July 2010

Finding Key Lookups In Cached Execution Plans

Ask anyone with performance tuning experience to list the most expensive operations in an execution plan and it's a safe bet you'll find key lookups near the top. The good news is they're usually easy to fix - Glenn Berry (Blog | Twitter) blogged about it recently and… Read more

6 comments, 3,962 reads

Posted in Kendal Van Dyke on 29 July 2010

SQL Bits 7 – Registration is Open !

Registration is now open for SQLBits—The 7 Wonders of SQL Conference !!

This year its in York (Sept 30th till October 2nd).

SQLBits is the largest SQL Server conference held in Europe, and well worth attending !

After the success of last years event in my home country, this year… Read more

0 comments, 1,457 reads

Posted in DatabaseExpertise.com on 29 July 2010

Video: Disk Tuning and Optimization for SQL Server


This video focuses on accelerated Disk Optimization and improved productivity with SQL Query Tuning.

Video created Dec. 18, 2006.

Read more

0 comments, 1,417 reads

Posted in Kevin E. Kline on 29 July 2010

Pesky Protected Mode

How many of you keep falling for this one…You open up Report Manager for a user that you know you have given access to view reports. Only to see this annoying error! It is basically stating that the user BIGMAC has not been given the appropriate permissions to browse to… Read more

0 comments, 1,444 reads

Posted in BrianKMcDonald on 29 July 2010

The Killer Backslash in TSQL

--it is quite startling to see that this, in TSQL, executes.
Select    \
(1 row(s) affected)
so does this....
Select    null  /\/\/\/\/\/\/\/\/\/\/\/ Read more

7 comments, 5,737 reads

Posted in Phil Factor's Phrenetic Phoughts: The SQL on 29 July 2010

Interviewed by Andy Leonard

Last year Brent Ozar interviewed all the candidates for the PASS Board of Directors. I think it went over pretty well, and this year Andy Leonard (blog | Twitter) has taken up the cause and is interviewing each candidate.

I sent in my answers, albeit a little slower than others,… Read more

3 comments, 1,886 reads

Posted in The Voice of the DBA on 29 July 2010

Ambiguities and the wild object.oriented brigades

--Whilst trying to design a more effective way of detecting dependencies in a SQL Server database, I was mulling over the cruelty of SQL Server's parser in allowing this to compile and run..
create schema int
create table int.int (int int)
select int.int. Read more

0 comments, 1,955 reads

Posted in Phil Factor's Phrenetic Phoughts: The SQL on 29 July 2010

Log Shipping By Abi Chapagai (Revised)

 Log Shipping  By Abi  Chapagai (Revised)

In SQL Server, transaction log provides an ability to recover a database to a point in time. Log shipping is a process of copying the transaction log back up from a source server to a destination server and restore on the destination server.  The… Read more

2 comments, 2,346 reads

Posted in DatabaseExpertise.com on 29 July 2010

Older posts