Creating features nobody wants

You hear all the time that your code (not just Microsoft’s; everybody in a software development firm hears this) has features in it that “nobody wants”.  But is this true?Well, sometimes it is. But sometimes there are solid business (not necessarily technical) reasons that a feature is included in your software. You might have legal…

2

SQL Server and Green Computing

As I was working through the list of customer requests for the next feature set in SQL Server 2008, one item that kept floating to the top was “multiple monitor support”. More and more of us are using two flat-screen monitors to do our work each day. I do the same thing here. I remember…

0

Using the Tools

A lot of the comments I get at conferences and over e-mail ask for various features within the management tools. To be sure, there are many things we can do to make the tools better, but many times (over half, actually) I end up saying “You know you can already do that, right?” I then…

1

Speeding up encryption

A friend of mine from Tampa, Florida wrote me the other day with an interesting observation: “I have a small finding and don’t know where to publish it.  Maybe you can help get the word out via your blog?   OPEN SYMMETRIC KEY is somewhat costly to execute.  Since keys will remain open unless explicitly…

2

Script of the day – Remove White Space from a String

OK – this might be stretching the “Is this Useful” question a bit, but hey, I needed it today and thought I would share it with you – it’s free!  This construct takes the whitespace out of a string. /* usc_DBA_Remove_White_Space.sql Removes extra white spaces between two words in a character string */ DECLARE @TEXT…

12

Connection Security Confusion

You know, more than just about any other question I get the most common is around connection security for SQL Server Management Studio. Let’s take a couple of scenarios and walk through the basics. Windows Accounts on SQL Server (Windows Authentication)This setting means that you can use your current Windows account and log in to…

1

Index Overlaps

There are a lot of tools in SQL Server 2005 that will help you with indexes, from enhanced plan diagrams to the Database Tuning Advisor. But I was scouting around this morning for a script that would find places where I had indexes that included duplicate columns – that is unecessary and could potentially confuse…

0

Don’t Negelct Yourself

Wow – I have a new job where I’m trying to drink from a firehose of knowledge, my mother was up for the week from Florida (see here for more on that: http://carpedatum.spaces.live.com/), I had to write a complete tutorial on locking, get a project plan together on some new SQL Server 2008 features, and get ready for my…

0

Longhorn (Windows Server) and SQL Server

Feeling a bit adventurous, I’ve installed the latest Longhorn Beta and then SQL Server 2005 Developer Edition on top of it. Other than the inevitable video driver issues, it’s been pretty stable. One feature I do like is the “Server Manager” that pops up when you start. While this can be a pain, in this…

2

Powershell Plus – Very Nice!

Our group (the Management Platform Team) is heavily involved in the PowerShell-as-it-applies-to-SQL area. We’re working on a new provider for SQL Server 2008, as I’m sure you’ve seen in some of the demos we’ve been giving at various user groups. Well, a third party has given us a preview of a mondo-cool improvement to the shell…

2