June 2010 - Posts

Dave Ballantyne (twitter) is starting a new SQL usergroup in Kent. Having looked on LinkedIn there does appear to be quite a number of people in Kent that are doing SQL so hopefully we can make it a great success.

The first meeting is on the 18th August in Maidstone http://sqlsocialkent20100818.eventbrite.com/ The evening starts at 7:00 which should allow people to get back from work and get to the event.

The agenda is as follows, to register go to  http://sqlsocialkent20100818.eventbrite.com/

7:00 Dave Ballantyne - Meet and greet - Pass Overview

7:15 Neil Hambly – Replication

Neil Hambly an experienced Architect/DBA/Developer who has been using the SQL Server Product family since version 6.5 during the last 12 years. A regular attendee and sometime presenter @ UK SQL Server user groups & events as well as an avid Twitter & Powershell fan, when not out and about can usually be found coding and Performance tuning and generally "Trying to learn" even more useful SQL knowledge.

This presentation on Replication will start with an overview of the various SQL Server replication models:
Snapshot, Transactional, Merge with Peer-Peer added in SQL 2008 release
Following the overview, I will then present in further detail (along with some demos) on the following key topics

Components, Describe the various components and how they interact

Administration,Best practices.

Performance, Replication Agents & Jobs

Troubleshooting {Techniques & Tools}

Tools available to use for monitoring and troubleshooting
Techniques to overcome common problem scenarios

8:15 Nibbles and Drinks

8:30 Allan Mitchell , SQL Server MVP - Complex Event Processing (CEP)
http://sqlis.com/sqlis/

StreamInsight is Microsoft’s first foray into the world of Complex Event Processing (CEP) and Event Stream Processing (ESP).  In this session I want to show an introduction to this technology.  I will show how and why it is useful.  I will get us used to some new terminology but best of all I will show just how easy it is to start building your first CEP/ESP application.

9:30 Q and A - Anything else

If there is one thing I hate its error messages that are not very helpful. This error on the face of it looks fine and nicely helpful (although no indication of what to do about it).

However digging in the situation I got this error resulted in me banging my head against the wall.

I have a windows 2008 domain (all windows server 2008 servers) and I was getting this error trying to make a network connection to a share from a windows 7 desktop.

This error is largely related to windows before 7 and 2008 where there is license restrictions in place for per cal configurations or on XP where there is a limit to the number of connections that can be made.

None of those applied here so what was the problem.

The problem was occurring when using net use with a domain account. So I thought I’d try it with out a domain account and it worked. So this led me to believe it was an authentication issue.

I looked at the domain controller and all seemed fine. There were no active sessions and so nothing there. Then I thought about time.

Time is essential in AD to get authentication working. If the time on your servers is out then authentication won’t work.

So looking at the time on my servers something was wrong. I’d recently rebooted my servers, and for some reason my DC was now showing a difference of 8 hours to what the time should be.

I got the servers in sync and heh presto it worked.

So if you get the error “No more connections can be made to this remote computer at this time because there are already as many connections as the computer can accept” and it doesn’t make sense, check the time on your servers to make sure they are in sync.

Posted by simonsabin | 3 comment(s)

If you work with SQL then a friend of mine would like you to complete a survey on what methodologies, tools and processes you use. She is doing a Phd and this research will play an important part and so if you can spare a few minutes it will be much appreciated it will only take a few minutes

 http://spreadsheets.google.com/viewform?formkey=dGRpMWduTUUteHVhQ3NVUHc4MFhqQ2c6MQ 

Posted by simonsabin | 2 comment(s)

I will be doing a write up of the SQL Master class last week but a tweet reminded me that if you want more of Paul and Kimberly then you can by hoping over to Dublin.

There are running a series of workshops over the next few weeks. These workshops are the business, during the masterclass they had to cover a lot in a short period. For these workshops they will be covering more specific topics in more depth.

So if you liked what you saw last week and want to take your learning to the next level, then make sure you get registered.

Paul has details on his blog http://www.sqlskills.com/BLOGS/PAUL/post/Last-call-for-Ireland-SQL-classes-next-week.aspx

Copied here for ease

  • 4-Day Immersion Event, June 28-July 1 2010: See this site for full details, registration links and options.
  • 2-Day Performance Tuning Masterclass, July 5-6 2010: See the this site for full details, registration links and options.
  • 2-Day Disaster Recovery Masterclass, July 7-8 2010: See the this site for full details, registration links and options.
  • Posted by simonsabin | 3 comment(s)

    I just bought my second set of SSD drives. I bought a set a few years ago but didn’t really use them and I tend to think they degraded over time.

    The new ones I’ve bought are OCZ Vertex 2 240GB versions. http://www.overclockers.co.uk/showproduct.php?prodid=HD-049-OC

    I’ve bought a Startech adapter that allows me to have 4x2.5 inch drives in a 5.25 inch slot, magic. http://www.misco.co.uk/applications/searchtools/item-Details.asp?EdpNo=463175&sourceid=2003

    So I plug them in and stick an stripe across the pair and this is the performance I get.

    image

    Up the block size and

    image

    Yes thats 517 MB/s, random IO Oh my.

    What about writing you say

    image

    And for IO,

    image

    Yes thats 84,000 IOPS from £1000 worth of hardware.

    Clearly this is my first play with these little babies. I will be putting some VMs and some SQL on them to see how that affects things.

    But suffice to say SSD are here to stay and IMHO they are one massive great sticking plaster that many will be able to use to get their poorly performing systems to run faster.

    Posted by simonsabin | 4 comment(s)

    I’ve been trying to use RML to process some files and couldn’t figure out why the numbers where all so much smaller than they should be. I then found a line in the RML output

    “Found [TRACE_STOP] event indicating the end of the trace files”

    This causes RML to stop processing further data, oh.

    In my case I had stopped the trace to add some error events because the client was experiencing errors.

    How do I get RML to process all the other data I wondered. This lead me to the eventclasses in the trace data which I had loaded directly into a table for detailed analysis (RML doesn’t give you exact statements).

    This gave me the following eventclasses 10,12,13,17,33,65527,65528,65533,65534. I can explain the first 5 but not the 655** ones.

    THis one post gave me an idea of what they where and so I did some digging http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/ddb8691a-7a46-4c56-b5e1-ed3407482cce/

    From my analysis this is what they are

    65534 Trace start
    65528 First file in trace sequence, seems to appear after all the existing connections events. A bit like this is the start of the live events.
    65527 Trace Rollover (i.e. a new file has been started
    65533 Trace Stop

    How does that help me well I can remove the Trace Stop and Start events I don’t want load the trace data in profiler and then save back to a file and have RML process it. Very painful but the only option I can think of.

    Posted by simonsabin | 2 comment(s)

    Contrary to many posts and even press releases from Microsoft StreamInsight is not just for Data Center edition. It is available in all paid for editions.

    If you read the license terms http://go.microsoft.com/fwlink/?LinkID=186261&clcid=0x409 you will see you get StreamInsight in all paid editions.

    Whats confusing is the performance/limitations in each edition. The only reference I could find of these limitations is here

    http://blogs.msdn.com/b/streaminsight/archive/2010/02/10/streaminsight-versions-and-sql-server-skus.aspx

    There are two flavours of StreamInsight a Premium and a Standard one. The Premium is for processing events > 5000/s and with a latency of < 5s, with the standard being below that level.

    The confusing thing is that all other documentation only refers to StreamInsight being in Data Centre, Enterprise and Standard. No mention of Web or workgroup which are mentioned in the license.

    If anyone can find any references please do post them here.

    Update Allan Mitchell blogged about this last week http://www.sqlis.com/sqlis/post/StreamInsight-Licensing.aspx pointing to an MSDN page about the difference versions http://msdn.microsoft.com/en-us/library/ff518551(SQL.105).aspx, Interestingly this doesn’t even mention workgroup, go figure.

    Posted by simonsabin | 2 comment(s)

    Thank you for those that attended the SQL Social last night I hope you enjoyed it. When I get presentation details from the team I will pass them on, meanwhile have a look at their blog http://blogs.msdn.com/b/streaminsight/ which has details of most of the things that were discussed last night.

     

    The speakers where

    Azam Husain

    Balan Sethu Raman

    Torsten Grabs

    Roman Schindlauer

     

    Some interesting videos from these guys are here

    http://channel9.msdn.com/learn/courses/SQL2008R2TrainingKit/SQL10R2UPD00/SQL10R2UPD00_REC_04/

    http://www.dotnetrocks.com/default.aspx?showNum=465

     

    I would much appreciate it if you would provide feedback on the evening just follow this link http://www.surveymonkey.com/s/SQLSocial_June_9th_2010

     

    We have two events coming up one in Cambridge on the 15th July and one which is a very social one which is a trip to the Great British Beer Festival on the 5th August.

     

    You can sign up to the events here http://sqlsocial.com/Events.aspx

     

    I look forward to seeing you at a future event.

    Posted by simonsabin | 2 comment(s)

    I’ve been given details of another great off that you can’t miss out on for the Paul Randal and Kimberly Tripp Masterclass next week.

     

    REGISTER TODAY AT www.regonline.co.uk/kimtrippsql on the registration form simply quote discount code: BOGOF and enter your colleague’s details and you will save 100% off a second registration – that’s a 199 GBP saving! This offer is limited, book early to avoid disappointment.

    Posted by simonsabin | with no comments

    Don’t forget that we have the Stream Insight team coming to London and will be presenting at a SQL Social event on the 9th June.

    Stream Insight is one of the exciting new features in SQL Server 2008 R2. There are numerous uses of Stream Insight one being Algorithmic Trading an exciting topic in the banking sector. For details of what Stream Insight is go to the teams blog http://blogs.msdn.com/streaminsight/archive/2010/04/22/rtm.aspx and follow some of the links.

    For more details of the SQL Social event go to the website http://sqlsocial.com/Events.aspx

    Places are limited so please register quick if you want to attend.

    Microsoft will also be announcing a $10,000 competition whilst they are here so make sure you come along especially if you work in banking.

    Make sure you register by going to  http://sqlsocial.com/Events.aspx

    Did I mention free beer and pizza.

    Posted by simonsabin | 2 comment(s)