SQL 2005 Metadata Samples Toolkit and whitepaper now available

Reposted 10/1/06 to include in ‘free tools’ category  I’m constantly asked “what’s Microsoft doing about metadata and do we have a solution.” In the old days (SQl 2000 and 7), Microsoft provided Meta Data Services, a platform designed to help tools and applications manage metadata and information models more effectively. It included the Open Information…


New SQL 2005 code samples available

I guess now the pressure is off to release the product we’ll see more useful samples comming out of corp; here’s a link to the latest December update: http://msdn.microsoft.com/sql/downloads/samples/default.aspx  


Feature Pack for Microsoft SQL Server 2005 – November 2005

Overview The Feature Pack is a collection of standalone install packages that provide additional value for SQL Server 2005. It includes: Latest versions of redistributable components for SQL Server 2005 Latest versions of add-on providers for SQL Server 2005 Latest versions of backward compatibility components for SQL Server 2005 http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en


SQL Server Reporting Services Report Packs – looking for suggestions

when I was over in the US recently, I attended a ‘Bill Baker and team unplugged’ session, (Bill is the GM for SQL Server Business Intelligence).  Reporting Services Report packs came up as a topic for discussion.  The team asked the audience if the Report Packs had been well recieved, to which I quickly responded…


Get Ready for SQL Server 2005 with Free Microsoft E-Learning Courses.

More and more people are asking me about SQL 2005 training courses and certification.  I believe the exams will be ready in Q1 next year.  In the meantme, how about access to the training courses absolutely free until 1st November @ https://www.microsoftelearning.com/sqlserver2005    


SQL Server 2005 JDBC Driver Beta 1 Now Available

Not many people know we have a SQL JDBC driver at all, well now we’ve got a beta version for SQL Server 2005.  It works for a wide variety of OSs including: HP-UX, IBM AIX, Linux, Solaris, Windows 2000, Windows Server 2003, or Windows XP.  Apparently it goes a lot better than the old (SQL…


Querying and Reporting on Report Execution Log Data

Well I didn’t realise, or maybe I just plain forgot, that these reports and the necessary support infrastrucuture come with Reporting Services under the extras folder on the CD – all useful stuff for report heads. Longest Running ReportsMost Executed Reports Report Exections By Hour Report Parameters ReportsByMonth ReportsByUser ReportsExecutedByDay ReportSize ReportSuccessRate Todays Reports For…


Download Microsoft SQL Server 2005 Express Edition: Community Technology Preview April 2005

Microsoft SQL Server 2005 Express Edition: Community Technology Preview April 2005 Download the Community Technology Preview (CTP) of Microsoft SQL Server 2005 Express Edition. Unlike beta releases that receive a much higher level of testing and feature work, CTPs are intended to expose the latest working build.   This CTP is feature complete and looks…