FWSSUG Meetings http://www.fwssug.com/meetings.aspx http://www.rssboard.org/rss-specification mojoPortal Blog Module en-US 120 no An introduction to the Azure Data Lake and U-SQL 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
altadmin]]>
http://www.fwssug.com/an-introduction-to-the-azure-data-lake-and-u-sql.aspx mjmsqldroid@gmail.com (altadmin) http://www.fwssug.com/an-introduction-to-the-azure-data-lake-and-u-sql.aspx http://www.fwssug.com/an-introduction-to-the-azure-data-lake-and-u-sql.aspx Mon, 17 Oct 2016 14:36:00 GMT
Dynamic SSIS packages using C# and BIML: Paul LaGrone 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.


dbo.judith]]>
http://www.fwssug.com/dynamic-ssis-packages-using-c-and-biml-paul-lagrone.aspx http://www.fwssug.com/dynamic-ssis-packages-using-c-and-biml-paul-lagrone.aspx http://www.fwssug.com/dynamic-ssis-packages-using-c-and-biml-paul-lagrone.aspx Mon, 18 Jul 2016 04:56:00 GMT
The Modern Data Warehouse in the Cloud with Azure 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
altadmin]]>
http://www.fwssug.com/the-modern-data-warehouse-in-the-cloud-with-azure.aspx mjmsqldroid@gmail.com (altadmin) http://www.fwssug.com/the-modern-data-warehouse-in-the-cloud-with-azure.aspx http://www.fwssug.com/the-modern-data-warehouse-in-the-cloud-with-azure.aspx Sun, 12 Jun 2016 20:01:00 GMT
April 20: Intro to Agile Data Warehouse Design altadmin]]> http://www.fwssug.com/april-20-intro-to-agile-data-warehouse-design.aspx http://www.fwssug.com/april-20-intro-to-agile-data-warehouse-design.aspx http://www.fwssug.com/april-20-intro-to-agile-data-warehouse-design.aspx Mon, 18 Apr 2016 03:45:00 GMT Jan 20 No 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.
dbo.judith]]>
http://www.fwssug.com/jan-20-no-meeting.aspx dbo.judith@gmail.com (dbo.judith) http://www.fwssug.com/jan-20-no-meeting.aspx http://www.fwssug.com/jan-20-no-meeting.aspx Tue, 19 Jan 2016 03:25:00 GMT
Time out for our hosting provider dbo.judith]]> http://www.fwssug.com/time-out-for-our-hosting-provider.aspx dbo.judith@gmail.com (dbo.judith) http://www.fwssug.com/time-out-for-our-hosting-provider.aspx http://www.fwssug.com/time-out-for-our-hosting-provider.aspx Fri, 09 Oct 2015 02:27:00 GMT Happy New Year - And Get Well Soon! Well wishes to our Mascot who is recovering. Let's all wish him a much better rest of the year.

We normally facilitate a small segment of time the third Wednesday of the month to get together and learn about SQL Server and related database technologies. 

We want to start out the first quarter of 2015 a little differently How about we trade you three Wednesday evening 1 hour sessions for 3 full day training classes? Would you take that trade? 

We are finalizing another round of Saturday classes. Back by popular demand, Mike Hotek is giving up more of his weekend time. 

The 3 days of topics coming the last Saturday in Feb and the first two Saturdays in March: 

Real World Data Warehouse Build

You’ve seen plenty of theoretical articles, lots of demos of disconnected snippets of solutions.  We’re going to take all of these items plus a lot more and put them together into something useable and practical to build a real solution from start to finish. This class will provide the knowledge necessary to implement all of the processes you need to quickly, flexibly, and incrementally build out a data warehouse.  You don’t need weeks of contiguous blocks of time, you just need a few hours here and there, directed appropriately to have a large impact. In this class we will cover the following:

Team Foundation Server (TFS)

What it is, how you use it, and why you need it (or a tool like it)

Source code control

What it is, how to implement it, how to manage your source code, branching/merging

 Work items

Planning your work

Packaging into deliverable components (user stories)

Breaking down business deliverables into technical tasks (tasks)

Estimating work

Work flows

Data modeling

Building out a warehouse model

Source control

Data Dictionaries

Tagging

Automation macros

Basic ETL framework

Building your T-SQL layer

Merge procs

Watermark procs

Code generating the T-SQL layer

Unit testing

                     What is it, why you do it, how you do it

ETL workflows

Code generating the T-SQL layer

Code generating your SSIS packages using Biml

SSIS deployments

Parameters

Environments

References

 


dbo.judith]]>
http://www.fwssug.com/happy-2015-and-get-well-soon-.aspx http://www.fwssug.com/happy-2015-and-get-well-soon-.aspx http://www.fwssug.com/happy-2015-and-get-well-soon-.aspx Wed, 14 Jan 2015 04:29:00 GMT
Happy New Year to Our Fellow SQL Enthusiasts!  

Happy new year to our fellow SQL enthusiasts from the folks at the Fort Worth SQL Server Users Group!

 

Our new year's resolution every year is to stay current and master the technologies that make us quality professionals and help us explore patterns and move data.

 

We are a community-based organization which provides, promotes, and directs people to opportunities, education, training, and fellowship related to Microsoft SQL Server and other database technologies in the DFW area.

 

We facilitate occasional weekend classes  and host monthly meetings to cover topics ranging from SQL queries, SQL Server Reporting Services, SQL Server Integration Services, SQL Server Database implementation and maintenance, Business Intelligence, SharePoint and more.

 

We have a great spring lined up for you:

 

January 15: Bryan Smith - Hadoop!

February 19: Tim Mitchell

March 19: Michael Bourgon

April 16: Ryan Adams


dbo.judith]]>
http://www.fwssug.com/happy2014.aspx http://www.fwssug.com/happy2014.aspx http://www.fwssug.com/happy2014.aspx Tue, 07 Jan 2014 23:49:00 GMT