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)

Aug 15, 2012 Kellyn Pot'vin: Curious About Oracle?  

Monday, August 6, 2012 5:49:00 PM Categories: Meeting

Are you curious about Oracle, but afraid to admit it?  It is common for many DBA's to be biased to one database platform, but it has become more and more demanding of the database administrator to manage and have a firm knowledge of more than one in many environments.  This session will introduce the SQL Server DBA to Oracle in a way that will meet their day to day challenges in a multi-platform database environment.  Come learn about how Oracle and SQL Server are very similar, different and how to translate common concepts in SQL Server to Oracle database administration.  No prior experience in Oracle is required and important features and concepts will be covered to assist the SQL Server DBA in incorporating Oracle into their database skill set.

 

Kellyn Pot'vin, (pronounced Poet-Vaughn) has been a Database Administrator for over twelve years, specializing in large database performance tuning for myriad of platforms, including Oracle, MSSQL and MySQL. In recent years she's been working with large SSD databases and Exadata, taking advantage of the newest technology and performance tuning features. Kellyn is known for her technical blog, dbakevlar.com and resides on the board of directors for the Rocky Mountain Oracle User Group, (RMOUG).  She is an Oracle ACE recipient and database track volunteer for ODTUG’s, (Oracle Developer Tool User Group) KSCOPE 2012 Conference.  She's performed numerous presentations in the US and Europe, along with articles for various technical newsletters and websites.  She is a current contributor to oradbpedia.com and a contributing author for Apress.  Kellyn lives with her partner, Tim and her three children in Broomfield, CO and currently is honing her technical skills at Enkitec, an Oracle-centric consulting partner, (www.Enkitec.com)

 

 

Food at 6:30

Lecture at 7PM

 

​See you there

​The folks at the Fort Worth SQL Server Users Group

 

​We meet the third Wednesday of most months

July 18, 2012 David Stein: Have you got the Urge to Merge? 

Monday, July 9, 2012 6:10:00 PM Categories: Meeting

 

The T-Sql Merge statement, introduced in SQL 2008, is powerful, versatile, and performant. However, it is also one of T-SQL's least understood statements. Most DBAs know they can use It to insert, update, and delete data in a target table in a single transaction, generally outperforming separate statements. Fewer know, however, that it can be used to load slowly changing dimensions, facilitate auditing, and for many other uses. Come to the user group meeting and learn the in and outs of T-SQL Merge. I'll even show you how to write complex Merge statements with lightning speed.

 

David Stein is a Senior Business Intelligence Consultant with WaveTwo in Irving, TX. He’s worked in SQL Server Business Intelligence for almost a decade, designed Data Warehouses from scratch, as well as saved projects in serious jeopardy. He is also very active in the community, having spoken at PASS events at all levels, including the PASS Summit, SQL Rally, and at numerous SQL Saturday events and user groups.

 

You can learn more about Data Warehousing, Business Intelligence, and other technical topics on his blog at Made2Mentor.com or follow him on Twitter, @Made2Mentor.

 

 

Food at 6:30

Lecture at 7PM

 

​See you there

​The folks at the Fort Worth SQL Server Users Group

 

​We meet the third Wednesday of most months

 

June 20, 2012 Trevor Barkhouse: Quantitative Analysis of SQL Server Error Logs  

Sunday, June 17, 2012 7:56:00 AM Categories: Meeting

Our favorite SQL Sleuth is back! Trevor has transmogrified into an outstanding speaker and educator. You can follow his tweets at @SQLServerSleuth. He's doing a very engaging and interactive talk this Wednesday that you won't want to miss. Show up and be heard. 

Abstract: The SQL Server error log is essential for managing SQL Server.  Unfortunately it is a flat text file that defies efficient analysis.  There is a new open-source tool (a PowerShell module) that breaks the contents of the error log into data that can be queried and aggregated.  Come and learn how to finally unlock all of the valuable information that has been hiding in your log files!

Speaker biography: Trevor has been a production or escalation DBA for almost a decade. He recently joined Microsoft CSS as a Senior Support Escalation Engineer for Microsoft SharePoint. Trevor's passions are automation, performance tuning, and troubleshooting.  He has spoken at dozens of user group meetings, SQLSaturday events, and conferences.

 

 

 

Excited post Tech-Ed chatter and munchies at 6:30
Error Log Intel at 7PM

 

​See you there

​The folks at the Fort Worth SQL Server Users Group

 

 

May 16, 2012 Judith Hotek : SQL 2012 File Table in Use 

Tuesday, May 15, 2012 7:52:00 AM Categories: Meeting

We've all been very excited about all the promise  the File Table feature extension holds.

 

Can you imagine being able to finally dump unstructured files into SQL Server and still be able to access them in their native format in windows explorer? There's no ugly GUID names as there was with File Stream only in 2008. Your existing apps can simply reference a file share and not have to be rewritten to go through SQL Server. Sound too good to be true? Try implementing it and you will learn there are trade offs. 

 

Two of your comfortable old tools, a SQL Server  table and a file folder,  will look like they used to but will behave in quirky knew ways till you get used to the new combination.

 

Other considerations:

Just how well does File Table play with Antivirus? What does the security look like? What nasty files and apps could someone drop onto my SQL Server??  What do you mean non-transacted data? Can I track who is looking at files this way? Can I replicate these files and back them up? What happens if I detach a file table? Will it ever reattach? What happens if I reference my file table rows in other tables to add metadata? We can't get to demos for all those questions in one hour, but they are the sorts of things to start asking yourself if you think this might be a great solution for some of your business needs.

 I've been dragging my feet on emailing you the monthly meeting announcement because it's me speaking this time around. We meet the third Wednesday of most months in southwest Fort Worth. Thank you  Mark Valentino and Freese & Nichols for graciously hosting us!

Food and friends at 6:30

File Table exploration at 7PM

Judith

 

 

Apr 18, 2012 Brian Guarnieri SAN TOPOLOGY 101: How do I know if my SAN Administrator is lying to me?  

Friday, April 13, 2012 6:15:00 AM Categories: Meeting

Our very own Brian G is back at the podium to talk about all the SAN stuff no one in the database world seems to talk about but we all have to understand.

Your job is to use up disk resources and the SAN man's job is to protect and keep those resources. So the fight is on! G.I. Joe says knowing is half the battle. Here's some of what Brian will arm you with:

What is a SAN Anyway?

  • Quick review of RAID 5, 0, 1, 10, 1+0
  • Common SAN Data Protocols
    •   SCSI
    •   i-SCSI
    •   Fibre Channel
  • Connective Media
    •    Fibre Optics
    •    Ehternet

   

  • SAN Components
    •    HBA (Host Bus Adapter)
    •    PCI Express BUS
    •    SVC (San Volume Controller)/Zoning
    •    SAN FABRIC 
    •    SWITCHES
    •    Disk Array / Striping
  • A SAN by ANY Other Name
    •      SAN in a Box//Card - Direct Attached Storage (External & Internal)
    •      NAND Flash Drives (Fusion IO)
    •      RAM SAN (RAM SAN) 

     

  • How does a SAN work?
    •      SAN Fabric, Management, HotZones
    •      Zoning
    •      CLUSTER AWARENESS and SOFTWARE RAID by VERITAS: Why it hurts and how bad.  
    •      Putting it all together
  • How do I know if My San Administrator is lying?
    •      What does he look like? Is he shifty? 
    •      Latency verse Bandwidth
    •      T-SQL Queries to show the Jig is up
    •      SQL Simulator
    •      IOMeter
    •      How many spindles is enough? Spindle Gluttony.
    •      Why does my Latency graph have a Heart Beat?

 

 

 

​Food and Wookiee Language Lessons at 6:30 (See Jack)

Fun with SANs at 7:00

 

​See you there

​The folks at the Fort Worth SQL Server Users Group

 

​We meet the third Wednesday of most months

 

 

 

 

Mar 21, 2012 Mike Hotek DBA 101 

Thursday, March 1, 2012 10:56:00 PM Categories: Meeting

Back in January Mike Hotek had two topics. Hierarchy IDs ended up being a substantial enough topic to hog up the whole meeting. He's offered to take a break from writing his SQL Server 2012 books and come back to address that second topic.  

He's back in March with DBA 101: Figuring out THE most important deficiency 

You walk into or are handed a completely dysfunctional SQL Server environment, where do you start and how do you fix it without going insane or working 200 hours a week.

 
Also, March 7th is the SQL 2012 online launch event: http://www.sqlserverlaunch.com
 
Editorial note: For those of you who joined in the Hierarchy data type and graph theory discussion, did you run home and reread some of the NoSQL buzz that has been surfacing the last few years? Graph databases may be finding their niche to solve a number of interesting problems but the needs of most business still rest on good old relational databases. Fortunately our good old relational DBMS can handle some interesting graph theory problems as well. 
 
Join us on the third Wednesday of the month.
Post SQL Server 2012 launch buzz and munchies at 6:30 PM
Michael Hotek SQL Server experience download starting at 7 PM
 
See you there!

 

 

Feb 15, 2012 Tim Costello Building Your Visual Vocabulary 

Monday, February 13, 2012 10:46:00 PM Categories: Meeting

 

The yellow laptop rides again!

 

Bars, lines, dots, bullets and pies. The choices can be overwhelming. Data visualization is the art of using shape, color, size and proximity to tell stories with your data. In this session we will explore the building blocks of data visualizations, discuss some of the most common visualization types and talk about when and how to use them to tell stories with your data.

 

We meet most 3rd Wednesdays of the month. See you at 6:30 for snacks and and shared SQL stories and 7 for the presentation.

Jan 18, 2012 Mike Hotek Using the HierarchyID and DBA 101 

Wednesday, January 11, 2012 10:45:00 PM Categories: Meeting

 

We have a topic for each end of the experience spectrum. For those that have done quite a bit with SQL Server:

 

1.      Using the HIERARCHYID data type

What a tree is and the basic rules around trees, what is a hierarchyid, inserting data, retrieving data, changing the tree structure (reparenting and adding new branches)

 

For those of you getting into it and for those who are about to move companies again here's a great reminder topic:

 

2.      DBA 101 – Figuring out what is THE most important deficiency

You walk into/are handed a completely dysfunctional SQL Server environment, where do you start and how do you fix it without going insane or working 200 hours a week.

 

It's Mike Hotek so you know there will likely be something relevant no matter what your experience level.

 

Dec 2011 No Meeting 

Monday, December 12, 2011 10:44:00 PM Categories: Meeting

 

We usually meet the third Wednesday of the month, so that means we usually skip the December meeting in favor of the holiday season. We must prepare to receive our annual lumps of coal and other merriments!

 

We'd like to encourage you all to book a slot to speak next year! Email us with your topic proposals. Mary and Andy and Brian have been out talking with folks  and asking what they'd like to learn about.

 

We'd also like to encourage and foster ACTION in 2012. We want to hear about what you have implemented as a result of what you learned in a meeting or from a class. We would also like to know what certs you scored as a result of this group, or the cert study group the two Brians formed. 

 

It's easy to go to any number of user group meetings or SQL classes, but it's another step to wrestle the time out to DO what you learned.

 

If you have a great story about what you did with what you learned, we want to hear about it. We want  your SQL Server stories.

 

Happy holidays to you all from the folks at the Fort Worth SQL Server Users Group!

Page 7 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