Anatomy of Select

Categories: Presentations
Comments: No Comments
Published on: July 11, 2016

Abstract

 

TSQL is one of the most valuable tools any SQL Server professional can add to their tool-set. More aptly, TSQL is a whole chest of tools for the SQL Server professional. One of the most important tools in that TSQL chest is a good understanding of the SELECT statement.

When was the last time you sat down to evaluate a SELECT statement? What actually goes into the processing of that teeny little word? There might be a fair bit more to this simple term than just fetching data from the database. This session covers the simplicity of the select. Then we take it a step further to dive into some of the complexities tied directly to this particular statement.

This session will help the attendee better understand the Select statement. With a more solid understanding of this statement, the attendee can return and implement some of this new knowledge to help improve processing and query response times in their own environments.

An Introduction to Indexes

Categories: Presentations
Comments: No Comments
Published on: July 11, 2016

Abstract

Among the many critical and basic concepts to understand within SQL Server comes the concept of indexes. Indexes can be a significant asset or a scary detriment to your environment. During this session we will work through the basics of indexing within SQL Server and then explore some of the more interesting misconceptions I have encountered.

Do you know how useful your indexes are? Do you know if your indexes might be a bit piggy? Do you know the impact of the indexes on your execution plans? These are just a few of the many questions that I will cover throughout the session as we move quickly through these important topic.

Profiler vs. Xe Smackdown

Categories: Presentations
Comments: No Comments
Published on: July 11, 2016

Abstract

Extended Events were introduced in SQL Server 2008. With SQL 2014, we have seen a significant upgrade to this feature. Join me for a little adventure into the realm of extended events. Not only will we explore extended events, we will also take a dive into profiler. During this session, we will compare and contrast the two trace utilities and how they can be of potential benefit to the attendee.

This session is largely demo and attendee driven. Attendees should come ready to discuss both extended events and profiler as we will explore the barriers to entry for extended events. Once explored, we will work to resolve those barriers in preparation to reduce the use of profiler.

Download

SQL Server 2016 Just made SQL Server BEEFY-er!

Categories: Presentations
Comments: No Comments
Published on: July 11, 2016

Abstract

SQL Server 2016 has just been released and your manager is pressing hard to hear from you what this could potentially mean for the business. Is there anything useful in this new release? More succinct, is there any feature in the new edition of SQL Server that would drive value to the business or your job to warrant an upgrade?

Many new features have been added. Each new feature could mean a wealth of business value. In this session, I hope to share just a handful of features that could impact your business or possible make your job more interesting again. Among the features I will be discussing are json, query store, live query stats, and RLS. This is an information packed session that will move quickly. Even moving fast, we will fit in some demos for some of these features.

Extended Events – Better than Profiler

Categories: Presentations
Comments: No Comments
Published on: March 23, 2016

Abstract

Extended Events were introduced in SQL Server 2008. With SQL 2014, we have seen a significant upgrade to this feature. Join me for a little adventure into the realm of extended events. We will discuss how to use extended events to aid in performance tuning and in day to day administration. We will also explore some background and the architecture of extended events. This is a fast paced session and will be a lot of fun. Attendees will be able to take back several sample XE sessions to help troubleshoot different issues and get to more intimately know their data/environment.

Download

Bare Naked Skinny on SQL Server

Categories: Presentations
Comments: No Comments
Published on: March 23, 2016

Abstract

Ever feel like there are just too many layers with SQL Server? You peel off a layer and behold there is yet another layer. SQL Server is rather complex. The complexities can be rather frustrating from time to time.

Join this NSFW (not safe for whining) session as we strip SQL down to the bare bones. I will help you undress the complexities of a few of the basic SQL Server concepts. These concepts will include locks, principals, query directives and deadlocks.

In this session I will disrobe misunderstandings related to the aforementioned topics. I will show the different types of principals in SQL Server. I will also show various scenarios involving locks and deadlocks along with some of their effects with and without query directives. The goal is to better understand these topics and to hopefully stop using and perpetuating common mis-uses of terminology and common misconceptions about the technology.

Download

Monitoring SQL Server with Extended Events

Categories: Presentations
Comments: No Comments
Published on: March 23, 2016

Abstract

Every good enterprising DBA has the prime directive of monitoring the SQL Servers under his/her jurisdiction. The last thing a DBA wants to hear is that there is a problem with a database under his/her purview from an end-user.

SQL Server has progressed over time to give better and better information to the DBA.  Much of this information can be used in a home grown solution to monitor SQL Server. With the constant increase in surface area from Extended Events, the power to build a home grown solution becomes more and more feasible while being limited only by the imagination of the enterprising DBA (or developer or data professional). This full day workshop will introduce you to an Extended Events based solution to achieve that home-grown monitoring goal.

This full day session on Extended Events will help prepare you to put this tool to immediate use as you walk back to your daily duties.  This workshop will teach you about Extended Events starting with the basics and moving through how to create XE sessions that will get the right data for you, while doing so with minimal impact.

You will be exposed to advanced troubleshooting techniques as we work through complex issues that are made easier through the use of XE.  Take advantage of this opportunity to dive into the world of Extended Events and learn how you can make best use of this tool in your SQL 2008+ environment.

Download

A Masters Passport to Extended Events

Categories: Presentations
Comments: No Comments
Published on: August 31, 2015

Abstract

As is commonly the case, all good things come to an end.  And now is as good a time as any for the use of SQL Trace and Profiler to come to an end.  Let’s face it, Trace was a good tool and had some wonderful uses.  Profiler for that matter was a good tool and was useful at times.

It is time to let those old tools retire gracefully and move into the world of XE.  This full day workshop will provide you the means to let Profiler and Trace be retired from your toolset as you discover all that XE has to offer.

This full day session on Extended Events will help prepare you to put this tool to immediate use as you walk back to your daily duties.  This workshop will teach you about Extended Events starting with the basics and moving through how to create XE sessions that will get the right data for you, while doing so with minimal impact.

You will be exposed to advanced troubleshooting techniques as we work through complex issues that are made easier through the use of XE.  Take advantage of this opportunity to dive into the world of Extended Events and learn how you can make best use of this tool in your SQL 2008+ environment.

Download

SQL Server Compression and what it can do for You

Categories: Presentations
Tags: No Tags
Comments: No Comments
Published on: May 30, 2015

ABSTRACT

SQL Server 2008 has introduced Table compression to the DBA toolkit. We all know there are different kinds of compression available in SQL Server. What some may not know is the subtleties of compression. Such subtleties include that not all Page Compressed tables are entirely page compressed. This session will show you how to reach into the database and discover compression states at the page level. At the lower level, this session will also show how to determine compression settings of objects in the database. Participants will be able to use undocumented commands as well as commands such as PIVOT to derive some interesting information from the database engine.

Material Download

Extended Events in SQL Server

Categories: Presentations
Comments: 3 Comments
Published on: May 30, 2015

Abstract:

Extended Events were introduced in SQL Server 2008. With SQL 2014, we have seen a significant upgrade to this feature. Join me for a little adventure into the realm of extended events. We will discuss how to use extended events to aid in performance tuning and in day to day administration. We will also explore some background and the architecture of extended events. This is a fast paced session and will be a lot of fun. Attendees will be able to take back several sample XE sessions to help troubleshoot different issues and get to more intimately know their data/environment.

Download

page 1 of 1








Calendar
March 2017
M T W T F S S
« Jan    
 12345
6789101112
13141516171819
20212223242526
2728293031  
Content
SQLHelp

SQLHelp


Welcome , today is Wednesday, March 29, 2017