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

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

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)

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

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

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

Tuesday

PASS Performance Virtual Chapter - Parallelism and Performance - Are You Getting Full Return on Your CPU Investment? - Adam Machanic

Thursday

SQL Lunch - Analysis Services Security - Devin Knight

 

I'll be trying to catalog these as I find them, so if you know of training that… Read more

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

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

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

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

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

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

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

http://www.youtube.com/watch?v=3AzXktJtjko&feature=PlayList&p=091D0077982CC37D&playnext=1&index=5

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

Video created Dec. 18, 2006.

Read more

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

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

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

--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

 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