Yep, you read that right. I’m building tools in Go.
I can hear you now…. But Wes you are a SQL Server guy, a WINDOWS guy! What about C#? What about Powershell? What about ANY THING ELSE???Making Decisions
Sometimes you make choices, not based on what you want to use but what you must use when building your tool set.
Here was my decision making path I hope it isn’t too complex.
It must run on everything from Windows Server 2003 through Windows 2012 R2 where I don’t have total control over the OS or what is installed on it.
That was it. I had no clue it would be so difficult to More >
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 >
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 >
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 >
I’m still stunned in this day and age that people pay obscene amounts of money on tools that are easily replaced in most cases with quality and stable open source alternatives. Part of the problem is that a lot of OSS tools don’t work well on Windows or require some fiddling which can scare off some people. The two tools I’ll be chatting about today don’t fall under that category. In one or two steps you have them installed and ready to rock. I’m constantly working with clients that require file movement in a secure manor. Ether upload or download.cURL, World Wide More >