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
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.
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
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
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!
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.