Here is a similar bit of T-SQL code that generates 15 character passwords for service accounts. There is a numeric keypad character in each of the first seven and second...

Here is a nice bit of T-SQL code that will generate a 128 byte strong (some will say 'impossible') password that works for an SA login. It will work in Query...

As a basic text editor, I use a tool called TextPad. It can be setup to have color coded keywords and do regular expression search and replace across a section...

SQL CLR makes such things as generating a hash really easy.

Here is a quick function (as well as a RandomNumber generator) built from the framework encryption classes in C#:

Here...

It's all about money. If the system thinks that monoculture is cheaper in the lifetime of the people (i.e. how long they are responsible for their immediate situation) that run...

Note: Shameless plug to follow: If you want to get a better insight into SQL CLR, come to my SQL PASS presentation, "SQL CLR for the DBA and Database Designer"...

Sounds like the scenario for a Dilbert series...

Good job, Steve. No one is going to *nix. MS needs to get its act together. SA is just not the deal it should be. How about SA being 15%...

I'm the database designer for a major higher education ERP application (in the hundreds of customers) that rides on top of both SQL Server and Oracle. This is on a...

In SQL 2000 if you remove this group and the SQL Agent Service account is the machine SYSTEM account, then SQL Agent will not start.

Good for Mark and MS. I suspect both Mark and MS know what they are doing here. People love to rail against things they don't understand by dreaming up all...

Invalid means it will not work. I don't think there is any filename that will not work as long as it has valid file characters. The datatype for filename is...

Google (and other search engines) is a special animal from a DB perspective. If data is missing from a single or even relatively small percentage of searches, no one is...

I tend to think of this as a design issue. If the data is stored unencrypted on disk (ie in the table) during design then you are asking for it....

I'm not sure why you use UNSAFE to get this to work. I was able to get it to work with EXTERNAL_ACCESS. I strongly named the compilation of the executable....