Sometimes that is the motivation. Maybe the tool you want doesn’t really exist yet? For me it was those things and the joy of building something useful. I’ve built dozens if not hundreds of tools in the form of scripts, batch files and executable code. Did you know some of the tools you are paying your employers hard earned money for came up from the same roots? Someone needed a tool to do X, and lo’ there were others who were willing to pay for that work.Great, Someone Has Written The Tool…
They also want something called money for me to use it. That may be the case but some More >
Codeplex is probably the best source for Microsoft focused projects. You will find a lot more than just base SQL Server bits. Codeplex covers a large range of technologies and also covers pretty much every aspect of SQL Server. Codeplex isn’t as old as SourceForge so if you do find a project that has been abandoned it may not be too old to use or may be easier to update. When Codeplex finally added git support they on me over in a big bad way. The search feature is a bit simplistic but you still have some sorting and filtering options available to you.SQL Power More >
Google Code was very thin when it comes to SQL Server. I did find a few of interesting projects that may appeal to others as well as me. I will say there was a TON of use SQL Server with x programming language.Project RoundhousE
“Professional Database Versioning and Change Management”
RoundhousE is an automated database deployment (change management) system that allows you to use your current idioms and gain much more.
It seeks to solve both maintenance concerns and ease of deployment. We follow some of the same idioms as other database management systems (SQL More >
BitBucket was very thin when it comes to SQL Server. I did find a couple of interesting projects that may appeal to others as well as me.BonSQL
Turn any version of Microsoft SQL Server into a platform capable of acting just like MongoDB – only you get transactions and the ability to join with traditional relational data as well!
This is a nice example of using newer methods with our good ol’ SQL Server engine.DeploySQL
Scripts to auto-deploy SQL from SQL Server and to dump database objects to disk (so they can be searched or committed to source control).
There More >
About every three to six months I will burn some time and just go digging for tools. Mostly, I’m looking for stuff related to SQL Server, PowerShell or C# development. There are lots of places to search through that could yield your next life saving tool. All the major sites have a search feature but if you just put in SQL Server you will get a ton of hits that don’t have anything to do with SQL Server. I usually do something like “SQL Server” NOT MySQL NOT Postgresql NOT DB2 NOT Oracle to keep the other databases from cluttering up the results. The More >
I’ve been doing the whole conference thing for a while. Not as long as some but quite a while. Along the way I’ve collected quite a bit of stuff. I’ve also given away most of it to the local user group too.
I always keep a few little things like ducks and note books.
I also keep a few of the drink-ware items too.
Oh the humanity, the amount of clothing I have from conferences is just crazy. I give away quite a bit but always try to keep one shirt or item from everywhere I go.Carry All Your Stuff
With all those shirts I need all these bags to More >
Yep me. I have been honored with the Microsoft Most Valuable Professional again this year in SQL Server. This is my third year to receive the award and just like the last two years I am humbled and honored to be a recipient.Remember, What It Is.
And what it isn’t. I didn’t get my MCM before the shutdown. I didn’t earn that title and certification. I was given an honor for the service I performed to the community last year.Others are worthy.
Maybe more so. I personally know people that deserve to be awarded. I have and will continue to nominate those people, even it it means next More >
Today is bitter sweet for me. I am moving on from Catapult Systems to pursue other opportunities.
What does that mean exactly? Was I treated poorly? Did the work suck? No on both accounts. I haven’t been this happy in my professional life in quite a while.
But you are leaving? Yep.Self Examination Is As Important as Feedback From Others
To answer those questions accurately I had to take a serious look at my life and the things I want from it.
I’m a list maker. I do the whole pro and con’s thing. Making short, mid and long term goals all that stuff. This time I did More >
Recently Brent Ozar (blog|twitter) wrote a post SQL Server Standard Edition Sucks, And It’s All Your Fault. Needless to say, he isn’t happy with the price and what you don’t get in Standard Edition of SQL Server 2012. Brent seems to be mostly upset that since SQL Server 2008 Standard edition has been restricted to 64GB of ram. Adding additional insult, Always On is an Enterprise only feature with Database Mirroring on the green mile Microsoft will have to do something in the near future to fill this gap.
What about the rest of his list?
- Database snapshots (a huge More >
What else can I say. I finally broke when I had to build a flat file connector with 258 columns that needed to be imported into a staging database. 258 columns… I almost had a stroke. Not only is it mind numbing it’s also error prone. I do dabble in c# so I build a little tool to automate this for me.Introducing SSISConnectionBuilder
SSISConnectionBuilder is a simple command line tool to ease the burden of building flat file connectors for SSIS. It is WAY WAY alpha but I am working on cleaning up the code. You can pick it up here on codeplex.
I More >