Wednesday, January 11, 2012 10:45:00 PM
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.
Monday, December 12, 2011 10:44:00 PM
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!
Friday, November 11, 2011 10:43:00 PM
Andy wants to welcome everyone to the Applied Strategic Thinking session at the Fort Worth SQL Server User Group this Wednesday night at 4055 International Plaza, Fort Worth, Texas 76109. We will be discussing ways to strategically plan and prepare ourselves for the learning opportunities coming to us in the next year. Take advantage of the time now to plan, prepare, and choose your future.
Very few people have the passion and drive to get people educated about SQL Server and B.I. like Andy
Tuesday, October 18, 2011 10:41:00 PM
Our first speaker had to cancel due to her mother's passing. Our second speaker is on a flight to be with a family member recently rushed to the hospital.
....we have other folks who have volunteered and we are slightly worried about asking lest we bring medical calamity one of their loved ones by association!
We may cancel the October meeting and remind everyone to cherish your time and your loved ones.
Thursday, August 18, 2011 10:40:00 PM
Synchronous and asynchronous components, memory buffers, data type choices, Oh My!
Tuning the data flow is all about choices.
In this session we'll walk through some of the choices that can give you the biggest performance boosts in your SSIS data flow. Together we'll work through the differences between synchronous and asynchronous components. We'll highlight components that should be avoided and explore alternates that can help us create the fastest data flow possible.
We just ran into Tim at Microsoft the other day and he was NOT sporting his yellow laptop. His company laptop was a very un-Tim gray; though he had made amends with his screaming yellow mouse. In support of Tim, bring your favorite yellow food. We'll make sure we get our US RDA of yellow #5!We will be providing food as usual, just of a slightly different hue.
Thursday, August 11, 2011 10:39:00 PM
No. He's still camped out in Denali land, but he'll take a break from researching and writing about the latest release of SQL Server code named Denali to let us know what new tools we may soon get to use. He's trekked farther up and farther in with CTP 3 and has some great stories to share around the campfire.
Bring your s'mores, but don't set off Mark's sprinkler system.
Sunday, July 10, 2011 10:37:00 PM
A Chalk Talk on Scheduling: Understanding How SQL Server Decides What to Do
In this informal and interactive session, we will discuss how SQL Server determines what to execute. Along the way, we'll cover locking and blocking as well as wait statistics. If we finish early, be ready for some Pictionary!
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 has spoken at many user group meetings, seven SQLSaturday events, the 2010 Houston TechFest, CodeStock 2011, and last two the PASS Community Summits (North American).
Check out his blog at http://sqlserversleuth.com/
This spring SQLRally 2012 is coming to Dallas. If you get the chance to vote for speakers, vote for Trevor and all the great folks who facilitate our meetings. http://www.sqlpass.org/Community/PASSBlog/entryid/342/Dallas-Hosting-PASS-SQLRally-2012.aspx
This July is our 5th anniversary meeting as the Fort Worth SQL Server User Group. As a gift, we were given SQL Server Denali CPT 3! It was really great of Microsoft to get that out the door for us like that. Very thoughtful. It's like "Uncle Bill" sent us flowers. There will be additional pictures, food and merriment. Can't wait to see you all again.
Book Swap: We cleaned out our bookshelves. We're bringing them in for a book swap and give away. If you bring books, please take them back home if no one takes them. We will already have a truck load and don't wish to add to it. Bring your wheel barrows.
Friday, June 10, 2011 10:35:00 PM
SSIS framework provides centralized logging and Auditing of package execution, tracking the number of Good records and bad records, notification of errors, and migration of SSIS packages into production with minimum of issues. Come join our own Andy Eggers for an evening of SSIS Framework HOW TO!
Friday, May 13, 2011 10:34:00 PM
Many of us have had the frustration of trying to convince “the company” of the great benefits a data warehouse would provide for them only to have the notion swept under the rug or fall on deaf ears!
David Stein is a SQL Server Business Intelligence DBA specializing in designing, developing, and maintaining Data Warehouses using Microsoft BI Tools.
Monday, April 18, 2011 10:28:00 PM
TOPIC: An Introduction to Profiler and SQL Trace
Profiler (and its underlying subsystem, SQL Trace) is a tool for recording a SQL Server instance's activity. This diagnostic and performance data is valuable for troubleshooting and characterizing a system's workload. Like any powerful tool, misuse can be quite harmful, so great care must be exercised. This session will teach you how to efficiently configure, run, and analyze the data from traces, while minimizing the overhead of the data collection and avoiding common pitfalls.
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 has spoken at many user group meetings, seven SQLSaturday events, the 2010 Houston TechFest, and last two the PASS Community Summits (North American).