FWSSUG Meetings http://fwssug.com/meetings.aspx http://www.rssboard.org/rss-specification mojoPortal Blog Module en-US 120 no January 2019 - Meeting Cancelled altadmin]]> http://fwssug.com/january-2019-meeting-cancelled.aspx mjmsqldroid@gmail.com (altadmin) http://fwssug.com/january-2019-meeting-cancelled.aspx http://fwssug.com/january-2019-meeting-cancelled.aspx Tue, 15 Jan 2019 20:27:00 GMT October 2018 - Meeting Cancelled No meeting this month.

If you are subscribed to our Meetup page and are subscribed to Meetup messages, you should have received an email message requesting input for time and location and content changes for future FWSSUG meetings.


altadmin]]>
http://fwssug.com/october-2018-meeting-cancelled.aspx mjmsqldroid@gmail.com (altadmin) http://fwssug.com/october-2018-meeting-cancelled.aspx http://fwssug.com/october-2018-meeting-cancelled.aspx Wed, 17 Oct 2018 04:53:00 GMT
SEPTEMBER 2018 - Meeting Cancelled No meeting this month.

If you are subscribed to our Meetup page and are subscribed to Meetup messages, you should have received an email message requesting input for time and location and content changes for future FWSSUG meetings.


altadmin]]>
http://fwssug.com/september-2018-meeting-cancelled.aspx mjmsqldroid@gmail.com (altadmin) http://fwssug.com/september-2018-meeting-cancelled.aspx http://fwssug.com/september-2018-meeting-cancelled.aspx Wed, 19 Sep 2018 16:08:00 GMT
Querying Semistructured Data in Azure Data Lake with USQL
Meet & Greet at 6:30PM Presentation at 7PM
Please join and RSVP at our FWSSUG MEETUP page!

Abstract:
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 find out? Microsoft’s Azure Data Lake is a cloud storage and analytical service for parking a variety of data. When you are ready, you can query that semi-structured data using an ANSI SQL language called U-SQL. In this session I will demonstrate the similarities and differences between U-SQL and T-SQL. I will demonstrate how easy it is to build a query against 21 GB of CSV files. Such queries can help you determine whether you have a gold mine in your data or a bunch of garbage before investing in a full data warehouse build.
We will go beyond simply extracting data from CSV files. We will look at how easy it is to gain greater insight from your data using U-SQL and Microsoft’s Cognitive Services. We will also look at how to extract data from JSON files using U-SQL.

Bio:
Russ Loski is an SQL Server ETL developer based in Dallas, TX. Twenty years ago, he began working with SQL Server 6.5. He has continued to develop applications connected to all of the versions of SQL Server since. His clients have ranged from insurance to healthcare, from movie theaters to American football. Russ is a regular speaker at SQL Saturday events, as well as the SQL Server Users Groups in the North Texas region. Russ likes working with data in various shapes. He has used DTS, SSIS, U-SQL, R, and .Net to process XML, CSV and other file formats.



Freese and Nichols graciously host our group once a month at their Fort Worth location. We’re on the ground floor in their beautiful training center. Follow the tile hallway to the left of the reception desk as you walk in the front doors. 4055 International Plaza Fort Worth, Texas 76109
altadmin]]>
http://fwssug.com/querying-semistructured-data-in-azure-data-lake-with-usql.aspx mjmsqldroid@gmail.com (altadmin) http://fwssug.com/querying-semistructured-data-in-azure-data-lake-with-usql.aspx http://fwssug.com/querying-semistructured-data-in-azure-data-lake-with-usql.aspx Wed, 08 Aug 2018 18:44:00 GMT
Azure SQL Managed Instance, the New Hotness!
Meet & Greet at 6:30PM Presentation at 7PM
Please join and RSVP at our FWSSUG MEETUP page!

Abstract:
You can't wait to move your databases to an Azure PaaS offering so you don't have to patch and maintain an operating system and SQL Server. You looked at Azure SQL DB, but there are some limitations that prevent you from migrating to this service. Don't worry, you're not stranded. There is a new option designed to "Lift and Shift" your workload to Azure PaaS. It's a brand new offering that just came out of private preview and into public preview. We'll discuss this new offering, its advantages, and how you can migrate with ease.

Bio:
Ryan Adams is a Senior Premier Field Engineer for Microsoft. He works directly with customers to help them realize their business potential and accelerate their digital transformation on premises and in the cloud. Previously, Ryan was a Microsoft Data Platform MVP and spent 19 years working for a fortune 100 company. His passion is the SQL Server Engine, High Availability, and Disaster Recovery. He also served on the Board of Directors for the North Texas SQL Server User Group, was President of the PASS Performance Virtual Chapter, was a PASS Regional Mentor, and served as a Director for the PASS organization.



Freese and Nichols graciously host our group once a month at their Fort Worth location. We’re on the ground floor in their beautiful training center. Follow the tile hallway to the left of the reception desk as you walk in the front doors. 4055 International Plaza Fort Worth, Texas 76109
altadmin]]>
http://fwssug.com/azure-sql-managed-instance-the-new-hotness.aspx mjmsqldroid@gmail.com (altadmin) http://fwssug.com/azure-sql-managed-instance-the-new-hotness.aspx http://fwssug.com/azure-sql-managed-instance-the-new-hotness.aspx Mon, 09 Jul 2018 22:31:00 GMT
How to configure your new instances of SQL Server.
Meet & Greet at 6:30PM Presentation at 7PM
Please join and RSVP at our FWSSUG MEETUP page!

Abstract:

When you set up a new SQL Server, it doesn't stop at the installation. Wednesday, Andy is sharing his multi-version SQL Server configurations with us.

Bio:
Andy is one of our FWSSUG officers and is about the most enthusiastic supporter of education for the SQL community. He is always the first to volunteer his support in any SQL Saturday event, and is always ready to help teach and mentor anyone who asks. Andy keeps us focused and driving toward education with pure intent. If you want to see this guy get passionately animated, let him start talking about his business intelligence initiatives or educating the community. Andy has end to end expertise in Data Architecture, Statistical Analysis, BIML, SQL Server 2008 through 2016 and the full Microsoft BI stack, and thrives in solving complex business problems. He holds Graduate Certifications from SMU in both Analytics and Marketing and earned his MBA from the University of Dallas.



Freese and Nichols graciously host our group once a month at their Fort Worth location. We’re on the ground floor in their beautiful training center. Follow the tile hallway to the left of the reception desk as you walk in the front doors. 4055 International Plaza Fort Worth, Texas 76109

See you there


altadmin]]>
http://fwssug.com/how-to-configure-your-new-instances-of-sql-server.aspx mjmsqldroid@gmail.com (altadmin) http://fwssug.com/how-to-configure-your-new-instances-of-sql-server.aspx http://fwssug.com/how-to-configure-your-new-instances-of-sql-server.aspx Tue, 19 Jun 2018 17:05:00 GMT
"Real World" Examples on How to Load Data Warehouse Structures using SSIS
Meet & Greet at 6:30PM Presentation at 7PM
Please join and RSVP at our FWSSUG MEETUP page!

Abstract:
In this session we will discuss the value of a SSIS Framework, explore forward engineering benefits, and demonstrate SSIS design patterns on loading SQL structures when developing Data Warehouses, SSAS Cubes, and Power BI Analytics.

Live Demo SSIS Framework
    Load & Error Meta Data
    Restart ability, Rollback, Reload Count
    Master Load ID, LoadID, ExecutionID (SSISDB), Refresh
    Package Sequencing and Signatures
    Connections, Expressions, Parameters, Event Handlers
    Alerting (SMTP), Error Flows (XML Destination Script)

Forward Engineering SQL Structures
    Relationships, Primary & Foreign Keys
    Data Types, Nullability, Indexes

Demos for Multiple Design Patterns
    Dimensions (Slowly Changing)
    Facts (Inserts, Updates, Deletes)
    Bridges / Snowflakes

AutoBiography:
Ryan Casey, MBA, LLC
@AimYourData on Twitter
BI Architect, AIM Business Driven Data Solutions

Website: http://www.aimyourdata.com/
LinkedIn: https://www.linkedin.com/in/ryancaseymba/
Facebook: https://www.facebook.com/aim.yourdata.9
Blog: http://www.rhynodata.com/
You Tube Channel: https://www.youtube.com/channel/UCd4RTLBn8sjVR5D3gfJhq9Q

Microsoft Data Platform MVP, Public Speaker, and Group Moderator

SQL Saturday Speaker @
• Dallas, TX 2018, 2017 (BI), 2016, 2015
• Phoenix, AZ 2018, 2017 (BI)
• Kansas City, MO 2017
• Baton Rouge, LA 2017
• Oklahoma City, OK 2016
• San Antonio, TX 2016

SQL User Group Speaker @
• NTSSUG, Dallas, TX
• CACTUSS, Austin, TX
• OKCSQL, Oklahoma City, OK
• MSBIC, Dallas, TX
• SALSSA, San Antonio, TX
• FWSSUG, Fort Worth, TX

AIM Business Driven Data Solutions combines the collaborative and creative arts included in Technical Communication, the business acumen of a Harvard MBA program, and the technical discipline of object-oriented programming and business intelligence (data warehouses).



Freese and Nichols graciously host our group once a month at their Fort Worth location. We’re on the ground floor in their beautiful training center. Follow the tile hallway to the left of the reception desk as you walk in the front doors.


4055 International Plaza
Fort Worth, Texas 76109
altadmin]]>
http://fwssug.com/real-world-examples-on-how-to-load-data-warehouse-structures-using-ssis.aspx mjmsqldroid@gmail.com (altadmin) http://fwssug.com/real-world-examples-on-how-to-load-data-warehouse-structures-using-ssis.aspx http://fwssug.com/real-world-examples-on-how-to-load-data-warehouse-structures-using-ssis.aspx Mon, 14 May 2018 23:14:00 GMT
Security, Hypocrisy, and Standards, "OH MY" or How to hack your data center in three easy steps
Meet & Greet at 6:30PM Presentation at 7PM
Please join and RSVP at our FWSSUG MEETUP page!

Abstract:
How secure do you think your data is? Why is everyone trying to get your data? How do you get a Comptroller of a large bearing supplier to be your puppet and do things they would never do? Hacking....Hacking....And more hacking. An introduction to situational awareness, on premise security, and social engineering. Learn the secrets of a pen tester and how they get your data. (Answer: it's Usually not through SQL Server.) Trust no one and ummmm always keep your protractor ready. (See Paranoia Role-playing Game). The chances are you've already been hacked and you don't even know it. Take a humorous journey through the eyes of an everyday DBA who sizes up weaknesses using tried and true Red Team hacking techniques. Lets face it. The data is where the money is. It's not in the snazzy new middle-ware that Bob the programmer is so proud of. It's in your data and sometimes your co-worker is your worst enemy. Remember never blame your self, always always blame the PROGRAMMER. It's Bob's fault!

AutoBiography:
Brian Guarnieri is a man of mystery. Does anyone know this person. One part human two parts whovian. He's sleek silent and subtle as a brick to the face. An IT professional since 2000 working as a DBA and moonlighting as a super hero. The only database oriented member of the Dallas Hackers Association he spreads his message of governance and coding practices to the masses. Once a leader of a cult, he has put away his Elvis wig, rhinestones, and snazzy shoes to talk about the comical eccentricities of the IT World. You may know him from such television shows as "The Dukes of Hazzard" and "Small Wonder". Once a child actor he now revels in obscurity. As the only Dalek DBA he seeks to exterminate poor code in all its many forms.



Freese and Nichols graciously host our group once a month at their Fort Worth location. We’re on the ground floor in their beautiful training center. Follow the tile hallway to the left of the reception desk as you walk in the front doors. 4055 International Plaza Fort Worth, Texas 76109

See you there,


altadmin]]>
http://fwssug.com/security-hypocrisy-and-standards-oh-my-or-how-to-hack-your-data-center-in-three-easy-steps.aspx mjmsqldroid@gmail.com (altadmin) http://fwssug.com/security-hypocrisy-and-standards-oh-my-or-how-to-hack-your-data-center-in-three-easy-steps.aspx http://fwssug.com/security-hypocrisy-and-standards-oh-my-or-how-to-hack-your-data-center-in-three-easy-steps.aspx Tue, 17 Apr 2018 22:41:00 GMT
SQL SERVER PERFORMANCE!
Meet & Greet at 6:30PM Presentation at 7PM
Please join and RSVP at our FWSSUG MEETUP page!

Abstract:
Andy will continue to show us how to gather performance-tuning data, review of the SQL Server Internals, which wait stats should be collected and how to use them to increase performance.
As in Part 1, the why of “it Depends” is always a good starting point and where to look for setup areas to check / review. Andy will show us where SQL Server hides its information and how we can use it efficiently to improve performance.

Bio:
Andy is one of our FWSSUG officers and is about the most enthusiastic supporter of education for the SQL community. He is always the first to volunteer his support in any SQL Saturday event, and is always ready to help teach and mentor anyone who asks. Andy keeps us focused and driving toward education with pure intent. If you want to see this guy get passionately animated, let him start talking about his business intelligence initiatives or educating the community. Andy has end to end expertise in Data Architecture, Statistical Analysis, BIML, SQL Server 2008 through 2016 and the full Microsoft BI stack, and thrives in solving complex business problems. He holds Graduate Certifications from SMU in both Analytics and Marketing and earned his MBA from the University of Dallas.



Freese and Nichols graciously host our group once a month at their Fort Worth location. We’re on the ground floor in their beautiful training center. Follow the tile hallway to the left of the reception desk as you walk in the front doors. 4055 International Plaza Fort Worth, Texas 76109

See you there,


altadmin]]>
http://fwssug.com/sql-server-performance.aspx mjmsqldroid@gmail.com (altadmin) http://fwssug.com/sql-server-performance.aspx http://fwssug.com/sql-server-performance.aspx Tue, 20 Mar 2018 17:53:00 GMT
**CANCELLED** Part 2 - Performance Monitoring and SQL Server Internals for the Poor Man
** CANCELLED due to Weather! **
We want everyone to be able to stay safe on the roads this evening since this freeze line is moving all around Fort Worth!
Andy's presentation will be moved to our MARCH 21st meeting.

See you then!
~ MJ




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

Abstract:
Andy will continue to show us how to gather performance-tuning data, review of the SQL Server Internals, which wait stats should be collected and how to use them to increase performance.
As in Part 1, the why of “it Depends” is always a good starting point and where to look for setup areas to check / review. Andy will show us where SQL Server hides its information and how we can use it efficiently to improve performance.

Bio:
Andy is one of our FWSSUG officers and is about the most enthusiastic supporter of education for the SQL community. He is always the first to volunteer his support in any SQL Saturday event, and is always ready to help teach and mentor anyone who asks. Andy keeps us focused and driving toward education with pure intent. If you want to see this guy get passionately animated, let him start talking about his business intelligence initiatives or educating the community. Andy has end to end expertise in Data Architecture, Statistical Analysis, BIML, SQL Server 2008 through 2016 and the full Microsoft BI stack, and thrives in solving complex business problems. He holds Graduate Certifications from SMU in both Analytics and Marketing and earned his MBA from the University of Dallas.



Freese and Nichols graciously host our group once a month at their Fort Worth location. We’re on the ground floor in their beautiful training center. Follow the tile hallway to the left of the reception desk as you walk in the front doors. 4055 International Plaza Fort Worth, Texas 76109

See you there,


altadmin]]>
http://fwssug.com/cancelled-part-2-performance-monitoring-and-sql-server-internals-for-the-poor-man.aspx mjmsqldroid@gmail.com (altadmin) http://fwssug.com/cancelled-part-2-performance-monitoring-and-sql-server-internals-for-the-poor-man.aspx http://fwssug.com/cancelled-part-2-performance-monitoring-and-sql-server-internals-for-the-poor-man.aspx Tue, 20 Feb 2018 20:23:00 GMT
Data Modeling for the Modern Data Warehouse
Meet & Greet at 6:30PM Presentation at 7PM
Please join and RSVP at our FWSSUG MEETUP page!

Abstract:
A theoretical discussion on the topic of graphical data modeling using enterprise modeling tools.

Discuss why we model data, the different modeling type, and different modeling techniques. Explore why and when to use different modeling techniques. Explain dimensional modeling when developing data warehouses, SSAS Cubes, and Power BI Analytics.

Sample model diagrams will be used to explain these different modeling techniques and try to bring a more tangible aspect to the theoretical aspects of the discussion.

Why Model Data
The Value of Enterprise Data
Business Benefits of Data Modeling
Different Model Types
Conceptual / Logical / Physical
Dimensional
Different Modeling Techniques
Star & Snow Flake Schema
Slowly Changing Dimensions
Many to Many Relationships


Bio: Ryan Casy: Managing BI Architect, Microsoft Data Platform MVP, Friend of Redgate, LinkedIn Group Moderator, and a SQL Saturday Speaker.

• 15+ Fortune 500 Corporations Implementing Data Centers and Warehouses • 14+ years SQL Server and Oracle (T-SQL, PL-SQL), (Excel, Flat Files, XML) • 12+ years Visual Studio (SSDT Business Intelligence, DevOps, MVC, C#, VB) • 11+ years Excel, SSAS, SSIS, and SSRS using Agile Methodology • 6+ years Leading Large BI Teams (multi-country off-shore locations)

AIM Business Driven Data Solutions combines the collaborative and creative arts included in Technical Communication, the business acumen of a Harvard MBA program, and the technical discipline of object oriented programming and business intelligence (data warehouses).



Freese and Nichols graciously host our group once a month at their Fort Worth location. We’re on the ground floor in their beautiful training center. Follow the tile hallway to the left of the reception desk as you walk in the front doors. 4055 International Plaza Fort Worth, Texas 76109
altadmin]]>
http://fwssug.com/data-modeling-for-the-modern-data-warehouse.aspx mjmsqldroid@gmail.com (altadmin) http://fwssug.com/data-modeling-for-the-modern-data-warehouse.aspx http://fwssug.com/data-modeling-for-the-modern-data-warehouse.aspx Sat, 13 Jan 2018 16:33:00 GMT
Performance Monitoring and SQL Server Internals for the Poor Man
Meet & Greet at 6:30PM Presentation at 7PM
Please join and RSVP at our FWSSUG MEETUP page!

Abstract:
We will look at how to gather performance-tuning data, review of the SQL Server Internals and where the wait stats are collected and how to use them to determine what changes can be made to increase performance.
The Why “it Depends” is always a good starting point and where to look for setup areas to check / review. We will discover where SQL Server hides its information in public. We will only be looking at the SQL Server engine and its components.

Bio:
Andy is one of our FWSSUG officers and is about the most enthusiastic supporter of education for the SQL community. He is always the first to volunteer his support in any SQL Saturday event, and is always ready to help teach and mentor anyone who asks. Andy keeps us focused and driving toward education with pure intent. If you want to see this guy get passionately animated, let him start talking about his business intelligence initiatives or educating the community. Andy has end to end expertise in Data Architecture, Statistical Analysis, BIML, SQL Server 2008 through 2016 and the full Microsoft BI stack, and thrives in solving complex business problems. He holds Graduate Certifications from SMU in both Analytics and Marketing and earned his MBA from the University of Dallas.



Freese and Nichols graciously host our group once a month at their Fort Worth location. We’re on the ground floor in their beautiful training center. Follow the tile hallway to the left of the reception desk as you walk in the front doors. 4055 International Plaza Fort Worth, Texas 76109
altadmin]]>
http://fwssug.com/performance-monitoring-and-sql-server-internals-for-the-poor-man.aspx mjmsqldroid@gmail.com (altadmin) http://fwssug.com/performance-monitoring-and-sql-server-internals-for-the-poor-man.aspx http://fwssug.com/performance-monitoring-and-sql-server-internals-for-the-poor-man.aspx Mon, 16 Oct 2017 20:21:00 GMT
Using Extended Events to Expose Application Performance Issues
Meet & Greet at 6:30PM Presentation at 7PM
Please join and RSVP at our FWSSUG MEETUP page!

Abstract:
When an application is performing poorly, the database is almost always suspected to be the source of the problem. Not so fast! In this session, learn how to use Extended Events to analyze the space BETWEEN calls to the SQL Server. This non-traditional technique can help you to identify where an application is actually the source of a performance issue and not the SQL Server.

Bio:
Mindy Curnutt is a 3X Microsoft Data Platform MVP. She is also a Trimble Distinguished Engineer, the VP of Information Management at TMW Systems and an Idera Ace. She helps support almost 1,500 companies in the logistics and trucking industry using SQL Server as their database platform. Within the transportation industry, Mindy is well known as THE “Go-To” person when it comes to SQL Server questions or issues. Her specialties are hardware, configuration, scalability and performance tuning.

Mindy has been actively involved in the SQL Server Community for over a decade and has become a well known speaker within the SQL and Transportation Management communities. She presented at the SQLPASS Summits in 2005, 2006, 2012, 2013, 2015 and was honored as the September, 2016 SQLPass Outstanding Volunteer. Mindy spoke at her local North Texas SQL Server User Group in 2002, 2003 & 2015, and numerous SQLSaturday chapters throughout North America.

In 2013 and 2014 she was a Team Lead for the SQLPASS Summit Abstract Review Process. In 2015 and 2016 served (and is serving) as one of the 2-3 SQLPASS Summit Program Managers. Mindy was a SME for both the SQL 2012 and 2014 Microsoft Certification Exams. In 2016 she delivered a speech during the Keynote about the Future of Big Data in Transportation at TMW Systems & PeopleNet’s In.Sight event – “Data Quality and Reference Data“. You can download some of her presentations here,

She mentors others, helping to educate and promote scalable and sustainable SQL Server architecture and design. She is an enthusiastic and effective participant within the SQL Server community, giving her time and resources to help it improve and grow.

Twitter: @sqlgirl



Freese and Nichols graciously host our group once a month at their Fort Worth location. We’re on the ground floor in their beautiful training center. Follow the tile hallway to the left of the reception desk as you walk in the front doors. 4055 International Plaza Fort Worth, Texas 76109
altadmin]]>
http://fwssug.com/using-extended-events-to-expose-application-performance-issues.aspx mjmsqldroid@gmail.com (altadmin) http://fwssug.com/using-extended-events-to-expose-application-performance-issues.aspx http://fwssug.com/using-extended-events-to-expose-application-performance-issues.aspx Thu, 14 Sep 2017 13:54:00 GMT
So how does SQL Server take a query and decide what to do with it? 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.
altadmin]]>
http://fwssug.com/so-how-does-sql-server-take-a-query-and-decide-what-to-do-with-it.aspx mjmsqldroid@gmail.com (altadmin) http://fwssug.com/so-how-does-sql-server-take-a-query-and-decide-what-to-do-with-it.aspx http://fwssug.com/so-how-does-sql-server-take-a-query-and-decide-what-to-do-with-it.aspx Fri, 04 Aug 2017 00:43:00 GMT
JULY 19th Meeting CANCELLED for 24 HOURS of PASS event!! altadmin]]> http://fwssug.com/july-19th-meeting-cancelled-for-24-hours-of-pass-event.aspx mjmsqldroid@gmail.com (altadmin) http://fwssug.com/july-19th-meeting-cancelled-for-24-hours-of-pass-event.aspx http://fwssug.com/july-19th-meeting-cancelled-for-24-hours-of-pass-event.aspx Fri, 14 Jul 2017 21:12:00 GMT Exploring the New Features of SSRS 2016
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.
altadmin]]>
http://fwssug.com/exploring-the-new-features-of-ssrs-2016.aspx mjmsqldroid@gmail.com (altadmin) http://fwssug.com/exploring-the-new-features-of-ssrs-2016.aspx http://fwssug.com/exploring-the-new-features-of-ssrs-2016.aspx Wed, 21 Jun 2017 00:37:00 GMT
Will it Shred? The utter basics of XML in SQL Server. 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.
altadmin]]>
http://fwssug.com/will-it-shred-the-utter-basics-of-xml-in-sql-server.aspx mjmsqldroid@gmail.com (altadmin) http://fwssug.com/will-it-shred-the-utter-basics-of-xml-in-sql-server.aspx http://fwssug.com/will-it-shred-the-utter-basics-of-xml-in-sql-server.aspx Tue, 16 May 2017 16:44:00 GMT
SS2014/2016 In-Memory Tables --Formula One Performance Unleashed, Part 1 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).
altadmin]]>
http://fwssug.com/ss20142016-in-memory-tables--formula-one-performance-unleashed-part-1.aspx mjmsqldroid@gmail.com (altadmin) http://fwssug.com/ss20142016-in-memory-tables--formula-one-performance-unleashed-part-1.aspx http://fwssug.com/ss20142016-in-memory-tables--formula-one-performance-unleashed-part-1.aspx Tue, 18 Apr 2017 17:11:00 GMT
Azure Data Factory and SSIS Automation With Biml 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.
altadmin]]>
http://fwssug.com/azure-data-factory-and-ssis-automation-with-biml.aspx mjmsqldroid@gmail.com (altadmin) http://fwssug.com/azure-data-factory-and-ssis-automation-with-biml.aspx http://fwssug.com/azure-data-factory-and-ssis-automation-with-biml.aspx Tue, 14 Mar 2017 17:14:00 GMT
SQL Server 2016: It Just Runs Faster 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.


altadmin]]>
http://fwssug.com/sql-server-2016-it-just-runs-faster.aspx mjmsqldroid@gmail.com (altadmin) http://fwssug.com/sql-server-2016-it-just-runs-faster.aspx http://fwssug.com/sql-server-2016-it-just-runs-faster.aspx Tue, 31 Jan 2017 06:00:00 GMT