Showing posts with label SQL Server 2008. Show all posts
Showing posts with label SQL Server 2008. Show all posts
Monday, January 16, 2012

SQL Advent Recap and What is coming in SQL Server 2012 recap

›
In case you missed these, here is a recap of the SQL Advent and the SQL Server 2012 posts SQL Advent Recap Day 1:  Date and time I...
Sunday, December 11, 2011

SQL Advent 2011 series of posts

›
I have started a series of post about upgrading your skills to 2005 and 2008 versions of your code from 2000. Below is a list of posts that ...
Friday, October 31, 2008

SQL Server 2005 Service Pack 3 Beta and SQL Server 2008 Feature Pack October 2008 available for download

›
SQL Server 2005 Service Pack 3 Beta and SQL Server 2008 Feature Pack October 2008 are available for download Download SQL Server 2005 Servic...
1 comment:
Thursday, September 18, 2008

Interview With Louis Davidson Author of Pro SQL Server 2008 Relational Database Design and Implementation

›
I interviewed Louis Davidson in 2005 about the 2005 edition of his book. I did another one today about Pro SQL Server 2008 Relational Databa...
Monday, August 25, 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 le...
Monday, August 11, 2008

Microsoft Visual Studio 2008 Service Pack 1 Available For Download

›
Get it here: http://www.microsoft.com/downloads/thankyou.aspx?familyId=fbee1648-7106-44a7-9649-6d9f6d58056e&displayLang=en Here is the l...
Monday, July 07, 2008

sp_indexinfo an enhanced index information procedure

›
Tibor Karaszi has created a very useful index information stored procedure for SQL Server 2005 and up. This stored procedure will tell you t...
Tuesday, June 10, 2008

SQL Server 2008 Release Candidate 0 Available To The General Public For Download

›
SQL Server 2008 Release Candidate 0 has been made available to the general public. There are 2 versions (and 3 flavors of each) ISO or DVD D...
Tuesday, May 27, 2008

Interview With Erland Sommarskog About SQL Server and Transact SQL

›
I have interviewed Erland Sommarskog, you can find that interview here: Interview With Erland Sommarskog About SQL Server and Transact SQL E...
Wednesday, May 07, 2008

Should SQLServer Have The CREATE [OR REPLACE] PROCEDURE Syntax?

›
I was asked by a developer at work the other day why SQL Server does not have the create or replace syntax. I started thinking and there wer...
3 comments:
Tuesday, April 22, 2008

How to rename a column in a SQL Server table without using the designer

›
If you have a table and you want to rename a column without using the designer, how can you do that? First create this table CREATE TABLE T...
2 comments:
Tuesday, April 15, 2008

Solutions for Common T-SQL Problems Wiki Launched

›
Volunteer Moderators and Answerers who support the Microsoft MSDN SQL Server Forums have launched a Wiki with Solutions for Common T-SQL Pro...
Monday, April 14, 2008

Use IDENT_CURRENT() to return the last identity value generated in all tables in a SQL Server Database

›
This is how you return all the tables with their last generated identity values in a SQL Server Database SELECT IDENT_CURRENT (table_name),...
Wednesday, March 12, 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...
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...
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...