Thursday, November 10, 2005 - Posts

Most interactive demo at UK Launch

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Most interactive demo at UK Launch
The new RSS feed is here

Jonathan Greensted was presenting in the chalk and talks at the UK launch of Visual Studio 2005 and SQL 2005 on Tuesday. As someone heavily involved in software using the compact framework i.e. for mobiles and pocket Pcs, he was able to do a very cool demo.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Most interactive demo at UK Launch

posted Thursday, November 10, 2005 7:22 PM by SimonSabin with 0 Comments

Deleting/archiving data in SQL Server 2005

A delete can now use TOP i.e.

DELETE TOP (2000) FROM MyBigTableWHERE someCondition = true  ORDER BY Dateolumn ASC

Michael Campbell has blogged about removing data from a table in chunks http://sqladvice.com/blogs/repeatableread/archive/2005/09/20/12795.aspx. This can be simplified even further in SQL Server 2005 using the above.

This very is similar to my post http://www.sqljunkies.com/WebLog/simons/archive/2005/10/23/17204.aspx.

 

 
posted Thursday, November 10, 2005 7:12 PM by SimonSabin with 0 Comments

All the extra bits for SQL Server 2005

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/All the extra bits for SQL Server 2005
The new RSS feed is here

If you are looking for all the add-ons, redistributables, client installs of components in SQL Server 2005 including the following

Microsoft ADOMD.NET
Microsoft Core XML Services (MSXML) 6.0
Microsoft OLEDB Provider for DB2
Microsoft Operations Manager 2005 Management Pack for Microsoft SQL Server 2005
Microsoft SQL Server 2000 PivotTable Services
Microsoft SQL Server 2000 DTS Designer Components
Microsoft SQL Server Native Client
Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider
Microsoft SQL Server 2005 Backward Compatibility Components
 Including DTS runtime, SQLDMO, DSO, SQLVDI
Microsoft SQL Server 2005 Command Line Query Utility
Microsoft SQL Server 2005 Datamining Viewer Controls
Microsoft SQL Server 2005 JDBC Driver
Microsoft SQL Server 2005 Management Objects Collection
Microsoft SQL Server 2005 Mobile Edition
Microsoft SQL Server 2005 Notification Services Client Components
Microsoft SQL Server 2005 Upgrade Advisor
Microsoft .NET Data Provider for mySAP Business Suite
Reporting Add-In for Microsoft Visual Web Developer 2005 Express

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/All the extra bits for SQL Server 2005

posted Thursday, November 10, 2005 12:48 PM by SimonSabin with 1 Comments

Management studio for express

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Management studio for express
The new RSS feed is here

If you were at my chalk and talk on managebility in Sql Server 2005 at the launch in Birmingham, you will have heard me talk about the Sql Server Express edition of management studio.
Well its out,

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Management studio for express

posted Thursday, November 10, 2005 8:52 AM by SimonSabin with 0 Comments