Browse by Tags

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

• A Quick Look At Compression In SQL 2008

  To use compression you have to understand what your data looks like, if your data is mostly unique then compression might not really help a lot. If your data is repeated on a page then it could be beneficial. In my own test compression would improve performance Read More... Posted Tuesday, April 07, 2009 4:32 PM by Denis Gobo | 4 Comments Filed under: compression, SQL Server 2008

• SQL Server Proximity Search

  George, a good friend of mine created a blog post showing how you can do a SQL Server Zipcode Latitude/Longitude proximity distance search without using the geography data type. I searched the internet to see if anyone had something similar with the geography Read More... Posted Wednesday, February 11, 2009 10:28 PM by Denis Gobo | 1 Comments Filed under: geography, geospatial, SQL Server 2008

• A year in review, The 31 best blog posts on SQLBlog for 2008

  Wow, it has been already a year since I wrote A year in review, The 21 + 1 best blog posts on SQLBlog last year Here we are with another fascinating collection of links, some of them are chosen for their content and some of them for the great comments. Read More... Posted Wednesday, December 31, 2008 11:36 AM by Denis Gobo | 3 Comments Filed under: list, SQL Server 2008

• Cumulative update package 2 for SQL Server 2008 has been released

  Cumulative update package 2 for SQL Server 2008 has been released, this build of the cumulative update package is also known as build 10.00.1779.00 To see all the fixes and how to obtain Cumulative update package 2 for SQL Server 2008 go here: http://support.microsoft.com/default.aspx/kb/958186/en-u Read More... Posted Wednesday, November 19, 2008 2:10 PM by Denis Gobo | 1 Comments Filed under: HotFix, SQL Server 2008

• Some of my reasons for upgrading to SQL Server 2008

  So Aaron posted My reasons for upgrading to SQL Server 2008 I thought it was an interesting list, not as interesting as the one by Jason Massie ( 10 Reasons to Upgrade to SQL Server 2008 ) but still interesting :-) I would like to give you my list. Date Read More... Posted Wednesday, November 19, 2008 11:59 AM by Denis Gobo | 1 Comments Filed under: SQL Server 2008

• Converting IP Addresses Between Bigint and Varchar And How to Sort IP Addresses

  I was wondering yesterday what else to add to the SQL Server Programming Hacks , I used twitter and asked for some inpiration and K. Brian Kelley responed with Some systems store IPs as large integers. Converting back and forth would be cool . Interesting, Read More... Posted Sunday, October 05, 2008 3:26 PM by Denis Gobo | 10 Comments Filed under: Sorting, SQL Server 2008

• SQL Server to scale into hundreds of terabytes of data by using DATAllegro

  Microsoft just released an interesting press release: Microsoft Closes Acquisition of DATAllegro The important stuff from this press release: Microsoft will offer a new solution based on DATAllegro’s technology that extends Microsoft SQL Server to scale Read More... Posted Tuesday, September 16, 2008 2:13 PM by Denis Gobo | 1 Comments Filed under: SQL Server 2008

• Interesting Bug/Feature In SQL Server 2008 RTM

  Someone had a problem with 8 year old procs which started to fail after moving to SQL Server 2008 Of course he should have used ints, but let's see what happens Run this code on SQL Server 2005 and 2000 DECLARE @num_Passed Numeric ( 2 , 0 ); SET @num_Passed Read More... Posted Monday, August 25, 2008 12:28 PM by Denis Gobo | 3 Comments Filed under: Bug, SQL Server 2008

• SQL Server 2008 Management Studio tip: Status Bar Custom Colors

  Joni Moilanen has a very nice tip about how you can use custom colors in the status bar so that you don't truncate that production table yet again :-) Check it out here: http://blog.jemm.net/2008/08/12/sql-server-2008-management-studio-tip-status-bar-custom-colors Read More... Posted Wednesday, August 13, 2008 4:59 PM by Denis Gobo | 0 Comments Filed under: SQL Server 2008, Tips and Tricks

• Microsoft SQL Server 2008 Feature Pack, August 2008 Available for download

  The 2008 Feature Pack for Microsoft SQL Server 2008, a collection of stand-alone install packages that provide additional value for SQL Server 2008 is available for download. One of these components is Microsoft SQL Server 2008 Policies Microsoft SQL Read More... Posted Thursday, August 07, 2008 4:25 PM by Denis Gobo | 0 Comments Filed under: SQL Server 2008

• SQL Server 2008 cannot be installed if you have Visual Studio 2008 RTM installed

  Visual Studio 2008 does not support having both Visual Studio 2008 without a service pack and Visual Studio 2008 with SP1 installed on the same computer. Because certain SQL Server 2008 features install components that are also part of the release version Read More... Posted Thursday, August 07, 2008 11:54 AM by Denis Gobo | 10 Comments Filed under: SQL Server 2008

• Converting Columns To Date From Datetime Does Not Result In A Scan In SQL Server 2008

  I was reading Itzik Ben-Gan's An Introduction to New T-SQL Programmability Features in SQL Server 2008 article yesterday after one of my friends allerted me to the following from that article For example, the plan for the following query performs an index Read More... Posted Thursday, July 24, 2008 3:20 PM by Denis Gobo | 1 Comments Filed under: dates, SQL Server 2008

• SQL Server 2008 geography data type screencasts on Channel 9

  Channel 9 has two screencast that deal with the new geography data type in SQL Server 2008. Saving Virtual Earth Polygons to SQL Server 2008 Marc Schweigert shows you how to draw a polygon on a Virtual Earth map and save it using ASP.NET AJAX, Windows Read More... Posted Saturday, July 19, 2008 5:34 PM by Denis Gobo | 0 Comments Filed under: LINQ, screencast, SQL Server 2008, WCF

• If you are upgrading from SQL Server 2000 to 2008 and you never touched SQL Server 2005, then I feel sorry for you

  “I sense you skipped SQL Server 2005 in you... Skipping SQL Server 2005 leads to a bigger learning curve... A bigger learning curve leads to not knowing the product as well...Not knowing the product as well leads to suffering..Running in compatibility Read More... Posted Wednesday, July 09, 2008 2:33 PM by Denis Gobo | 17 Comments Filed under: sqL Server 2000, SQL Server 2005, SQL Server 2008, Upgrading

• 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: dmv, SQL Server 2008