August 2009 - Posts

This has just drove me mad for half an hour; I've just took delivery of a new machine I'm building for my client - 2 x 146GB SAS in RAID 1 and 4 x 300GB SAS in RAID 10 - going through the DELL install I eventually get to the Windows 2008 x64 Server install and the bit where it asks which partition to install on - empty - no devices found and you can proceed.

I went into the PERC controller and removed all but 1 of the disk groups (where I'm putting the OS) and its worked fine.

I guess I needed to install the OS first then set up the other virtual disk group; bizzarre - perhaps never tested by DELL as it came like that (2 disk groups).

Whatcha!

I'm writing a new content area on http://sqlserverfaq.com/ to hold our LiveMeeting recordings and the other content we have and I wanted to create a short character/digit code that you can put on the end of the domain eg http://sqlserverfaq.com/FGRE2 that shorts the URL so you can go straight to the article - makes news letters and blog posts a lot neater.

Anyway, here is how you can use Views and CTE (Common Table BLOCKED EXPRESSION to accomplish generating A - Z and 0 - 9 and get a random selection of that for 'x' number of alphanumeric combinations...

In a real system you'd probably store them to inch that extra performance out, but - this is the fun and educational way of building the data....

create view vw_alpha_numerics

as

      with chrs ( chr ) as (

 

            select chr = ASCII( 'A' )

           

            union all

           

            select chr = chr + 1

            from chrs

            where chr < ASCII( 'Z' )

            )

      , nums ( chr ) as (

 

            select chr = ASCII( '0' )

           

            union all

           

            select chr = chr + 1

            from nums

            where chr < ASCII( '9' )

            )

           

      select chr_code = chr, chr = CHAR( chr )

      from chrs

      union all

      select chr_code = chr, chr = CHAR( chr )

      from nums

 

go

 

with nums ( pos ) as (

 

      select pos = 1

 

      union all

     

      select pos = pos + 1

      from nums

      where pos < 10

      )

select top 10 va.chr

from nums n

      cross join ( select chr

                       from vw_alpha_numerics

                         where chr not in ( '0', 'A', 'E', 'I', 'O', 'U' ) ) as va

order by NEWID()

And one of many ways of getting back the string...

declare @short_lookup_name varchar(10)

 

with nums ( pos ) as (

 

      select pos = 1

 

      union all

     

      select pos = pos + 1

      from nums

      where pos < 10

      )

select @short_lookup_name = (

      select chr as [text()]

      from (

            select top 4 va.chr

            from nums n

                  cross join ( select chr

                                     from vw_alpha_numerics

                                     where chr not in ( '0', 'A', 'E', 'I', 'O', 'U' ) ) as va

            order by NEWID()

      ) as r     

      for xml path( '' ) )

 

print @short_lookup_name

 


SQL Server 2008 R2 August CTP Availability Announcement

Link: http://blogs.technet.com/dataplatforminsider/archive/2009/08/10/download-sql-server-2008-r2-august-ctp-today.aspx 

Executive Summary

The SQL Server Team is pleased to announce the release of the August
Community Technology Preview (CTP) of SQL Server 2008 R2.

Your Data, Any Place, Any Time

SQL Server® 2008 R2 expands on the value delivered in SQL Server® 2008 to
help your organization scale with confidence and improve IT and developer
efficiency with new and enhanced tools for application and multi-server
management, master data services and complex event processing. The new Self
Service BI capabilities will empower end users to access, integrate, analyze
and share information using business intelligence tools they already know -
Microsoft® Office.

The Microsoft® SQL Server® 2008 R2 August Community Technology Preview (CTP)
includes Application and Multi-server Management which will help
organizations manage database environments efficiently at scale with
increased visibility and control across the application lifecycle. Also
included is Report Builder 3.0 with support for geospatial visualization
(mapping, routing, custom shapes) which can help produce new insights and
discoveries well beyond what can be achieved with standard tables and charts
when geospatial data is combined with business information. Microsoft® SQL
Server® StreamInsight will also be made available for Community Technology
Preview in the coming weeks. This new complex event processing technology
will help businesses derive better insights by correlating event streams
from multiple sources with near-zero latency.

Don't forget this Monday evening Chris Testa-O'Neill has secured from Microsoft Corp - Ken Jones, Gerry O'Brien and Joseph Sack to talk to us about Understanding SQL Server Certification and Learning Technologies from Microsoft Learning).

This will be a session using the online LiveMeeting application, the URL is https://www.livemeeting.com/cc/mvp/join?id=GCTB28&role=attend.

The session will start at 7pm promptly and finish around 8pm; please be sure to visit the above url about 5-10 minutes before the event starts to make sure you have the applet installed.

Microsoft Learning builds innovative learning products that enable you to make the most of your investment in Microsoft technology. We offer a diverse range of products—including classroom training, e-learning, certification, Microsoft Press books, and more—to serve the needs of customers and partners worldwide.

This one hour webcast will provide information about the certification and learning tracks available on SQL Server 2005 and SQL Server 2008 from Microsoft, direct from the people who work at or partner with Microsoft Learning.

Want to get off with the right start?
To start you of on your experience with Microsoft Learning. There is an opportunity to win one of the following prizes:

Kindly donated by Microsoft Learning
www.microsoft.com/learning

Microsoft Elearning voucher for collection 2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
Microsoft Press Book: Microsoft SQL Server 2008 T-SQL Fundementals
A free exam voucher

Kindly donated by the Remarc Group
www.remarc.co.uk
A choice of a free three day Official Microsoft Learning SQL Server course at one of Remarc's training centres in Leeds or Manchester (travel and accomodation not included)

The speakers include


Gerry O'Brien, Certification Manager for Microsoft, will share information about the certification tracks, including:

• Microsoft Certified Technical Specialist track
• Microsoft Certified IT Professional track.

Ken Jones, working as a Senior Product Manager for Microsoft Learning will explore the books available from Microsoft Press to support your certification requirements

Chris Testa-O'Neill, who is an author for Microsoft E-learning in SQL Server 2008 and a Microsoft Certified Trainer with the Remarc Group in the UK will explore the learning tracks for both classroom and online training using Microsoft Official Curriculum and Microsoft E-learning courses.

Already certified?

Joseph Sack from Microsoft will be providing information about the new Microsoft Certified Masters programme and the Microsoft Certified Architects programme

Many thanks

Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com/
http://sqlblogcasts.com/blogs/tonyrogerson