Friday, April 25, 2008

SQL Teaser: Some Things Are Not What They Seem

›
This one is a little sneaky, don’t send me hate mail for it. What does this return? SELECT ISNUMERIC ( '+' ), ISNUMERIC ( '–...
2 comments:
Tuesday, April 22, 2008

How to rename a column in a SQL Server table without using the designer

›
If you have a table and you want to rename a column without using the designer, how can you do that? First create this table CREATE TABLE T...
2 comments:
Monday, April 21, 2008

Interview With Stéphane Faroult About Refactoring SQL Applications

›
I decided to interview Stéphane Faroult, the author of The Art of SQL because it is one of my favorite SQL books. Stéphane told me he has a...
Tuesday, April 15, 2008

Solutions for Common T-SQL Problems Wiki Launched

›
Volunteer Moderators and Answerers who support the Microsoft MSDN SQL Server Forums have launched a Wiki with Solutions for Common T-SQL Pro...
Monday, April 14, 2008

Use IDENT_CURRENT() to return the last identity value generated in all tables in a SQL Server Database

›
This is how you return all the tables with their last generated identity values in a SQL Server Database SELECT IDENT_CURRENT (table_name),...
Sunday, April 13, 2008

Links Of The Week 20080414

›
Here are the links for this week Database SQL Server 2005 Memory Limits and Related Questions Microsoft to Increase Use of SQL Server 2005 B...
Monday, April 07, 2008

Video: SQL Server Data Services Architecture

›
SQL Server Technical Evangelist Ryan Dunn sits down and talks turkey with two of the creators of SQL Server Data Services (SSDS), Architect ...
Saturday, April 05, 2008

Links Of The Week 20080405

›
Here are the links for this week Database Send Table or View as embedded HTML in an email – stored procedure How It Works: SQL Server 2005 D...
Wednesday, April 02, 2008

Database Refactoring Interview With Scott W. Ambler

›
Since I am doing scrum and other agile methodologies myself I decided to interview the authority on agile in the database world. Scott W. Am...
Tuesday, April 01, 2008

SQL Champ - A Quiz to Prove Your SQL Knowledge

›
In case you are bored CodeProject has a small SQL test (7 questions) Take the test here: SQL Champ - A Quiz to Prove Your SQL Knowledge And ...
1 comment:

Not An April Fool’s Joke: SQL Server 2000 Mainstream Support Ends In A Week

›
April 1st 2008 is the day on which support for SQL Server 2000 ends (and it is also my birthday) SQL 2000 SP4 - currently supported; support...
Sunday, March 30, 2008

Links Of The Week 20080330

›
Who needs SQL links when you have this gem? Check out (grand)ma in the background, she doesn't miss a beat.
1 comment:
Friday, March 28, 2008

How To Use COALESCE And NULLIF To Prevent Updating Columns When A Parameter IS NULL Or A Default Value

›
A variation of this question popped up twice in the SQL programming newsgroup since yesterday, this means it is time for a blogpost. Let...
Tuesday, March 25, 2008

Technet Radio: A Look Inside SQLCAT (SQL Customer Advisory Team)

›
Channel9 has a podcast with the SQLCAT team. On this episode of TechNet Radio, We learn more about SQL CAT – the SQL Customer Advisory Team....
Saturday, March 22, 2008

Links Of The Week 20080322

›
Here are the links for this week Database Programming Policy-Based Management with SMO - Part 1 - Intro Programming Policy-Based Management ...
Thursday, March 20, 2008

SOT: I found a new 'worst query'

›
Before you ask, SOT means Slightly Off Topic :-()) Take a look at Hi, I need help on simplyfying this Update query! I don't even want to...
Tuesday, March 18, 2008

What tastes better, Microsoft SQL Server 2005 or Oracle 11g?

›
Find out here: http://www.databasetastechallenge.com/landing/index.html You can win some cool prizes. the video is very funny
Monday, March 17, 2008

Links Of The Week 20080317

›
Here are the links for this week Database TechNet Radio: SQL 2008 Part 2 of 2: Management, Troubleshooting and Throttling SQL Server: XQuery...
Wednesday, March 12, 2008

6th Annual Financial Services Developer Conference

›
I went to the 6th Annual Financial Services Developer Conference today in New York City. This year’s focus was on High Performance Computing...
Sunday, March 09, 2008

StrataFrame Or CSLA.NET, Which Framework Would You Use?

›
If you would have to choose between StrataFrame or CSLA.NET, which one would you pick? The team I am part of at work is trying to pick a fra...