Posts in Category: Meeting

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

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

April 20: Intro to Agile Data Warehouse Design 

Speaker: Tim Costello
Sunday, April 17, 2016 10:45:00 PM Categories: Announcement Meeting
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

March 16 Meeting Cancelled 

Wednesday, March 16, 2016 10:37:00 AM Categories: Meeting
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!

Feb 17 Meeting: Strategic Career Planning with Andy Eggers 

Monday, February 15, 2016 9:12:00 AM Categories: Meeting
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

Jan 20 No Meeting 

Posted by dbo.judith Monday, January 18, 2016 9:25:00 PM Categories: Announcement Meeting

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.

What Lurks Beneath your SQL Server : WMI & Error Logs for the Rest of Your Environment with Michael Bourgon 

There's more to it than just SQL Server
Friday, October 16, 2015 3:38:00 PM Categories: Meeting
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.

Sept 16 Meeting - SSIS Performance Tuning with BimlScript - David Stein 

Sunday, September 13, 2015 10:23:00 PM Categories: Meeting
Abstract:
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.
 
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.
 
Page 1 of 8 1 2 3 4 5 6 7 8 > >>
Site Map | Printable View | © 2008 - 2017 Fort Worth SQL Server Users Group | Powered by mojoPortal | HTML 5 | CSS | Original design by Andreas Viklund