Lincoln SQL Server User Group

Past Meetings:

 

September 10th, 2015

Ted Henderson's Performance Dashboard presentation

Presentation PDF

 

February 5th, 2015

21 attended Paul Randal's presentation on Performance Tuning Using Wait Stats.

Presentation PDF

Demo Code

 


June 6, 2013

 

Seven attended Jeremiah Peschka's talk titled Reporting in Production: A Hadoop Case Study.


 April 4, 2013


 May 2, 2013


 March 7, 2013

Seven of us attended Todd Kleinhans' presentation SQL 2012 Encryption and You. Another great presentation with some great questions and attendee input. Todd introduced us to encryption and cryptography including column level encryption, TDE, third party tools and Enterprise Key Management (EKM). Todd's slide deck and SQL Scripts are available in the download section.


 

February 7, 2013

Seven of us attended Kendra Little's presentation Index Tuning Tutorial: How to Get Started Fast. Despite me being late with the food (since the cook at Pizza Hut decided to walk out!) and a few technical difficulties to start off the meeting we had a great presentation with some great questions. Kendra introduced us to the sp_BlitzIndex a free script. Watch Kendra's video on this topic.


 

January 3, 2013

Instead of a speaker, we had a Holiday Potluck at John Danley's home. Happy holidays!




December 6, 2012

About 8 of us met at our first meeting at Architecture Hall on UNL's downtown campus. This month we all brought issues from work for an open discussion. We had a great discussion on subjects ranging from configuration and settings to indexing / performance to mirroring and more.




November 1, 2012

Naras Jayachandran joined us to discuss The Top 3 Things a DBA Should Know. This presentation focused on scripting backups, restores and recovery planning.




 

October 6, 2012

There was no October event, but we did host SQL Saturday #165.




 

September 6, 2012

In place of a speaker, we spent the September meeting planning for SQL Saturday #165.




 

August 2, 2012

For our August meeting, Kalen Delaney joined us via Live Meeting to discuss SQL Server internals.




 

July 5, 2012

In July, Bill Fellows joined us to discuss the new language features in SQL Server 2012 and some of the problems they can help you solve.




 

June 7, 2012

This month, Dean Richards from Confio Software was on hand to discuss SQL Server on VMware.  His presentation focused on metrics and monitoring.


 

May 3, 2012

This month, Chris Price with Pragmatic Works allowed our group to select the topic he would present, and after the votes were tallied, the selected topic was "SSIS Moving Beyond the Script Task & Script Component".  About 10 of us were on hand to learn quite a bit about custom .NET components in SSIS.


April 5, 2012

This month, David Klee from House of Bricks gave a deep dive presentation on virtualizing Tier 1 production environments.

About 12 attendees learned an awful lot about virualization, and some even came away with new ideas to put to work right away.


March 1, 2012

This month, Couchbase introduced their Couchbase NoSQL product.

About 12 attendees learned a bit about NoSQL and raised some questions trying to understand how this technology might affect them.


February 2, 2012

This month, John Morehouse will be on hand to talk about how to prevent database fires.

Do you find yourself always putting out "fires"? Can't take the heat in the data center? Then come learn about some things that you can do to help you do "fire prevention" instead of "fire fighting". We will look at several things that you can take back to your shop and implement ranging from code tuning, backup maintenance, monitoring and performance tuning!

About 15 attendees stayed engaged in this interesting discussion that went on for about 2 1/2 hours. The slides and downloads are provided below.


December 1, 2011

Our December meeting was actually a Holiday Potluck held at the home of John Danley.  Around a dozen of us gathered to enjoy good food and company.  A great time was had by all!


November 3, 2011

This month we had another great presentation via Live Meeting.  Kevvie Fowler (of Ringzero, Inc.) demonstrated numerous methodologies for tracking the actions of a hacker after the fact as part of a database forensics investigation.  The Live Meeting presentation talked about the different types and locations of data that provide evidence for a hackers activity, both in the database and at the file system level.  In particular, he discussed a number of system tables that may track information about DML or DDL statements executed in the database, as well as the query cache.  

Kevvie has over 12 years of professional experience securing and leading investigations on Microsoft technologies.  He is the author of SQL Server Forensic Analysis, and is a contributing author of How to Cheat at Securing SQL Server 2005 and The Best Damn Exchange, SQL, and IIS Book Period.  As an expert within the security industry, Kevvie is also a frequent speaker at leading information security conferences such as Black Hat and SecTor.  

You can find more information on this subject at www.applicationforensics.com.  That site has a lot of great information, particularly this section specific to SQL Server.

 


October 6, 2011

For our fifth meeting, Rob Kraft of Kraft Software Solutions, Inc. gave an excellent presentation describing how SQL Injection and Cross Site Scripting (XSS) can be used to hack web pages and databases, and what can be done to prevent these attacks.  He describes Defense in Depth as a strategy to address these kinds of attacks at multiple layers of the application.

Click here to see a PDF of his powerpoint presentation.


August 4, 2011

Our fourth meeting featured the presentation “Powershell Scripting for the DBA” by Ed Wilson the Microsoft Scripting Guy. Ed Wilson is a well-known scripting expert, and writes the daily Hey Scripting Guy! blog. Ed discussed Windows PowerShell best practices as they apply to each stage of the script development lifecycle. He also demonstrated working interactively from the Windows PowerShell prompt, writing an inline script, adding basic function, advanced functions and finally the implementation of Windows PowerShell Modules.
 


July 7, 2011

Our third meeting was once again well attended by 23 attendees. David Brockelsby from 1Staff Training gave his presentation on "Creating and Maintaining a Data Warehouse Using SSIS for SQL Server 2008". David discussed some of the basic concepts of a data warehouse and how SSIS plays into maintaining a data warehouse.



May 5, 2011

Our first meeting was well attended by 24 folks not including myself, Bill Fellows or our sponsors from TEK Consulting. Bill Fellows presented his new topic, "Kama Sutra of SSIS: A guide to loving ETL". In this presentation Bill covered some of the following topics regarding SSIS:

  • Configuration
  • Logging
  • Settings
  • Deployment
  • Performance
  • Common mistakes

You can find Bill's blog here: http://billfellowsblogspot.com/


Steering Committee Meeting

Steering Committee meeting on Wednesday, March 23th, 2011.

We discussed what has happened since the last meeting and discuss where we want to go from here. This includes getting this website started, starting a Twitter account @LincolnSSUG, an email account LincolnSSUG@gmail.com and the continued growth of our LinkedIn group "Lincoln SQL Server User Group".

We have a number of potential speakers and sponsors, but nothing is firmed-up yet. It looks like Embarcadero and Aureus Group may sponsor a meeting. Potential speakers/visitors may include Bill Fellows from K.C., Kevie Fowler may speak on Database Forensics, John Morehouse from the Omaha User Group, Jorge Segarra could do a webinar with us, Chris Shaw and Steve Jones might visit us from Colorado. I've also discussed the possibility of having a speaker provided by Aureus Group speak on the topic of professional development, perhaps later this Fall. When I go to SQLSaturday #63 in Dallas I will do some additional networking to try to locate speakers and sponsors.

The number of folks joining our LinkedIn group continues to grow. We have had an interest from DBAs from Nebraska Book Company, Fiserv, Ameritas, the State of Nebraska, Healthcare Data Solutions and many other locations. Keep spreading the word.

Some ideas for meeting topics included a Panel Discussion between DBAs and Developers, a comparison between SQL Server and Oracle, Reporting Services, and Managing VLDBs.

 

 


June 6, 2013

Seven attended Jeremiah Peschka's talk titled Reporting in Production: A Hadoop Case Study.


 

June 6, 2013

Seven attended Jeremiah Peschka's talk titled Reporting in Production: A Hadoop Case Study.


 

 TitleCategoryModified DateSize Description
PowerShell Best Practices for the DBAPowerShell8/5/20111.14 MBDownloadEd Wilson presents PowerShell Best Practices for the DBA
Kama Sutra of SSISSSIS8/5/201110.53 MBDownloadMay 5, 2011 Meeting slide deck for Bill Fellow's "Kama Sutra of SSIS: A Guide to Loving ETL"
Data Warehouse Using SQL 2008 SSISSSIS8/5/20112.90 KBDownloadDavid Brockelsby's presentation at our July 7th, 2011 meeting.
Rob Kraft - SQL Injection and XSS 10/6/2011568.71 KBDownloadRob Kraft presents an introduction to how SQL Injection and Cross Site Scripting (XSS) can be used to give hackers control of web pages or machines.
Only You Can Prevent Database Fires!Administration2/10/20123.39 MBDownloadJohn Morehouse guides us through ways to help prevent disasters big and small on our SQL Servers
SQL 2012 Encryption and You  3/8/20134.15 MBDownloadTodd Kleinhans slide deck on data encryption.
SQL 2012 Encryption and You scripts 3/8/201310.24 KBDownloadTodd Kleinhans' SQL Scripts used during the presentation
Proactively & Automagically Manage your SQL Footprint 9/9/201365.26 KBDownloadFiles from Mark Marinovic for Proactively & Automagically Managing your SQL Footprint
Paul Randal - Performance Troubleshooting Using Wait Stats PDF 2/8/20153.60 MBDownloadPDF of Paul Randal's presentation, Performance Troubleshooting Using Wait Stats
Paul Randal - Performance Troubleshooting Using Wait Stats Demo Code 2/8/201529.66 KBDownloadDemo Code for Paul Randal's presentation, Performance Troubleshooting Using Wait Stats
Branding Yourself For a Dream JobProfessional Development7/20/20155.74 MBDownloadSteve Jones presents "Branding Yourself For a Dream Job" at our July 2015 meeting.
September 2015 Performance Dashboard Presentation 9/11/20151.33 MBDownloadTed Henderson's Performance Dashboard presentation
Common SQL Server MistakesAdministration2/8/20161.75 MBDownloadTim Radney's Presentation at the February 2016 meeting.
Kimberly Tripp - Stored Procedure Optimization Techniques 4/8/20162.80 MBDownload Kimberly will discuss stored procedure caching and the potential for performance problems due to a problem known as parameter sniffing. There are some common solutions and while they can drastically improve performance, they can also cause other problems
SQL Server Database Administration for the Non-DBAAdministration5/6/20161.67 MBDownloadDenny Cherry's PASS Summit 2015 presentation "SQL Server Database Administration for the Non-DBA"

Lincoln SQL Server User Group

Welcome to the Lincoln, NE chapter of PASS (Professional Association for SQL Server)

 

Follow us:  

Click here to learn more about our group and how to attend meetings.

Sponsors:

 

  

sql_micro_sm.gif 

TEK Systems

 

 

Tegile

 

SkillForge

 

Pluralsight

 


2016 Meeting Sponsors:Pluralsight

 



 

 

 Visit these Publisher websites and you may be able to get free E-Books!

 

 

 

 

 

 

 

 


 

 





 

 





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