For six years I have been an avid and outspoken fan and paying customer of SourceGear products…from Vault to Dragnet to Fortress and on to Vault Professional, but that is all changing now.
Read more →
“SELECT *” isn’t just hazardous to performance, it can actually return blatantly wrong information.
There are a number of blog posts and articles out there that actively discourage the use of the SELECT * FROM …syntax.
Read more →
So how do the new SQL Server Developer Tools (previously code-named Juneau) stack up against SQL Source Control? Read on to find out.
At the PASS Community Summit a couple of weeks ago, it was announced that the previously code-named Juneau software would be released under the name of SQL Server Developer Tools with the release of SQL Server 2012.
Read more →
In part 2 of my previous series regarding Red-Gate’s tool, SQL Source Control, I warned about an aspect of the tool that could cause you to lose data if you were not careful.
Read more →
Everything worked fine for the last six years…and then today we hit the tipping point. I lost many hours today due to the misuse of DISTINCT which was the root cause of timeout errors in our web application.
Read more →
Today I had to find a way to regain SysAdmin access to an instance of SQL Server when I technically had no permissions. Here is how I did that.
Every developer on my team is setup to be able to work 100% stand-alone.
Read more →
HOORAY! It is officially here! Today, Red-Gate officially released SQL Source Control version 2.1 with support for Vault.
While we have been happily and successfully running the beta version (a.k.a. the Early Access release) of Red-Gate SQL Source Control with support for Vault for quite a while, it is good to have the official RTM (or GOLD, or PROD, or whatever you call your “no-longer-in-beta”) release of the product.
Read more →
Two weeks ago I upgraded our installation of Fortress to the latest version, which is now named Vault Professional. This is the version of Vault (i.e. Vault Standard 5.1 / Vault Professional 5.
Read more →
Hey! What do you know? Microsoft Connect really works!
I was very happy this morning to open my email and find a notice from Umachandar on the SQL Programmability Team that they have created a fix for the Odd Profiler Results with EF4 issue that I wrote about last June.
Read more →
In parts one and two of this series, I have been specifically focusing on the latest version of SQL Source Control by Red Gate Software. But I have been doing source-controlled SQL development for years, long before this product was available, and well before Microsoft came out with Database Projects for Visual Studio.
Read more →
In Part 1, I started talking about using Red-Gate’s newest version of SQL Source Control and how I really like it as a viable method to source control your database development.
Read more →
I am fanatical when it comes to managing the source code for my company. Everything that we build (in source form) gets put into our source control management system. And I’m not just talking about the UI and middle-tier code written in C# and ASP.
Read more →
Recently, SQL Sentry told me something about my SQL Server disk configurations that I just didn’t want to believe, but alas, it was true.
Several days ago I posted my First Impressions of the SQL Sentry Power Suite.
Read more →
I’m not a big fan of the built-in Maintenance Plan functionality in SQL Server. I like the interface in SQL 2005 better than 2000 (it looks more like building an SSIS package) but it’s still a bit of a black box.
Read more →
After struggling to defend my SQL Servers from a political attack recently, I realized that I needed better tools to back me up, and SQL Sentry is the leading candidate.
Read more →
I have certainly been reading blogs a whole lot more than writing them the last several weeks, and it’s about time I got back to writing. I have been collecting several topics and references for blog posts…some of which will probably just never get written as the timeliness of the topics fade over time.
Read more →
Last night at the Exhibitor Reception at the Summit, Lance Harra said to me, “I thought you gave up on Twitter.” That was in response to seeing my Twitter ID on my name badge.
Read more →
I have been editing some ASP.NET pages lately and finding a LOT of code that is either all commented out, or worse, someone created a way to permanently hide it from the user (such as ASP Panel that is never made visible) yet left all the code active.
Read more →
You know... that "handy" keyword that eliminates duplicates from your result set. Yeah, that DISTINCT. I Hate it! My team thought I was crazy (maybe I am, but this is not proof of it).
Read more →
I got this question in email a while ago, and it seems to come up quite a bit, which frankly surprises me. I guess it's because I almost never* write an application where I need to retrieve the 10th (or whatever number) record.
Read more →