July 2007 - Posts

• Summer SQL Teaser #9 ROLLBACK

  This one is not so much a teaser but it will show you what you can do in case you want to insert data in a logging table after a rollback occurs Without running this try to guess what the counts of the three tables will be after the rollback CREATE TABLE Read More... Posted Friday, July 27, 2007 10:01 AM by Denis Gobo | 3 Comments Filed under: Teaser, transactions

• Visual Studio 2008 Beta 2 Available For Download

  Visual Studio 2008 Beta 2 is available for download, pick your poison from the list below. Visual Studio Team System 2008 Beta 2 Team Suite (VPC) Visual Studio 2008 Beta 2 Standard Edition Visual Studio 2008 Beta 2 Team Foundation Server (VPC) MSDN Library Read More... Posted Thursday, July 26, 2007 7:23 PM by Denis Gobo | 0 Comments Filed under: Visual Studio 2008, Orcas, .Net 3.5

• Perfect way to manage a database project.........not!

  I found this gem yesterday here: http://www.tek-tips.com/viewthread.cfm?qid=1391668&page=1 here is the question I have a situation where a person can have more then one item ordered. I need to layout the information as follows: Person Item Ordered Read More... Posted Thursday, July 26, 2007 9:08 AM by Denis Gobo | 1 Comments Filed under: SQL Server, Oracle, Sad but true

• Becoming A Better Programmer In 6 Months: The First 10 days

  Here is an update of what I accomplished in the first 10 days Read the book lifehacker Read the book Microsoft SQL Server 2005 Integration Services Read 126 pages of Extending SSIS 2005 with Script Installed PostgreSQL, Python, Eclipse and Django. Now Read More... Posted Wednesday, July 25, 2007 3:26 PM by Denis Gobo | 8 Comments Filed under: Extreme Programming, Book, SSIS, Django, Better Developer, Python, PostgreSQL

• Summer SQL Teaser #8A @@TRANCOUNT

  Here is another quick teaser (since the last one wasn't that good). What will be the values of the print statements? Try to guess it before running this code SET ANSI_DEFAULTS ON PRINT '#1 == ' + LTRIM ( STR ( @@TRANCOUNT )) BEGIN TRANSACTION PRINT '#2 Read More... Posted Sunday, July 22, 2007 8:59 AM by Denis Gobo | 4 Comments Filed under: Teaser

• Summer SQL Teaser #8 Comments And Go

  Without running the following two blocks of code what do you think will the output be? /* code 1 SELECT GETDATE() GO */ SELECT GETDATE () /* code 2 SELECT GETDATE() GO */ SELECT GETDATE () Read More... Posted Friday, July 20, 2007 1:56 PM by Denis Gobo | 4 Comments Filed under: Teaser

• Non-Technical: Happy Birthday Twins

  Today my twins are one year old . It is supposed to be a little easier from now on (until they hit 2 that is). Here is one picture. If you want to see more you can go here: http://www.flickr.com/photos/denisgobo/ This is the last non-technical post I Read More... Posted Tuesday, July 17, 2007 8:36 PM by Denis Gobo | 5 Comments Filed under: non-technical

• Become a Better Developer... in 6 months

  I just listened to the latest Hanselminutes podcast: Be a Better Developer in Six Months Scott Hanselman asks “what are you going to do in the next 6 months to become a better developer”? He suggest reading books, nerd dinners, having lunches together Read More... Posted Monday, July 16, 2007 11:37 AM by Denis Gobo | 11 Comments Filed under: programming, code, Books

• Best Practice: Backups

  What if I told you to take your latest production backup, restore it on a different machine and try using the database? Are you comfortable with that task? Do you think it will work? When was the last time you tested your backups? Do you even have a backup? Read More... Posted Saturday, July 14, 2007 10:40 AM by Denis Gobo | 3 Comments Filed under: Best Practices, Subversion, Source Control, Tortoise, Backup

• Summer SQL Teaser #7A Datetime Yet Again

  Okay one more quick teaser You have this date '2007-01-01 00:00:00.001' When adding 1 or 2 milliseconds to that date what will be the result? SELECT DATEADD ( ms , 1 , CONVERT ( datetime , '2007-01-01 00:00:00.001' )) SELECT DATEADD ( ms , 2 , CONVERT Read More... Posted Friday, July 13, 2007 10:34 AM by Denis Gobo | 2 Comments Filed under: Teaser

• Summer SQL Teaser #7 Datetime

  First create this table CREATE TABLE #DateMess (SomeDate datetime ) INSERT #DateMess VALUES ( '20070710' ) INSERT #DateMess VALUES ( '20070711' ) INSERT #DateMess VALUES ( '20070712' ) INSERT #DateMess VALUES ( '20070713' ) This should be easy for most Read More... Posted Friday, July 13, 2007 9:08 AM by Denis Gobo | 1 Comments Filed under: Teaser

• Good LINQ to SQL Posts

  Over the last few weeks Scott Guthrie has been writing a series of blog posts that cover LINQ to SQL. LINQ to SQL is a built-in O/RM (object relational mapper) that ships in the .NET Framework 3.5 release, and which enables you to easily model relational Read More... Posted Thursday, July 12, 2007 10:03 AM by Denis Gobo | 0 Comments Filed under: DLINQ, LINQ, ORM

• Microsoft SQL Server 2008 will launch on Feb. 27, 2008

  Windows Server® 2008, Visual Studio® 2008 and Microsoft SQL Server™ 2008 will launch together at an event in Los Angeles on Feb. 27, 2008 , kicking off hundreds of launch events around the world. As the next wave of innovation from Microsoft’s Server Read More... Posted Tuesday, July 10, 2007 6:09 PM by Denis Gobo | 1 Comments Filed under: SQL Server 2008, Visual Studio 2008, Windows Server 2008

• SQL Controversy: Capitalizing Keywords

  Do you write code like this? set ROWCOUNT 10 select Products.ProductName as TenMostExpensiveProducts, Products.UnitPrice from Products order by Products.UnitPrice desc Or like this? SET ROWCOUNT 10 SELECT Products.ProductName AS TenMostExpensiveProducts, Read More... Posted Monday, July 09, 2007 12:11 PM by Denis Gobo | 9 Comments Filed under: SQL Controversy

• Summer SQL Teaser #6 Non Existing Database

  Here is a simple teaser, BTW I assume you don't have a database named WasabiDb or do you? USE WasabiDb IF @@Error <> 0 PRINT 'db doesn''t exist' USE WasabiDb GO IF @@Error <> 0 PRINT 'db doesn''t exist' If you would run this in one shot (hit Read More... Posted Friday, July 06, 2007 10:10 AM by Denis Gobo | 3 Comments Filed under: Teaser

• SQL Server 2005 Best Practices Analyzer Released, End Of Support For SQL Server 2000 SP3a In 6 Days

  End of Support for SQL Server 2000 Service Pack 3a Support for SQL Server 2000 Service Pack 3a (SP3a) will end on July 10, 2007. Microsoft will end technical support on this date, which also includes security updates for this Service Pack. Microsoft is Read More... Posted Wednesday, July 04, 2007 5:40 AM by Denis Gobo | 0 Comments Filed under: sqL Server 2000, SQL Server 2005

• SSIS Script Task In SQL Server 2008 Can Use VB Or C#

  Where do I send a thank you letter? Finally we are allowed to use C# in the SQL Server Integration Services Script Task. I always wondered why SQL Server 2005 only uses VB and not C#, you can use C# in the SQLCLR but not in a Script Task. It turns out Read More... Posted Wednesday, July 04, 2007 5:21 AM by Denis Gobo | 4 Comments Filed under: SQL Server 2008, SQL Server Integration Services, SSIS, C#