North Texas SQL Servers Users Group

Meeting Archive

2012

Date: Wednesday, December 12, 2012 5PM - 7PM

Topic:

NTSSUG Holiday Party and Networking Event

Location:  Microsoft Campus in Las Colinas Bldg: LC1. For more info click here
Details:

Please plan to join us on the Microsoft Campus as we celebrate an amazing year of learning.

We will get access to the Microsoft Company Store to buy software at Microsoft Employee prices!

From what I hear you will be able to buy Windows 8 and Halo 4 as well. There will be a limit of how much you can buy and we will provide those details when you arrive.

Registration for this event is required.  Registration closes on 12/7/2012 at 4pm, so be sure to register as soon as possible. 

http://ntssugholidayevent.eventbrite.com/

There is a small caveat - We cannot provide store access to any government employees.  So to verify this, during the  registration, you will be required to provide your employer information.

Date: Thursday, November 15, 2012 6:00pm

Topic:

Multi-Threading SSIS to Optimize File Processing

Taking advantage of the ability to spin up parallel SSIS threads according to file workloads can greatly enhance an organizations ability to process large amounts of data as quickly as possible. I will demonstrate a solution comprised of a C# service, SQL Format Files, T-SQL Merge, Table Partitioning, SSIS, and SQLCLR that monitored a nightly FTP file drop folder and inserted records into a queue table (one record per file) to support dynamic SSIS spin-up and processing into the database.
Location:  Microsoft Campus in Las Colinas Bldg: LC1. For more info click here
Speaker:
Sal De Loera
 
I started my career in IT nearly 10 years ago and have remained influenced and driven by two particular technology initiatives - Business Intelligence and Data Warehousing. Opportunities for partnership, learning, and innovation will continue to present themselves as we strive to meld people, business, and technology. I look forward to these opportunities as I am fulfilled by my membership to a scientific community that is driven by the development and execution of technology solutions that enhance the way we live and conduct business.
Download: TBD
Meeting Sponsor: This meeting is sponsored by Insource Group. We want to thank them for their continued support!
Date: Thursday, October 18, 2012 6:00pm

Topic:

Mouth Wide Shut: Coherent Interviewing

"Interviews are so easy," says absolutely nobody. In fact, interviewing for your next DBA or SQL developer job is a very tricky process, with many common pitfalls. In this fun and interactive session, we'll give you all the best advice you've never heard about pre-interview preparation, typical traps, and the new professionalism. You will start to refine the way you present yourself, tailor your answers appropriately, and learn about our revolutionary negotiating tactics. Most importantly, we'll quantify the most difficult aspect of interviews: knowing when to keep silent.
Location:  Microsoft Campus in Las Colinas Bldg: LC1. For more info click here
Speaker:
Sean McCown is a Certified Master in SQL Server 2008. He is also a SQL Server MVP with 17yrs experience in databases. Sean is also founder and co-owner of the renowned website MidnightDBA.com where he records free SQL Server training videos and co-hosts the popular webshow, DBAs@Midnight.
 
Jen McCown is a Microsoft SQL Server MVP, developer, and DBA. She is Senior Editor at MidnightDBA.com, where she creates training videos, the DBAs at Midnight webshow, blogs, reviews, and podcasts.
Download: TBD
Meeting Sponsor: This meeting is sponsored by Insource Group. We want to thank them for their continued support!
Date: Thursday, September 20, 2012 6:00pm

Topic:

Performance Tuning for Pirates!

If you follow baseball you will notice that our speakers favorite team the Pittsburgh Pirates has to do more with less to be successful. Working as a consultant, I have also noticed this trend with several IT shops. If you need to improve the performance of your SQL Server instances and cannot purchase 3rdparty tools this session is for you. I will help improve your performance tuning process while using several free tools. Through this presentation we will go over wait stats, dynamic management objects, perfmon, PAL, SQL Trace, ClearTrace, SQL Nexus and SQLDiag.
Location:  Microsoft Campus in Las Colinas Bldg: LC1. For more info click here
Speaker:
John Sterrett is a senior database administrator at Remote DBA Experts. John has been active within the SQL Server community, including hosting the first and second SQL Saturday in West Virginia. John also presented a spotlight session at the first SQL Rally, PASS Member Summit in 2011,and a lightning talk and chalk-talk at the SQL Server 2010 Member Summit, presented sessions at SQL Saturday’s, and presented to the Pittsburgh SQL Server User Group. John is one of the co-founders for the WVPASS User Group. John is a syndicated blogger at SQLServerPedia and contributes tips at MSSQLTIPS. You can find his blog at www.johnsterrett.com
Download: TBD
Meeting Sponsor: This meeting is sponsored by Idera. We want to thank them for their continued support!
Date: Thursday, August 16, 2012 6:00pm

Topic:

Have you got the Urge to Merge?

The T-Sql Merge statement, introduced in SQL 2008, is powerful, versatile, and performant. However, it is also one of T-SQL's least understood statements. Most DBAs know they can use It to insert, update, and delete data in a target table in a single transaction, generally outperforming separate statements. Fewer know, however, that it can be used to load slowly changing dimensions, facilitate auditing, and for many other uses. Come to the user group meeting and learn the in and outs of T-SQL Merge. I'll even show you how to write complex Merge statements with lightning speed.
Location:  Microsoft Campus in Las Colinas Bldg: LC1. For more info click here
Speaker:
David Stein is a Senior Business Intelligence Consultant with WaveTwo in Irving, TX. He’s worked in SQL Server Business Intelligence for almost a decade, designed Data Warehouses from scratch, as well as saved projects in serious jeopardy. He is also very active in the community, having spoken at PASS events at all levels, including the PASS Summit, SQL Rally, and at numerous SQL Saturday events and user groups. You can learn more about Data Warehousing, Business Intelligence, and other technical topics on his blog at Made2Mentor.com or follow him on Twitter, @Made2Mentor.
Download: TBD
Meeting Sponsor: This meeting is sponsored by the Insource Group. We want to thank them for their continued support!
Date: Thursday, July 19, 2012 6:00pm

Topic:

Failover Clustering Troubleshooting Tips and Best Practices Part 2

OK! So you built your “Top of the World” SQL Server Failover Cluster. But it keeps failing and your application High Availability is in jeopardy, now what?? This session is going to cover some of the important best practices that you need to follow before, during and after installing SQL Server in a Failover Cluster environment along with why they are important so you can build a highly Available cluster solution with no single points of failure. We are also going to cover some of the common issues and troubleshooting scenarios with SQL Server Failover Clustering, so you are armed and ready if/when you DO have cluster failures.
Location:  Microsoft Campus in Las Colinas Bldg: LC1. For more info click here
Speaker:
Kal Yella has 12+ years of experience in the SQL Server field as a DBA, Consultant for various financial and consulting organizations. In his current position as a Dedicated Support Engineer for the Premier Field Engineering team at Microsoft, Kal supports a major Health Care customer in maintaining and improving their large SQL Server environment. Kal holds several SQL Server certifications including MCITP, MCT (Microsoft Certified Trainer) and the esteemed MCM (Microsoft Certified Master).
Download: TBD
Meeting Sponsor: This meeting is sponsored by the NTSSUG annual sponsors Insource Group and Idera. We want to thank them for their continued support!
Date: Thursday, June 21, 2012 6:00pm

Topic:

Failover Clustering Troubleshooting Tips and Best Practices Part 1

OK! So you built your “Top of the World” SQL Server Failover Cluster. But it keeps failing and your application High Availability is in jeopardy, now what?? This session is going to cover some of the important best practices that you need to follow before, during and after installing SQL Server in a Failover Cluster environment along with why they are important so you can build a highly Available cluster solution with no single points of failure. We are also going to cover some of the common issues and troubleshooting scenarios with SQL Server Failover Clustering, so you are armed and ready if/when you DO have cluster failures.
Location:  Microsoft Campus in Las Colinas Bldg: LC1. For more info click here
Speaker:
Kal Yella has 12+ years of experience in the SQL Server field as a DBA, Consultant for various financial and consulting organizations. In his current position as a Dedicated Support Engineer for the Premier Field Engineering team at Microsoft, Kal supports a major Health Care customer in maintaining and improving their large SQL Server environment. Kal holds several SQL Server certifications including MCITP, MCT (Microsoft Certified Trainer) and the esteemed MCM (Microsoft Certified Master).
Download: TBD
Meeting Sponsor: This meeting is sponsored by the NTSSUG annual sponsors Insource Group and Idera. We want to thank them for their continued support!
Date: Wednesday, May 9, 2012 5:00pm - 10:00pm

Topic:

Meet the SQL Professionals

Meet and network with the SQL Server pros in town getting ready for SQLRally. This is also a great opportunity to welcome all the SQLRally speakers. Come over, introduce yourself, and get to know the speakers, their sessions, and why you should attend them. RSVP to reserve your spot!
Location:  Wxyz Bar in Aloft Hotel 1033 Young St. Dallas, TX 75202. Click here to RSVP 
Speaker:
All SQLRally speakers will be at this event and you get direct access to build personal relationships with them. That's the type of value you can't put a price on, especially considering that everyone is invited whether they attend the SQLRally or not.
Download: Direct download via osmosis from industry experts to your brain!
Meeting Sponsor: This meeting is sponsored by the NTSSUG annual sponsors Insource Group and Idera. We want to thank them for their continued support!
Date: Thursday, April 19, 2012 6:00pm

Topic:

Troubleshooting Performance on SQL Server 2012 with Extended Events

Have you heard of Extended Events (XEvents)? Has it been hard for you to figure out how to take advantage of that to get a handle on your performance issues on SQL Server? SQL Server 2012 has the answer for you! This talk will start by looking at the new XEvents introduced in SQL Server 2012. We will also have a look at the new XEProfiler tool that you can use to configure and view results from XEvents. After that, we will dive into some scenarios showing how to use XEvents to troubleshoot some common performance problems on SQL Server.
Location:  Microsoft Campus in Las Colinas Bldg: LC1. For more info click here
Speaker:
Rohit Nayak is a Support Escalation Engineer based at the Microsoft Customer Service and Support site in Irving, Texas and has worked with the SQL group since 2008.His primary focus area is troubleshooting performance issues on SQL Server.
Download: TBD
Meeting Sponsor: This month's meeting is being sponsored by Maxsys Solutions. We want to thank them for their support by buying the food and drink for this meeting.
Date: Thursday, March 22, 2012 6:00pm

Topic:

The New Tabular Power in SQL Server 2012

This session will show the synergy between PowerPivot 2012 for Excel, SSAS in Tabular mode and Power View. Topics will include new architecture, advanced usage tips and a demonstration integrating predictive analytics with self-service BI.
Location:  Microsoft Campus in Las Colinas Bldg: LC1. For more info click here
Speaker:
Drew Minkin is Director of Analytic Solutions, Partners and Platforms at Predixion Software. He is a frequent speaker at local SQL Server events and a former member of Microsoft's SQL Server Escalation and Premier Field Engineer groups.
Download: TBD
Meeting Sponsor: This month's meeting is being sponsored by GTN Technical Staffing. We want to thank them for their support by buying the food and drink for this meeting.
Date: Thursday, February 16, 2012 6:00pm

Topic:

What are the largest SQL Server projects in the world?

This presentation showcases the largest custom SQL Server projects in the world. It is divided into three sections, Data Warehouse projects, OLTP Projects and how these projects scale. This session demonstrates how SQL Server scalability is not a contention point anymore, defines various solutions and techniques for scaling SQL Server and how SQL Server can be adopted for large applications.
Location:  Microsoft Campus in Las Colinas Bldg: LC1. For more info click here
Speaker:
Kalyan Yella has 12+ years of experience in the SQL Server field as a DBA, Consultant for various financial and consulting organizations. In his current position as a Dedicated Support Engineer for the Premier Field Engineering team at Microsoft, Kal supports a major Health Care customer in maintaining and improving their large SQL Server environment. Kal holds several SQL Server certifications including MCITP, MCT (Microsoft Certified Trainer) and the esteemed MCM (Microsoft Certified Master).
Download: TBD
Meeting Sponsor: This month's meeting is being sponsored by NTSSUG.
Date: Thursday, January 19, 2012 6:00pm

Topic:

AlwaysOn - Finally, A usable 'mirror'!

In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are great, but the mirror/secondary database is not very usable since it is not online. Finally, AlwaysOn solves this limitation by merging both multi-node Clustering and mirroring. AlwaysOn also allows the secondary database to remain ONLINE, so we can use it for reporting purposes without resorting to a Snapshot! Come see this lively session with extensive demos of setting up, configuring and testing AlwaysOn. We'll also test automatic fail-over using a real web app to see how well that feature works.
Location:  Microsoft Campus in Las Colinas Bldg: LC1. For more info click here
Speaker:
Jim Murphy has been using Microsoft SQL Server since version 6.0 back in the 90's. He is the President/CEO of SQLWatchmen, LLC., a managed DBA service provider for smaller companies who do not need a full-time DBA. He runs the Austin SQL Server User Group: CACTUSS Central and sits on the board of POSSE. He has been a professional DBA and developer for over 20 years and has run a consulting company full-time for over 10 years.
Download: TBD
Meeting Sponsor: This month's meeting is being sponsored by The Insource Group. We want to thank them for their support by buying the food and drink for this meeting.

2011

Date: Thursday, November 17, 2011 6:00pm

Topic:

eXtreme XML eXtraction: eXamining XML in SSIS

XML is all over the place. But how do you get that data into SQL Server? SSIS provides an XML Source, but it is not easy to use. In this session we will handle increasingly complex XML documents. After an introduction to using the XML Source with a single set of elements, we will look at how to work with multiple element sets. This includes hierarchically structured XML documents.
Then we will work through some puzzling problems with XML including documents with multiple namespaces, deeply hierarchical XML documents and the problem of getting information from the root node. We will adjust the XML Schema as well as develop simple XSLT transformations to scrub the XML to handle these issues. 
Location:  Microsoft Campus in Las Colinas Bldg: LC1. For more info click here
Speaker:
Russ Loski is an independent software developer and trainer based in Dallas, TX. He has worked with SQL Server since 6.5 and also develops .Net applications. He has worked with clients such as the Dallas Cowboys, T-Mobile and Coca Cola Enterprises. Currently he is working for Bank of America. He especially likes to work with ETL products such as SSIS.
Download: TBD
Meeting Sponsor: This month's meeting is being sponsored by RedGate Software. They will be sponsoring the food and drink for the meeting. Thanks to RedGate for their support!
Date: Thursday, October 20, 2011 6:00pm

Topic:

An Introduction to NoSQL

NoSQL technologies are growing in popularity, challenging the role long maintained by traditional relational database management systems (RDBMSs) in data-centric applications. Through this presentation, you will be introduced to some of the different classes of NoSQL database technologies, explore how they are used to address challenges difficult to address in RDBMSs, and consider what these technologies imply for data management infrastructures in corporate IT environments. 
Location:  Microsoft Campus in Las Colinas Bldg: LC1. For more info click here
Speaker:
Bryan Smith is a Database Technology Specialist with Microsoft in Dallas, TX. Prior to his current role, Bryan served as a consultant and trainer with Hitachi Consulting, assisting a variety of customers in designing, implementing, and supporting database and Business Intelligence solutions.
Download: SLIDES
Meeting Sponsor: This month's meeting is being sponsored by RedGate Software. They will be sponsoring the food and drink for the meeting. Thanks to RedGate for their support!
Date: Wednesday, September 14, 2011 6:00pm

Topic:

What's New in SSIS in Denali

In this session, you’ll go through a whirlwind tour of what’s new in SSIS for you as a developer and administrator. You'll first learn about the new designer experience and the death of configuration files in Denali. You'll then learn how to deploy and administer packages in Denali. This release is going to be huge and you will not want to miss this session about the differences. 
Location:  Microsoft Campus in Las Colinas Bldg: LC1. For more info click here
Speaker:
Brian Knight, SQL Server MVP, MCSE, MCDBA, is the co-founder of SQLServerCentral.com, BIDN.com and SQLShare.com. He works as President and lead architect for Pragmatic Works and has written thirteen books on SQL Server over his fifteen year database career.
Download: TBD
Meeting Sponsor: This month's meeting is being sponsored by Pragmatic Works. They will be sponsoring the food and drink for the meeting. Thanks to Pragmatic Works for their support!
Date: Thursday, August 18, 2011 6:00pm

Topic:

Data Access and Connectivity Troubleshooting

Any client application trying to access data against SQL Server would involve Data Access Connectivity Technologies that come with SQL Server, the .NET Framework or the Operating System. In this talk, we will discuss issues that we typically encounter when connecting to SQL Server and how to troubleshoot them, we will look at configuration items, such as Kerberos and how it can impact authentication, as well as connectivity in general.
 
Location:  Microsoft Campus in Las Colinas Bldg: LC1. For more info click here
Speaker:
Meer Alam is a Sr. Support Escalation Engineer for Microsoft
Download: SLIDES
Meeting Sponsor: This month's meeting is being sponsored by Equity Staffing. They will be sponsoring the food and drink for the meeting.  Thanks to Equity Staffing for their support!
Date: Thursday, July 21, 2011 6:00pm

Topic:

Manage your shop with CMS and Policy Based Management

In this presentation we talk about Central Management Server and how it can help you manage a disperse environment. We will also cover what Policy Based Management is and how you can leverage its power to better manage your environment. With PBM we'll see what it can and cannot do to help you enforce standards in your enterprise. We will cover and demonstrate PBM for the beginner from creating and evaluating policies to receiving alerts on policy violations.
 
Location:  Microsoft Campus in Las Colinas Bldg: LC1. For more info click here
Speaker:
Ryan is a SQL DBA and has worked for a Fortune 100 company for 13 years. He is the sole SQL Server DBA for his organization, supporting both vendor databases and custom databases. His primary focus is database design and performance, but also works with SSRS report development, and SSIS ETL. He serves on the board of directors for the North Texas SQL Server User Group and holds the following certifications: MCP MCSA MCSE MCDBA - SQL 2000 MCTS - SQL 2005 MCITP - SQL 2005.
Download: SLIDES
Meeting Sponsor: This month's meeting is being sponsored by The InSource Group. They will be sponsoring the food and drink for the meeting.  Thanks to The InSource Group for their support!
Date: Thursday, June 16, 2011 6:00pm

Topic:

Building Secure Database Applications with MS SQL Server

As recent breaches and disruptions have demonstrated, application security could not be more critical. As the foundation of many of our applications and the stores of our most sensitive data, databases are a prime target. Still, very few developers take advantage of security features available to them to secure the databases behind their applications. Join Bryan Smith, a Database Technical Specialist with Microsoft, in exploring security features and best practices applicable to Microsoft SQL Server which will allow you to secure your database applications.
 
Objectives:
  • Explore best practices for securing Microsoft SQL Server databases
  • Review in-depth several security techniques application developers can take advantage of to protect their data
Location:  Microsoft Campus in Las Colinas Bldg: LC1. For more info click here
Speaker:
Bryan Smith is a Database Technology Specialist with Microsoft in Dallas, TX. Prior to his current role, Bryan served as a consultant and trainer with Hitachi Consulting, assisting a variety of customers in designing, implementing, and supporting database and Business Intelligence solutions.
Download: SLIDES
Meeting Sponsor: This month's meeting is being sponsored by The InSource Group. They will be sponsoring the food and drink for the meeting.  Thanks to The InSource Group for their support!
Date: Thursday, May 19, 2011 6:00pm

Topic:

Inside SQL Server Wait Types

Have you ever encountered a wait type with SQL Server but can't find any information on what it means? Perhaps you have thought the meaning of these is hidden away somewhere in a dark closet? In this talk, we will explore the internals of wait types within the SQL Server Engine. Rather than cover some of the more common wait types such as lock and latches, we will explore the more advanced and obscure wait types that may be surfaced by the engine. The ones you can't find much information about.
 
In this talk, we will cover (but not limited to) the following topics:
•Internal algorithms of wait types in the engine
•Exploring some of the more advanced wait types in the engine
•PREEMPTIVE wait types in SQL Server 2008
•What are some of the wait types that you can safely ignore and why?
•Learning to use Extended Events to debug wait types
•How to interpret information about wait types in SQL Server DMVs and metadata
 
This talk is a very advanced 500 level session that may include the use of advanced diagnostics such the Windows debugger and discussion of Windows APIs. I will assume the audience has a basic working knowledge of the SQL Server engine including an understanding of some of the more common SQL Server Engine DMVs such as sys.dm_exec_sessions, sys.dm_exec_requests and sys.dm_os_wait_stats.
Location:  Microsoft Campus in Las Colinas Bldg: LC1. For more info click here
Speaker:
Bob Ward is a Principal Architect Escalation Engineer in Microsoft Customer Service and Support (CSS) based in the Microsoft Regional Support Center in Irving, Texas. He has worked with Microsoft since 1993 and has now supported every release of Microsoft SQL Server from 1.1 for OS/2 to SQL Server 2008. Bob has been presenting topics on SQL Server at PASS Summits since 2003 both in the United States and Europe. His background in the computer industry spans 24 years and includes database development projects with companies like General Dynamics, Harris Hospital, and American Airlines. Bob graduated with a bachelor's degree in computer science from Baylor University in 1986. Bob has co-authored the book SQL Server 2005 Practical Troubleshooting: The Database Engine including chapters on advanced data recovery and troubleshooting critical errors. He now authors and directs one of the most popular blog sites for SQL Server advanced users at http://blogs.msdn.com/psssql
Download:

SLIDE DECK

CODE

Meeting Sponsor: This month's meeting is being sponsored by Accelebrate who offers SQL Server Training. They will be sponsoring the food and drink for the meeting.  Thanks to Accelebrate for their support!
Date: Thursday, April 21, 2011 6:00pm

Topic:

T-SQL Techniques to Survive Zombie Databases

Do you have a Zombie Database? Does your database suffer from roaming hordes of problems like the lack of primary and foreign keys, poor normalization, in place updates and deletes, and an insatiable drive to eat your braaaaaaaaaaaaaains (CPU cycles).

 

Fear not fellow survivor for in this session, I’ll show you how to fortify your code against zombie infestation. How to deal with the unknown (nulls), how to Restore Order by Joining together in Groups. Flak Jackets are Optional, but encouraged.

Location:  Microsoft Campus in Las Colinas Bldg: LC1. For more info click here
Speaker:
David Stein aka Made2Mentor is a SQL Server Business Intelligence DBA specializing in designing, developing, and maintaining Data Warehouses using Microsoft BI Tools. He is also considered the world’s foremost expert in a SQL Database ERP Product that few have ever heard of.
 
You can visit David on his blog at Made2Mentor.com
Meeting Sponsor: This month's meeting is being sponsored by Accelebrate who offers SQL Server Training. They will be sponsoring the food and drink for the meeting.  Thanks to Accelebrate for their support!
Date: Thursday, March 17, 2011 6:00pm

Topic:

Essential Database Maintenance

In this session, Paul and Kimberly will run you through their top-ten database maintenance recommendations, with a lot of tips and tricks along the way. These are distilled from more than 30 years combined experience working with SQL Server customers and are geared towards making your databases more performant, more available, and more easily managed (to save you time!). Everything in this session will be practical and applicable to a wide variety of databases. Topics covered and myths debunked include: backups, shrinks, fragmentation, statistics, and much more! Focus will be on 2005/2008 but we'll explain some of the key differences for 2000 as well.

Location:  Microsoft Campus in Las Colinas Bldg: LC1. For more info click here
Speaker:
SQLskills.com is owned and run by the husband and wife team of Paul S. Randal and Kimberly L. Tripp, both world-renowned SQL Server experts. Together they have almost 35 years combined experience working with all sizes of SQL Server databases, in organizations as diverse as Fortune-100 companies to small, single-database businesses. Together they teach the storage internals, performance tuning, database design, database maintenance, and disaster recovery sections of Microsoft's most advanced course - Microsoft Certified Master - SQL Server.
Download: Video can be found HERE.
Meeting Sponsor: This month's meeting is being sponsored by Neverfail. They will be sponsoring the food and drink for the meeting.  Thanks to Neverfail for their support!
Date: Thursday, February 17, 2011 6:00pm

Topic:

Simplifying StreamInsight

After a very brief introduction and demo of Microsoft SQL 2008 R2's Complex Event Processing, this topic will focus on the places where database administrators will need to provide guidance for developers.

Location:  Microsoft Campus in Las Colinas Bldg: LC1. For more info click here
Speaker:
Drew Minkin has been a speaker at the MS Business Intelligence Community, North Texas SQL Server User's Group and SQL Saturday events in the Dallas Metroplex for four years. He worked at Microsoft in SQL Support and in Premier Field Engineering for over six years. After leaving Microsoft, Drew has designed and supported cubes for dozens of Fortune 1000 companies. he has design data mining models on pricing optimization, fraud detection, customer retention and marketing campaigns.
Meeting Sponsor: This month's meeting is being sponsored by Beacon Hill Staffing. They will be sponsoring the food and drink for the meeting.  Thanks to Beacon Hill for their support!
Date: Thursday, January 20, 2011 6:00pm

Topic:

Waits and Queues and YOU! 

Many database professional have little to no understanding about how to use wait events as part of an overall performance tuning process. And yet wait events are the secret sauce that many leading experts have been using for years. Attend this talk and you will gain an understanding of the SQLOS execution model, an understanding of how to use DMVs to find out what your queries are waiting for, and why using wait events could be the best thing to happen for your career as a DBA.

Location:  Microsoft Campus in Las Colinas Bldg: LC1. For more info click here
Speaker:
Thomas LaRock is a seasoned IT professional with over a decade of technical and management experience. Currently serving as a Senior DBA for Confio Software, Thomas has progressed through several roles in his career including programmer, analyst, and DBA. Thomas holds a MS degree in Mathematics from Washington State University and is a member of the Usability Professional’s Association. Thomas currently serves on the Board of Directors for the Professional Association for SQL Server (PASS), and is also a SQL Server MVP. Thomas can also be found blogging at http://thomaslarock.com and is the author of DBA Survivor: Become a Rock Star DBA (http://dbasurvivor.com).
Meeting Sponsor: This month's meeting is being sponsored by Confio Software. They will be sponsoring the food and drink for the meeting.  Thanks to Confio for their support!

 

2010

Date: Thursday, November 18, 2010 6:00pm

Topic:

Introduction to PowerPivot 

In this session, you’ll learn how to use PowerPivot to create self-service analytics in your organization. You’ll see how Office 2010 and SQL Server 2008 R2 will help your users answer their own questions and bring together datasets that may be heterogeneous like a SQL Server table and data feed from a website. Then, you’ll see how to take that data and create a striking report for your end users and collaborate with the data in SharePoint.

Location:  Microsoft Campus in Las Colinas Bldg: LC1. For more info click here
Speaker:
Brian Knight, SQL Server MVP, MCITP, MCSE, MCDBA, is the owner and founder of Pragmatic Works. He is also the co-founder of SQLServerCentral.com and JumpstartTV.com. He runs the local SQL Server users group in Jacksonville (JSSUG). Brian is a contributing columnist at several technical magazines and does regular webcasts at Jumpstart TV. He is the author of a dozen SQL Server books. Brian has spoken at conferences like PASS, SQL Connections and TechEd and many Code Camps. His blog can be found at http://www.bidn.com.
Meeting Sponsor: This month's meeting is being sponsored by Pragmatic Works.  They will be sponsoring the food and drink for the meeting.  Thanks to Pragmatic Works for their support!
Date: Thursday, October 21, 2010 6PM

Topic:

Mirroring: The Bear Necessities

Mirroring can be an integral part of your high availability and disaster recovery planning. We’ll cover what mirroring is, how it can fit into an HA/DR plan, the rules surrounding its use, configuration via the GUI and T-SQL, as well as how to monitor mirroring. This presentation is designed to not only give you an overview of mirroring, but to also walk you through a basic implementation. At the end you will have learned what mirroring is, how it can fit into your environment, what business requirements it solves, and how to configure it.

Location:  Microsoft Campus in Las Colinas Bldg: LC1. For more info click here
Speaker:
Ryan Adams is a highly skilled Microsoft oriented administrator and has worked for a Fortune 100 company for 12 years. In his time there he has supported everything from desktop to server. Most recently he has served as a senior Active Directory Architect and Identity Management (MIIS, ILM, FIM) Consultant. He is the sole SQL Server DBA for his group, supporting both vendor databases and custom databases. His primary focus is database design and performance, but also works with SSRS report development, and SSIS ETL. He enjoys being involved in the SQL community and serves on the board of directors for the North Texas SQL Server User Group. He is well versed in many core Microsoft technologies, has implemented and supported them both nationally and internationally for a company of 250k+ users, and holds the following certifications:

MCP MCSA MCSE MCDBA - SQL 2000 MCTS - SQL 2005 MCITP - SQL 2005
Download: Slide deck and demo code can be found HERE.
Meeting Sponsor: This month's meeting is being sponsored by Maxsys Solutions.  They will be sponsoring the food and drink for the meeting.  Thanks to Maxsys Solutions for their support!
Date: Thursday, September 16, 2010

Topic:

T-SQL Brush-Up: The Best Things You Forgot You Knew

You're a good database professional—you attend conferences and webinars, you read articles and books, you know your way around SQL Server. But sometimes, just sometimes, some piece of T-SQL slips by you unnoticed or falls out of memory. Come and revisit old favorites and brush up on new T-SQL features and enhancements such as MERGE, OVER, and PARTITION BY. This session is chock-full of code examples, including before-and-after demos and how-to illustrations.

Location:  Microsoft Campus in Las Colinas Bldg: LC1. For more info click here
Speaker:
Jen McCown is a 10-year SQL Server developer and DBA, currently serving as the lead DBA at a state trade association in Texas. She is co-author and co-owner of MidnightDBA.com, where she creates training videos, the DBAs at Midnight webshow, blogs, reviews, and podcasts. She also writes for Petri IT Knowledgebase and is a forum moderator. Jen is a member, volunteer, and speaker in NTSSUG, PASS, and the PASS Women in Technology virtual chapter. She presented at SQLSaturday #41 in Atlanta and SQLSaturday #35 in Dallas and is on staff at the SQL University. She is scheduled to present at PASS Summit 2010 in November.
Meeting Sponsor: This month's meeting is being sponsored by GTN Technical Staff.  They will be sponsoring the food and drink for the meeting.  Thanks to GTN for their support!
Date: Thursday, August 19, 2010

Topic:

Tuna Helper - Proven Process for Tuning SQL

Many DBAs and Developers are faced with tuning poorly performing SQL statements.  However, many tuning projects fail because the process being used is inefficient. This presentation will walk through a process Confio Software uses with great success and will include topics such as: SQL diagramming, wait time data, indexing strategies, column selectivity and several more that will help the you succeed on future tuning projects.

Location:  Microsoft Campus in Las Colinas Bldg: LC1. For more info click here
Speaker:
Janis Griffin has over 20 years of DBA experience including design, development and implementation of many critical database applications. Before coming to Confio, Janis held DBA positions primarily in the Telecom Industry (15 yrs), working with both real-time network routing databases and OLTP business to business applications.
Janis was also a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning. She was responsible for managing all aspects of the Voice Network databases including short and long-term technical planning and strategic alliances. As a highly successful liaison between management and technical staff, Janis has proven to be an effective collaborator implementing cutting-edge database solutions.
Meeting Sponsor: This month's meeting is being sponsored by Confio.  They will be sponsoring the food and drink for the meeting.  Thanks to Confio for their support!
Date: Thursday, July 15, 2010

Topic:

Microsoft Entity Framework 4.0 for DBAs

While most enterprise applications are object-oriented, the data upon which they depend is not. Often, binding these two platforms together can result in significant amounts of lost productivity and a less than optimal solution.  To resolve these shortcomings, Microsoft has created the ADO.NET Entity Framework and is now strongly recommending that development teams implement it in their applications. As a DBA, you’ll need to understand how the Entity Framework works and how it affects your role as a DBA.

 

In this session, we’ll…

 

·         Explore the Entity Framework 4.0, its related components and show how it all works

·         Demonstrate the various ways to build a business object model (Entity Data Model) and map it to an underlying database

·         Walk through a variety of examples of how to interact with the model, including LINQ, Entity SQL and Stored Procedures

·         Show how the Entity Framework can generate select, insert, update and delete SQL statements on the fly

·         Explore the Entity Framework’s impact on permissions, connections, transactions, performance, security and concurrency

 

You’ll walk-away with a clear understanding of how the Entity Framework 4.0 works, why developers and architects want to implement it and how it affects your role as a DBA. 

Location:  Microsoft Campus in Las Colinas Bldg: LC1. For more info click here
Speaker:

Rob Vettor is a C# MVP, INETA Regional Speaker and Microsoft .NET Architect/Technical for Jack Henry and Associates, a large financial services software company. Rob has built systems for a number of corporations, including Avanade, Raytheon and American Express. Rob lives in Dallas, TX, with his wife, twin sons, three dogs and rooms full of NET computer books. You can contact Rob at robvettor@hotmail.com, and check out Rob’s blog at www.robvettor.com.

 

 

Meeting Sponsor: This month's meeting is being sponsored by GNET.  They will be sponsoring the food and drink for the meeting.  Thanks to GNET for their support!
Date: Thursday, May 20, 2010

Topic:

How to Analyze Performance Monitor Data Using PAL

Analyzing Performance Monitor data is not always an easy task. It often involves viewing Performance Monitor logs in graph view, seeing what has been happening, and hoping that your knowledge and background in SQL Server and the Windows OS provides you with enough information to help you to be able to pinpoint specific performance-related issues.
 
One way to make this job easier is by using a free tool called "Performance Analysis of Logs," or "PAL", for short. It was developed by Clint Huffman of Microsoft, and can be downloaded free from Codeplex at www.codeplex.com/PAL. In brief, the tool takes a Performance Monitor log file (.blg), analyzes it, and provides you with an HTML report that presents a graphical analysis of the data, including alerts for those counters that exceed a specified threshold. The thresholds for the counters are based on those recommended by various Microsoft product teams.
 
In this session, you will learn how to use this tool, including how to customize it for your specific needs. You will also learn how to analyze the output so you can better understand what performance problems your SQL Server instances may be having.
 
This session is filled with demonstrations, and assumes attendees have a basic foundation of DBA knowledge, and a solid understanding of how to use Performance Monitor. After attending the session, attendees will be able to return to work and immediately put what they have learned into practice.

Location:  Microsoft Campus in Las Colinas Bldg: LC1. For more info click here
Speaker:

Brad McGehee

Meeting Sponsor: This month's meeting is being sponsored by Red Gate Software.  They will be supplying door prizes to be given away at the end of the presentation, in addition to sponsoring the food and drink for the meeting.  Thanks to Red Gate for their support!
Date: Thursday, April 15, 2010

Topic:

T-SQL Code Sins

Learn the best of what NOT to do when writing Transact-SQL. Comment, format, and streamline your way to a happy and virtuous coding life!

Location:  Microsoft Campus in Las Colinas Bldg: LC1. For more info click here
Speaker:

Jen McCown

Meeting Sponsor: This month's meeting is being sponsored by Insource Group.  They will be in attendance and have some door prizes to give away in addition to sponsoring the food and drink for the meeting.  Thanks to Insource for their support!
Video: Watch the video from this meeting
Date: Thursday, March 18, 2010

Topic:

Data Mining for SQL Developers

This session will introduce SQL Developers to how SQL Server Analysis Services (SSAS)'s Data Mining algorithms can enhance your applications.  Topics covered will include basics of data mining theories and practices, data life cycle managment, building a data mining structure and model, and choosing an algorithm.

Location:  Microsoft Campus in Las Colinas Bldg: LC1. For more info click here
Speaker:

Drew Minkin

Drew Minkin has been working with Microsoft SQL since 1997.  He worked at Microsoft in the SQL Product's CSS group and as a SQL Advisory Support Consultant from 2000-2006.  He has been a Senior SQL Consultant for Fujitsu, a Technical Lead for the startup Zilliant and a Business Intelligence Architect for a leading retail banking software company.

Meeting Sponsor: This month's meeting is being sponsored by Odyssey Information Services.  They will be in attendance and have some door prizes to give away in addition to sponsoring the food and drink for the meeting.  Thanks to Odyssey for their support!
Video: Watch the video from this meeting
Date: Thursday, January 21, 2010

Topic:

Dynamic SQL: Using Expressions and Configurations

In this session, we'll review the use of expressions and configurations that can help make your SSIS packages more dynamic and flexible. We'll cover the basics of the SSIS expression language and will demonstrate some practical uses, and will discuss using package configurations to abstract hard-coded package settings into external resources for maximum flexibility.

Location:  Microsoft Campus in Las Colinas Bldg: LC1. For more info click here
Speaker:

Tim Mitchell

Tim Mitchell is a Microsoft SQL Server consultant, developer, speaker, and trainer.  He has been working with SQL Server for over 7 years, working primarily in database development, business intelligence, ETL/SSIS, and reporting.  He has earned a number of industry certifications and holds a Bachelor's Degree in Computer Science from Texas A&M at Commerce, and is a Microsoft SQL Server MVP.  Tim is a Business Intelligence Consultant for Artis Consulting, a Microsoft Gold Certified Partner in the Dallas area.

As an active member of the community, Tim has spoken at venues including SQL Saturday and the PASS Business Intelligence SIG, is a board member and speaker at the North Texas SQL Server User Group in Dallas, and is a volunteer for PASS.  Tim is an author and forum contributor on SQLServerCentral.com and has published dozens of SQL Server training videos on SQLShare.com.  You can find his full profile and blog at www.TimMitchell.net.

Meeting Sponsor: This month's meeting is being sponsored by Matrix Resources. They will be in attendance and have some door prizes to give away in addition to sponsoring the food and drink for the meeting.  Thanks to Matrix for their support!

 

2009

Date: Thursday, November 19th, 2009
Topic: SQL Server Failover Clustering
Overview:

This session covers Planning, Implementing, Testing and Administration of SQL Server Failover Clustering while mainly focusing on SQL Server 2008. This session also includes a step-by-step demo of implementing a SQL Server 2008 failover cluster.

Speaker:

Kalyan Yella (Kal)

Kal has 10+ years of experience in the SQL Server field as a DBA, Consultant for various financial and consulting organizations. In his current position as a Senior Consultant for the Operations Consulting team at Microsoft, Kal helps several Enterprise level customers with various SQL Server focused operational reviews including Performance & Scalability, High Availability, Disaster Recovery, Consolidation and Migration reviews. Kal holds several SQL Server certifications including MCITP, MCT (Microsoft Certified Trainer) and the esteemed MCM (Microsoft Certified Master).

Sponsor:

Date: Thursday, October 15th, 2009
Topic: Leveraging PSSDiag/SQLDiag for Efficient Troubleshooting
Overview:

Over the years, Microsoft Customer Service and Support has developed a number of amazing tools for troubleshooting SQL Server. Thankfully many of these tools have been shared with the public. In this session I will demonstrate the configuration and usage of PSSDiag (for SQL Server 2000) and SQLDiag (for SQL Server 2005 and 2008), which collect valuable diagnostic data. We will then analyze the data using RML Utilities as well as a few scripts of my own. Come and see how these tools can save you massive amounts of troubleshooting time!

Speaker:

Trevor Barkhouse

Trevor is a DBA on the Database Escalations and Implementation team for Terremark Worldwide, Inc. He is also a volunteer on the board of NTSSUG and maintains the group's web site.

Date: Thursday, September 17th, 2009
Topic: Bad SQL - Why Does This "Perfectly Good" T-SQL Run So Slow?  
Overview:

Most tools in the SQL world exist to tell you what is running slow. Once you have found the offending T-SQL code, then what? This presentation will show you why particular code runs slow or doesn't do exactly what you think it does.

Speaker:

Geoff Hiten

Microsoft MVP Geoff Hiten is a Principal SQL Server consultant for Intellinet. Geoff began working with SQL Server in 1992 with version 4.2 and has used every version since. He specializes in high-availability and high-performance SQL systems. Recent projects include: system upgrades, SQL Server platform migrations, performance tuning, custom reporting solutions, virtualization, and database strategy implementations. Geoff is currently on the leadership team of the Atlanta area Microsoft Database Forum Users group (AtlantaMDF) and can be found lurking in the halls at PASS (Professional Association for SQL Server) Community Summit events. In addition, Geoff has been a Subject Matter Expert for Microsoft Training Curriculum materials and has authored articles, white papers and podcasts on SQL Server.

Sponsor:

Red Gate Software makes ingeniously simple tools for over 500,000 Microsoft technology professionals working with SQL Server, .NET, and Exchange. The company's product line includes tools for comparing, synchronizing, backing up and recovering SQL Server databases; understanding and fixing .NET code problems; and email archiving for Exchange. Red-Gate.com.

Date: Thursday, August 20th, 2009
Topic: Introduction to SQL Server Analysis Services 
Overview:

Ever want to implement drag-and-drop reporting in your application and stop the rampant report queue. In this session you'll have a gentle introduction to SQL Server Analysis Services. You'll see how to use it to give your users their own ad-hoc reporting and have better than expected performance results.

  • The Benefits of SSAS
  • What are Dimensions and Hierarchies
  • User Interfaces for Developers
  • Cube Design and Measures
  • Including UBO and MDX in SSAS
Speaker:

Brian Knight

Brian Knight, SQL Server MVP, MCSE, MCDBA, is the co-founder of SQLServerCentral.com and JumpstartTV.com. He runs the local SQL Server users group in Jacksonville (JSSUG) and was on the Board of Directors of the Professional Association for SQL Server (PASS). Brian is a contributing columnist for SQL Server Standard and also maintains a regular column for the database website SQLServerCentral.com and does regular webcasts at Jumpstart TV. He has co-authored and authored more than 9 SQL Server books including Admin911: SQL Server (Osborne/McGraw-Hill Publishing), Professional SQL Server DTS, Expert SSIS, Professional SQL Server 2005 Administration and Professional SQL Server 2005 SSIS (Wrox Press). Brian has spoken at conferences like PASS, SQL Connections and TechEd and many Code Camps.

Sponsor:

Date: Thursday, July 16th, 2009
Topic: [Anti]Patterns and [Mal]Practices: Learning to do Things Right by Evaluating How Others Have Done Them Wrong
Overview:

Time and again you hear people talk about how you should implement software using established patterns and best practices. Online forums, books, and conferences about .NET and SQL Server are filled with advice about how to do things correctly. But rarely do people focus on the other side of the equation: What are the potential pitfalls that exist, and how will you know when you've fallen into them? Software developers need to know more than just what they should do; knowing what not to do is half the battle. In this session you will learn how to make your SQL server prone to SQL Injection, how to use SQLCLR for all data access, how to use cursors instead of DML, exploit the Tumbling Data pattern, and so on. Come and learn what not to do -- and how to fix it -- from the masters of [anti]patterns and [mal]practices!

Speaker:

Peter DeBetta

Peter DeBetta is a SQL Server MVP and an independent consultant, author, and architect specializing in design, development, implementation, and deployment of Microsoft SQL Server, Microsoft SharePoint Server, and .NET solutions. Peter blogs at SQLblog.com (cofounder), and writes courseware, articles, and books - most notably the title Introducing SQL Server 2008 from Microsoft Press. Peter speaks at conferences around the world, including TechEd, SQL PASS Community Summit, DevTeach, SQL Connections, DevWeek, and VSLive!

Sponsor:

Date: Thursday, June 18th, 2009
Topic: Scripting in SSIS 
Overview:

SQL Server Integration Services includes a variety of tools to help you move and transform data many different ways. However, there are some situations that require more flexibility and customization than you'll find in the native SSIS controls. In this presentation, we'll take a look at the Script Task and Script Component in SSIS and will explore some ways these tools can be used to perform highly customized ETL operations.

Speaker:

Tim Mitchell

Tim Mitchell is a Microsoft SQL Server database developer/analyst, writer, and speaker. He has been working professionally with SQL Server for over six years, mostly in the areas of database development, scripting, ETL, and business intelligence.

Sponsor:

Date: Thursday, May 21st, 2009
Topic 1: Developing a Unified Dimensional Model (UDM) with Analysis Services 
Overview:

Analysis Service's OLAP component allows organizations to implement a Unified Dimensional Model (UDM) that is designed for rapid ad hoc information retrieval of their data. The UDM, as a single version of the truth, can be enriched to encapsulate business rules and calculations, and advanced Business Intelligence features including KPIs and actions.

For organizations that have a Standard or Enterprise SQL Server license, Analysis Services is a possible zero-cost opportunity for your organization today. In the session learn how to exploit the capabilities and features, and the basics of best practice design. Be prepared for numerous compelling demonstrations and to leave the session energized by the potential!

This session is targeted at IT professionals with an interest in data analysis, and equally for non-IT professionals interested to understand and evaluate Microsoft's BI strategy and platforms. Apart from a general understanding of relational database technologies, there is no requirement to have any background or experience with OLAP technology.

Speaker:

Peter Myers

Peter Myers has 12 years of solid experience working in OLTP database design and development, DBA support and Data Warehousing/Business Intelligence with SQL Server. He has a broad business background supported by a bachelor degree in applied economics, and he extends this with MCITP, MCSD, MCDBA, MCSE and MCT certifications. Currently, he provides mentoring and technical training internationally, and focuses on delivering training for the SQL Server database engine, Integration Services (DTS), Analysis Services, Reporting Services, ASP.NET and .NET programming (C# and VB.NET).

Since 2005, Peter has authored and presented courses and events for Microsoft internationally. He enjoys sharing his enthusiasm for Microsoft technologies by presenting at SQL Server launch events, user group meetings and technical events, including TechEd. In April 2009, Peter was re-awarded Microsoft MVP (Most Valuable Professional) for the third time.

Topic 2: Resource Governor for SQL Server 2008 
Overview:

In this presentation, Steve will provide an overview of Resource Governor, a new feature in SQL Server 2008 that will give DBAs and system administrators much more granular control over how CPU and memory are used by SQL Server. He'll discuss the components that make up Resource Governor, then walk through examples of how to set it up along with various usage scenarios. The basis of this presentation comes from work performed by SQL Server MVP, Aaron Bertrand.

Speaker:

Steve Wright

Steve is the Director of Product Support at SQL Sentry, which is located in the suburbs of Charlotte, North Carolina. He is a critical member of the development team behind the award winning SQL Sentry Event Manager and Performance Advisor. Steve holds MCSD, MCDBA, OCDBA 8i, and IT Project+ certifications. Prior to joining SQL Sentry in 2005, Steve developed and presented web based training courses for Wachovia Bank. Previous experience includes education positions at Techskills and Charlotte Mecklenburg Schools.

Sponsor:

In addition to our typical door prizes, SQL Sentry will also be providing a full license of SQL Sentry Performance Advisor (a $1,495 value) as a door prize for the meeting!

Date: Thursday, April 16th, 2009
Topic: Deadlocks: Detection, Troubleshooting, and Prevention 
Overview:

As an enterprise application grows and load increases, some concurrency issues are bound to surface. Deadlocks are one of the more aggravating of this class of problems. Fortunately, each release of SQL Server includes better tools for troubleshooting deadlocks.

Trevor will demonstrate approaches for handling deadlocks in SQL Server 2000, 2005, and 2008.

Speaker:

Trevor Barkhouse

Trevor is a DBA on the Database Escalations and Implementation team for Terremark Worldwide, Inc. He is also a volunteer on the board of NTSSUG and maintains the group's web site.

Date: Thursday, March 19th, 2009
Topic: Security Stuff in SQL Server
Overview:

This presentaton will focus on security related topics for SQL Server 2005 and 2008 including encryption, execute as, module signing, and other security-related topics.

Speaker:

Peter DeBetta

Peter DeBetta is a SQL Server MVP and an independent consultant, author, and architect specializing in design, development, implementation, and deployment of Microsoft SQL Server, Microsoft SharePoint Server, and .NET solutions. Peter blogs at SQLblog.com (cofounder), and writes courseware, articles, and books - most notably the title Introducing SQL Server 2008 from Microsoft Press. Peter speaks at conferences around the world, including TechEd, SQL PASS Community Summit, DevTeach, SQL Connections, DevWeek, and VSLive!

Sponsor:

Date: Thursday, February 19th, 2009
Topic: Refactoring T-SQL Code for Better Performance
Overview:

Sometimes index tuning isn't enough and you must resort to rewriting a stored procedure to improve its performance. When doing so, it is crucial to maintain the overall functionality of the routine so that calling applications don't break. I will be presenting a methodology and a set of tools that I use to ensure that the new implementation behaves identically to the original, but performs better.

Speaker:

Trevor Barkhouse

Trevor is a DBA on the Database Escalations and Implementation team for Terremark Worldwide, Inc. He is also a volunteer on the board of NTSSUG and maintains the group's web site.

Sponsor:

Date: Thursday, January 15th, 2009
Topic: PowerShell for DBAs: Class One
Overview:

This class will start with an intro to PS for those who know absolutely nothing and need the complete basics. Then it'll move to DB management and the many facets of DBA work.

There are so many things you can do with PS in the DB that you really owe it to yourself to learn how to use it.

Speaker:

Sean McCown

Sean McCown has been managing high-end transactional databases since 1995, and with terabyte databases since before they were common. His expertise is tuning databases for sub-second query performance. He has worked with IBM DB2, Microsoft SQL Server, Oracle Database, Sybase ASE, and many others including TeraData, MySQL, Ingres, and PostgreSQL. Sean has been a contributing editor to the InfoWorld Test Center since 2003, and he's written for many other publications including SSWUG.org, SQLServerCentral.com, SQL Server Magazine, and SQL Server Standard Magazine.

Sponsor:

2008

Topic: PowerShell for Database Developers and Administrators  
Date: Thursday, October 16th, 2008
Overview:

PowerShell is the new .NET-based interactive shell and scripting environment designed to assist in server management tasks. This presentation is packed with demos to cover PowerShell basic concepts, cmdlets and providers, architecture, in-depth look at SQL Server data access and management using SQL Server provider and snap-ins, error handling, PowerShell SDK, and tips and tricks. Come experience the power of PowerShell!

Speaker:

Darshan Singh

Darshan Singh is Sr. Software Engineer with Intuit, Inc. located in Plano, TX. He has co-authored several books on XML, .NET, and SQL Server.

Sponsor:

Topic: Wait-Time Based SQL Server Performance Management
Date: Thursday, September 18th, 2008
Overview:

Using Wait Time Analysis and Wait Types is a newer method for tuning SQL Server instances. As a result, there is often confusion on exactly what the data means. The issue typically centers around the fact the wait time data is analyzed at the wrong level or the collected wait time data is not detailed enough. This presentation will focus on these problems and review several real-life case studies of using SQL Server Wait Type data coupled with Wait-Time based performance analysis to solve the most difficult performance related issues.

Speaker:

Dean Richards

Dean Richards has over 20 years of Oracle and SQL Server project development, implementation and strategic database architecting. Before coming to Confio, Dean held engineering positions at McDonnell Douglas and Daugherty Systems, an object-oriented solution provider for Anheuser-Busch. Dean was also a technical director for Oracle Corporation managing all aspects of their broadband account including short and long-term technical planning and strategic alliances. As a highly successful liaison between management and technical staff, Dean has proven to be an effective collaborator implementing cutting-edge solutions.

Sponsor:

Topic: SQL Server Reporting Services for DBA's 
Date: Thursday, August 21st, 2008
Overview:

SQL Server Reporting Services has long been thought of as a tool specifically for Business Intelligence. While analysts and developers are typically the ones viewing and building reports, the system typically has to be installed, configured, and managed by DBA's. This presentation will discuss the basics of implementing and administering SQL Server Reporting Services as well as how Reporting Services can be used by the DBA's to assist with their own reporting tasks. The full lifecycle of Reporting Services will be discussed, from installation, administration, and report design.

Speaker:

Jason Hall

Jason Hall is a solutions architect for Quest Software, specializing in the architecture and implementation of disaster recovery and high availability solutions. Jason has also done extensive work in the field specializing in performance monitoring and tuning. In addition to on-site customer facing work, Jason has presented on Disaster Recovery at SQL Server Users Groups in Houston, Seattle and Chicago, as well as at SQL PASS conferences and SQL Server Summits.

Sponsor:

Topic: Choosing the Right Encryption in SQL Server 2005/2008 
Date: Thursday, July 17th, 2008
Overview:

Microsoft SQL Server 2008 now has a feature called Transparent Data Encryption, which can encrypt your data without any application changes required. But is it the ultimate solution for encrypting your data? This session discusses various options for encryption, including Extensible Key Management, Transparent Data Encryption, and other built-in encryption capabilities.

Peter will also discuss encryption functionality in SQL Server 2005, as well as several other noteworthy features from SQL Server 2008.

Speaker:

Peter DeBetta

Peter DeBetta is a SQL Server MVP and an independent consultant, author, and architect specializing in design, development, implementation, and deployment of Microsoft SQL Server, Microsoft SharePoint Server, and .NET solutions. Peter blogs at SQLblog.com (cofounder), and writes courseware, articles, and books - most notably the title Introducing SQL Server 2008 from Microsoft Press. Peter speaks at conferences around the world, including TechEd, SQL PASS Community Summit, DevTeach, SQL Connections, DevWeek, and VSLive!

Topic: Data Collections in SQL Server 2008 
Date: Thursday, June 19th, 2008
Overview:

Data collections are a new feature in SQL Server 2008. They allow you to collect perfmon, trace or query data to a central database. We will start off by setting up and configuring Data Collections. We will look at the default collections and historic reports in Management Studio. We will cover setting custom collections and providing a UI with SSRS.

Speaker:

Jason Massie

Jason is a SQL Server Consultant for Terremark Worldwide. He holds MCITP Database Administrator and Database Developer along with MCDBA on SQL Server 7.0 and 2000. Jason is active in the SQL community, speaking locally and nationally. He blogs at http://statisticsio.com. In his free time, Jason likes to spend time with his family, produce electronic music and play games.

Topic: How to Evaluate a Backup Solution 
Date: Thursday, May 15th, 2008
Overview:

Sean will begin with an overview of the current third-party backup solutions on the market. In the process, he'll show how to evaluate and compare them--what's important, what's not, and how to tell when they're working as designed. He'll also share some interesting history on the SQL Server backup space. In his role at InfoWorld, he's been reviewing the backup products for several years. We should also come away with how a magazine like InfoWorld conducts its reviews.

Speaker:

Sean McCown

Sean McCown has been managing high-end transactional databases since 1995, and with terabyte databases since before they were common. His expertise is tuning databases for sub-second query performance. He has worked with IBM DB2, Microsoft SQL Server, Oracle Database, Sybase ASE, and many others including TeraData, MySQL, Ingres, and PostgreSQL. Sean has been a contributing editor to the InfoWorld Test Center since 2003, and he's written for many other publications including SSWUG.org, SQLServerCentral.com, SQL Server Magazine, and SQL Server Standard Magazine.

Topic: What is LINQ and how can it help you? 
Date: Thursday, April 17th, 2008
Overview:

We'll be trying something a little different this month. Because of a speaker cancellation and scheduling conflicts with Microsoft's first-floor Multi-Purpose Room (MPR), we have decided to combine our April meeting with the Dallas .NET Users Group. Both groups will meet in the first-floor MPR and enjoy the same presentation on LINQ.

The following description has been copied from their web site ("Event Detail"):

  • What is LINQ and how does it work?
  • What benefits does LINQ deliver to the .NET developer?
  • What are the flavors of LINQ (LINQ to SQL, LINQ to ADO.NET, LINQ to XML, LINQ to Entities)?
  • How can the "LINQ to SQL" Designer in Visual Studio help you build a data access layer?
  • What is the future of LINQ?
Speaker:

Rob Vetto

Topic: Predicting Change Outcomes - Leveraging SQL Server Profiler 
Date: Thursday, March 20th, 2008
Overview:

Viewing changes to a database in a development or test environment under a workload leaves much to be desired when considering how they will look in production. Load testing tools work well, but still fall short of delivering a true picture of what you might expect to see. Please join us for a presentation on a technique that you can use to understand and view the impact of changes to the database before they are rolled to production. The presentation will include 1) a case for using this technique, 2) its methodology, and 3) several examples to consider.

Speaker:

Lee Everest

Lee Everest is a Sr. SQL Server Consultant for Integrated Services, Inc. located in Dallas, TX and has worked in a number of industries throughout his career: web, banking, insurance, finance, mortgage, health care, and retail, in both OLTP as well as OLAP environments. He has been a member of the North Texas SQL Server Users Group since 2000, and has taught Microsoft SQL Server courses at North Lake College in Irving, TX since 2002. He can be reached at tsql-northlake@dcccd.edu or through his blog at www.texastoo.com.

Topic: SSIS Improvements in SQL Server 2008 
Date: Thursday, February 21st, 2008
Overview:

Russ Loski has been a member of the North Texas SQL Server Users Group since SQL Server 6.5. He has developed applications using all of the versions of SQL Server since then. Microsoft released DTS with SQL Server 7.0 and Russ began developing ETL applications. He was not content to just use simple transformations, he began tweaking the application using Visual Basic and scripting tasks. With the release of SSIS, many of his hacks were no longer necessary.

SQL Server 2008 has introduced several improvements to the database engine as well as SSIS. Russ will be demonstrating many of these enhancements.

Speaker:

Russ Loski

Russ Loski has been a member of the North Texas SQL Server Users Group since SQL Server 6.5. He has developed applications using all of the versions of SQL Server since then.

Sponsor:

Topic: SQL Server 2008 Policy Management 
Date: Thursday, January 17th, 2008
Overview:

It used to be called Declarative Management Framework (DMF), now it has a new name: Microsoft SQL Server 2008 Policy-Based Management. This new feature of SQL Server allows database administrators to create a set of policies to help you control the configurations of one or more SQL Server installations. In this session, I will discuss the new policy management feature of SQL Server 2008 and how the feature may be useful for database administrators. As a by-product I will also introduce the new ability to manage multiple servers at once using SQL Server 2008 Management Studio.

Speaker:

Randy Dyess

Randy is a mentor with Solid Quality Mentors and has been a SQL Server specialist for over 15 years. His current job includes a variety of SQL Server related training and mentoring engagements with a focus on SQL Server performance tuning. Randy has authored dozens of articles and whitepapers on SQL Server topics as well as spoken numerous times at local, national, and international conferences and user groups. Randy’s background involves working with a range of SQL Server environments from those having thousands of databases, hundreds of servers, and thousands of users to environments with over 200TB of SQL Server data. Randy is currently a SQL Server MVP and member of the North Texas SQL Server Users Group Board of Directors.

Sponsor:

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