By Russ Loski
Monday, October 17, 2016 9:36:00 AM
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
by Brian Guarnieri
Friday, August 12, 2016 4:01:00 PM
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.
Happy Anniversary and Welcome back Paul!
Sunday, July 17, 2016 11:56:00 PM
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.
Presented by Neal Hollingsworth
Sunday, June 12, 2016 3:01:00 PM
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.
"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
Speaker: Tim Costello
Sunday, April 17, 2016 10:45:00 PM
Can Data Warehouse Design be agile? You bet! In this session, we will explore the ways we can be more agile, collaborative, iterative and successful with our dimensional designs. Data Warehouse ... here we come!
Tim Costello is a data enthusiast, data warehouse architect, Tableau trainer and occasionaly writes half way good SQL.
(NOTE: That's Tim saying that! We here at FWSSUG know how great he truly is!!!)
6:30 PM Meet & Greet |
7 PM FWSSUG Future Plans |
7:30 - 8:30 Presentation
Wednesday, March 16, 2016 10:37:00 AM
Our normal first quarter planning has been affected by several funerals we've had to deal with over the last few months. So we are very sorry to say that we must cancel tomorrow's FWSSUG meeting.
We will re-group for APRIL's meeting.
Thank you for understanding!
Monday, February 15, 2016 9:12:00 AM
Every year we are required to perform a job self-elevation as part of our jobs. So are you looking for a way to evaluate your current job skill sets, changing direction in your career, in job transition, looking for a new career path? Has your career path been shifted by other people’s decisions? Then join us for a new way to perform some self-evaluation and outline a new career strategy.
Andy Eggers is one the pillars of the Fort Worth SQL Group and his dedication and passion for fostering professional and technical training for the community is unparalleled.
6:30 PM Meet & Greet | 7 PM Presentation
See you there,
The folks at the Fort Worth SQL Server Users Group
Monday, January 18, 2016 9:25:00 PM
We are opening our 10th year as a user group on February 17th with our very own Andy Eggers!
Also, we also have Paul LaGrone coming all the way back from Florida this July to help us celebrate! Good times ahead.
Look for several of us at the Austin SQL Saturday this month too: http://www.sqlsaturday.com/461/eventhome.aspx
Happy 2016 and see you in February.
There's more to it than just SQL Server
Friday, October 16, 2015 3:38:00 PM
There's far more occurring on your Windows servers than just SQL Server, and looking at ERRORLOG won't show you the whole story: other applications stealing your memory, OS issues, hardware errors, and more. We'll start by looking at different ways to collect Event Logs. From there we'll delve into WMI and WQL, which allow us to query servers (remotely or locally) to get information such as performance statistics, System and Event Logs, and even changes within SQL Server. We'll finish it off with two immediately-usable implementations you can set up on Thursday morning.
Michael Bourgon is the Senior Production DBA for a large healthcare company. He's always looking for a better way to be a Lazy DBA - spending far too many hours automating processes in order to accomplish that. In Fort Worth we think of him as the Caspian Sea Monster of Eventing.
Sunday, September 13, 2015 10:23:00 PM
You know that Biml can automate ETL loads, but your data warehouse is several terabytes with a tight load window. In this demo focused presentation, we'll discuss how to use BimlScript to accomplish the following:
- Dynamically create multiple SISS packages for a data warehouse ETL load, each following a different best practice design pattern.
- Automatically execute each package multiple times and record the results for analysis.
- Determine which package version should be used in production.
The only way to be sure that your SSIS packages are performing optimally is to test them against multiple patterns. Make your life easier and let BimlScript do the work for you.
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.