Presentations and Demos

Row Count Addiction

sheffron — Wed, 15 May 2013 14:51:17 GMT

Speaker: Dandy Taylor

Description: When we start with SQL, we learn the ubiquitous COUNT (*) option, which I like to call a Scan Count. For most of us, it is the method we fall back on whenever we need a quick count. However, there are other ways to get a row count. A couple of years ago, Kendal Van *** (blog|twitter) posted a piece about getting row counts off of the sys.indexes system view. Then last month, Ritesh Shah (blog|twitter) posted how to do a similar count off of the sys.partitions and sys.allocation_units system views. Since both methods use the system views, let’s call these System Counts. For fun, I tested both Scan Counts and System Counts for speed and accuracy, so let’s look at the results.

Excel 2013 PowerPivot in Action From Alberto Ferrari

pwright — Fri, 08 Mar 2013 08:04:45 GMT

Presentation from Alberto Ferrari on Excel 2013 power pivot in action.

2012 Presentation by Jimmy May on columnstore Indexes

pwright — Tue, 19 Feb 2013 03:59:04 GMT

Here is the presentation by Jimmy May on columnstore Indexes for 2012.

Schedule for SLC User Group for 2013

pwright — Tue, 08 Jan 2013 03:16:39 GMT

List of all the dates for the 2013 SLC SQL Users group

Tobe Pittman Deployment Presentation

pwright — Wed, 14 Nov 2012 03:48:33 GMT

Presentation from the November Meeting from Tobe on Deploying Databases

Performance Tuning Slides from Pat Wright Sql Byte presentation

pwright — Mon, 12 Nov 2012 23:19:49 GMT

This is the slide deck from Pat Wright's session on Performance tuning.

Presenting 101

sheffron — Tue, 10 Jul 2012 22:58:48 GMT

Presenter: Pat Wright

We will discuss what you need to know to start presenting. Presenting is a great way to build self confidence, help you to communicate better with your fellow workers/managers. We will discuss all the steps from writing a good abstract to presentation skills. This is a great skill to have.

Starting in SSRS Part #1

sheffron — Thu, 16 Feb 2012 13:58:27 GMT

This is the presentation given by Andrea Allred in the February user group meeting.

March 2011 Topic - Datawarehouse for the DB

sheffron — Wed, 16 Mar 2011 16:44:59 GMT

This presentation was given by Pat Wright and discusses the introduction of data warehousing for the dba at a high level.

SQL Server Denali - Sneak Peak

sheffron — Thu, 16 Dec 2010 00:30:30 GMT

Here is Pat Wright's presentation on SQL Server's new version code named: Denali.

TempDB Performance - August 2010

sheffron — Tue, 10 Aug 2010 06:22:07 GMT

This is the talk given by Pat Wright about TemDB performance. We discussed some of the common issues of Tempdb and what you can do to improve the performance of tempdb. We will also talked about disk performance you can make with SSD drives to give you even more performance from your tempdb and databases.

Exception Handling (Try and Catch) - July 2010

sheffron — Sun, 18 Jul 2010 18:22:57 GMT

The TRY...CATCH statement in Transact-SQL allows you to detect and handle error conditions gracefully within your database applications. This statement is the cornerstone of SQL Server error handling and is an extremely important part of developing robust database applications. TRY..CATCH works by allowing you to specify…

TDE Demo Script - May 2010

benmiller — Tue, 11 May 2010 20:51:28 GMT

TDE Presentation - May 2010

benmiller — Tue, 11 May 2010 20:48:26 GMT

These are the slides for the Presentation. I will also post the TSQL.

SQL CLR - April 2010

sheffron — Fri, 16 Apr 2010 18:34:06 GMT

The presentation focused on CRL (Common Languag Runtime) . This is a technology for hosting Microsoft .NET engine within SQL Server. Included in the zip file are the examples that were presented at the meeting

Speaker: Scott Heffron