FWSSUG Meetings

-August 2017+
SMTWTFS
303112345
6789101112
13141516171819
20212223242526
272829303112
3456789
  • RSS
  • Add To My MSN
  • Add To Windows Live
  • Add To My Yahoo
  • Add To Google

Statistics

  • Entries (93)
  • Comments (0)

So how does SQL Server take a query and decide what to do with it? 

Presented by Forrest McDaniel
Posted by altadmin Thursday, August 3, 2017 7:43:00 PM
AUGUST 16th - Meet & Greet at 6:30PM Presentation at 7PM
Please join and RSVP at our FWSSUG MEETUP page!

Abstract: There are many internal mechanisms that SQL Server uses to build a query plan. Join me as I survey the process, with special attention paid to cardinality, statistics, and the memo. DBCC commands and undocumented trace flags abound as I show how to investigate internals for yourself. Only some of the presentation will be useful, but all of it will be nerdy!

Bio: Forrest McDaniel
I've only been a DBA for two years, so don't take my word for anything!
Before this new career I was a teacher and tutor, so I love explaining concepts, especially math.

JULY 19th Meeting CANCELLED for 24 HOURS of PASS event!! 

Posted by altadmin Friday, July 14, 2017 4:12:00 PM
FWSSUG members! This month PASS has a 24 hour PASS Summit preview sessions event going on that conflicts with our meeting! No way can we provide as much learning as this free PASS event, so we are cancelling July's FWSSUG meeting so that everyone can register and take advantage of the great PASS sessions online. Here is the session lineup: Http://www.pass.org/24hours/2017/summitpreview/Schedule.aspx Don't miss this! Pick what you want to learn and go register! It is free after all! ~Mary Mathias

Exploring the New Features of SSRS 2016 

Presented by Tim Mitchell
Posted by altadmin Tuesday, June 20, 2017 7:37:00 PM


Meet & Greet at 6:30PM Presentation at 7PM
Please join and RSVP at our FWSSUG MEETUP page!

Abstract:
For years, SQL Server Reporting Services chugged along with very few updates. Although it remained a reliable and popular reporting tool, the feature set largely remained unchanged for a decade. With the release of SQL Server 2016, everything changed. Microsoft delivered a brand new SSRS. This session will review and demonstrate the new features of SQL Server Reporting Services 2016. You'll walk through the essential changes in SSRS, from the new report manager to the new visualizations. You'll also discuss the SSRS ecosystem and how it fits together with PowerBI and other Microsoft reporting/analytics platforms.

Bio:
Tim Mitchell is a business intelligence consultant, author, and trainer.  He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting.  He holds a Bachelor’s Degree in Computer Science from Texas A&M at Commerce, and is recognized as aMicrosoft Data Platform MVP.  Tim is the founder and principal data architect at Tyleris Data Solutions.

As an active member of the community, Tim has spoken at international, regional, and local venues including theSQL PASS Summit, SQLBits, SQL Connections, SQL Saturday events, and various user groups and webcasts.  Tim is coauthor of the book SSIS Design Patterns, and is a contributing author on the charity book project MVP Deep Dives 2.  He is an active group member and speaker at the North Texas SQL Server User Group in the Dallas area.

You can visit his website and blog at TimMitchell.net or follow him on Twitter at  twitter.com/Tim_Mitchell.

Will it Shred? The utter basics of XML in SQL Server. 

FWSSUG NEW SPEAKER - Forrest McDaniel
Posted by altadmin Tuesday, May 16, 2017 11:44:00 AM
Meet & Greet at 6:30PM Presentation at 7PM
Please join and RSVP at our FWSSUG MEETUP page!

Abstract: For SQL Server folk comfortable with relational data, XML is an unavoidable evil. SQL doesn't work on it, and nested substrings are awkward, so how can we shred it?
In this presentation I cover the basics of handling XML. I briefly review what XML is, and point out where we commonly see it. I show basic XPath, touch on XQuery, and spend the bulk of my time demoing the main methods in T-SQL for applying XPath to XML.
Bonus topics include XML schemas (and why they actually matter), XML indexes, and a CLR demo.

Bio: Forrest McDaniel
I've only been a DBA for two years, so don't take my word for anything!
Before this new career I was a teacher and tutor, so I love explaining concepts, especially math.

SS2014/2016 In-Memory Tables --Formula One Performance Unleashed, Part 1 

Posted by altadmin Tuesday, April 18, 2017 12:11:00 PM
Meet & Greet at 6:30PM Presentation at 7PM
Please join and RSVP at our FWSSUG MEETUP page!

Abstract:
Query performance is what it is all about. SQL Server 2014/2016 now has the new in-memory functionality that takes a completely different approach to data access and manipulation. This session will consolidate the relevant information from all these sources so the production DBA/Developer will be able to understand, create, use, maintain, and trouble-shoot in-memory table functionality. This session will also examine several demo scripts showing performance gains using the in-memory tables with and without columnstore indexes over equivalent disk based tables. This session is all about when and how to apply in-memory tables in a production environment. After this session you will 1. Understand what in-memory tables are and how to create and maintain them including their limitations 2. Be able to identify performance gains over equivalent disk back tables 3. Comprehend the new data monitoring needed for in-memory table

In_MemoryPresentationLink is a dropbox link containing zip file containing my PowerPoint and all TSQL script demo files.

Bio:
Mike Byrd Bio:

Email: mbyrd@nctv.com Phone: 512-657-5349 Twitter: @ByrdNest_TX Web Site: www.TSQLMentoring.com Company: ByrdNest Consulting (Business Owner) Job Title: Senior Database Engineer Address: 213 Lakeview, Sunrise Beach, TX 78643-9308 LinkedIn profile: https://www.linkedin.com/in/mike-byrd-bbbaa01 Summary: Former rocket scientist and USAF Fighter Test Pilot -- now a SQL Server geek. Past opportunities include free-lance technical writer for PC Magazine, Senior Software Manager for government sponsored munitions effectiveness committee, and IT Director for Texas Windstorm Insurance Association (9 years), Current in SQL Server 2016 (RC3), 2014, 2012, 2008R2, and 2005. Presented many SQL Saturday presentations at Austin, Baton Rouge, Denver, Dallas, Houston, Oklahoma City, South Florida, Gothenburg (Sweden), Atlanta BI, Albuquerque, Tampa, Jacksonville, Pensacola, Nashville, Atlanta, Oslo, and Sydney. Currently consulting for several Austin based software companies and free-lance writing a series of performance articles for SolarWinds (http://logicalread.solarwinds.com/?s=Byrd ). Also working up new data architecture and implementation plan for Daughters of Republic of Texas system. Specialties: SQL Server performance tuning; database (OLTP & OLAP) architecture; trouble-shooting; teaching TSQL (Basic through Advanced). Instruction: Have presented group TSQL classes for Newgistics, Austin, TX; Conexis, Irving, TX; and Mentor (Johnson & Johnson), Irving, TX, and individualized mentoring on a one-on-one basis, Have presented TSQ: Basic to Advanced PreCon at Dallas SQL Saturday #447 – 17 paid attendees with all excellent reviews. Recently presented Advanced TSQL 8 hour session to Solarwinds Corporate Office, Austin, TX with very positive reviews (25 attendees).

Azure Data Factory and SSIS Automation With Biml 

Presented by David Stein
Posted by altadmin Tuesday, March 14, 2017 12:14:00 PM
Meet & Greet at 6:30PM Presentation at 7PM
Please join and RSVP at our FWSSUG MEETUP page!

Abstract:
SSIS was originally designed to work in a world where all data was structured and on premise. As modern enterprise data projects increasingly move online, tools like Azure Data Factory (ADF) can extend SSIS capabilities to the cloud. Azure Data Factory is a flexible and powerful cloud based ETL service, but it doesn't replace the functionality of SSIS.
In this session you will learn the advantages and disadvantages of both ETL platforms; how to use both in tandem to maximize productivity; and how both ETL platforms, as well as any supporting structures, can be automatically generated with Biml Script.
All of the code used in this presentation can be downloaded by attendees, customized, and used in their production environments.

Bio:
David Stein
- Data Warehouse Architect and Independent Consultant - has more than a decade of experience working in SQL Server Business Intelligence. He’s designed multi-terabyte, multi-tenant Data Warehouses from scratch as well as saved projects in serious jeopardy.

SQL Server 2016: It Just Runs Faster 

by Bob Ward, Principal Architect, Microsoft
Posted by altadmin Tuesday, January 31, 2017 12:00:00 AM
Meet & Greet at 6:30PM Presentation at 7PM
Please join and RSVP at our FWSSUG MEETUP page!

Abstract:
Join Bob Ward in taking a deep dive and a behind the scenes look at how SQL Server 2016 ‘It Just Runs Faster’, focused on scalability and performance enhancements. This talk will discuss the improvements, not only for awareness, but expose design and internal change details. The beauty behind ‘It Just Runs Faster’ is your ability to just upgrade, in place, and take advantage without lengthy and costly application or infrastructure changes. If you are looking at why SQL Server 2016 makes sense for your business, you won't want to miss this session.

BIO:
Bob Ward is a Principal Architect for the Microsoft Data Group (Tiger Team) which owns the development and servicing for all SQL Server versions. Bob has worked for Microsoft for 23 years supporting and speaking on every version of SQL Server shipped from OS/2 1.1 to SQL Server 2016. He has worked in customer support as a principal escalation engineer and Chief Technology Officer (CTO) interacting with some of the largest SQL Server deployments in the world. Bob is a well-known speaker on SQL Server often presenting talks on internals and troubleshooting at events such as SQL PASS Summit, SQLBits, SQLIntersection, and Microsoft Ignite. You can find him on twitter at @bobwardms or read his blog at https://blogs.msdn.microsoft.com/bobsql.

SSMS Tips and Tricks  

Presentation by Latish Sehgal
Posted by altadmin Friday, January 13, 2017 4:31:00 PM
Abstract
In this talk, we’ll go through tips and tricks to make you much more productive and efficient with SQL Server Management Studio, so that IDE does not get in your way and lets you focus on writing SQL.

Bio
Latish works as a Principal Software Engineer for a startup. He is an avid learner and a productivity geek.. He also created SqlSmash, a productivity plugin for SSMS. He can be reached via his blog at http://www.dotnetsurfers.com/ or twitter (http://twitter.com/latish).

Meet and Greet: 6:30 PM Presentation begins at 7 PM

No Meetings for the Holidays! 

--resuming in January 2017
Posted by altadmin Wednesday, November 16, 2016 5:53:00 PM
Remember, we have no meetings for the Holiday Season: November and December 2016
We will resume our third Wednesday of the month meetings in January 2017.

In January, we'll have Latish Sehgal: Creator of SqlSmash, a productivity plugin for Sql Server Management Studio!
In April, we'll have Mike Byrd: Former rocket scientist and USAF Fighter Pilot turned SQL Server geek who has presented at over 17 SQL Saturdays last count!
And, more to be posted once confirmed.

Happy Holidays to you all!

~ Your FWSSUG Officers!

An introduction to the Azure Data Lake and U-SQL 

By Russ Loski
Posted by altadmin Monday, October 17, 2016 9:36:00 AM Categories: Announcement Meeting
Data is exploding across enterprises. Much of it is semi-structured junk. Or is it junk? What are you going to do with it until you can explore it? Microsoft’s Azure Data Lake is a cloud storage and analytical service for parking a variety of data. When you are ready to discover what is in those files you can spin up the resources you need and run ANSI SQL queries using the U-SQL language. You can join those files to other files and even to SQL Server on Azure in a single query.
After we look at how easy it is to set up a Data Lake we will develop some simple queries against files that I have already loaded into the data lake. We will run a query against a set of files with over 15 GB of data. We will look at the different SQL elements that we are all familiar with (grouping, where clauses) and note the similarities and glaring differences between U-SQL and T-SQL.

Bio: Russ Loski is a local SQL Server developer in the DFW area. He has worked with SQL Server since version 6.5. His passion is finding ways to get information out of a variety of formats from SQL Server to comma delimited files. He is currently working as a contract ETL developer at Baylor Scott & White.

6:30 PM Meet & Greet | 7 PM Presentation
Page 1 of 10 1 2 3 4 5 6 7 8 9 10 > >>

MAY 18: Forum - FWSSUG

The Modern Data Warehouse in the Cloud with Azure

Site Map | Printable View | © 2008 - 2017 Fort Worth SQL Server Users Group | Powered by mojoPortal | HTML 5 | CSS | Original design by Andreas Viklund