Browse by Tags

All Tags » SQL Server 2008 (RSS)
VBUG Manchester March 3rd 2010 - Slides and examples
15 March 10 10:23 PM | MartinBell | with no comments
At the VBUG meeting in Manchester on 3rd March, I was scheduled to talk about Table Valued Parameters, but when I got there the guys wanted something more general so I talked about some of the new features of SQL 2008. The presentation is here and the...
Filed under: ,
Learning SQL Server
12 March 10 07:21 AM | MartinBell | 2 comment(s)
Everyone is different when it comes to learning, here are a few options to help you find your own preference....
Filed under:
SQL Server 2008 R2 Update for Developers Training Kit Released
06 February 10 09:37 PM | MartinBell | 2 comment(s)
I noticed that the SQL Server 2008 Developers Training Kit has been re-released last week with a R2 Update. It looks like a great resource for SQL 2008 information and the additional features in SQL 2008 R2. It includes links to 8 videos (mainly R2 features...
Filed under: ,
New CTP release of SQL Server 2008 R2 available
14 November 09 07:17 AM | MartinBell | with no comments
The November CTP of SQL Server 2008 R2 was released last Thursday...
Filed under: ,
SQL Server 2008 Cumulative Updates
24 July 09 09:52 PM | MartinBell | with no comments
Monday saw a couple of cumulative updates released for SQL Server 2008 which seems to have gone unnoticed by most, including SQL Server Central and wasn't included in Steve's build list on Wednesday! Cumulative update 3 for SQL Server 2008 SP1...
Filed under:
WMI Event Alerts
26 May 09 10:30 AM | MartinBell | 2 comment(s)
WMI Event Alerts can be used to capture event notification information, using these could be the start of a pro-active approach to monitoring your database systems....
Filed under: , , ,
Table-valued parameters in SQL Server 2008 (Part 3)
22 May 09 07:57 PM | MartinBell | 3 comment(s)
Table-valued parameters are a new Feature in SQL Server 2008 in this post I try an look at how they perform compared to other methods you may have previously used....
Filed under: , ,
Missing Row Constructors?
21 May 09 10:23 AM | MartinBell | 10 comment(s)
ROW CONSTRUCTORS are a new feature in Books Online, but you may not know about them if you can't find them!...
Filed under: , ,
Time for another Date?
15 May 09 03:34 PM | MartinBell | 2 comment(s)
At last SQL Server has a separate date and time datatypes!! I have updated the blog I originally posted on Technet Industry Insiders blog and recreated it here....
Filed under:
When are you upgrading to SQL Server 2008?
13 May 09 08:13 AM | MartinBell | 1 comment(s)
The apparently slow uptake for SQL Server 2008, seems to imply the hard lessons learn't from previous recessions. This blog will point you to some research that would show this is foolhardy; and show there is more to Computer Weekly than Dilbert, Downtime and the DPM's diary....
Filed under: ,
Table-valued parameters in SQL Server 2008 (Part 2)
11 May 09 03:00 PM | MartinBell | 4 comment(s)
One advantage of the Table-valued parameter (TVP) is that you can build up the data for the TVP within a client application. Here is show how easy it is to pass a Datatable as a TVP in a simple .NET application....
Filed under: ,
Table-valued parameters in SQL Server 2008 (Part 1)
10 May 09 10:05 PM | MartinBell | 5 comment(s)
Table-valued parameters are a new feature in SQL Server 2008. This series of posts is inspired by a talk I gave at the inaugral meeting of the Manchester SQL Server User Group in March....
Filed under: , ,