Speaking at SNESSUG

October 13, 2010 at 3:10 pm (SNESSUG) (, )

I’ll be presenting tonight at the Southern New England SQL Server Users Group (SNESSUG). The topic is “Using DMVs as a Shortcut to Query Tuning.” It’s a practice run for my spotlight session at the PASS Summit, so if you can’t make it to the Summit, you should swing by Rhode Island.

Permalink Leave a Comment

In the Clouds

July 14, 2010 at 7:15 am (SNESSUG) (, , , , )

The July meeting for the Southern New England SQL Server Users Group is tonight. Andrew Novick will be talking about SQL Azure. It’ll be a great meeting. Our sponsor is Red Gate. They bought pizza.

Permalink 2 Comments

SNESSUG 4/14/2010

April 14, 2010 at 7:32 pm (SNESSUG, Visual Studio) (, , , )

Tonight’s Southern New England SQL Server Users group is sponsored by Idera. Our presenter is Scott Abrants of Iron Mountain. He’s talking about deploying databases using Visual Studio Team System:Database Edition. We have a good turnout with 12 people (yeah, we’re small).

Scott’s presentation was a lot of fun and very informative. He’s very involved with automating his deployments to a fare-thee-well. He really has Visual Studio dancing and singing. It was a very thorough overview of the VSTS:DBE soltuion. Other user groups should be jealous that we got to see this presentation.

Permalink 3 Comments

Southern New England SQL Server Users Group

April 13, 2010 at 11:02 am (SNESSUG) (, , , , )

Tomorrow, Wednesday April 14th, is the next SNESSUG meeting. We’re going to get a great presentation from Scott Abrants on using Visual Studio Team System for database deployments. I saw Scott presenting this at SQL Saturday:Boston to a packed room. If you didn’t get to see it then, come on down to Rhode Island tomorrow evening. You won’t be sorry.

Permalink 1 Comment

SNESSUG March Meeting

March 15, 2010 at 6:17 pm (SNESSUG, SQL Server 2005, SQL Server 2008) (, , )

Aaron Bertrand showed up to teach us tips and tricks for SQL Server Management Studio. We had to move our meeting night because of a conflict at our wonderful host, New England Tech. But we still had 12 people show up. For SNESSUG, that was a good turnout. I gave away some swag that I had received from Microsoft and some stuff that we had purchased. Bribary works (at least that’s my theory, so feel free to bribe me, whenever).

Aaron’s presentation was great. He’s just showing nothing but meat. There’s no fluff. He’s just showing a series of tips & tricks in SSMS and explains why you want to use them. First revelation, -nosplash has no effect whatsoever on load time. He called it a placebo. It just kept going from there. Aaron’s stated goal was to make everyone in the audience say “wow” or “cool” at some point during the presentation. I’m pretty sure he succeeded. The first one that got a lot of people is when he demonstrated setting the connection color so you can track different connections visually on your screen. My personal one was the Registered Servers import list so you can maintain a common list, move copies around, share registered server lists within your team… I love learning stuff at a good presentation.

Oh yeah, and everyone said “wow” or “cool” at least once.

Permalink 1 Comment

New England Data Camp v2/SQL Saturdy #34 Update

January 11, 2010 at 8:04 am (SNESSUG) (, , , )

The second annual New England Data Camp is shaping up to one excellent event. We’ve put together a great set of sponsors. Thanks to them we’re providing much better food than last year and the chance at a bit of swag, again, better than last year. But, most importantly, we have an excellent selection of speakers. The schedule has been posted so you can go and check it out and start laying out which ones you can hit. Some of the people speaking are known internationally (Adam Machanic, Aaron Bertrand), some are local luminaries, some are up and coming, and several are probably on the fast track to being MVP’s. In other words, this is the place to go to learn something about SQL Server in New England.

It’s not too late to register, and of course you can register at the door. It’s a free event and, as you can see, it’s going to be very educational and useful.

And don’t forget your local user groups. Southern New England SQL Server Users Group has Adam Machanic speaking this Wednesday, and on a different topic than he’s presenting at the Data Camp, so it’ll be worth visiting both.

Permalink 2 Comments

SQL Saturday #34/New England Data Camp v2.0

November 30, 2009 at 1:54 pm (SNESSUG, SQLServerPedia Syndication) (, , , , )

It’s official sports fans. Well, it’s been official since last week since Adam Machanic set up the web site. The New England SQL Server Users Group and the Southern New England SQL Server Users Group are again jointly hosting a full day of SQL Server goodness on January 30th. The call for sponsors and speakers is open. We already have several local luminaries lined up to present including Aaron Bertrand on Management Studio Tips & Tricks and Scott Abrants on Automating Database Deployments with Visual Studio.

Please register to spend a day with your peers, learning and networking. It’s being held at the Microsoft Waltham office, a great facility. We should have a full day with lots to do and learn.

Permalink Leave a Comment

SNESSUG September Meeting

October 8, 2009 at 12:31 pm (SNESSUG) (, , , , )

We had a good night with 13 people attending. I ran unopposed for president of SNESSUG for my second, and final, term. We were graced with the prescence of Jeff Moden, MVP and on of the top posters over at SQL Server Central. He was just visiting. He’s a great guy and I was very happy for the chance to meet him in person. Jeff is going to be at the PASS Summit this year, so you too can have a chance to meet him.

The presentation was on SSAS and SSRS by Sunil Kadimdiwan. He did a full introduction of cubes from Excel to Analysis Services, all with the purpose of showing how to generate good reports using Reporting Services. Attendees were very interested in some of the security settings for Analysis Services. Sunil walked us through the use of BIDS, or Business Intelligence Development Studio, to build & modify cubes.  The presentations were well received. Interestingly enough, he used very few slides and spent all his time working through examples.

Then, the fire alarm went off. We lost about 20 minutes.

Sunil came back in and finished up on Reporting Services. He’s a trooper.

Permalink 2 Comments

Community

March 24, 2009 at 12:35 pm (PASS, SNESSUG, SQLServerPedia Syndication) (, , , , , , )

I’m always impressed and amazed with what happens in the SQL Server community. If you need help, there almost always seems to be a willing and able hand that reaches down to pull you up. It happens again and again, all around. I take part in SQL Server Central, one of the best, and biggest, communities out there for SQL Server. The people that pitch in every day are some of the nicest you’re ever going to meet, but they’re also extremely well informed. I regularly benefit from people swinging by this blog to offer suggestions or solutions or improvements to my ramblings. I’ve been making friends and developing contacts at the PASS Summit for the last four years and at my local user’s group for the last two.  I’ve also been using Twitter for some entertainment, chat, and the occasional question or answer regarding SQL Server. You can get involved with Twitter by looking at the list of active DBA’s over at SQLServerPedia.

The reason I’m talking about all this? I’m trying to implement spatial data in SQL Server 2008. I’ve played with it a bit, but now I’m really drilling down for the first time. I have a vendor that’s supply our company with some geospatial information and we need to import it automatically into the database. The format I had was .GML. After searching through the internet, several times, several ways, to try to find whatever methods for loading .GML files had already been worked out, I came up empty handed. Apparently no one does this much. So, in addition to trying to refine or broaden my search to land more pertinent data, I sent out a question on Twitter. I recieved a response very shortly, pointing me to a resource. I sent him a message and I received enough information back to get over the hump I was in. Easy-Peasy Lemon Squeezy. Not only did I have more information than previously, but I had another contact that I hope I can return the favor and help out someday.

Another triumph for networking, communication and community. This stuff works.

Permalink Leave a Comment

PASS Chapter Spotlight

February 11, 2009 at 1:23 pm (SNESSUG)

The Southern New England SQL Server Users Group was picked for the February spotlight on the PASS web site. This was largely based on the work we did helping Adam Machanic run the New England Data Camp. I’ve said it before and I’ll say it again, we helped. Adam did 90% of the work. It’s still good to be singled out. Thanks PASS and thanks to the volunteers at SNESSUG.

Permalink Leave a Comment

Next page »