FWSSUG Meetings

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

DO-OVER! With a Projector! Thinking like a Hacker: A guide to Life, SQL, and Security 

by Brian Guarnieri
Posted by altadmin Monday, September 19, 2016 7:52:00 PM
Now that the projector is working, Brian will be able to show us his scripts and slides! It was great even without those last month, but will be better understood with them!
SO, once again, join Brian Guarnieri for colorful anecdotes on how to think like a hacker and use the hacker ethos to fix holes, and see holes you never thought might be there.
Hacking affects everyone and databases hold the keys to the kingdom. What is a business if not it’s data in the 21st Century?
Learn and understand interesting facts, social engineering, hacking, and how a little common sense can save you when your company hemorrhages data. Find out how users made a company a “classless society” one afternoon.

This is an open comedic look at a serious subject and audience participation is both wanted and encouraged. A sense of humor is highly suggested.

So, come join the Fort Worth SQL Server User Group for a comedic look at security, hacking, and how it effects your bottom line day to day.

Meet and Greet: 6:30 PM Presentation(interactive!) begins at 7 PM

Bio: Does anyone really know the world of Brian Guarnieri? Raised on Max Headroom, Tron, Weird Al, and Monty Python, he brings his dark sense of humor to the masses.
One part administrator, one part developer and one part security enthusiast. He’s a here to spread his collective last minute wings to bring the act of security and server hardening out of the depths of boredom.
Currently working for Robert Half Consulting as a SQL Server Administrator and part-time ETL engineer. He’s the guy poking around all those places in the dark so clients don’t have too.

Aug 17: Thinking like a Hacker: A guide to Life, SQL, and Security. 

by Brian Guarnieri
Posted by altadmin Friday, August 12, 2016 4:01:00 PM Categories: Meeting
This month, join Brian Guarnieri for colorful anecdotes on how to think like a hacker and use the hacker ethos to fix holes, and see holes you never thought might be there.
Hacking affects everyone and databases hold the keys to the kingdom. What is a business if not it’s data in the 21st Century?
Learn and understand interesting facts, social engineering, hacking, and how a little common sense can save you when your company hemorrhages data. Find out how users made a company a “classless society” one afternoon.

This is an open comedic look at a serious subject and audience participation is both wanted and encouraged. A sense of humor is highly suggested.

So, come join the Fort Worth SQL Server User Group for a comedic look at security, hacking, and how it effects your bottom line day to day.

Meet and Greet: 6:30 PM Presentation(interactive!) begins at 7 PM

Bio: Does anyone really know the world of Brian Guarnieri? Raised on Max Headroom, Tron, Weird Al, and Monty Python, he brings his dark sense of humor to the masses.
One part administrator, one part developer and one part security enthusiast. He’s a here to spread his collective last minute wings to bring the act of security and server hardening out of the depths of boredom.
Currently working for Robert Half Consulting as a SQL Server Administrator and part-time ETL engineer. He’s the guy poking around all those places in the dark so clients don’t have too.

Dynamic SSIS packages using C# and BIML: Paul LaGrone 

Happy Anniversary and Welcome back Paul!
Sunday, July 17, 2016 11:56:00 PM Categories: Announcement Meeting

For our tenth year anniversary as a Users Group, our original founder is making the journey all the way back from Florida to speak Wednesday night!

That's right, Paul LaGrone is BACK! He'll be showing us how to build Dynamic SSIS packages using C# and BIML.

Come say hi to Paul and have a little fun with BIML.

The Modern Data Warehouse in the Cloud with Azure 

Presented by Neal Hollingsworth
Posted by altadmin Sunday, June 12, 2016 3:01:00 PM Categories: Announcement Meeting
Topic: This presentation explains end to end, the Microsoft architectural and software solution for a data issue that faced Cook Children's that could be the solution for many other businesses, too. This is the newest way to handle non-relational data in an extremely efficient manner.
Bio: "I've worked with SQL Server for 12 years or more in many different roles. I'm kind of a jack of all trades; master of none. My current role is Senior Business Intelligence Analyst with Cook Children's."
- Neal Hollingsworth
LinkedIn profile: http://linkedin.com/in/nhollingsworth20

6:30 PM Meet & Greet | 7:00 - 8:00 Forum on Topics

MAY 18: Forum - FWSSUG 

Posted by altadmin Wednesday, May 18, 2016 12:59:00 PM
As previously requested, tonight we will cover advantages of a Group PASS membership, and the PASS expectations for PASS groups. We'll also be setting up our plan for generating and training Junior DBAs, ETL Engineers, and BI developers for the Fort Worth employment market...so those of you who raised your hands on this, now's the time to speak freely! (Andy has more on getting "R" into our training lineup in his hip pocket for us, too.) 6:30 PM Meet & Greet | 7:00 - 8:00 Forum on Topics
Page 1 of 9 1 2 3 4 5 6 7 8 9 > >>

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