FWSSUG Meetings

-August 2017+
SMTWTFS
303112345
6789101112
13141516171819
20212223242526
272829303112
3456789
  • RSS
  • Add To My MSN
  • Add To Windows Live
  • Add To My Yahoo
  • Add To Google

Statistics

  • Entries (93)
  • Comments (0)

Jan 19, 2011 Tim Costello and Data Visualization 

Monday, January 10, 2011 10:11:00 PM Categories: Meeting

 

 

Our special guest runs his very own user's group over in Addison for Tableau. He has been a SQL Server professional for many years and has now extended into Tableau and heavy data visualization. Tim has taught us some great SSIS stuff in the past, but know he wants to focus our attention on how to visualize our data. You probably think in tables and code. If you really want to reach your audience, think about how to present it visually. 

 

This month, we will be meeting in the same location you're all used to, except we will be using an upstairs room.  It's the Tim room, in fact. Every time he presents, this is his room. Maybe Freese & Nichols will paint it yellow to match his laptop.  Thanks again to Mark and Freese & Nichols for hosting us.

 

Other learning opportunities:

 

  • Free videos for Master Certification training:

http://www.sqlskills.com/T_MCMVideos.asp

 

Dec 2010 - No Meeting: Happy Holidays from Fort Worth SQL Server Users Group! 

Sunday, December 12, 2010 11:08:00 PM Categories: Meeting

 

It's the third Wednesday of the month, but We are not meeting in December in observance of holiday mania/joy.

 

We wish you glad tidings of a slight increase in hiring! We have quite a few jobs coming up, particularly in Oklahoma City.

 

Enjoy the season, and see you January 19th.

 

 

Nov 17, 2010 Bryan Smith Wrote THE Book on MDX 

Monday, November 8, 2010 10:03:00 PM Categories: Meeting

 

If you have never gotten to hear this well known SQL author break it down for you, you're missing out. Bryan is going to take us on a foray through MDX.

 

Bryan Smith is a SQL Server Specialist with Microsoft in Dallas, TX. Before joining Microsoft, Bryan served as a senior architect and trainer with Hitachi Consulting.  At Hitachi Consulting, Bryan helped numerous organizations get started with the development of Business Intelligence programs leveraging Microsoft technologies and is the author of several books on SQL Server technologies

Sep 15, 2010 Professor Muttiah Takes Us Back to School on Mapping SQL Server Geospatial Data 

Sunday, September 12, 2010 10:02:00 PM Categories: Meeting

 

Hear a distinguished and seasoned lecturer speak on mapping spatial data types from SQL server 2008 to online virtual earth and google earth mapping services using APIs. The topics covered will include:

 

1). Javascripts for APIs

 

2). AJAX (asunchronous javacript and XML)

 

3). Example use of stored procedure to query spatial data

 

4). Web handler as intermediary between SQL server and VE/GE

 

Dr. Muttiah even promised to hit a little dojo.connect listener for ArcGIS if he has time and if we are good boys and girls.

 

Aug 18, 2010 Mark Valentino's Geospatial Mania 

Sunday, August 8, 2010 10:01:00 PM Categories: Meeting

 

Our Mascot and host takes the stage to showcase geospatial data types. Mark has worked with ArcGIS for far longer than SQL has supported geospatial data types. He has spent years out in the field and making real life solutions for terabytes of geospatial data. He has deep industry knowledge and I can't wait to hear what he's doing with the new SQL Server 2008 features for geospatial data. 

Jul 21, 2010 Jack Green's Facets & FWSSUG Turns 4! 

Monday, July 12, 2010 9:59:00 PM Categories: Meeting

 

This coming July 21st is our fourth year! Celebration time! We are delighted to have our very own Jack Green share his experiences with policy based management and what he is doing with the new Facets in SQL Server 2008.

 

SQL Server 2008 defines over 70 different facets that can be used to manage SQL Server 2008 instances. This introduction to Policy-based management will discuss how those facets can be used to manage the configuration of your SQL Server 2008 databases.  We’ll cover setting policies to monitor and control your SQL Server 2008 environment using real-life scenarios that you can start using right away to help manage your SQL Server databases more effectively.

 

Jack Green is the Lead Database Administrator at Rapp, a marketing an advertising firm located in Las Colinas. They are currently using policy-based management to manage over 30 SQL Server 2008 instances.

Jun 16, 2010 Trevor Barkhouse's PowerShell Cookbook for DBAs 

Wednesday, June 16, 2010 9:58:00 PM Categories: Meeting

 

OK, we’re finally past the newness of PowerShell and have some great scripts to apply directly to SQL Server. Trevor has a great show and tell lined up for us!

Description:     This introduction to PowerShell is different than most.  Instead of starting with a full treatment of the language, you will receive a brief overview then a collection of “recipes,” stand-alone PowerShell scripts that automate various administration tasks for SQL Server 2000, 2005, and 2008.  You will learn by example, and quickly realize why investing a little time into learning PowerShell will make your job a great deal easier.  Despite the title, there will be value for database and business intelligence developers too!

Biography:       Trevor Barkhouse is an Escalation DBA for Terremark Worldwide, Inc., a leading global provider of IT infrastructure services.  His passions are automation, performance tuning, and troubleshooting.  Trevor is very active in the community. In addition to recently finishing a term on the board of directors of the North Texas SQL Server Users Group, he has spoken at many user group meetings, three SQLSaturday events, and at the 2009 PASS Community Summit.

Web site:          http://SQLServerSleuth.com/

May 19, 2010 Professor Stewart Rogers What Business Intelligence Really Means  

Wednesday, May 5, 2010 9:55:00 PM Categories: Meeting

 

We have a very special opportunity for you to learn from Professor Stewart Rogers of the Business Intelligence Graduate Program at SMU – Cox School of Business!
 

Professor Stewart Rogers is going to give us a rare and valuable insight into what Business Intelligence really means to the corporate world and how YOU can enable their Business Analysts to do their analysis work without overburdening Report Writers.

 

Some of the topics Professor Rogers will cover will be:

·         Tips and tricks for identifying, (via the SSIS DNS Test Connection)

·         Which applications are being called and how to optimize this

·         Why and when to use Excel as a reporting tool

·         The Pro's and cons of using Excel pivot tables as a reporting and alternatives to pivot tables

(collecting SQL data and creating dynamic Excel reports in the formats that are actually being utilized for large corporations by their Business Analysts (using 7-11 as an example of this methodology)…in other words, pushing into specific Excel fields exactly what the BA’s are having to cut’n’paste and restructure into their spreadsheets to perform their Business Analysis, such as the Pivot Tables in Excel as they almost always need).

·         How to take slices from a data warehouse and move into a smaller stand-alone database for portability to locations that have no external connectivity or have limited software approaches (small businesses or remote businesses that must rely on stand-alone solutions such as SQL Express or Access databases), which actually enables DBA’s to branch out to assist in or create solutions for a turn-key data analysis solution for small to medium businesses or even large corporations when their business processes restrict their network connectivity.

 

Apr 21, 2010 Jason Massie Running Mixed Workloads on SQL Server 

Sunday, April 18, 2010 8:21:00 AM Categories: Meeting

 

Those of you who have had the privilege to hear MVP Jason Massie speak know the surprising new twists and depths he brings to a topic. Check out his blog: http://statisticsio.com/  And come check him out this Wednesday. 

 

 

In an ideal world, you can separate your OLTP traffic and reporting so the databases can be optimized for their respective workloads. In the real world, this is not always an option. Business requirements may require real time data which means reporting off of the OLTP environment. We will first look at the shortcomings of different reporting solutions. We will then look at features that help a mixed workloads play nicely together. Some of these features include filtered indexes, indexes views, persisted computed columns, data compression, resource governor, partitioning and others. We will also touch on database design concepts that can help mixed workloads and leave you with topics to research further so you master the juggling act that is mixed workloads

Mar 17, 2010 Andy Eggers and his Glorious Time Calculations! 

Wednesday, March 10, 2010 8:20:00 AM Categories: Meeting

 

Who needs a little more BI? Since we just finished up a weekend SSAS classes with Michael Hotek, we'd like to keep the BI discussion rolling.

Any of you that have come for the classes or the monthly meetings know that if you give Andy Eggers 5 minutes he will bubble over about analysis. He loves analysis and he loves talking about it. He also has some really nifty time calculation tools and tips to share. You have to see his time dimension! It never occurred to me all the ways to calculate the fiscal and calendar years and the business days in this detail.

This is real customer analysis you can do on site, now. This should be a real treat.

Come see Increasing Customer Loyalty Using Business Intelligence with Andy Eggers.

 

After the meeting, follow Brian to the Covey just north on Hulen to address the St. Patty's day portion of the equation.

 

See you there,

Judith

Page 9 of 10 << < 1 2 3 4 5 6 7 8 9 10 > >>
Site Map | Printable View | © 2008 - 2017 Fort Worth SQL Server Users Group | Powered by mojoPortal | HTML 5 | CSS | Original design by Andreas Viklund