Tuesday, May 15, 2012 7:52:00 AM
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.
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
Sunday, April 29, 2012 10:26:00 PM
Friday, April 13, 2012 6:15:00 AM
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
HBA (Host Bus Adapter)
PCI Express BUS
SVC (San Volume Controller)/Zoning
Disk Array / Striping
A SAN by ANY Other Name
SAN in a Box//Card - Direct Attached Storage (External & Internal)
NAND Flash Drives (Fusion IO)
How does a SAN work?
SAN Fabric, Management, HotZones
CLUSTER AWARENESS and SOFTWARE RAID by VERITAS: Why it hurts and how bad.
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
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
Thursday, March 1, 2012 10:56:00 PM
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!
Monday, February 13, 2012 10:46:00 PM
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.
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.