February 2008 - Posts

Announcing the new CUE website for SQL Server 2008 - You must check this out!!

We’re announcing the launch of the new SQL Server 2008 CUE website.  SQL Server 2008 is the third product to be migrated to the new Consistent User Experience (CUE) framework and CSP publishing platform and another great leap forward in driving consistency across all STB product sites.  

 

The CUE framework was designed to “bring it all together” for our customers and provides a number of customer-focused enhancements including consistent navigation and content, improved discoverability, and greater integration with other sites in the MS web ecosystem.    The new SQL Server 2008 site integrates these improvements and starts to take CUE to the next level with a greater focus on page visuals and deeper linking to related SQL content on the Tech & DevCenters.   (Note that the new site does not replace the existing product site, which will continue to support our sales efforts for SQL Server 2005.) 

 

 

Cheers,

 

Itay Braun                Premier Field Engineer - SQL Server                    Microsoft Services - UK

E-Mail: itayb@microsoft.com          Mobile: +44-796-928-9996       Blog: http://sqlblogcasts.com/blogs/thepremiers/

Veni              Vidi              Fixit

Announcing the TechNet and MSDN Roadshow (Free of charge)

 

Now the roadshow is coming to a city near you

 

Following the 2008 Launch event in Birmingham on 19th March, TechNet will be going out on the road.

The roadshow will be heavy on demos and light on PowerPoint. We'll look at various scenarios, such as managing Windows Server 2008 and how Windows Server 2008 works alongside Windows Vista.

You'll have the opportunity to meet the Microsoft Community, our user groups and Most Valued Professionals, as well as experts with top technical information and real-world scenarios.

Places really are limited due to a high number of pre-registrations so register today

- Cardiff, 22 April 2008
- London, 24 April 2008
- Manchester, 30 April 2008
- Glasgow, 12 May 2008
- Newcastle, 15 May 2008

To register go to the Heroes Happen Here website or call us on 0870 166 6620


 

Calling all developers……

Now the roadshow is coming to a city near you

 

This is your opportunity to meet the MSDN team and find out all about the latest developer tools and technologies from Microsoft.

 

The MSDN Roadshow is a series of full day, demo-heavy events where you can find out more about Visual Studio 2008 and future Microsoft technologies. It's also your opportunity to meet the MSDN team and discover the latest developer tools.

Now that Visual Studio 2008 and .NET Framework V3.5 have been launched, the MSDN Roadshow will also focus on other products of interest for .NET developers. We'll look at Silverlight, ASP.NET, ADO.NET and Visual Studio Team Suite to create sessions that are all about code, not PowerPoint.

Places are limited so register today

- Cardiff, 21 April 2008
- London, 25 April 2008
- Manchester, 1 May 2008
- Glasgow, 13 May 2008
- Newcastle, 16 May 2008

Register now by visiting the Heroes Happen Here website or phone us on 0870 166 6650


 

Enjoy

Itay Braun                Premier Field Engineer - SQL Server                    Microsoft Services - UK

E-Mail: itayb@microsoft.com          Mobile: +44-796-928-9996       Blog: http://sqlblogcasts.com/blogs/thepremiers/

Veni              Vidi              Fixit

 

What is the latest cumulative update/ build for SQL Server?

 

I got this question a lot. Here is my answer (last Updated 2008-02-28):

Microsoft Links

 

Cumulative list of the hotfixes that are available for SQL Server 2000 SP4

http://support.microsoft.com/kb/894905

 

  • Latest build reported is 8.00.2249 but the external links below list latest build 8.00.2265 along with link to KB.

 

The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 2 was released

http://support.microsoft.com/kb/937137

 

External Links

 

http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx

 

Microsoft SQL Server 2008, 2005, 2000 and 7.0 Builds

http://sqlserverbuilds.blogspot.com/

 

http://www.aspfaq.com/SQL2000Builds.asp 

 

Visual Studio Team System 2008 Database Edition Power Tools

The “DataDude” team is happy to announce the availability of the Power Tools for Visual Studio Team System 2008 Database Edition.

 

The Power Tools for 2008 contains all the functionality we shipped in 2005 plus:

·         Command line SQL Static Code Analysis execution through MSBuild, this was the biggest customer request, which is why I was holding the release. This enables SQL Static Code Analysis to be part of Team Build!

·         Data Generation Wizard; this is another customer request where we allow them to create a new data generation plan by pointing at an existing database, the plan will be fully configured by the wizard to pull all data from the database. This way users can use an existing data set and only override the privacy concerned data and save about half a day or more of configuration

·         File based data generator; this allows you to insert the content of files in to the database (works for string and binary, not for XML yet)

·         XML based data generator; this allows you to generate XML based on an XSD (the XSD has to be provided as file right now, and cannot be selected from database or inherited from the data type)

·         Refactoring Command Generator has been made available as a MSBuild task for better project build integration so it can be made part of the pre-build and pre-deployment stages in the project. This allows users to automated the results of refactoring to some degree in to the project.

 

Download page:

http://www.microsoft.com/downloads/details.aspx?FamilyID=73ba5038-8e37-4c8e-812b-db14ede2c354&displaylang=en

 

Installer download:

http://download.microsoft.com/download/f/b/8/fb8d1c0d-c0c4-4004-ab86-12396b2a3ee3/VSTSDB2008PT.msi

 

Documentation download:

http://download.microsoft.com/download/f/b/8/fb8d1c0d-c0c4-4004-ab86-12396b2a3ee3/Power Tools 2008.doc

OLAPQueryLog analysis

We can learn a lot about cube usage and actual aggregation usage from the OLAPQueryLog table.  

I attached here my demo from Tech Ready 6.

In the attached file you can find a Word document which guides you what to do, T-SQL Scripts and SSRS reports.

More details in a proper post when I'll be back from Seattle.

 

Itay Braun                Premier Field Engineer - SQL Server                    Microsoft Services - UK

E-Mail: itayb@microsoft.com          Mobile: +44-796-928-9996       Blog: http://sqlblogcasts.com/blogs/thepremiers/

Veni              Vidi              Fixit

Search

Go

This Blog

Tags

Syndication