In this session we will look at some of the practices that you shouldn't follow when developing a SQL Server database. We will cover items such as query design, table design, indexes, constraints and more.
After this session you will have some practices that you know you should avoid in your SQL Server database if you want the best performance. If you have them you will know what you need to do to resolve them.
The target audience is anyone who feels, where reporting is concerned, that they are running on the spot in the Red Queen's Race! Please join me to learn more about the processes involved in designing, displaying and producing reports effectively, using SSRS.
Powershell is a powerful scripting engine that can be used to automate admin tasks making more efficient use of your time. This session will introduce Powershell and how it can be used within a SQL Server environment.
Learn about the most frequently made Analysis Services design mistakes, the problems they cause, and how to fix them or not make them in the first place
SQLDIAG is a great tool that was introduced in SQL Server 2005 to help co-ordinate the collection of perfmon logs and SQLTraces as well as gathering other system data. In this session you’ll learn how to configure, customize and run SQLDIAG as well as the perfstats script from Microsoft which adds locking, blocking and wait stats to the list of collectors that SQLDIAG co-ordinates. This tool is one of the secrets of the trade for efficient data collection and this session is a must for anyone not using it extensively already. Using the output from sqldiag we'll then look at SQLNexus to analyze the results. I'll show you how to configure, run and draw conclusions from the reports created by this tool which is by far the most useful piece of software in the troubleshooting kit bag of people that have taken the time to learn it. This session is based on 2 chapters from Professional SQL Server 2008 Internals and Troubleshooting.
If you want to learn how to make your business systems available then attend this session
Explore the new features of SQL Server 2008 R2 Reporting Services
DAC(Data Tier Applications) a new feature introduced in SQL Server 2008 R2, learn how this new feature can fit into your database deployment lifecycle strategies, monitor the health & performance of your DAC applications using Utility Explorer
Database projects allow offline development and easy deployment of a database. Previously they were only available in team system versions of visual studio, but with the release of visual 2010 they will also be available in the professional version.
This presentation will introduce the key concepts of database projects. It will also show you how to create a database project, import an existing database, modify objects and then deploy it to any sql server.
My Name is Thomas Keyser and I work for Microsoft in the SQLCAT team. I hold the land speed record for data loading in SQL Server so come here my talk on the options you have.
My Name is Thomas Keyser and I work for Microsoft in the SQLCAT team. I hold the land speed record for data loading in SQL Server. This talk focuses on lessons learned when using high end hardware and stressing it.
The heart of this session will be an end-to-end technical demo that will show the role of MDS in extracting master data from source systems, before demonstrating how data is fed via MDS to subscribing downstream systems. Whilst the focus of the session will be on MDS, other parts of the Microsoft BI stack will be shown, in order to demonstrate how a Microsoft MDM solution complements existing parts of SQL Server.
SQL Azure is Microsoft’s new strategy for storing your data in the cloud, but what to do when you exceed the 10/50GB limit. This is where sharding or partitioning comes into play – this session shows you how it can be done in an OLTP system and show you some of the common pitfalls of SQL azure as we have discoverd in analyzing SQL Azure as an alternative to onsite SQL Server instances at different clients.
Consolidation of SQL Server infrastructure has become increasingly popular.
This is true from both a technological and financial perspective, may it be through virtualization, instance concentration or in building SQL Server hotel environments.
This is an in-depth presentation on one of the biggest consolidation projects ever in the Nordic countries based on SQL Server 2008.
This presentation will cover both the business aspects as well as the technical reasons behind this project by two of its top resources.
In one year the customer went from nearly 200 physical machines hosting over 1100 databases to only 20 servers without using any form of virtualization!
You will learn about a comprehensive checklist you can use to verify a SQL Server’s health, which you can use to help you determine if the instance is running optimally and is highly available.
This session will introduce the basic concepts of the new multidimensional calculation language, DAX, and show how to implement several common calculations in it
SQL Modelling Services will provide new ways of developing data driven modelling solution to allow focus on business design, that will be the future centre of application architecture.
Why is NoSQL becoming a real player in the database market? Attend this session and find out.
attend this session to understand exactly how the optimiser decides on its plans
In this session with examples we will continue to cover how to identify inefficiencies in parallel query execution.
Part I was presented during SQLBits VI in London, if you missed it, view the Webcasts @ http://webcast.sqlworkshops.com.
If you’ve only ever chosen to use Microsoft database products then there’s a chance you might hide a curiosity deep down about the Oracle database platform; or like me a few years ago be told that your next big production system will use it and now’s the time to upskill. This session introduces some key concepts and differences about the Oracle database platform to people like myself who are used to the UI-heavy Windows-based database world and hopefully make you curious enough to want to at least give it a try when you get back home.
See how the optimiser chooses the operators it does through real world examples.
A look at the principles of Dashboard and report design design and how to achieve them with SSRS
A number of techniques have been discussed for scaling SQL Server on big-iron systems. Some apply to transaction processing, others to data warehouses. However there is very little available guidance on the impact of each for specific application characteristics. Learn which techniques are absolutely essential and which contribute a only few percent.
A look at the basics of CLR integration with SQL Server, focusing on the nuts and bolts of CLR objects, followed by some practical examples.
PANIC IN THE DATACENTER! Your databases are approaching - or surpassed - the Terrible Terabyte mark. You're pouring money into the SAN, but your data isn't pouring back out as fast as you want. You're terrified to DBCCs or index maintenance because everything takes forever, and you don't have big maintenance windows.
After years of careful observation and recording of the Species SSIS, Genus ETL, in both natural and artificial environments, I’ve gathered a large collection of fieldnotes. Find out the little decisions that get made that can have big impacts on you project later on. What option to choose for better performance, or better management, and what are the trade-offs? This session won’t just focus on holy grail of performance, it will review the way you build and use SSIS taking into account the on going maintenance and management aspects as well.
Look deep under the covers at what is involved when building a StreamInsight application.
A data professionals introduction to spatial data concepts and how they are implemented in SQL Server
The Microsoft SQL Server provides a complete library of programmatically accessed objects for all Business Intelligence relevant services. With this set of functions almost any customer challenge can be solved without the need to purchase additional products. This possibility is often underestimated in projects. The session will explain the hidden power of using the Microsoft APIs to build BI middleware solutions for enterprise customers.
Generalize your skills so you can specialize on SQL Server.
An overview of some everyday TSQL tuning techniques.
An overview of the steps required to get certified with Microsoft Learning
These two technologies can make a very big – and very bad – difference in how your SQL Server performs. Wouldn’t it be great if you could get the real, honest lowdown from a virtualization administrator, a SAN administrator, and a DBA? Wouldn’t it be even better if one person had done all three, and could give you the pros and cons of each point of view? That person is Brent Ozar, a Microsoft Certified Master who’s been there and done that.
Corporate data is expensive to create, expensive to report. Adding free data sources and mapping can lift the simplest of reports to a stunning presentation.