Effective Indexing – Niall Flanagan – Belfast, May 15th 2014

This topic will cover the performance benefits and important considerations of good indexing design in SQL Server including

  • Considerations
  • Benefits & Concepts
  • Statistics
  • Table/Index Design
  • Clustered, Non-clustered, & Heap
  • Fragmentation
  • Why cheap hardware is not always the answer

About Niall:
Niall Flanagan is a Team Lead in a Database Services team that manages production Oracle, Sybase and SQL Server databases in a large Irish retail bank. Niall founded the SQL Server Ireland User Group in early 2006 and continues to lead it. In addition, he presents on SQL Server to various user groups and conferences throughout Ireland. Niall is a Microsoft SQL Server Most Valued Professional (MVP) since October 2006.

Venue:
Adelaide Exchange Belfast.

Registration: http://www.mtug.ie/events/event/effective-indexing-belast-sql-user-group/

When: May 15th, 2014 18:00 – 20:30

Getting the most from your SAN – File and Filegroup Layout – with Stephen Archbold

Synopsis: You’ve been given the task of optimising the File and Filegroup layout to get the most from your storage. Not sure where to start, or thinking you could get a more from your storage with a different design?

Are your SAN guys telling you your storage can process 2 GB/s but you’re only seeing 200 MB/s?

This session will dive into how to optimise your file and filegroup layout strategy to get the most from your I/O Subsytem, including a case study where we took a customers table scans from 500 MB/s to 1.2 GB/s with only a change in filegroup layout.

Topics covered include: – Layout for OLTP – Data Warehousing Fast Track Style – Data Warehousing on a SAN – Get data into your SSAS cubes faster (ProcessData) – Hidden options and “go faster” buttons – How to maximise performance in enterprise edition and master read ahead

Bio: Stephen is a SQL Consultant at Prodata Business Systems, with over 6 years experience working with SQL Server as a Production DBA. He has a focus on Performance Tuning and Consolidation to get the most from your investment in SQL Server.

Venue: Microsoft Atrium, Sandyford. Limited parking available accessible from the rear of the building.

Registration:

http://ssiug140107.eventbrite.ie

When January 7th, 2014 18:30 – 20:30

2013 in review

The WordPress.com stats helper monkeys prepared a 2013 annual report for this blog.

Here’s an excerpt:

A New York City subway train holds 1,200 people. This blog was viewed about 5,900 times in 2013. If it were a NYC subway train, it would take about 5 trips to carry that many people.

Click here to see the complete report.

Xmas with AppDynamics, DubJUG, ISDN and Dublin DevOps!

 

Date/Time Date(s) – 12/12/2013 6:00 pm – 9:00 pm

Location TCube

Join AppDynamics’ Pete Holditch, Irish Comedian Colm O’Regan and musician Greg Clifford for the final 2013 event of the Dublin Java User Group and the Irish Software Developers Network, which will see the launch of the Dublin DevOps User Group, and a chance to win a year’s Magnet broadband worth up to €1000*! Read the full post »

Monday, Sept 30 is the last chance for MSDN subscribers to win an Aston Martin

Do you have an MSDN subscription? If so, it includes monthly credit for using Windows Azure. Below is a link for activating the Azure benefit, NO CREDIT CARD required!
Use this link: http://bit.ly/140w35v

By the way, all Gold and Silver Microsoft Partners, all members of BizSpark, all companies that have an EA agreement have multiple free MSDN subscriptions. If you are not using those, this is another incentive to start.

The monthly credit is quite generous, more than enough to run your Dev and Test environments for even large application development projects.

As an added incentive to try out your free MSDN benefits, Microsoft is currently holding a special Aston Martin Sweepstake offer through Sept 30th. The lucky winner will win a 2013 Aston Martin V8 Vantage! (which is why I signed up today)

C Drive Full & guess where SQL Server was installed – Aargh!

It has been a while since I blogged on those “gotchas” that I come across as a SQL Server DBA.

I still acquire already installed & configured SQL Server database systems after an outage brings them to my attention. A more common scenario than desirable is the C Drive filling and impacting the SQL Server installation resident on this same drive. A colleague, James Donnelly, came up with the following script to help move the critical system databases to another drive. This example does assume a default instance rather than a named instance of SQL Server.

1 open command prompt & type the following

NET STOP MSSQLSERVER

2 once complete – start it up again with the /f /T3608
NET START MSSQLSERVER /f /T3608

3 open SQL connection to DB & run the following commands, This will identify where the current location of the mdf & ldf files are located. Open up an Explorer window to this location & verify that the files exist

SELECT name, physical_name AS CurrentLocation, state_desc
FROM sys.master_files

4 Execute the following scripts against the Master db.

— Master DB
ALTER DATABASE master MODIFY FILE( NAME = master , FILENAME = ‘E:\MSSQL\Data\master.mdf’ )
ALTER DATABASE master MODIFY FILE( NAME = mastlog , FILENAME = ‘E:\MSSQL\Log\mastlog.ldf’ )

— Model DB
ALTER DATABASE Model MODIFY FILE( NAME = modeldev , FILENAME = ‘E:\MSSQL\Data\model.mdf’ )
ALTER DATABASE Model MODIFY FILE( NAME = modellog , FILENAME = ‘E:\MSSQL\Log\modellog.ldf’ )

— MSDB DB
ALTER DATABASE MSDB MODIFY FILE( NAME = MSDBData , FILENAME = ‘E:\MSSQL\Data\MSDBData.mdf’ )
ALTER DATABASE MSDB MODIFY FILE( NAME = MSDBLog , FILENAME = ‘E:\MSSQL\Log\MSDBLog.ldf’ )

— TEMPDB
ALTER DATABASE TEMPDB MODIFY FILE( NAME = TempDev , FILENAME = ‘E:\MSSQL\Data\TEMPDB.mdf’ )
ALTER DATABASE TEMPDB MODIFY FILE( NAME = TempLog , FILENAME = ‘E:\MSSQL\Log\TEMPLog.ldf’ )

5 Open CMD prompt & run the following:-
NET STOP MSSQLSERVER

6 Move the following files from the location identified in 3 to the new locations identified in 4

7 Launch SQL Server Configuration Manager (Start-> Programs -> SQL 2012 ->Config Tools -> SQL Server Configuration Manager

Select SQL Server Services & right click on SQL Server (MSSQLSERVER) & select Properties

Select each of the above values for master.mdf & mastlog.ldf files & change them to be the location identified in 4
** Also change the ERRORLOG value to be the MSSQL\Log location.
Select Apply & then OK to close the properties window. Select OK to confirm changes will not take effect until server is restarted.

8 Go to CMD prompt again & type the following command
NET START MSSQLSERVER
** SQL Server should be started now.

9 Execute the following SQL to confirm that all the DB’s have moved
SELECT name, physical_name AS CurrentLocation, state_desc
FROM sys.master_files

New SQL Server Ireland User Group website

The SQL Server Ireland User Group now has it’s own user group blog at http://ssiug.wordpress.com

The first user group meeting details are now published there & I will continue to publish upcoming user group meetings, SQL Server notices, & other related news & events here.

I will continue to blog on other topics, including about SQL Server, here too.

Wayne McCrum talks about Microsoft Premier Support’s Risk Assessment Program

The next SQL Server Ireland User Group meeting is on Microsoft Premier Support’s “Risk Assessment Program” on Tuesday, September 10th, 2013 in the Microsoft Atrium building, in Sandyford.

Wayne will discuss the program and discuss some of the common misconfigurations seen in the field.

When: September 10th, 2013 at 18.30

Where: Microsoft Atrium, Carmanhall Road, Sandyford, Dublin 18. A limited amount of underground parking is available via the rear of the building.

Cost: FREE Community Event

Registration: http://ssiug130903.eventbrite.ie/

Wayne McCrum has been working with SQL Server since 2004 in a variety of SQL orientated roles. He currently works as a SQL Server Field Engineer for Microsoft assisting customers within Western Europe on both proactive and reactive engagements around the SQL Server product.

Ian Meade on Flexible Data Modelling with EAV & other technologies

Ian Meade, from Ergo, will present on “Flexible Data Modelling with EAV & other technologies” in the Auditorium on the Ground Floor of the Microsoft Atrium on Tuesday, August 6th, 2013 at 18:30

The event is free and details can be found at http://www.mtug.ie/UserGroups/sqlserver/Lists/Calendar/DispForm.aspx?ID=7

The MTUG (www.mtug.ie) website has been updated with the details of all forthcoming SQL Server Ireland User Group meetings for 2014.

Sharepoint User Group Ireland – Making SharePoint work for Records Management & Social Features in SharePoint 2013

Making SharePoint work for Records Management.

SharePoint has had record management since version 2007 but has struggled in real world implementations due to design limitations and user unfriendliness . SharePoint 2010 added improvements such as document sets and in-place record management. In this talk Tony Ogilivie will bring real world experience in how to make SharePoint work for Records Management

Presenter: Tony Ogilvie – Automated Intelligence Tony brings many years of experience delivering high value and very successful deployments for a number of global organisations. Prior to joining Automated Intelligence Tony was a senior consultant with Parity and before that Autonomy. Tony is an expert in Microsoft SharePoint and is often engaged by customers and partners alike to design and implement their information architecture.

Social Features in SharePoint 2013.

SharePoint 2013 has added a major set of new features for based around Facebook and Twitter style collaboration. We’ll walk through Microblogging, User Feeds, Communities for both on Premise and Office 365. The usual Live Demo and Presentation mix plus a video clip of Steve Jobs, why? come and find out.

Presenter: Colin Byrne Colin is a SharePoint architect working in Ireland and the Uk. He is currently implementing a SharePoint solution for one of the worlds largest Aircraft Lessors.

Registraton : https://tito.io/tcube/sharepoint-user-group-ireland-june-meetup-2013

Location : TCube, 32-34 Castle Street, Dublin 2

Date & Time : June 20th, 2013 @18:30

Event is free & all are welcome.

%d bloggers like this: