Wednesday, February 27, 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 s...
Thursday, February 21, 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 ne...
Wednesday, February 20, 2008

Microsoft SQL Server 2008 Feature Pack CTP, February 2008

›
The Feature Pack is a collection of stand-alone install packages that provide additional value for SQL Server 2008. It includes the latest v...

SQL Server 2008 February CTP is now available for public download

›
SQL Server 2008 February CTP is finally here, this CTP is supposed to be feature complete. Download the February CTP from the Download Cente...
Monday, February 18, 2008

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 sp...
1 comment:
Sunday, February 17, 2008

Weekly Links 20080217

›
I decided to do a weekly links post with interesting SQL Server stuff, I also include a bunch of funny things at the bottom. Technical Stuff...

HTTP Endpoints deprecated In SQL Server 2008, Just Like Notification Services

›
Just like Notification Services HTTP Endpoints have been deprecated in SQL Server 2008. Bob Beauchemin's Blog has more info here: HTTP E...
Thursday, February 14, 2008

SQL Server 2008 Whitepapers

›
General SQL Server 2008 Product Overview Microsoft® SQL Server™ provides a policy-based system for managing one or more instances of SQL Ser...
Friday, February 08, 2008

This is just awesome

›
Thursday, February 07, 2008

SQL Server 2008: When Was The Server Last Started?

›
SQL Server 2008 has an additional column in the sys.dm_os_sys_info Dynamic Management View. The name of the column is sqlserver_start_time a...
2 comments:

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 perspec...
Wednesday, February 06, 2008

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 D...
2 comments:
Monday, February 04, 2008

Windows Server 2008 and Vista SP1 releasing to manufacturers today

›
Windows Server 2008 RTM: http://www.microsoft.com/presspass/features/2008/feb08/02-04WS2008.mspx Windows Vista SP1: http://windowsvistablog...

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...
2 comments:
Friday, February 01, 2008

Vote for SQL Server 2005 Service Pack 3

›
Hugo Kornelis makes a good point here: Want a Service Pack? Ask for it! Service pack 2 for SQL Server 2005 is already 11 months old. And th...
Tuesday, January 29, 2008

Some Very Sad News For The SQL Server Community

›
Ken Henderson passed away this last Sunday . My condolences go out to his family, friends, and coworkers. I owe so much to Ken, if it wasn...
Saturday, January 26, 2008

SQL Server 2008 To RTM In Q3 2008

›
Francois Ajenstat on his blog writes that "Microsoft is excited to deliver a feature complete CTP during the Heroes Happen Here launch...
Friday, January 25, 2008

Tip: Find all The Rows Where Any Of The Columns Is Null Or Zero Or Both

›
This question is asked every now and then so I decided to do a little blog post. How can you quickly without writing a bunch of OR statement...

Some Links To Blogs By Some Friends Of Mine

›
Since I have nothing useful to post today I decided to post some links to some of my friends The first one is from someone in Belgium, his n...
3 comments:
Monday, January 21, 2008

SQL Server 2005 Best Practices Analyzer (January 2008) Available For Download

›
This download is the January 2008 release of SQL Server 2005 Best Practices Analyzer. Get it here: http://www.microsoft.com/downloads/detail...