Manchester SQL Server User Group

Manchester (UK) SQL Server User Group

Network, learn, ask a question, meet fellow SQL Server Professionals and have some pizza - these are all things that happen at user group events. These events are a really great opportunity to socialise in an informal learning experience. Remember to tell your friends and the people you work with.

For details of all up and coming meetings and to register for events, please see our Eventbrite page here  https://manssug.eventbrite.co.uk

Follow us on  Twitter manssug or Facebook Manchester User Group

Next Meeting: Wed, Mar 14 2018

Manchester PASS User Group

Register Here : https://manssug-201803.eventbrite.co.uk

17.30 – 18:00 Registration and networking

18:10  19:10- First Session.Performance tips for faster SQL queries – DEV2DEV Emanuele Zanchettin

Abstract

When you need to extract data from the database you are writing, more or less complex, T-SQL code. Often simplistic and procedural approach reflects what you have in your mind, however this could have a negatively impact about performance because the database engine might think otherwise. Fortunately T-SQL, as a declarative language, allows us to ask the "what" and delegate to the engine the "how". Everything works best as long as you respect a few simple rules and you may use special constructs. In this session, with few slides and a lot of real-case scenarios, you can see the advantages of writing the query for high performance, even when they are written by that "someone else" called ORM

Level

200-300


Emanuele Zanchettin, after studying in Computer Engineering, began his career with DB2 in the banking sector in 1998. After a few years and a change of scope of application, he encountered Access and Oracle with which he subsequently worked for several years in data access tuning and database design for new application features. Since 2007 he has also launched into the SQLServer world 2K, 2005, 2008* and 201* and more importantly, since 2011, into Azure SQL Database (SQL Azure). In order to have a greater capacity for assessment and familiarity with the various technologies that the market offers, he has deepened his knowledge to include MySQL and DocumentDB. Today Emanuele is mainly involved in IT projects and database management.


19:10 – 19:30 - Break. Time for pizza.

19:30  20:30 - Second Session. Documenting and exposing your PowerBI & SSAS data model - Steve Powell

Abstract

Documenting and exposing your PowerBI & SSAS data models. It makes life easier for your end users and helps to settle those “what does this number mean” arguments. You can do it manually if you like but I’m way too lazy to do that.

Steve has been working with SQL server for longer than he likes to admit and developing code for longer still. He works as a BI Ninja for a global Law firm, which is way less exciting than it sounds. He spends far too much time wrestling with recalcitrant servers and cursing developers who think documentation is something that happens to other people, but its the only way he can fund his sons ongoing Lego addiction.


20:30 – Feedback and Close and head for drinks down the pub

Attachments

PASSChapterLogo.jpg

sql_micro_sm.gif

 rg-logo.png

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids