February 2008 - Posts

• 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 | 9 Comments Filed under: Benchmarks, Performance, SQL Server 2008

• 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

• SQL Sentences

  Why not store all of the SQL queries in the database? http://thedailywtf.com/Articles/SQL-Sentences.aspx Read More... Posted Monday, February 25, 2008 12:15 PM by Denis Gobo | 5 Comments Filed under: Sad but true

• 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 | 5 Comments Filed under: Dynamic Management Views, SQL Server 2008

• Five Different Ways To Return Data From One Table Which Doesn't Exists In another Table

  There are at least 5 ways to return data from one table which is not in another table. Two of these are SQL Server 2005 and greater only. This is a post mostly for beginners but hopefully everyone will get something out of it. Here are the 5 different Read More... Posted Wednesday, February 20, 2008 11:36 AM by Denis Gobo | 10 Comments Filed under: T-SQL

• If Airplanes Were Made By Using Scrum/Agile

  So I have been doing Scrum for a while now, I came across this video and thought it was hilarious. When you do Scrum you develop by using sprints, a sprint is usually between 2 and 4 weeks and at the end of the sprint you should have something working Read More... Posted Monday, February 18, 2008 3:43 PM by Denis Gobo | 2 Comments Filed under: Agile, Scrum

• 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: Learning, SQL Server 2008, Video, Webcast, Whitepapers

• Functions That Are Not Often Used: SIGN

  SIGN is one of those function which you almost never see used in code. Sometimes you are asked by the front-end/middle-tier developers to return a rowcount as well with the result set. However the developers want you to return 1 if there are rows and Read More... Posted Tuesday, February 12, 2008 3:46 PM by Denis Gobo | 1 Comments Filed under: Functions

• Banking Trojan Targets 400 Banks, updates itself multiple times a day

  Not a SQL Server post but I still think that this is important. I was listening to Security Now yesterday and Steve Gibson talked about this silent banking trojan. This is just scary, read the excerpt of the article first. Targeting over 400 banks (including Read More... Posted Saturday, February 09, 2008 10:43 AM by Denis Gobo | 0 Comments Filed under: Security

• Review of Inside Microsoft SQL Server 2005 Query Tuning and Optimization

  SQL performance tuning is probably one of those things you can do to really make a HUGE difference in performance. Let’s put this in perspective: take a typical application, if you can improve the performance by 100% then you really made a huge improvement. Read More... Posted Thursday, February 07, 2008 4:20 PM by Denis Gobo | 7 Comments Filed under: Book, review, SQL Server 2005

• 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 | 9 Comments Filed under: Dynamic Management Views, SQL Server 2008

• Should You Get Your Database Under Version Control?

  CodingHorror has a blogpost titled Get Your Database Under Version Control It is suggested that you also keep the data in version control. I am reading through the comments and I am amazed. One person writes "Once you have used ActiveRecord Migrations Read More... Posted Monday, February 04, 2008 11:34 AM by Denis Gobo | 10 Comments Filed under: Version Control