Browse by Tags

Quick and Dirty Code Compare

MS Word 2007 (and probably earlier versions) have the ability to do a basic document compare, useful if you're at a location that doesn't have more advanced comparison tools for TSQL. Just load your scripts into separate Word documents, click on the View ribbon, then click on View Side by Side...

Posted to It Depends (Weblog) by Andy Warren on 06-30-2008
Why Format TSQL?

Recently I had the chance to help a student debug a problem on a production server. It appeared to be failing because duplicate uniqueidentifiers were being created. Thinking that unlikely because the G in GUID stands for global, we dug in but found the code painfully hard to follow due to poor formatting...

Posted to It Depends (Weblog) by Andy Warren on 06-29-2008
SQL Compare 7 Beta

Red Gate's schema comparison tool, SQL Compare , is in beta for the newest version, SQL Compare 7. You can find details and a link to download here: Red Gate Forums: SQL Compare 7 Beta This version does include support for SQL Server 2008 (through CTP 6). The beta period will run through July 4,...

Posted to K. Brian Kelley - Databases, Infrastructure, and Security (Weblog) by bkelley on 04-07-2008
Browse Source Code for .Net Objects in SQL (Reflector.SQL2005Browser)

Saw a mention of this in the latest MSDN Magazine, you can download Reflector.SQL2005Browser and install it as an add-in for the well know Reflector tool (both are free). Point it at a server, pick a database, and you can browse through the deployed CLR objects. From there you can pick a function and...

Posted to It Depends (Weblog) by Andy Warren on 03-13-2008
Using TripIt for Travel Plans

Not a SQL related topic today. I first noticed Tripit on Joels Blog and so far it solves a problem I've had from time to time; making sense out of all the various email messages I get when I book a trip. Their implementation is simple, just forward the email from the vendor (Expedia, etc) to them...

Posted to It Depends (Weblog) by Andy Warren on 02-26-2008
Changing the Command Prompt

I spend a lot of time at the command prompt and to be perfectly honest, I'm tired of looking at: C:\Documents and Settings\Brian> Or whatever directory I happen to be in. Back in the old DOS days we got rather creative with command prompts, usually through the use of ANSI to add colors. Colors...

Posted to K. Brian Kelley - Databases, Infrastructure, and Security (Weblog) by bkelley on 02-20-2008
Metasploit 3.1 is out

The new version of Metasploit is out. Included is a GUI interface. It's a complete re-write in Ruby (note to self, learn more about Ruby) whereas the previous version were in Perl. The Metasploit Framework site If you aren't familiar with Metasploit, here's what it does (taken verbatim from...

Posted to K. Brian Kelley - Databases, Infrastructure, and Security (Weblog) by bkelley on 01-28-2008
Lists of Tools

I ran across this list of interesting tools by Scott Hanselman and there is some good stuff to look at it. I've always had a fondness for small special purpose (and mostly free) tools (software or woodworking!). I've made a note to start my own page with some original ideas on tools soon.

Posted to It Depends (Weblog) by Andy Warren on 12-14-2007
Honeypots in the Database

As a follow up to my post about Cesar Cerrudo's new whitepaper , earlier this month David Litchfield talked about putting honeypots in the database in his blog post, Database tripwires... , to catch someone snooping around. The basic idea for non-Oracle databases is to create some sort of alerting function...

Posted to K. Brian Kelley - Databases, Infrastructure, and Security (Weblog) by bkelley on 11-23-2007
Resources: SQL Server 2005 Security

Work responsibilities took up my time on Thursday and Friday, so I never got around to posting. Here's the resources I planned on covering on Friday: online sources for SQL Server security. Website: Center for Internet Security - SQL Server Benchmarks CIS is well known for producing quality benchmarks...

Posted to K. Brian Kelley - Databases, Infrastructure, and Security (Weblog) by bkelley on 11-11-2007

Page 1 of 9 (86 items) 1 2 3 4 5 Next > ... Last »