Wow its been a busy few weeks in SQLBits land.

Session Voting

We’ve opened up voting for the sessions for SQLBits 10 http://sqlbits.com/information/PublicSessions.aspx Make sure you vote so we pick the sessions you want.

You’ve got to register on the SQLBits site (this is different from the username and password used on the registration site).

Even though we’ve opened up voting we still have submissions coming in, we have hit 257 sessions being submitted, and currently only space for 70 of them. Thats going to be tough.

Registration is open

Registration is open, and we’ve been overwhelmed with over 400 registrations and we haven’t announced the training day speakers. If I was you I’d get in and register for a training day so that when they are announced you can select yours as quick as possible. To ensure attendees get a quality experience we will be limiting numbers for each training day seminar. We are so excited about the lineup for the training days and they should be announced soon.

I can tell you know when you see the lineup it won#t matter which area of SQL Server you use you will want to attend at least one of the training day seminars. We will have more SQL Server product team members giving training days than ever before.

Tell your friends what sessions you like

We’ve updated the site so that you can “Like” sessions and also easily tweet about the session too.

image

When you watch a video make sure you tell your friends you like it.

Posted by simonsabin | 2 comment(s)
Filed under: ,

Have you voted for the DBA in space competition? If not then make sure you do.

I’ve voted for Victoria, not just because she’s one of only two women finalists but also for the sheer balls of playing the trombone in her video.

Whats more Victoria is a true geek and a great DBA supporting a large SQL infrastructure in the UK.

You can see here video here https://dbainspace.com/finalists/victoria-holt

Having sent her name on previous space missions vote for her so this time she can go in person.

https://dbainspace.com/finalists/victoria-holt

Posted by simonsabin | 1 comment(s)

Many people have reported that you can’t install the CTP4 of Juneau/SQLServer Data Tools (SSDT) even though you already have Visual Studio SP1 installed.

The problem is the install for SSDT requires Visual Studio SP1 and if it can’t find it, the setup tells you to install it. But you have it installed so what can you do?

Well the team have found one cause of this problem and have detailed in this blog post

http://blogs.msdn.com/b/ssdt/archive/2011/11/30/ctp4-installation-issue-with-vs2010-service-pack-1.aspx

For your ease I’ve copied the supported resolution here

“Since the release of SSDT CTP4, we have become aware of an installation issue dealing with Visual Studio 2010 Service Pack 1. We are working on a fix, but below is temporary workaround that can be employed to successfully install SSDT CTP4.

Symptom: When attempting to install SSDT, you will receive an error, stating the following, “You have to upgrade your Visual Studio 2010 to SP1 before installing SQL Server Data Tools,” even when you have previously taken steps to install SP1.

We have identified the primary scenario in which this error is wrongfully encountered:

1. Install VS2010 Professional or above from the install media

2. Install full VS2010 SP1

3. Install SQL Server 2012 setup, including Management Tools

4. Attempt to install SSDT CTP4

Installation of SSDT CTP4 in step 4 of this sequence should be successful, as VS2010 SP1 is applied when SQL Server Management Tools are installed. However, due to an issue in the application of SP1, you will indeed be blocked from installing CTP4.

The suggested workaround for this scenario is to reinstall VS2010 SP1 from http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=23691. Manually reapplying this pack will perform the necessary actions to repair this problem. After reinstalling SP1, you will then be able to successfully install SSDT CTP4.”

There is an unsupported solution but I will let you go to the blog post (http://blogs.msdn.com/b/ssdt/archive/2011/11/30/ctp4-installation-issue-with-vs2010-service-pack-1.aspx) to get those details.

I am looking for 2 SQL Contractors to join my data team to help build our database platform.

The role is for a SQL generalist. The person will be doing TSQL, SSIS, SSRS and maybe some SSAS.

Experience of agile development processes would be great.

This is a great opportunity to work in a great team.

If you are interested them please let me know.

http://sqlblogcasts.com/blogs/simons/contact.aspx

Posted by simonsabin | 1 comment(s)
Filed under: ,

If you are looking for SQL Server training they there is no better place to start than a new company Technitrain Its been setup by a fellow MVP and SQLBits Organiser Chris Webb.

Why this company rather than any others?

Training based on real world experience by the best in the business.

The key to Technitrain’s model is not to cram the shelves high with courses and get some average Joe trainers to deliver them. Technitrain bring in world renowned experts in their fields to deliver courses written by the experts themselves based on their experience.

This means the course are focused on what you need to know, not just every feature in SQL Server.

If you’ve got questions then these trainers will definitely know the answer, and if they don’t they will definitely know someone that will and more often than not thats someone on the SQL Server team itself.

So if you are considering training now or in the future then make sure you keep an eye on Technitrain and the courses it is offering.

At the moment they have 4 courses available.

Christian Bolton - Advanced Internals and Troubleshooting Workshop for SQL Server

Jeremy Kashel - Introduction to Master Data Services

Andy Leonard  - From Zero to SSIS

Chris Webb - Introduction To MDX

Chris Webb - Real World Cube Design and Performance Tuning with Analysis Services

Web Edition will have all the features of web edition in 2008 R2 and the following features which are new for 2012

· Windows Server, Server Core Support

· Database Recovery Advisor

Posted by simonsabin | 1 comment(s)
Filed under: ,

I just found this on a hosted SQL server I use. The query was trying to enable service broker and was just waiting for an exclusive database lock which it wasn’t getting.

So it was sitting there for 58 days.

 

image

Do you have a query thats been running for longer ?

Posted by simonsabin | 2 comment(s)
Filed under:

The demos, presentations and all code from my Advanced Reporting Services precon are now available here

http://sqlblogcasts.com/files/folders/reporting_services_presentations_and_demos/entry15915.aspx

Enjoy

Posted by simonsabin | 1 comment(s)

This is what I like to see. I hope that means no problems with internet today.

image

Posted by simonsabin | with no comments

if you are looking to work with Analysis Services then you need to learn MDX and there is no better person to learn it from than Chris Webb

Chris is a Microsoft MVP and a leading expert on MDX. He is the co-author of two books, "MDX Solutions" (second edition) and "Expert Cube Development with SQL Server Analysis Services 2008", and blogs about Microsoft BI topics at http://cwebbbi.wordpress.com/

Chris is doing an introduction to MDX course Wednesday, 26 October 2011 to Friday, 28 October 2011

To register for the Introduction to MDX course or get more details click here

 

Day 1

  • What is MDX and why should I use it?
  • Understanding the structure of a cube: recognizing cubes, measure groups, dimensions and hierarchies
  • Understanding the concepts of members, tuples and sets
  • Writing simple queries: using SQL Management studio to write SELECT statements
  • Creating simple calculated members: when to use query, session and cube-scoped calculations, using simple MDX expressions and functions

Day 2

  • Standard Calculations: looking at the best ways to implement common calculations, such as time series, market shares and rankings
  • Using set functions: using common MDX functions such as Crossjoin, Filter, Order, Generate to create more complex queries
  • Advanced concepts: autoexists, solve order and subselects

Day 3

  • MDX Script Assignments: making scoped assignments, understanding how assignments affect aggregation, using assignments with calculated members
  • MDX for Reporting Services
  • Performance Tuning and Troubleshooting: using Profiler, building aggregations, functions to avoid

Cost £749 + VAT

More Posts « Previous page - Next page »