SQL Server User Group–Edinburgh meet up

20 June, 2011 by Leave a Comment

The SQL Server User Group will be meeting at 18:30 (for 19:00) on 29th June at Microsoft’s offices at Waverley Gate.

Agenda

18:30 – 18:50 – Introduction, Networking and Food

18:50 – 19:40 – How to get throughput of over 1GBytes per second for less than 2.5K using commodity kit – Tony Rogerson SQL MVP

In this session Tony will talk about the recent paradigm brought into play through the NoSQL movement for dealing with high performance, high scalability requirements but at a fraction of traditional costs. Tony will demonstrate a box built using commodity kit and will talk about how it may be used to good effect in a Business Intelligence setting. It will be an open discussion.

19:40 – 20:00 – Break

20:00 – 20:50 – SQL Injection Attacks (and how to prevent them) – Colin Angus Mackay

With recent reports of a man convicted of stealing the details of 130million credit cards by use of SQL Injection Attacks, isn’t it time to find out how to defend your systems against them? In this talk Colin Mackay will show you what a SQL Injection Attack is, what they look like, how they work and most importantly how to harden your application and database security in order to defend your systems against them.

Although the technologies used in this talk are SQL Server and the .NET Framework, the general ideas presented apply to any database that uses SQL as a query language, and to any framework that may interact with that database.

Colin Angus Mackay

Colin Angus Mackay is a software developer specialising in Microsoft technologies located in Glasgow, Scotland. A former Microsoft MVP (C#) for four years running, the Treasurer of Scottish Developers, Code Project MVP for five years running, and has co-organised four DDD Scotland events. While not involved in software related pursuits is an amateur photographer (which generally involves wondering why his camera’s autofocus mechanism chooses the potted plant off to the side rather than the main subject).

20:50 – 21:00 – Close

To register for this event visit: http://sqlserverfaq.com/events/262/Scottish-Area-User-Group-Meeting-June.aspx

Filed under Third party events Tagged with , , ,

What’s new in SQL Server 2008 R2 and What’s in your procedure Cache

17 January, 2011 by Leave a Comment

The SQL Server User Group will be running an upcoming event in Edinburgh on 3rd February discussing the new features in SQL Server 2008 R2 and finding out what is in your procedure cache.

 

Agenda

18:00 – 18:30 – Introduction and Networking

18:30 – 19:30 – SQL Server 2008 R2 :: the X factor for DBA’s life – Satya Shyam K Jayanty

By now you know about what’s new in SQL Server 2008 R2, this session we will overview on highlights of  how SQL Server 2008 R2 manageability features can help DBAs day-to-day life with an eX-tra factor.

Satya Shyam K Jayanty Knowledge is the power and you will gain by sharing it;
Solutions Architect and Consultant for database solutions with over 18+ years of experience in Software Engineering and Database applications using industry famous technologies & software, having awarded MVP since the year 2006. Active member, Contributing Editor & Moderator for MSDN and other popular SQL Server related forums, in addition to regular participation as a Speaker & Subject-Matter-Expert in the major events such as Microsoft Tech-Ed, SQLBits, SQLPASS and other European based conferences. Founder & Writer of www.sqlserver-qa.net [knowledge sharing network] and writer for sqlblogcasts.com/blogs/ssqanet/default.aspx site.

19:30 – 19:50 – Break and Food

19:50 – 20:50 – What’s in your procedure cache? – Rob Carrol

Do you know what’s in your procedure cache? This presentation will look at the procedure cache, what is in it, how it is used and what can effect it. It will show you how to use DMVs to determine the cache usage, how programming techniques effect how the cache is used, how plans in the cache can be re-used, and how query plan use can be optimized. It will also investigate the new “optimize for ad hoc workloads” option in SQL Server 2008.

Rob Carrol has been working with SQL Server since 1999, initially as a web developer, but primarily in a DBA and consultancy capacity. He joined Microsoft in 2008 as a SQL Server Premier Field Engineer, working with some of Microsoft’s largest clients in the UK and Europe. Rob lives in South Ayrshire, Scotland and he’s married with 2 daughters. When he’s not working with SQL Server you’ll usually find him playing his Xbox and hiding from his kids!

20:50 – 21:00 – Close

Location:

Microsoft Office at Waverley Gate

http://www.microsoft.com/uk/about/map-edinburgh.mspx

Registration will be necessary as I have to submit registrations to Microsoft on Thursday morning.

 

More information and to sign up here: http://sqlserverfaq.com/events/260/Scottish-Area-User-Group-Meeting-looking-at-SQL-Server-2008-R2-the-X-factor-for-DBAs-life-with-Satya-Shyam-K-Jayanty-and-Whats-in-your-procedure-cache-with-Rob-Carrol.aspx

Filed under Events Tagged with , , , ,

SQL Server UG meeting in Edinburgh

19 November, 2009 by 1 Comment

This just in from the SQL Server User Group:

Hopefully everyone who is coming to SQLBits will have recovered by next Thursday. I’ve decided to run a SQL Nugget competition so you can share any  nuggets you have picked up or know. The best one will get a prize. I’ve also decided to put together some observations gained for the news groups and show they are not just useful for posting when you have a problem.
Here is the full itinerary:

  • SQL Nuggets Competition
  • A look into the Newsgroups – Martin Bell

In this session I’ll look at using the newsgroup as source of information, inspiration and perspiration. How you can learn for the postings in newsgroup and forums, if you want to ask a question, the how, why and what to post and I’ll look at some of the posts and how to set about answering the questions.

Agenda

18:30 – 19:00 – Introduction, Networking and Food
19:00 – 19:50 – SQL Nuggets competition
19:50 – 20:00 – Break
20:00 – 20:50 – A look into the newsgroup – Martin Bell
20:50 – 21:00 – Close

Location

Microsoft Office at Waverley Gate
http://www.microsoft.com/uk/about/map-edinburgh.mspx
Registration will be necessary as I have to submit registrations to Microsoft on Thursday morning.

 

You can register here: http://www.sqlserverfaq.com/events/208/SQL-Server-Nuggets-and-a-look-into-the-Newsgroups.aspx

Filed under Events, Third party events Tagged with ,

Next SQL Server UG Meeting

24 September, 2009 by Leave a Comment

This just in from Martin Bell at the SQL Server User Group:

I’ve just put up the meeting details for an User Group Meeting on the 8th October. Rob is going to be talking about useful tools for performance analysis and showing you how to use them, I’ll be following with an introduction to powershell. Check out here for more details:

http://www.sqlserverfaq.com/events/202/SQL-Server-Performance-Analysis-Tools-and-Powershell.aspx

Don’t forget that the early bird offers for SQLBits will finish on the 30th September. We have a great line up for the Thursday and Friday including a keynote speech by Donald Farmer. Make sure that you vote for the sessions you want to see on the Saturday; session voting will close on the 4th October. There is still a chance to win a free ticket to all 3 days of the conference by entering our Mug Shot competition. For more see www.sqlbits.com

Filed under Third party events Tagged with , , , , ,

Follow

Get every new post delivered to your Inbox.