Speaking at SNESSUG

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.
Read More

In the Clouds

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.
Read More

SNESSUG 4/14/2010

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.
Read More

Southern New England SQL Server Users Group

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.
Read More

SNESSUG March Meeting

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…
Read More

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

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.
Read More

SNESSUG October Meeting

PASS
The Southern New England SQL Server Users Group's October meeting was a bit sparsely attended with 7 attendees. The sponsor for the night was ApexSQL. The presenation was by AJ Dharmapuri who spoke on using DMV's. Barbara Sampson, SNESSUG Treasurer, did a demo of ApexSQL's SQLEdit. It's a pretty powerful TSQL coding and scripting tool. There's a lot of functionality that worked in a very snappy way during the demo and looked great. I may need to spend some time with their products to see if we can put them to work. As part of the sponsorship, we gave away a license for the Apex SQL Univeral Studio. Quite a prize. I was very excited to see AJ's presentation for a few reasons. First, because he presented on DMV's, based…
Read More

SNESSUG September Meeting

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…
Read More

Recap of Cape Cod .NET User's Group

PASS
I presented last night at the Cape Cod .NET User's Group. What a great bunch of people. About 20 people showed up at the nice facility they're using, Venture Think Together. A little pizza and a little chat and the meeting got started. Marcia McLean, their president, gave me a nice little introduction and I went through my slides. As I did them, I kept thinking about some of the advice offered up by Brent Ozar yesterday. Suddenly my slides seemed so wordy. It started to throw me off, but I just ignored it & plowed on. Overall, I think the presentation went well. I hit a couple of snags on some of the examples that I'm going to tweak before I present this at the PASS Summit in just…
Read More

Simple Talk Editorial on PASS

PASS
If you don't subscribe to the Simple-Talk newsletter, why not? This month's newsletter is chock full of interesting stuff, a DBA checklist from Brad McGehee, a workbench on keys, an article on how covering indexes are faster than clustered indexes (they are too), and an article on why one DBA is learning PowerShell (I want to, but my spare time is taken up with writing a new book). All great stuff and worth reading. I'm going to be reading all these articles, but the most fascinating piece of the current newsletter is the editorial by Tony Davis. I was actually a little shocked by it. I'm a PASS volunteer for the Special Interest Groups and the Editorial Committee. I've attended the last three PASS events. I'm the current president and…
Read More