Browse by Tags

• Benchmarks
• Better Developer
• Book
• C#
• dates
• DELETE
• Django
• dmv
• Dynamic Management Views
• Extreme Programming
• Katmai
• Learning
• LINQ
• NULLIF
• Nulls
• ORM
• Performance
• PostgreSQL
• Productivity
• Python
• Shortcut
• SQL Myth
• sqL Server 2000
• SQL Server 2005
• SQL Server Integration Services
• SSIS
• time
• Tip
• Tips and Tricks
• trick
• TRUNCATE
• UPSERT
• Video
• Visual Studio 2005
• Visual Studio 2008
• Webcast
• Whitepapers
• Windows Server 2008

• No New DMVs In RC0 Compared to CTP6

  Remember this post 46 New Dynamic Management Views In SQL Server 2008 CTP6 ? I just checked SQL Server 2008 RC0 and there are no new Dynamic Management Views when compared to CTP6. Sorry, can't make up any DMVs :-( Now, if you could do this SELECT CAST('00:15:00' Read More... Posted Tuesday, June 24, 2008 4:21 PM by Denis Gobo | 2 Comments Filed under: SQL Server 2008, dmv

• Microsoft SQL Server 2008 Feature Pack RC0, June 2008 Available For Download

  Microsoft SQL Server 2008 Feature Pack RC0, June 2008 is available for download here: http://www.microsoft.com/downloads/details.aspx?familyid=089a9dad-e2df-43e9-9cd8-c06320520b40&displaylang=en&tm Sample Databases for Microsoft SQL Server 2008 Read More... Posted Thursday, June 12, 2008 5:30 PM by Denis Gobo | 0 Comments Filed under: SQL Server 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 (HPC). I must say that I have enjoyed this conference a lot. It seems that SQL Server is very prevalent on the Read More... Posted Wednesday, March 12, 2008 10:11 PM by Denis Gobo | 1 Comments Filed under: SQL Server 2008

• Windows Server 2008 and SQL Server 2008 Benchmarks

  Microsoft released a document today with some SQL Server 2008 benchmarks I found this sentence very interesting The result demonstrates the scale-up capabilities of SQL Server 2008 on HP Integrity. The 10TB benchmark is so demanding that only six other Read More... Posted Wednesday, February 27, 2008 5:11 PM by Denis Gobo | 8 Comments Filed under: Performance, SQL Server 2008, Benchmarks

• In SQL Server 2008 The CONVERT function is enhanced to allow conversions between binary and character hexadecimal values

  SQL Server 2008 CTP 6 has enhanced the convert function when you do conversion between binary and character hexadecimal values There are 3 styles: Style 0 works the same as on 2005 it converts binary to varchar, if you have 0x64656E6973 then you will Read More... Posted Wednesday, February 27, 2008 12:02 PM by Denis Gobo | 4 Comments Filed under: SQL Server 2008

• 46 New Dynamic Management Views In SQL Server 2008 CTP6

  Remember the 33 new DMVs in SQL Server 2008 post? I was just poking around in SQL Server 2008 CTP6 and wanted to know if there were any new Dynamic Management Views since CTP5. There are 13 new DMVs in CTP6 and there are a total of 46 new Dynamic Management Read More... Posted Thursday, February 21, 2008 3:55 PM by Denis Gobo | 3 Comments Filed under: SQL Server 2008, Dynamic Management Views

• Since A Long Weekend Is Coming Up And You Might be Bored...

  Since most people in the United States do not work on Monday I decided to give you some stuff to read just in case you don't know what to do with yourself this weekend. SQL Server 2008 Whitepapers There are 16 whitepapers that Microsoft has made available. Read More... Posted Thursday, February 14, 2008 1:18 PM by Denis Gobo | 9 Comments Filed under: SQL Server 2008, Video, Webcast, Learning, Whitepapers

• 33 New Dynamic Management Views In SQL Server 2008

  I was just poking around in SQL Server 2008 and wanted to know if there were any new Dynamic Management Views. There are a total of 33 new Dynamic Management Views. The list of them is below, I think their names make clear what the dmv is supposed to Read More... Posted Wednesday, February 06, 2008 3:31 PM by Denis Gobo | 8 Comments Filed under: SQL Server 2008, Dynamic Management Views

• A year in review, The 21 + 1 best blog posts on SQLBlog

  A year in review, The 21 + 1 best blog posts on SQLBlog Best posts according to me, it might have been the content or it might have been the comments. Either way here are the 21 + 1 posts I enjoyed the most. But wait the year is not over yet. Doesn't Read More... Posted Thursday, December 27, 2007 5:00 PM by Denis Gobo | 0 Comments Filed under: SQL Server 2008, sqL Server 2000, SQL Server 2005

• Video: Microsoft SQL Server 2008 Nov CTP - Spatial (Part 1/3)

  Head over to Channel 9 and watch the first part of a three part series about the spatial data type in SQL server 2008. Besides video formats there are also mp3 and wma versions in case you just want to listen to it Watch it here: http://channel9.msdn.com/ShowPost.aspx?PostID=363495#363495 Read More... Posted Saturday, December 08, 2007 10:53 AM by Denis Gobo | 0 Comments Filed under: SQL Server 2008, Video

• 2008: And Even More Row Constructor Fun

  I decided to do a quick post In addition to the posts by Peter and Louis . And yes I copied Louis' table and changed it a little :-) Row Constructor will get the most use by sending in a bunch of data to a proc and execute that. This way the app can just Read More... Posted Thursday, December 06, 2007 12:41 PM by Denis Gobo | 1 Comments Filed under: SQL Server 2008

• Visual Studio 2005 Support for SQL Server 2008, Community Technology Preview

  This CTP enables developers to use Visual Studio 2005 for SQL Server 2008 CTP5. This CTP resolves a problem that when you try to open a database connection to SQL Server 2008 by using Visual Studio 2005 design tools, you may receive the following error Read More... Posted Wednesday, November 21, 2007 10:29 AM by Denis Gobo | 1 Comments Filed under: SQL Server 2008, Visual Studio 2005

• Surface Area Configuration Tool Is Discontinued, SQL-DMO Removed from Microsoft SQL Server 2008 Express

  Just reading the readme file in SQL Server 2008 November CTP. I noticed that in addition to SQL Server Notification Services the following two things are also being removed. SQL-DMO Removed from Microsoft SQL Server 2008 Express Surface Area Configuration Read More... Posted Tuesday, November 20, 2007 3:47 PM by Denis Gobo | 1 Comments Filed under: SQL Server 2008

• Return Null If A Value Is A Certain Value

  You need to return NULL only if the value of your data is a certain value. How do you do this? There are three different ways. NULLIF DECLARE @1 char (1) SELECT @1 = 'D' SELECT NULLIF (@1 ,'D' ) REPLACE This should not really be used, I just added it Read More... Posted Tuesday, November 06, 2007 2:28 PM by Denis Gobo | 7 Comments Filed under: Tip, SQL Server 2008, sqL Server 2000, SQL Server 2005, trick, NULLIF, Nulls

• Microsoft Commits to November Release Date for Visual Studio 2008 and the .NET Framework 3.5

  Microsoft Commits to November Release Date for Visual Studio 2008 and the .NET Framework 3.5. But where is SQL Server 2008 ;-( I am still waiting for SQL Server 2008 CTP5 ;-( Visual Studio 2008 and the .NET Framework 3.5 will be available by the end of Read More... Posted Monday, November 05, 2007 10:12 AM by Denis Gobo | 2 Comments Filed under: SQL Server 2008, Visual Studio 2008