Code for T_SQL kullanımını kolaylaştıran ve hızlandıran, bilinmeyen teknikler is here. Enjoy!

Speaking | SQL Server

Thursday, January 25, 2007 9:16:48 AM (Eastern Standard Time, UTC-05:00)
Comments [0]  |  Trackback

You can download the code and slides for the ASP.NET Mobil Kontrolleri ile Gelişen Mobil Web Uygulamaları session. Enjoy!

Download the OpenWave Phone Emulator 7.0 here.

To view the application point your mobile browser here.

.NET | Speaking

Thursday, January 25, 2007 6:34:24 AM (Eastern Standard Time, UTC-05:00)
Comments [0]  |  Trackback

You can download the Sorgu Yöneticisi - SQL CLR in Action code and powerpoint session here. Enjoy!

.NET

Thursday, January 25, 2007 6:25:05 AM (Eastern Standard Time, UTC-05:00)
Comments [0]  |  Trackback

I've been tagged so I have to tell you 5 things you might not know about me. 

1)  I have suffered hearing loss as a child.   

2)  When I was a small boy my parents took me to the circus at Madison Square Garden. They bought the special seats so I would be chosen to ride around in the rings. I loved it, I was waving to everyone inside the world’s most famous arena-I remember it like it was yesterday.  When I got back to my seat my mom asked me: “Did you like it?” Little 5 year old me replied: “It was ok. I am surprised they did not give me a speaking part.”

3)  When I was 17, I was riding my bike and I was hit by a car and left for dead on the side of the road where I broke all my ribs. When I got up my first words were “where’s my bike?”

4)  I do not have a daughter in Australia, nor did I ever date Britney Spears.

5)  I actually get more pleasure when the Yankees lose then when the Mets win.

In order to keep the "chain" going I tag Richard Campbell, Clemens Vasters, Carl Franklin, Fahad Majeed, and Hans Verbeeck.

.NET

Tuesday, January 09, 2007 3:02:42 PM (Eastern Standard Time, UTC-05:00)
Comments [0]  |  Trackback

We are hiring a DBA at my company Corzen and instead of looking at resumes/cvs we are looking at how people solve particular SQL problems-not just the solution but the approach they take. (Do you use temp tables, (nolock), CTEs, table alias, etc.)

Here are the five test questions we ask. (If you want to come work here, just email me the answers.)

Here are three TSQL problems that can judge how you approach a SQL problem. There are no real wrong answers, but the more efficient and bulletproof the query is the better. No cheating and no cursors! Don't cheat and don't google the answers (we'll know.)

Step 1: run SetupTSQLProblems.sql in any database.

Problem 1.

Finding Duplicate Products in the Product table. Write a query to list only the duplicated products in the Products table. Assume that the dupe is the product with the highest Product_ID. The results of your SQL statement should be:

Problem 2.

Assign rooms to classes based on capacity using the Classes and Rooms tables. Rules: each class should have a room (and NULL if a room is not available). No class can be in a room where there are more students than capacity. No room can be used twice.

The results of your SQL statement should be:

Problem 3.

Make the following static pivot dynamic in AdventureWorks, assume that the orderyear can increment to 2005 and 2006. Assume that order years can skip.

SELECT *

FROM (SELECT CustomerID, YEAR(OrderDate) AS orderyear, TotalDue

      FROM Sales.SalesOrderHeader) as Header

PIVOT(SUM(TotalDue) FOR orderyear IN([2002],[2003],[2004])) as Piv

Problem 4.

You have a piece of XML:

<office id="NYC">

  <Employees>

    <employee num="1">Steveemployee>

    <employee num="2">Alemployee>

    <employee num="3">Mikeemployee>

    <employee num="4">Malishaemployee>

  Employees>

office>

<office id="Cairo">

  <Employees>

    <employee num="1">Remonemployee>

    <employee num="2">Lameesemployee>

    <employee num="3">Bassmaemployee>

  Employees>

office>

<office id="Pune">

  <Employees>

    <employee num="1">Vinayemployee>

    <employee num="2">Pradeepemployee>

    <employee num="3">Rashmiemployee>

    <employee num="4">Sujataemployee>

    <employee num="5">Ajitemployee>

  Employees>

office>

<office id="Karachi">

  <Employees>

    <employee num="1">Amratemployee>

  Employees>

office>

A. Using the XML datatype, write an XQuery to return the 3^rd employee in the NYC office. Your results should look like:

B. Using the XML datatype, write an XQuery to return the 3^rd employee in each office. Your results should look like:

Problem 5.

Using adventureworks, rank each salesperson by total sales in 2004 with the rank starting over for each country. Do not use temp tables, self joins, or cursors.

Enjoy!

SQL Server

Tuesday, December 12, 2006 7:08:14 AM (Eastern Standard Time, UTC-05:00)
Comments [0]  |  Trackback

See Steve Ballmer open the NASDAQ today alongside fellow RD Tim Huckaby at 9:30AM EST. Then you can watch SteveB and Tim launch Vista, Office 2007 and Exchange 2007 at 4:30PM EST. Tim is doing the demo of the Scripps Cancer Research solution (the one he let me demo at the PDC). Watch the demo here.

.NET

Thursday, November 30, 2006 8:46:34 AM (Eastern Standard Time, UTC-05:00)
Comments [0]  |  Trackback

Today Garry talks about me whining on Mt. Rainer (not true!) as well as the David Sharp story and the commercialization of Everest. Read it here.

Climbing | Everest

Wednesday, November 22, 2006 9:15:52 AM (Eastern Standard Time, UTC-05:00)
Comments [0]  |  Trackback

Part II of Gary's interview is here.

Climbing | Everest

Tuesday, November 21, 2006 10:31:43 AM (Eastern Standard Time, UTC-05:00)
Comments [0]  |  Trackback

Catch it here.

.NET | Tech*Ed 2004

Monday, November 20, 2006 10:03:41 PM (Eastern Standard Time, UTC-05:00)
Comments [0]  |  Trackback

Check out Part I of my three part interview with mountain climber Garry Porter.

Climbing | Everest

Monday, November 20, 2006 10:28:21 AM (Eastern Standard Time, UTC-05:00)
Comments [0]  |  Trackback