Showing posts with label programming. Show all posts
Showing posts with label programming. Show all posts

Wednesday, December 10, 2008

I like big blogs and I cannot lie.......

Okay so I created a blogpost titled The Ten Most Asked SQL Server Questions And Their Answers

After you are active in the newsgroups for a while you will notice that the same questions are asked over and over again. I had this idea to create a post like that for a while and I finally finished :-)

Here is what is in that post

1) Selecting all the values from a table for a particular date
2) Search all columns in all the tables in a database for a specific value
3) Splitting string values
4) Select all rows from one table that don't exist in another table
5) Getting all rows from one table and only the latest from the child table
6) Getting all characters until a specific character
7) Return all rows with NULL values in a column
8) Row values to column (PIVOT)
9) Pad or remove leading zeroes from numbers
10) Concatenate Values From Multiple Rows Into One Column

So check it out here: The Ten Most Asked SQL Server Questions And Their Answers

And I will leave you with the theme music of this post's title :-)

Tuesday, December 9, 2008

All the interviews I did with the SQL legends

Yesterday in the Christmas Came Early This Year post I linked to an interview I did with Itzik Ben-Gan, today I decided to link to all the interviews I did

The first interview I did was with the late Ken Henderson, I owe so much to Ken and his Guru's Guide to SQL books, they made me a much better developer. I was a technical reviewer for the 2nd edition of his Guru guide to SQL book and I just hope that it will be published some time...
An Interview With Ken Henderson About The Forthcoming Book SQL Server 2005 Practical Troubleshooting: The Database Engine

Say all you want about Celko and his behaviour in the newsgroups, he does write some pretty good books
Interview With Joe Celko About The Forthcoming Book Thinking In Sets
Inside SQL Server is a book every SQL Developer should have, it was an honor to interview SQL Goddess Kalen
Interview With Kalen Delaney About Inside Microsoft SQL Server 2005 Query Tuning and Optimization

Adam's book is filled with really good advice, I keep coming back to this book all the time
Interview with Adam Machanic Author Of Expert SQL Server 2005 Development

If T-SQL is your thing then there is no one better that Itzik, his books will open your eyes to the world of T-SQL
Interview With Itzik Ben-Gan Author Of Inside Microsoft SQL Server 2005: T-SQL Querying

A nice interview about refactoring SQL applications
Interview With Stéphane Faroult About Refactoring SQL Applications

I am a fan of Scott's column in Dr Dobbs and was very excited he wanted to do an interview
Database Refactoring Interview With Scott W. Ambler

Who doesn't know Erland? His curse and blessing of dynamic SQL is a must read
Interview With Erland Sommarskog About SQL Server and Transact SQL


Jamie is a real SSIS guru and I was glad he wanted to do this interview
Interview With SSIS Guru Jamie Thomson

Monday, December 8, 2008

Christmas Came Early This Year

This just arrived in the mail.
Christmas Came Early This Year

A big thanks to Itzik Ben-Gan. I will put up a review in a week or so.
Now I have a big problem, should I watch the season finale of Californication or should I start beginning to read Microsoft® SQL Server 2008 T-SQL Fundamentals?

I will not tell you what I will do. I interviewed Itzik a while back about his SQL Server 2005 book, you can read that interview here: Interview With Itzik Ben-Gan Author Of Inside Microsoft SQL Server 2005: T-SQL Querying