Select ALL THE THINGZ!

There are some T-SQL best practices that I have been hearing about for so long that it surprises me when I run into people who don’t know about them. Then I remember “every single person in the world starts out with absolutely zero knowledge about SQL Server“. With that in mind I have decided to document some of the things I have been seeing a lot of recently. I have been working on a project refactoring T-SQL for the past several months and one of the patterns I replace without thinking about it is

SELECT *

Continue reading

Advertisements

Lets Hear it for the Board (T-SQL Tuesday #59)

This month’s host for T-SQL Tuesday is the Real SQL Guy, Tracy McKibben (blog|twitter). In honor of Ada Lovelace Day Tracy has asked us to write about our heroes. I think Ada Lovelace is a great example of a hero and an inspiration as the first computer programmer, but I’ve decided to make my focus a little more local.

A little over two years ago I was starting to get more involved in PASSMN. The people on the PASSMN Board inspired me with their commitment and willingness to donate their time and knowledge to the Minnesota SQL Server community. At the time I didn’t know the board members as people. I viewed them with a certain amount of awe and nervously volunteered to speak and to help with events like SQL Saturday. It was easy to see them as heroes and they inspired me to push myself.

Maybe it is all of the activity these days around planning the current SQL Saturday, but I realized that I am now working side by side with some of these amazing people. My heroes are my fellow board PASSMN board members. They all do work that no one ever knows about and put in hours of volunteer time to help create the great SQL Server community we have here in Minnesota. I can’t begin to list all of the work these people do, but I want everyone to know how great they are. In no particular order here are the PASSMN Board heroes:

Continue reading

PASSMN September 2014 Meeting

MSPASSMNLogo

Next Tuesday (9/16) is the September meeting for the Minnesota chapter of the Professional Association for SQL Server (PASSMN). Our main presenter this month is the Paula Merns. Paula will be expanding on her checklist presentation from last December and showing us how she uses checklists as a database professional. In addition to the main topic we will have a short presentation on using XML functions to create correlated lists by Riley Major.

Continue reading

PASSMN August 2014 Meeting

MSPASSMNLogo

Next Tuesday (8/19) is the August meeting for the Minnesota chapter of the Professional Association for SQL Server (PASSMN). Our presenter this month is the Ross McNeely (twitter | blog). Ross will be presenting a Spatial Data Deep Dive going over Spatial Data types, the Bing Spatial Data Services, and Spatial Analysis. It is a topic I haven’t taken much time to dig into, but it seems like almost every company I have worked at has some sort of geospatial data.

Continue reading

Today’s Topic is SQL Saturday

As a part of the PASSMN Board I spend a lot of time talking about SQL and a lot of time talking about talking about SQL. (Trust me that is a real sentence.)

Each month at our user group meetings we have someone present on something that relates to our careers as SQL Server professionals and each year we host a SQL Saturday where we usually have at about 35-40 different people present. We are lucky in the Twin Cities because it isn’t usually hard to fill those spots. We have a lot of people involved in our community and many people who enjoy speaking or at least see the value in it.

Continue reading