It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. If your browser does not support JavaScript, click here for a page that doesn't require javascript.

Many of us know what dimensions and fact tables are. But dimensional modelling is more than just dimensions and fact tables. This session is about advanced dimensional modelling topics, which are useful for anybody involved in the design of a DW.

This session will show how to use DMVs (data management views) to query the OLAP cube structure, and then use SSRS to create a set of interactive reports including the BUS matrix, and using spatial data to generate automated star schemas.

This session will be an in-depth look at what the MDS business rules are and how they work, including a series of demos and guidance on how the rules are built. SharePoint Workflow will also be covered, as MDS can initiate a SharePoint workflow.

A new and fresh approach to datwarehousing that is agile, performant and easy to do. Data Vault is a new methodology that tries to overcome traditional problems that plagued traditional datawarehousing in the past.

Using technical demonstrations in Microsoft SQL Server Reporting Services, this presentation will focus on the practical implementation of data visualisation, along with cognitive science principles supporting data visualisations.

We all know how much love DBA's have for Developers and visa versa. You can measure it in milligrams. This fun session discusses the issues we have with one another and presents some solutions to save knives in backs and blood stained carpets.

SQL Server spatial features have not yet made it into mainstream usage and many developers still ask "But *why* would I use them?". In this session, I hope to answer that question by replicating the functionality of Google Maps using only SQL Server.

PowerPivot can be a great troubleshooting / performance tuning tool for a dba besides just loading all the data in a database and start querying. I'll show the pro's and cons of PowerPivot while trying work with waitstats, profiler data etc.

In this session you'll learn how SQL Server chooses parallel operations, how to investigate what's going on when you see the CXPACKET wait type, and whether your parallel query is running as efficiently as it could be.

Mark Souza (General Manager in the SQL Server product team) will spend an hour of presentation and discussion of Microsoft's next generation database platform followed by a discussion on cloud technology.

An introduction to LINQ covering what it is, why people choose to use it, and how you can help your developers when troubleshooting and performance tuning as you previously did through stored procedures.

Planning a failover clustering implementation in a single data center is fairly straightforward, but what happens when you want to span data centers? Come and find out how to plan a multi-site failover cluster.

This session will be presented jointly by Justin Langford and Gavin Payne . The focus of the session is the approach to a cross-team Performance Troubleshooting engagement where multiple stakeholders were involved.

The talk will go back to SQL Server 7.0 when we have introduced “parallel query” in SQL Server for the first time. Lubor will share our initial “parallelism” challenges and how this feature has been developing through the subsequent releases

In this presentation it will be clarified when and why parameter sniffing is a problem in SQL Server stored procedures. Of course we will offer several solutions for this problem and discuss which solution is applicable in which scenario.

In this session Aaron Bertrand and Steve Wright of SQL Sentry, will illustrate how SQL Sentry provides unparalleled insight, awareness and control over the true source of performance issues in SQL Server.

This session is taken from lessons learned in the field on being able to scale data models to handle multi-terabytes of data. Come to this session and understand the difficulties before you encounter them.

This session will compare and contrast the various SQL Server high availability options and discuss the things you need to do - both SQL Server and non-SQL Server - that you need to do to achieve availability.

Are you uncomfortable with the idea of SQL Server Clustering? Do you currently use it and are scared to go near your Clustered Instances and their physical hosts? Stop worrying and learn the "Dark Art" of SQL Server Cluster administration.

Join Quest Software to test your knowledge at our fun lunchtime quiz with SQL Server MVP Kevin Kline, where he’ll be exploring the myths and truths surrounding SQL Server. Come along to test how much you really know and for a chance to win prizes

Building performant data flows takes more than just dragging a few boxes onto a design surface. In this session I'll demonstrate that SSIS perf tuning is less about fine-grained tweaks and more about designing packages correctly in the first place.

This session will cover the "Dark Arts" of SQL Server namely performance tuning. Rather than a traditional look at query tuning it will focus on common misconceptions and a look a why sometimes you get query plans that do "odd" things

About

SQL Bits was started by a group of individuals that are passionate about the SQL Server product suite.
There is a breadth of knowledge in the SQL Community that will benefit everyone in the community.
We want to spread that knowledge.

We all work with the SQL community, some of us for many years. We have a range of skills and experiences from being given the MVP award by Microsoft, organising user groups and speaking at events around the world.