Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL Man of Mystery

Wes Brown is a PASS chapter leader and SQL Server MVP. He writes for SQL Server Central and maintains his blog at http://www.sqlserverio.com. Wes is Currently serving as a Senior Lead Consultant at Catapult Systems. Previous experiences include Product Manager for SQL Litespeed by Quest software and consultant to fortune 500 companies. He specializes in high availability, disaster recovery and very large database performance tuning. He is a frequent speaker at local user groups and SQLSaturdays.

Growing It At Home: Building Your Own Tools

Short On Money?

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

2 comments, 301 reads

Posted in SQL Man of Mystery on 10 February 2014

Digging Around For Free Tools – Google Code

Digging Around In Google Code

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

Read more

1 comments, 242 reads

Posted in SQL Man of Mystery on 4 December 2013

Digging Around For Free Tools – BitBucket

Digging Around In BitBucket

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

1 comments, 189 reads

Posted in SQL Man of Mystery on 2 December 2013

Digging Around For Free Tools – SQL Server

Tool Archaeology, Digging Through The Web

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

1 comments, 211 reads

Posted in SQL Man of Mystery on 29 November 2013

Oh, The Free Stuff!

Ah, Shwag

 

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.

 

Little Things

I always… Read more

1 comments, 216 reads

Posted in SQL Man of Mystery on 8 October 2013

I Am Surprised Every Time

Who me?

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

1 comments, 219 reads

Posted in SQL Man of Mystery on 2 October 2013

SQL Server, Pricing, Editions and Features

I Want Features Not Cost!

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

2 comments, 352 reads

Posted in SQL Man of Mystery on 1 August 2013

Moving Files with Open Source Software, cURL and winSCP

Open Source, ON WINDOWS!

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

1 comments, 353 reads

Posted in SQL Man of Mystery on 23 July 2013

Building Flat File Connectors Dynamically For SSIS

Building Connectors Is Crap in SSIS – Updated

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

2 comments, 961 reads

Posted in SQL Man of Mystery on 10 July 2013

Finding SQL Server Installs with Powershell, Again

But the SQL Listener isn’t started!

Yep, I heard you loud and clear. There is more than one way to find SQL Server on your network. This time we will dig deep into the TDS protocol docs again along with a bit of guess work.

Old Dog New Protocol Plus…

Read more

0 comments, 287 reads

Posted in SQL Man of Mystery on 15 April 2013

Parsing Glenn Berry’s Diagnostic Information Queries With PowerShell

Do It In Bulk

I usually don’t run queries on just one server. Most of the time I need to get some piece of information from dozens if not hundreds of servers at a time. I also really like Glenn’s diagnostic queries and use them regularly with some modifications and… Read more

0 comments, 275 reads

Posted in SQL Man of Mystery on 12 April 2013

Finding SQL Server Installs Using Powershell

Old Dog, New Tricks

I’ve been writing tools for SQL Server for a lot of years. Some of these tools were never completely released. Some of them were just for me. Some of them overlapped other tools already on the market and free for all. Recently, I started updating my… Read more

3 comments, 577 reads

Posted in SQL Man of Mystery on 27 February 2013

New Toy: The Brydge iPad Keyboard – Updated

Finally a REAL keyboard for my iPad!

I can’t tell you how long I’ve wanted a real keyboard that my iPad could dock with easily. I have always hated lugging around a laptop everywhere to do any real typing. When I got the first iPad I really thought it was… Read more

3 comments, 616 reads

Posted in SQL Man of Mystery on 28 November 2012

Quick Tip: SSIS and SAP BW Round 2

Again, frustration.

After almost breaking my arm patting myself on the back getting past my last SAP BW issue I found that SAP BW Connector and SQL Server 2012 were punishing me again. I was building a second package against the same SAP instance on the same SQL Server 2012… Read more

0 comments, 516 reads

Posted in SQL Man of Mystery on 19 November 2012

Quick Tip: SSIS and SAP BW

Frustration.

If you have ever had to work with Integration Services and data sources other than the Microsoft variety you know how frustrating it can be. I recently started a project using SQL Server 2012 and SAP BW 7. The customer had already decided that the other commercial options weren’t… Read more

1 comments, 1,179 reads

Posted in SQL Man of Mystery on 15 November 2012

Solid State Storage: Enterprise State Of Affairs

Here In A Flash!

Its been a crazy last few years in the flash storage space. Things really started taking off around 2006 when NAND flash and moores law got together. in 2010 it was clear that flash storage was going to be a major part of your storage makeup… Read more

1 comments, 1,610 reads

Posted in SQL Man of Mystery on 5 November 2012

SSIS and Oracle All Your Non-options

Why do some things have to be so hard?

I have been asking myself that question for the better part of two weeks as I wrestle with SSIS 2008 R2 and getting data out of Oracle and into SQL Server.

It’s like the shell game, only with drivers.

Like, go…

Read more

5 comments, 1,954 reads

Posted in SQL Man of Mystery on 30 October 2012

The Fundamentals of Storage Systems – Shared Consolidated Storage Systems

Shared Consolidated Storage Systems – A Brief History

Hey, “Shared Consolidated Storage Systems” did you just make that up? Why yes, yes I did.

For as long as we have had computers there has been a need to store and retrieve data. We have covered the basics of hard disks Read more

0 comments, 1,325 reads

Posted in SQL Man of Mystery on 26 October 2012

One Great Day And Mixed Feelings

If it happens two times then you know the first time wasn’t a fluke.

Today was my anniversary date for the SQL Server MVP award. I wasn’t expecting to be renewed. I was though. Three of my friends weren’t added to the MVP roster. All three of them have put… Read more

5 comments, 539 reads

Posted in SQL Man of Mystery on 2 October 2012

SQL In The City: Austin

So, No SQL Saturday in Austin This Year.

I know a lot of folks were disappointed that we (POSSE) weren’t able to pull together in time for a SQL Saturday in Austin this year. We are shooting for a spring date and I’ll be posting more about that in the… Read more

0 comments, 549 reads

Posted in SQL Man of Mystery on 25 September 2012

Older posts