<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://www.sqlservercentral.com/blogs/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>K. Brian Kelley - Databases, Infrastructure, and Security : Windows Workstation</title><link>http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Windows+Workstation/default.aspx</link><description>Tags: Windows Workstation</description><dc:language>en</dc:language><generator>CommunityServer 2007.1 (Build: 20917.1142)</generator><item><title>New Community Resource for IT Pros - Server Fault</title><link>http://www.sqlservercentral.com/blogs/brian_kelley/archive/2009/05/01/new-community-resource-for-it-pros-server-fault.aspx</link><pubDate>Fri, 01 May 2009 13:59:00 GMT</pubDate><guid isPermaLink="false">70975365-724d-4ce8-8d1c-45c963ab81ff:11612</guid><dc:creator>K. Brian Kelley</dc:creator><slash:comments>2</slash:comments><wfw:commentRss xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.sqlservercentral.com/blogs/brian_kelley/rsscomments.aspx?PostID=11612</wfw:commentRss><wfw:comment xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.sqlservercentral.com/blogs/brian_kelley/commentapi.aspx?PostID=11612</wfw:comment><comments>http://www.sqlservercentral.com/blogs/brian_kelley/archive/2009/05/01/new-community-resource-for-it-pros-server-fault.aspx#comments</comments><description>&lt;p&gt;Not too long ago the developer community got a fantastic resource called &lt;a class="null" href="http://stackoverflow.com"&gt;Stack Overflow&lt;/a&gt;. It&amp;#39;s a question and answer site, so it&amp;#39;s like forums, only it&amp;#39;s not. The interface is well done, finding questions to answer is easy because of the tag system, and the site has in place a capability to give people who are active more and more capabilities to help manage the site. It&amp;#39;s a really neat idea. The issue with Stack Overflow is it is development-centric and by design. So the powers over Stack Overflow have created a sister site called &lt;a class="null" href="http://serverfault.com"&gt;Server Fault&lt;/a&gt; which is for IT professionals -&amp;nbsp;Same interface, same tags, and same increasing ability to help be responsible for the community site. &lt;/p&gt;
&lt;p&gt;Now Server Fault is currently in &amp;quot;private&amp;quot; beta, but that should last only a week or two based on the &lt;a class="null" href="http://blog.stackoverflow.com/2009/04/server-fault-private-beta-begins/"&gt;post about Server Fault in the Stack Overflow blog&lt;/a&gt;. If you&amp;#39;ve been somewhat active on Stack Overflow, check out that blog post, because it tells you how you can get active on Server Fault right now. It is actively being used. If you don&amp;#39;t meet the criteria, don&amp;#39;t worry, one or two weeks go by fast. &lt;/p&gt;
&lt;p&gt;Does this replace&amp;nbsp;technology centric sites like &lt;a class="null" href="http://www.sqlservercentral.com/"&gt;SQL Server Central&lt;/a&gt;? Not really, it&amp;#39;s just another resource. The great thing about SQL Server Central is it covers all things SQL Server. So there are a lot of great SQL Server pros at SSC and at SSC you don&amp;#39;t have to worry about going to a different site if you have a programming question or a system administration/SQL Server administration type of question. SSC covers it all with respect to SQL Server. And you&amp;#39;ll see a lot of us on both sites. I&amp;#39;m a bit more active on Server Fault right now only because I&amp;#39;m trying to stay ahead of &lt;a class="null" href="http://www.brentozar.com/"&gt;Brent Ozar&lt;/a&gt; on reputation and to get a chance to answer some questions there. Brent is a question hawk who will snatch out your prey right from under you! If you post there on a subject related to SQL Server, SANs, or virtualization, do it quick and do it thorough, lest Brent swoop down from on high! Okay, I&amp;#39;m kidding about that. When he&amp;#39;s on, he&amp;#39;s just trying to help, just like the rest of us, and he has a very great in-depth knowledge of multiple technologies. He also helps &lt;a class="null" href="http://stackoverflow.com/about"&gt;support the actual&amp;nbsp;Stack Overflow site&lt;/a&gt; as their DB performance expert. &lt;/p&gt;&lt;img src="http://www.sqlservercentral.com/blogs/aggbug.aspx?PostID=11612" width="1" height="1"&gt;</description><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/MySQL/default.aspx">MySQL</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Tools/default.aspx">Tools</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Architecture/default.aspx">Architecture</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Security/default.aspx">Security</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Windows+Server/default.aspx">Windows Server</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Windows+Workstation/default.aspx">Windows Workstation</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Training/default.aspx">Training</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/SQL+Server/default.aspx">SQL Server</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/performance/default.aspx">performance</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Microsoft+SQL+Server/default.aspx">Microsoft SQL Server</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/professional+development/default.aspx">professional development</category></item><item><title>Microsoft Solution Accelerators on TechNet</title><link>http://www.sqlservercentral.com/blogs/brian_kelley/archive/2009/01/15/microsoft-solution-accelerators-on-technet.aspx</link><pubDate>Thu, 15 Jan 2009 19:49:00 GMT</pubDate><guid isPermaLink="false">70975365-724d-4ce8-8d1c-45c963ab81ff:10059</guid><dc:creator>K. Brian Kelley</dc:creator><slash:comments>0</slash:comments><wfw:commentRss xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.sqlservercentral.com/blogs/brian_kelley/rsscomments.aspx?PostID=10059</wfw:commentRss><wfw:comment xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.sqlservercentral.com/blogs/brian_kelley/commentapi.aspx?PostID=10059</wfw:comment><comments>http://www.sqlservercentral.com/blogs/brian_kelley/archive/2009/01/15/microsoft-solution-accelerators-on-technet.aspx#comments</comments><description>&lt;p&gt;I was browsing through the new titles that are on &lt;a class="" href="http://safari.informit.com/"&gt;Safari&lt;/a&gt; and saw some planning guides around Windows Server 2008 (Active Directory Services, File Services, etc.). Of course, all of these are published as solution accelerators, because they are designed to assist IT professionals understand, plan, and implement solutions quicker (hence the term, solution accelerator).&amp;nbsp;Some of these documents have been around for a while, but the Solution Accelerators section groups them all into one place. If you&amp;#39;ve not run across them before,&amp;nbsp;you can find them here:&lt;/p&gt;
&lt;blockquote&gt;
&lt;p&gt;&lt;a class="" href="http://technet.microsoft.com/en-us/solutionaccelerators/default.aspx"&gt;Microsoft TechNet : Microsoft Solution Accelerators&lt;/a&gt;&lt;/p&gt;&lt;/blockquote&gt;
&lt;p&gt;Among them are the &lt;a class="" href="http://technet.microsoft.com/en-us/library/cc196387.aspx"&gt;Infrastructure Planning and Design Guides&lt;/a&gt;. There&amp;#39;s guidance on Windows Server 2008, virtualization, and even IIS. But unfortunately, none out there yet for SQL Server. If you&amp;#39;re looking on the &lt;a class="" href="http://technet.microsoft.com/en-us/solutionaccelerators/cc835245.aspx"&gt;security side&lt;/a&gt;, there are the OS security guides from Windows XP on up, including for Vista and 2008. Sorry, no Windows 7 yet.&lt;/p&gt;&lt;img src="http://www.sqlservercentral.com/blogs/aggbug.aspx?PostID=10059" width="1" height="1"&gt;</description><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Tools/default.aspx">Tools</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Architecture/default.aspx">Architecture</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Windows+Server/default.aspx">Windows Server</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Windows+Workstation/default.aspx">Windows Workstation</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Virtualization/default.aspx">Virtualization</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Training/default.aspx">Training</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Windows+Server+2008/default.aspx">Windows Server 2008</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Vista/default.aspx">Vista</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Windows+security/default.aspx">Windows security</category></item><item><title>Whitepaper on Malware to Attack Databases</title><link>http://www.sqlservercentral.com/blogs/brian_kelley/archive/2007/11/23/3270.aspx</link><pubDate>Fri, 23 Nov 2007 09:01:00 GMT</pubDate><guid isPermaLink="false">70975365-724d-4ce8-8d1c-45c963ab81ff:3270</guid><dc:creator>K. Brian Kelley</dc:creator><slash:comments>4</slash:comments><wfw:commentRss xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.sqlservercentral.com/blogs/brian_kelley/rsscomments.aspx?PostID=3270</wfw:commentRss><wfw:comment xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.sqlservercentral.com/blogs/brian_kelley/commentapi.aspx?PostID=3270</wfw:comment><comments>http://www.sqlservercentral.com/blogs/brian_kelley/archive/2007/11/23/3270.aspx#comments</comments><description>&lt;a href="http://www.argeniss.com/about.html"&gt;Cesar Cerrudo&lt;/a&gt; of &lt;a href="http://www.argeniss.com/"&gt;Argeniss Information Security&lt;/a&gt; has put out a new whitepaper (.pdf format), &lt;a href="http://www.argeniss.com/research/Data0.pdf"&gt;&lt;i&gt;Data0: Next generation malware for stealing databases&lt;/i&gt;&lt;/a&gt;, describing how malware could be crafted to steal information out of databases. For the most part, it stays at a high-level, however, Cesar does give a few example queries (for SQL Server), the appropriate API calls to perform certain operations, etc., which delve a bit more into the technical side, but even these are fairly straight-forward. To demonstrate what he talks about in the whitepaper, he built a simple proof of concept (PoC), but based on what's in the whitepaper (and what is generally accepted as what's possible), nothing seemed outlandish or hard-to-do. Just for those worried about that PoC being out in the wild, Cesar states in the whitepaper he's not going to put it out for public consumption because he knows it'll be used for evil. &lt;br&gt;&lt;br&gt;Which brings us to how the malware attacks. The typical anatomy for an attack is something similar to:&lt;br&gt;&lt;ul&gt;&lt;li&gt;Discovery&lt;/li&gt;&lt;li&gt;Exploitation&lt;/li&gt;&lt;li&gt;Escalate Privileges (if necessary)&lt;/li&gt;&lt;li&gt;Cover Tracks&lt;/li&gt;&lt;/ul&gt;Since we're dealing with malware, the attack methods are well known. Keeping malware out of the corporate environment, especially considering most of the techniques for detecting malware are &lt;a href="http://searchsecurity.techtarget.com/originalContent/0,289142,sid14_gci991563,00.html"&gt;signature based&lt;/a&gt;, such as antivirus, is difficult. When users run as local administrators, all it takes is one person clicking on an email that sends that person to a website which exploits an Internet Explorer, Firefox, Microsoft Office, etc., vulnerability to download and install the malware. If the malware is new, there isn't a signature for it. Therefore, it'll likely pass through the scans. &lt;br&gt;&lt;br&gt;But what about the web site and web filtering software used by the organization? Well, if the site hasn't been categorized yet, it really depends on how the web filtering software is configured to handle such sites (if such an option exists). Some web filtering products have heuristic engines which try to analyze the content to determine if it's objectionable or not. Some engines can scan words, others also have the capability to look at images, and the engine in question generates a score. Depending on the score, the page does or does not get displayed. (I'm greatly simplifying the process, but you get the idea.) So if you're building a page that hosts said malware, you ensure it says all the right things to look legitimate for business. In fact, it may very well be a copy of another business page because the only thing you're interested in is deploying the malware. If it has been categorized, there have been known exploits of well-known organizations, such as &lt;a href="http://sunbeltblog.blogspot.com/2007/07/more-hacked-university-sites-this-is.html"&gt;educational facilities&lt;/a&gt; and even &lt;a href="http://www.enterpriseitplanet.com/security/news/article.php/3712496"&gt;Yahoo!&lt;/a&gt; in recent days. That means playing a catch up game before the individual page is categorized. So in other words, getting the malware deployed typically isn't the problem.&lt;br&gt;&lt;br&gt;Therefore, Cesar concentrates on the malware itself. The pattern it follows is the following:&lt;br&gt;&lt;ul&gt;&lt;li&gt;Discover&lt;/li&gt;&lt;li&gt;Attack&lt;/li&gt;&lt;li&gt;Transmit the Data Back&lt;/li&gt;&lt;li&gt;Cover Its Tracks (if necessary)&lt;/li&gt;&lt;/ul&gt;Discovery is where it locates database sources. The two most obvious, and most stealthy, is to check the ODBC DSNs on the local system and to look into existing processes to look for outbound connections to well-known ports (such as tcp/1433 for SQL Server). If necessary the malware could get substantially more noisy by doing a network scan (again, for well-known ports) or outright sniffing the network (but switched networks makes this extremely problematic and if you try to overcome this, it will be VERY noisy). &lt;br&gt;&lt;br&gt;Once the targets are identified, the next step is to attack the servers. Connections, like to SQL Server, which use Windows authentication are trivial. Otherwise, it might have to resort to brute force. Brute force, in and of itself, can be noisy (depends on whether or not you are auditing failed login attempts). And once it gets in, it can check replication settings, linked servers, etc., to locate further targets, which adds to the discovery process. However, once it's in, it'll need to scan for interesting information, and this usually means looking at metadata for table and column names. Once something of interest is found, it's all about extracting the data. &lt;br&gt;&lt;br&gt;After it has some data, it needs to get it off-site. Again, if you can get a site up where malware can be grabbed, getting back out isn't that difficult, either. Even if an organization is doing &lt;a href="http://www.sans.org/reading_room/whitepapers/firewalls/1059.php"&gt;egress filtering&lt;/a&gt;, they still allow out HTTP and HTTPS. As long as the web site passes the filters, all is well. And the data is in the hands of a malicious individual or organization.&lt;br&gt;&lt;br&gt;Afterwards, if necessary, the malware can cover its tracks by removing itself. This may be a good idea to make getting samples of the malware more difficult, thereby impeding a security company's ability to generate signatures on said malware. &lt;br&gt;&lt;br&gt;If it is really this easy, how do you prevent this from happening? Several things make the malware's job more difficult. Some of them I've taked about how to get around, but they should still be in place.&lt;br&gt;&lt;br&gt;&lt;b&gt;Network Layer:&lt;/b&gt;&lt;br&gt;&lt;ul&gt;&lt;li&gt;Up-to-date web filtering software&lt;/li&gt;&lt;li&gt;Firewalls with egress filtering on the perimeter&lt;/li&gt;&lt;li&gt;Firewalls in front of the database servers controlling access to them&lt;br&gt;&lt;/li&gt;&lt;li&gt;Network switches (although it is nearly impossible to find an actual hub nowadays, this still needs to be looked at, especially in smaller organizations with old equipment)&lt;/li&gt;&lt;li&gt;Network configuration on firewalls and switches to block udp/1434 (SQL Server Listener Service)&lt;br&gt;&lt;/li&gt;&lt;li&gt;Use of network-based Intrusion Detection/Prevention System (NIDS/NIPS, or just IDS/IPS)&lt;/li&gt;&lt;/ul&gt;&lt;b&gt;Client Workstation Layer:&lt;/b&gt;&lt;br&gt;&lt;ul&gt;&lt;li&gt;Personal firewalls on systems&lt;/li&gt;&lt;li&gt;Up-to-date anti-malware software&lt;/li&gt;&lt;li&gt;Up-to-date on system and application patches&lt;/li&gt;&lt;li&gt;User running with less than administrator privileges&lt;/li&gt;&lt;li&gt;Use of Host-based Intrusion Prevention system (HIPS) &lt;/li&gt;&lt;/ul&gt;&lt;b&gt;Server Layer:&lt;/b&gt;&lt;br&gt;&lt;ul&gt;&lt;li&gt;Use IPSEC Policies (Windows) to restrict IP addresses which can connect to the database system&lt;/li&gt;&lt;li&gt;Use IPSEC Polcicies to block the SQL Server Listener Service (udp/1434)&lt;br&gt;&lt;/li&gt;&lt;li&gt;Use IPSEC Policies to encrypt the traffic and to require authentication to make the connection to the database system&lt;/li&gt;&lt;li&gt;Up-to-date on system patches&lt;/li&gt;&lt;/ul&gt;&lt;b&gt;Database System Layer:&lt;/b&gt;&lt;br&gt;&lt;ul&gt;&lt;li&gt;Up-to-date on database system patches&lt;/li&gt;&lt;li&gt;Use non-standard ports (stay away from tcp/1433 for SQL Server and tcp/3306 for MySQL) - Hampers or prevents discovery&lt;/li&gt;&lt;li&gt;Users running with minimal permissions - restricts access to data&lt;/li&gt;&lt;li&gt;Data encryption (SQL Server 2005) on those interesting columns - simply querying the tables won't get sensitive data&lt;/li&gt;&lt;li&gt;Audit failed login attempts (SQL Server) - "Noise" that may allow for detection of a brute force attempt&lt;/li&gt;&lt;li&gt;Enforce Password Policies (SQL Server 2005) - Reduces likelihood of success of a brute force attack&lt;/li&gt;&lt;li&gt;Locking down users by IP, where possible (MySQL) - If the end user doesn't need to access &lt;/li&gt;&lt;/ul&gt;Notice I said more difficult, not impossible. A knowledgeable attacker, with a real desire to break into a system, will find a way to do so. The goal is to make it as difficult as possible while still being reasonable in budget and in functionality for the organization. An attacker who isn't specifically going after a certain company (such as what happened to &lt;a href="http://www.news.com/2100-7349_3-5087698.html"&gt;Valve for Half Life 2&lt;/a&gt;) will likely move on to a much easier target. &lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;font size="1"&gt;&lt;b&gt;Technorati Tags:&lt;/b&gt; 
&lt;a href="http://technorati.com/tag/DATABASE"&gt;DATABASE&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/SQL"&gt;SQL&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/T-SQL"&gt;T-SQL&lt;/a&gt;| 
&lt;a href="http://technorati.com/tag/SQL+Server"&gt;SQL Server&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/Microsoft+SQL+Server"&gt;Microsoft SQL Server&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/SQL+Server+2000"&gt;SQL Server 2000&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/SQL+Server+2005"&gt;SQL Server 2005&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/MySQL"&gt;MySQL&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/Security"&gt;Security&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/Database+Security"&gt;Database Security&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/SQL+Server+Security"&gt;SQL Server Security&lt;/a&gt;
&lt;/font&gt;
&lt;br&gt;&lt;img src="http://www.sqlservercentral.com/blogs/aggbug.aspx?PostID=3270" width="1" height="1"&gt;</description><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/SQL+Server+2000/default.aspx">SQL Server 2000</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/MySQL/default.aspx">MySQL</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/SQL+Server+2005/default.aspx">SQL Server 2005</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Security/default.aspx">Security</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Windows+Server/default.aspx">Windows Server</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Windows+Workstation/default.aspx">Windows Workstation</category></item><item><title>Tool: KeePass Password Safe password manager/vault</title><link>http://www.sqlservercentral.com/blogs/brian_kelley/archive/2007/10/31/3079.aspx</link><pubDate>Wed, 31 Oct 2007 12:00:00 GMT</pubDate><guid isPermaLink="false">70975365-724d-4ce8-8d1c-45c963ab81ff:3079</guid><dc:creator>K. Brian Kelley</dc:creator><slash:comments>1</slash:comments><wfw:commentRss xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.sqlservercentral.com/blogs/brian_kelley/rsscomments.aspx?PostID=3079</wfw:commentRss><wfw:comment xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.sqlservercentral.com/blogs/brian_kelley/commentapi.aspx?PostID=3079</wfw:comment><comments>http://www.sqlservercentral.com/blogs/brian_kelley/archive/2007/10/31/3079.aspx#comments</comments><description>Some time ago I was looking for a password vault and came across some recommendations for &lt;a href="http://keepass.info/"&gt;KeePass&lt;/a&gt;. KeePass is open source and free. It's a nice password manager and some of the &lt;a href="http://keepass.info/features.html"&gt;features&lt;/a&gt; I like are:&lt;br&gt;&lt;ul&gt;&lt;li&gt;Strong encryption of the password database&lt;/li&gt;&lt;li&gt;The ability to use a password, key file, or the combination of the two to secure access to said password database&lt;/li&gt;&lt;li&gt;A password generator with a multitude of options&lt;/li&gt;&lt;li&gt;The ability to copy the password to the clipboard (without ever showing it) and have it clear the password after a set amount of time&lt;/li&gt;&lt;li&gt;Organize password entries by groups and subgroups (think folders)&lt;/li&gt;&lt;/ul&gt;A new version, &lt;a href="http://keepass.info/news/n071012_1.09.html"&gt;1.09&lt;/a&gt;, released in October. There is also a &lt;a href="http://portableapps.com/"&gt;Portable Apps&lt;/a&gt; version which allows you to run it without installation. Therefore, you can stick on a USB drive and take it with you. I've also run it as a straight executable from a shared network drive. &lt;br&gt;&lt;br&gt;Looking at it from a shared location, KeePass can be used by an organization to store sensitive logins, such as the root password for MySQL, the sa account password, the usernames and passwords for the SQL Server service accounts, etc. In fact, in version 1.09, if the password database is opened by another user, it's smart enough to tell the next person opening it the situation and asking if that user wants to open the database in read-only or normal mode. One way to handle this is to distribute the key file to all admins and as long as they have that, they can unlock the password database. If someone leaves the organization who had access to the password database, generate a new key and re-distribute it, and you're back in business, even if they copied the key file. Granted, the fact that the password entries stored within will have to be addressed, but this is a problem regardless of your password vault solution (or lack thereof).&lt;br&gt;&lt;br&gt;&lt;font size="1"&gt;&lt;b&gt;Technorati Tags:&lt;/b&gt;
&lt;a href="http://technorati.com/tag/Security"&gt;Security&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/Database+Security"&gt;Database Security&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/Network+Security"&gt;Network Security&lt;/a&gt;  | 
&lt;a href="http://technorati.com/tag/Windows+Security"&gt;Windows Security&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/SQL+Server+Security"&gt;SQL Server Security&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/Work"&gt;Work&lt;/a&gt;
 &lt;/font&gt;&lt;br&gt;&lt;br&gt;&lt;img src="http://www.sqlservercentral.com/blogs/aggbug.aspx?PostID=3079" width="1" height="1"&gt;</description><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/SQL+Server+2000/default.aspx">SQL Server 2000</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/MySQL/default.aspx">MySQL</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/SQL+Server+2005/default.aspx">SQL Server 2005</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Tools/default.aspx">Tools</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Security/default.aspx">Security</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Windows+Server/default.aspx">Windows Server</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Windows+Workstation/default.aspx">Windows Workstation</category></item><item><title>Structuring the Blog Better</title><link>http://www.sqlservercentral.com/blogs/brian_kelley/archive/2007/10/28/3074.aspx</link><pubDate>Mon, 29 Oct 2007 02:59:00 GMT</pubDate><guid isPermaLink="false">70975365-724d-4ce8-8d1c-45c963ab81ff:3074</guid><dc:creator>K. Brian Kelley</dc:creator><slash:comments>0</slash:comments><wfw:commentRss xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.sqlservercentral.com/blogs/brian_kelley/rsscomments.aspx?PostID=3074</wfw:commentRss><wfw:comment xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.sqlservercentral.com/blogs/brian_kelley/commentapi.aspx?PostID=3074</wfw:comment><comments>http://www.sqlservercentral.com/blogs/brian_kelley/archive/2007/10/28/3074.aspx#comments</comments><description>For a variety reasons, including personal/family concerns and workload, I've not been able to write as often as I'd like. That doesn't just include the blog, but also writing articles. It's been a long while since I've written an &lt;a href="http://www.sqlservercentral.com/Authors/Articles/Brian_Kelley/4995/"&gt;article for SSC&lt;/a&gt;. I want to get back to writing at least monthly, if not more often. One of the keys to writing well is to write every day. Therefore, I'm going to provide some structure to the blog in order to make it easier to post every weekday with something that will hopefully be useful. Here's the types of posts that should be present based on the day of the week:&lt;br&gt;&lt;ul&gt;&lt;li&gt;&lt;b&gt;Monday&lt;/b&gt; - Career Development&lt;/li&gt;&lt;li&gt;&lt;b&gt;Tuesday&lt;/b&gt; - Tips, Tricks, and SQL Scripts&lt;/li&gt;&lt;li&gt;&lt;b&gt;Wednesday&lt;/b&gt; - Tools, Tools, and More Tools&lt;/li&gt;&lt;li&gt;&lt;b&gt;Thursday&lt;/b&gt; - Tips, Tricks, and SQL Scripts&lt;/li&gt;&lt;li&gt;&lt;b&gt;Friday&lt;/b&gt; - Notable Resources (Blogs, Articles, Books, Podcasts)&lt;/li&gt;&lt;/ul&gt;I won't limit to one post a day, but hopefully that becomes the minimum. While I primarily focus on Microsoft SQL Server in this blog, the reality is I deal with Active Directory, security, and MySQL on a daily basis as well, meaning I'll include posts in those technology areas as well. &lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;font size="1"&gt;&lt;b&gt;
Technorati Tags:&lt;/b&gt; &lt;a href="http://technorati.com/tag/DATABASE"&gt;DATABASE&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/SQL"&gt;SQL&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/SQL+Server"&gt;SQL Server&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/Microsoft+SQL+Server"&gt;Microsoft SQL Server&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/SQL+Server+2000"&gt;SQL Server 2000&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/SQL+Server+2005"&gt;SQL Server 2005&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/MySQL"&gt;MySQL&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/Active+Directory"&gt;Active Directory&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/Security"&gt;Security&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/Life"&gt;Life&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/Work"&gt;Work&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/Writing"&gt;Writing&lt;/a&gt;&lt;/font&gt;&lt;img src="http://www.sqlservercentral.com/blogs/aggbug.aspx?PostID=3074" width="1" height="1"&gt;</description><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/SQL+Server+2000/default.aspx">SQL Server 2000</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/MySQL/default.aspx">MySQL</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/SQL+Server+2005/default.aspx">SQL Server 2005</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Tools/default.aspx">Tools</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Books+_2F00_+Writing/default.aspx">Books / Writing</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Security/default.aspx">Security</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Windows+Server/default.aspx">Windows Server</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Windows+Workstation/default.aspx">Windows Workstation</category></item><item><title>Volunteering</title><link>http://www.sqlservercentral.com/blogs/brian_kelley/archive/2007/05/22/1701.aspx</link><pubDate>Tue, 22 May 2007 04:07:00 GMT</pubDate><guid isPermaLink="false">70975365-724d-4ce8-8d1c-45c963ab81ff:1701</guid><dc:creator>K. Brian Kelley</dc:creator><slash:comments>2</slash:comments><wfw:commentRss xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.sqlservercentral.com/blogs/brian_kelley/rsscomments.aspx?PostID=1701</wfw:commentRss><wfw:comment xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.sqlservercentral.com/blogs/brian_kelley/commentapi.aspx?PostID=1701</wfw:comment><comments>http://www.sqlservercentral.com/blogs/brian_kelley/archive/2007/05/22/1701.aspx#comments</comments><description>I've spent my spare time the last few weekends helping a non-profit called &lt;a href="http://www.fastforwardctc.com/"&gt;Fast Forward&lt;/a&gt; here in the Columbia, SC area. I don't post this here to blow my own horn but rather to point out the need many non-profit organizations have for quality IT support. Most non-profits operate on a limited budget meaning they take help where they can get it. Often times there just isn't money left in the budget for a services contract, etc., even for an organization like Fast Forward. &lt;br&gt;&lt;br&gt;This is where knowledgeable folks can really make a difference. I know the usual excuse: after spending all week looking at a computer screen, the last thing anyone wants to do is spend the weekend working on computers. I've been there, so I understand that feeling completely. However, I have to say that the time I've spent working at Fast Forward has been personally rewarding. There's a sense of accomplishment knowing I've put my skills to work helping others, with no expectation of any tangible reward. &lt;br&gt;&lt;br&gt;This isn't to say that there isn't some career benefit. I've read the myriad of blogs/books/articles which say volunteering at non-profits is a great way to build up skills you would like to develop. That's a true potential benefit. However, what if you're re-using the skills you've already developed? I work on servers every day. So helping out with servers and/or workstations isn't an expansion on my skill set. Fast Forward isn't likely to go and use SQL Server and experiment with Longhorn server or check out the latest features of MySQL. What's the personal gain? To that I point back to the "making a difference" reason. Sometimes it's gotta be more than just about ourselves.&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;font size="1"&gt;&lt;b&gt;Technorati Tags:&lt;/b&gt; 
&lt;a href="http://technorati.com/tag/Life"&gt;Life&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/Work"&gt;Work&lt;/a&gt;| 
&lt;a href="http://technorati.com/tag/Volunteering"&gt;Volunteering&lt;/a&gt;
&lt;/font&gt;&lt;br&gt;&lt;img src="http://www.sqlservercentral.com/blogs/aggbug.aspx?PostID=1701" width="1" height="1"&gt;</description><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/SQL+Server+2000/default.aspx">SQL Server 2000</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/MySQL/default.aspx">MySQL</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/SQL+Server+2005/default.aspx">SQL Server 2005</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Tools/default.aspx">Tools</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Leadership/default.aspx">Leadership</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Security/default.aspx">Security</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Windows+Server/default.aspx">Windows Server</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Windows+Workstation/default.aspx">Windows Workstation</category></item><item><title>Thoughts from The Cuckoo's Egg</title><link>http://www.sqlservercentral.com/blogs/brian_kelley/archive/2007/04/06/1526.aspx</link><pubDate>Fri, 06 Apr 2007 19:33:00 GMT</pubDate><guid isPermaLink="false">70975365-724d-4ce8-8d1c-45c963ab81ff:1526</guid><dc:creator>K. Brian Kelley</dc:creator><slash:comments>2</slash:comments><wfw:commentRss xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.sqlservercentral.com/blogs/brian_kelley/rsscomments.aspx?PostID=1526</wfw:commentRss><wfw:comment xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.sqlservercentral.com/blogs/brian_kelley/commentapi.aspx?PostID=1526</wfw:comment><comments>http://www.sqlservercentral.com/blogs/brian_kelley/archive/2007/04/06/1526.aspx#comments</comments><description>&lt;a href="http://www.amazon.com/gp/product/1416507787?ie=UTF8&amp;tag=truthsolution-20&amp;linkCode=as2&amp;camp=1789&amp;creative=9325&amp;creativeASIN=1416507787"&gt;
									&lt;img src="http://www.truthsolutions.com/images/reading_list/1416507787_01__AA_SCTZZZZZZZ_V47147111_.jpg" border="0" align="left"&gt;&lt;/a&gt; &lt;i&gt;&lt;br&gt;&lt;a href="http://www.amazon.com/gp/product/1416507787?ie=UTF8&amp;tag=truthsolution-20&amp;linkCode=as2&amp;camp=1789&amp;creative=9325&amp;creativeASIN=1416507787"&gt;The Cuckoo's Egg&lt;/a&gt;&lt;/i&gt; by &lt;a href="http://www.ocf.berkeley.edu/%7Estoll/"&gt;Clifford Stoll&lt;/a&gt; has been around for a while, having been published in 1989. It details how a system administrator (a trained astronomer who had to find something else to do) tracked a &lt;a href="http://en.wikipedia.org/wiki/Markus_Hess"&gt;malicious hacker&lt;/a&gt; through his system and numerous others including defense contractors and unclassified DoD systems. It's one of those books a lot of folks who work security say should be read if you're in the field. When I was a cadet at &lt;a href="http://www.citadel.edu/"&gt;The Citadel&lt;/a&gt;, one of the other guys in my company was reading it and said it was a good thriller of a book. I meant to borrow it from him and never did. Then I meant to read it for some time but every time I thought about it, I would subsequently forget to go look for it or check it out from the library. Well, I finally did read it and found that my friend's assessment was a good one. I think my wife would agree as she swiped it away from me before I was done and finished it first.&lt;br&gt;&lt;br&gt;As I went through the book I watched for security principles in play and what was true in 1989 in large part holds true today. Some of the things that were revealed as Mr. Stoll went through his meticulous process of tracking the intruder who was working for the KGB:&lt;br&gt;&lt;br&gt;&lt;ul&gt;&lt;li&gt;&lt;b&gt;Honeypots are effective to attract an attacker and learn about his or her methods.&lt;/b&gt; In the book Stoll's roommate comes up with an idea to place what look to be classified documents on a military defense system on one of the servers and to keep it updated so as to look like a regular project that is progressing. This is ultimately how they get the attacker to stay connected long enough to trace him. Honeypots are used today to attract attacks, especially automated ones, so we can analyze them and learn to defend against them.&lt;/li&gt;&lt;li&gt;&lt;b&gt;Dictionary based passwords don't work.&lt;/b&gt; The attacker in the tale kept grabbing the password file from the servers he was attacking. Stoll at first couldn't figure out why because the passwords were encrypted with a one way function which meant if you had the actual password it was easy to get the encrypted hash, but the opposite, where you have the hash and want to get the actual password wasn't true. However, the algorithm used to encrypt the passwords was well know. So if you calculate all the hashes for a set of words, you can compare the hashes and figure out what the passwords are. BTW, this is an issue with Windows passwords. Do a search for &lt;a href="http://www.google.com/search?q=rainbow+tables"&gt;rainbow tables&lt;/a&gt; and you'll find several sites that have rainbow tables for Windows-based passwords.&lt;/li&gt;&lt;li&gt;&lt;b&gt;Just because you can't see the monitoring devices doesn't mean you aren't being watched.&lt;/b&gt; Stoll put a line printer before the server itself, meaning he got an output of everything that was going back and forth on the line. this allowed him to watch the attacker as he came and went. Nothing was running on the server itself. This is analogous to two things in today's world: sniffers and rootkits. Sniffers watch the wire and from the server you can't tell you're being watched. This is why encrypting sensitive data across untrusted lines is important. Rootkits are running at a level where they can intercept any calls you make to try and detect them. That's why there was so much concern over rootkits (and still is).&lt;/li&gt;&lt;li&gt;&lt;b&gt;When doing forensics work, keep a log.&lt;/b&gt; This is a no-brainer. Log everything you do, who you speak to, every step. Time and time again Stoll went back to his log. Because he had it, he was able to connect a lot about the attacker's behavior, prove he had informed the right people of what happened, etc. This is actually a good rule for troubleshooting. Log everything you do because you (a) want to be able to undo anything that didn't work and (b) you want to know how exactly you fixed a problem.&lt;/li&gt;&lt;li&gt;&lt;b&gt;Don't assume your system has no value. &lt;/b&gt;Stoll's system didn't have classfied secrets on it. But it did represent a jumping off point to attack other systems. Frequently I have conversations with folks about securing development servers. To the attacker, a development server may be just as valuable as a production server. If a system is on your production network, it needs to be secured.&lt;/li&gt;&lt;li&gt;&lt;b&gt;Don't assume you are secure.&lt;/b&gt; Stoll found several folks who assumed their systems were secured. The evidence showed otherwise. Paranoia is good in the security field. Let me rephrase that... controlled and focused paranoia is good.&lt;/li&gt;&lt;li&gt;&lt;b&gt;Check your logs frequently and investigate inconsistencies. &lt;/b&gt;Stoll stumbled onto the hacker because of a 75 cent accounting error. That's what started the whole trace. The better an attacker is, the less likely he or she is to leave clues. Therefore, even the smallest details are important.&lt;/li&gt;&lt;li&gt;&lt;b&gt;Change default accounts and passwords.&lt;/b&gt; The attacker kept breaking into systems because administrators had left default accounts and passwords active. Blank passwords, passwords of password (or some derivative), and default passwords are all bad. If an attacker is knowledgeable of the defaults and we leave them active, we've opened the door. It was amazing how many systems the attacker got into using this simple method. &lt;br&gt;&lt;/li&gt;&lt;/ul&gt;&lt;br&gt;&lt;font size="1"&gt;&lt;b&gt;Technorati Tags:&lt;/b&gt; &lt;a href="http://technorati.com/tag/DATABASE"&gt;&lt;/a&gt;&lt;a href="http://technorati.com/tag/Security"&gt;Security&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/Database+Security"&gt;Database Security&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/Network+Security"&gt;Network Security&lt;/a&gt; |
&lt;a href="http://technorati.com/tag/Windows+Security"&gt;Windows Security&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/SQL+Server+Security"&gt;SQL Server Security&lt;/a&gt;&lt;/font&gt;&lt;br&gt;&lt;img src="http://www.sqlservercentral.com/blogs/aggbug.aspx?PostID=1526" width="1" height="1"&gt;</description><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/SQL+Server+2000/default.aspx">SQL Server 2000</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/MySQL/default.aspx">MySQL</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/SQL+Server+2005/default.aspx">SQL Server 2005</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Books+_2F00_+Writing/default.aspx">Books / Writing</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Security/default.aspx">Security</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Windows+Server/default.aspx">Windows Server</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Windows+Workstation/default.aspx">Windows Workstation</category></item><item><title>Daylight Saving Time and SQL Server</title><link>http://www.sqlservercentral.com/blogs/brian_kelley/archive/2007/02/13/1383.aspx</link><pubDate>Wed, 14 Feb 2007 03:54:00 GMT</pubDate><guid isPermaLink="false">70975365-724d-4ce8-8d1c-45c963ab81ff:1383</guid><dc:creator>K. Brian Kelley</dc:creator><slash:comments>8</slash:comments><wfw:commentRss xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.sqlservercentral.com/blogs/brian_kelley/rsscomments.aspx?PostID=1383</wfw:commentRss><wfw:comment xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.sqlservercentral.com/blogs/brian_kelley/commentapi.aspx?PostID=1383</wfw:comment><comments>http://www.sqlservercentral.com/blogs/brian_kelley/archive/2007/02/13/1383.aspx#comments</comments><description>If you're in the United States, chances are you've already heard about Daylight Saving Time (DST) occurring 3 weeks early this year. This is due to the &lt;a href="http://en.wikipedia.org/wiki/Energy_Policy_Act_of_2005"&gt;Energy Policy Act of 2005&lt;/a&gt;, so it's not new news, but a lot of systems and applications are only now getting the updates. The Energy Policy Act of 2005 changes DST to start on the 2nd Sunday in March instead of the first Sunday in April. In addition, it now lasts one week longer, ending the first Sunday of November instead of the last Sunday in October. For this year that means DST starts on March 11.&lt;br&gt;&lt;br&gt;For the most part SQL Server isn't affected. The only SQL Server component which is happens to be Notification Services. You can find information on how to update Notification Services here:&lt;br&gt;&lt;br&gt;&lt;a href="http://support.microsoft.com/kb/931815/en-us"&gt;2007 time zone update for SQL Server 2005 Notification Services and for SQL Server 2000 Notification Services (931815)&lt;/a&gt;&lt;br&gt;&lt;br&gt;Though most SQL Server components aren't affected, the operating system on which SQL Server is installed does need to be updated (with the exception of Vista). For Windows XP and 2003 there is a patch available. You can grab the update for these operating systems here:&lt;br&gt;&lt;br&gt;&lt;a href="http://support.microsoft.com/kb/931836/"&gt;February 2007 cumulative time zone update for Microsoft Windows operating systems (931836)&lt;/a&gt;&lt;br&gt;&lt;br&gt;Windows 2000, since it has passed into Extended support, does not have a publically available update. As a result, these systems must be updated by making modification to the registry. More information can be found here:&lt;br&gt;&lt;br&gt;&lt;a href="http://support.microsoft.com/kb/914387/"&gt;How to configure daylight saving time for the United States in 2007 (914387)&lt;/a&gt;&lt;br&gt;&lt;br&gt;Do note that if you have Outlook on the system (such as on a workstation), there are updates to Outlook which must follow almost immediately. Outlook isn't the only Microsoft based application to be affected. To find out more information on what Microsoft applications are impacted, see here:&lt;br&gt;&lt;br&gt;&lt;a href="http://support.microsoft.com/dst2007/"&gt;Microsoft Daylight Saving Time Help and Support Center&lt;/a&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;font size="1"&gt;&lt;b&gt;Technorati Tags:&lt;/b&gt; &lt;a href="http://technorati.com/tag/Daylight+Saving+Time"&gt;Daylight Saving Time&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/SQL+Server"&gt;SQL Server&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/Microsoft+SQL+Server"&gt;Microsoft SQL Server&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/SQL+Server+2000"&gt;SQL Server 2000&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/SQL+Server+2005"&gt;SQL Server 2005&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/Windows+2000"&gt;Windows 2000&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/Windows+2003"&gt;Windows 2003&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/Windows+XP"&gt;Windows XP&lt;/a&gt; &lt;br&gt;&lt;/font&gt;&lt;img src="http://www.sqlservercentral.com/blogs/aggbug.aspx?PostID=1383" width="1" height="1"&gt;</description><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/SQL+Server+2000/default.aspx">SQL Server 2000</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/SQL+Server+2005/default.aspx">SQL Server 2005</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Tools/default.aspx">Tools</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Architecture/default.aspx">Architecture</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Windows+Server/default.aspx">Windows Server</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Windows+Workstation/default.aspx">Windows Workstation</category></item><item><title>New Review: NGS Software's Typhon III</title><link>http://www.sqlservercentral.com/blogs/brian_kelley/archive/2007/01/25/1325.aspx</link><pubDate>Fri, 26 Jan 2007 04:59:00 GMT</pubDate><guid isPermaLink="false">70975365-724d-4ce8-8d1c-45c963ab81ff:1325</guid><dc:creator>K. Brian Kelley</dc:creator><slash:comments>0</slash:comments><wfw:commentRss xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.sqlservercentral.com/blogs/brian_kelley/rsscomments.aspx?PostID=1325</wfw:commentRss><wfw:comment xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.sqlservercentral.com/blogs/brian_kelley/commentapi.aspx?PostID=1325</wfw:comment><comments>http://www.sqlservercentral.com/blogs/brian_kelley/archive/2007/01/25/1325.aspx#comments</comments><description>I recently had the opportunity to review NGS Software's updated Typhon III general vulnerability scanner. I had previously reviewed it two years ago and was impressed with the product then. The updated version has some nice, new features. You can read my review here: &lt;a href="http://www.sqlservercentral.com/columnists/bkelley/2827.asp"&gt;A Review of Typhon III&lt;/a&gt;. It'll hit the main page of &lt;a href="http://www.sqlservercentral.com/"&gt;SQLServerCentral.com&lt;/a&gt; on Feburary 5, 2007.&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;font size="1"&gt;&lt;b&gt;Technorati Tags:&lt;/b&gt; &lt;a href="http://technorati.com/tag/DATABASE"&gt;DATABASE&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/SQL+Server"&gt;SQL Server&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/Microsoft+SQL+Server"&gt;Microsoft SQL Server&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/SQL+Server+2000"&gt;SQL Server 2000&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/SQL+Server+2005"&gt;SQL Server 2005&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/MySQL"&gt;MySQL&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/Security"&gt;Security&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/Database+Security"&gt;Database Security&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/Network+Security"&gt;Network Security&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/Windows+Security"&gt;Windows Security&lt;/a&gt;
&lt;br&gt;&lt;/font&gt;&lt;img src="http://www.sqlservercentral.com/blogs/aggbug.aspx?PostID=1325" width="1" height="1"&gt;</description><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/SQL+Server+2000/default.aspx">SQL Server 2000</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/MySQL/default.aspx">MySQL</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/SQL+Server+2005/default.aspx">SQL Server 2005</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Tools/default.aspx">Tools</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Security/default.aspx">Security</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Windows+Server/default.aspx">Windows Server</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Windows+Workstation/default.aspx">Windows Workstation</category></item><item><title>Adding value to our organizations</title><link>http://www.sqlservercentral.com/blogs/brian_kelley/archive/2007/01/09/1313.aspx</link><pubDate>Wed, 10 Jan 2007 01:38:00 GMT</pubDate><guid isPermaLink="false">70975365-724d-4ce8-8d1c-45c963ab81ff:1313</guid><dc:creator>K. Brian Kelley</dc:creator><slash:comments>1</slash:comments><wfw:commentRss xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.sqlservercentral.com/blogs/brian_kelley/rsscomments.aspx?PostID=1313</wfw:commentRss><wfw:comment xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.sqlservercentral.com/blogs/brian_kelley/commentapi.aspx?PostID=1313</wfw:comment><comments>http://www.sqlservercentral.com/blogs/brian_kelley/archive/2007/01/09/1313.aspx#comments</comments><description>Sean McCown writes in the latest &lt;a href="http://weblog.infoworld.com/dbunderground/"&gt;Database Underground&lt;/a&gt; about how &lt;a href="http://weblog.infoworld.com/dbunderground/archives/2007/01/dont_be_a_tool.html"&gt;DBAs should try and make things better for users of an organization&lt;/a&gt;. I think Sean hits upon an important point not just for DBAs but for all IT workers. Too often IT is seen as a cost center, an impediment, as something as necessary for an organization but not necessarily glorified or appreciated. As technicians we may find ourselves amazed at how the business people don't see value in what we do, we may groan and complain about they don't understand how hard we work or we may think they don't care. From the business perspective, though, it's hard to understand why it takes so much to do some of the things we do. But then again, we sometimes marvel at some of the things the business folks do and we shake our heads and say, "I don't get it." However, they do and it is their turn to wonder why we don't understand how hard they work and wonder why we don't care. &lt;br&gt;&lt;br&gt;Responsible IT workers seek to make a positive difference for the company beyond their "day jobs." It may not be helping automate a user's spreadsheet, after all, some system administrators may not have much expertise on the latest business software, but there is certainly something every IT worker can do to add value to the organization. A similar point was made by Vanessa Williams in her blog, &lt;a href="http://www.fridgebuzz.com/"&gt;fridgebuzz&lt;/a&gt;. In a recent post titled &lt;a href="http://www.fridgebuzz.com/2007/01/02/the-long-tail-of-web-services/"&gt;The Long Tail of Web Services&lt;/a&gt; she talks about how Amazon.com occasionally gets recognition for some of its initiatives which don't seem to have any relation to its core business. Google is the new "hot company" but just like Amazon.com, Google is investing heavily in its infrastructure. However, while Google has incredible expertise, they aren't utilizing it as a profit center. &lt;br&gt;&lt;br&gt;For Amazon.com, the model is already built. Amazon.com invested heavily in its infrastructure. Now it's seeking to use those investments to allow third-party vendors to partner and piggy-back on the great work its personnel have accomplished. Ultimately, that means a greater and more stable source of revenue for Amazon.com beyond selling warehouses full of books, CD, and DVDs. But for Amazon.com to be positioned to have such a strong infrastructure, that means someone in IT had to think beyond "web store." Then someone had to consider what to do with all that infrastructure and how to make money for Amazon.com. That's adding value, something we can all do. And when we start doing this enough, the organization will see IT as an asset and a wise investment rather than as "overhead."&lt;br&gt;&lt;br&gt;&lt;font size="1"&gt;&lt;b&gt;Technorati Tags:&lt;/b&gt; &lt;a href="http://technorati.com/tag/Life"&gt;Life&lt;/a&gt; |
&lt;a href="http://technorati.com/tag/Work"&gt;Work&lt;/a&gt; |
&lt;a href="http://technorati.com/tag/Information+Technology"&gt;Information Technology&lt;/a&gt; |
&lt;a href="http://technorati.com/tag/Adding+Value"&gt;Adding Value&lt;/a&gt;
&lt;br&gt;&lt;br&gt;&lt;/font&gt;&lt;img src="http://www.sqlservercentral.com/blogs/aggbug.aspx?PostID=1313" width="1" height="1"&gt;</description><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/SQL+Server+2000/default.aspx">SQL Server 2000</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/MySQL/default.aspx">MySQL</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/SQL+Server+2005/default.aspx">SQL Server 2005</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Leadership/default.aspx">Leadership</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Architecture/default.aspx">Architecture</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Security/default.aspx">Security</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Windows+Server/default.aspx">Windows Server</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Windows+Workstation/default.aspx">Windows Workstation</category></item><item><title>Shared Items on Google Reader</title><link>http://www.sqlservercentral.com/blogs/brian_kelley/archive/2007/01/06/1309.aspx</link><pubDate>Sat, 06 Jan 2007 17:05:00 GMT</pubDate><guid isPermaLink="false">70975365-724d-4ce8-8d1c-45c963ab81ff:1309</guid><dc:creator>K. Brian Kelley</dc:creator><slash:comments>1</slash:comments><wfw:commentRss xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.sqlservercentral.com/blogs/brian_kelley/rsscomments.aspx?PostID=1309</wfw:commentRss><wfw:comment xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.sqlservercentral.com/blogs/brian_kelley/commentapi.aspx?PostID=1309</wfw:comment><comments>http://www.sqlservercentral.com/blogs/brian_kelley/archive/2007/01/06/1309.aspx#comments</comments><description>I read through a lot of blogs each day in a variety of technology categories. I've always fashioned myself as a jack-of-all-trades and that helps me a great deal with my current position. However, it does mean consuming a lot of feeds to try and stay up in all the areas I have a profound interest in. Here are my &lt;a href="http://share.opml.org/viewsharedfeeds/?user_id=1672"&gt;shared feeds&lt;/a&gt; on &lt;a href="http://share.opml.org/"&gt;share.opml.org&lt;/a&gt;.&lt;br&gt;&lt;br&gt;&lt;a href="http://www.google.com/reader/"&gt;Google Reader&lt;/a&gt; has a nice feature where I can &lt;a href="http://www.google.com/help/reader/sharing.html"&gt;share items&lt;/a&gt; I find interesting. There are a ton of good blog posts each day, so I've started marking them to be shared. There are two ways to view these shared items: one is the &lt;a href="http://www.google.com/reader/shared/08724552586155039650"&gt;web page&lt;/a&gt; and the other is through the &lt;a href="http://www.google.com/reader/public/atom/user/08724552586155039650/state/com.google/broadcast"&gt;RSS feed&lt;/a&gt;.&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;font size="1"&gt;&lt;b&gt;Technorati Tags:&lt;/b&gt; &lt;a href="http://technorati.com/tag/Google+Reader"&gt;Google Reader&lt;/a&gt; | &lt;a href="http://technorati.com/tag/Blogging"&gt;Blogging&lt;/a&gt; | &lt;a href="http://technorati.com/tag/Sharing+Feeds"&gt;Sharing Feeds&lt;/a&gt; | &lt;a href="http://technorati.com/tag/RSS"&gt;RSS&lt;/a&gt; | &lt;a href="http://technorati.com/tag/OPML"&gt;OPML&lt;/a&gt; | &lt;a href="http://technorati.com/tag/Reading+List"&gt;Reading List&lt;/a&gt;&lt;/font&gt;&lt;br&gt;&lt;br&gt;&lt;img src="http://www.sqlservercentral.com/blogs/aggbug.aspx?PostID=1309" width="1" height="1"&gt;</description><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/SQL+Server+2000/default.aspx">SQL Server 2000</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/MySQL/default.aspx">MySQL</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Perl/default.aspx">Perl</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/SQL+Server+2005/default.aspx">SQL Server 2005</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Tools/default.aspx">Tools</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Books+_2F00_+Writing/default.aspx">Books / Writing</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Leadership/default.aspx">Leadership</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/.NET/default.aspx">.NET</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Architecture/default.aspx">Architecture</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Security/default.aspx">Security</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Windows+Server/default.aspx">Windows Server</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Windows+Workstation/default.aspx">Windows Workstation</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Conferences_2F00_User+Groups/default.aspx">Conferences/User Groups</category></item><item><title>Jason Haley recently began posting his interesting finds again</title><link>http://www.sqlservercentral.com/blogs/brian_kelley/archive/2006/12/09/1219.aspx</link><pubDate>Sat, 09 Dec 2006 16:40:00 GMT</pubDate><guid isPermaLink="false">70975365-724d-4ce8-8d1c-45c963ab81ff:1219</guid><dc:creator>K. Brian Kelley</dc:creator><slash:comments>0</slash:comments><wfw:commentRss xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.sqlservercentral.com/blogs/brian_kelley/rsscomments.aspx?PostID=1219</wfw:commentRss><wfw:comment xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.sqlservercentral.com/blogs/brian_kelley/commentapi.aspx?PostID=1219</wfw:comment><comments>http://www.sqlservercentral.com/blogs/brian_kelley/archive/2006/12/09/1219.aspx#comments</comments><description>&lt;a href="http://jasonhaley.com/Blog/default.aspx"&gt;Jason Haley&lt;/a&gt; used to post his Interesting Finds about every day, if not multiple times a day. The interesting finds were a collection of blog posts and other links he had come across from his various RSS feeds which is put together for others who were interested in the same sorts of things he was (Microsoft development topics, Boston happenings, and after his move to Seattle, Seattle happenings, career development articles, etc.). He took a break for several week, but it's nice to see that he's begun posting them again, &lt;a href="http://jasonhaley.com/blog/archive/2006/11/26/137607.aspx"&gt;starting back around Thanskgiving&lt;/a&gt;.&lt;br&gt;&lt;br&gt;Here's his RSS feed for those who might be interested: &lt;a href="http://jasonhaley.com/blog/Rss.aspx"&gt;JasonHaley.com blog feed&lt;/a&gt;.&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;font size="1"&gt;&lt;b&gt;Technorati Tags:&lt;/b&gt; &lt;a href="http://technorati.com/tag/Microsoft"&gt;Microsoft&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/Programming"&gt;Programming&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/DATABASE"&gt;DATABASE&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/SQL"&gt;SQL&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/T-SQL"&gt;T-SQL&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/SQL+Server"&gt;SQL Server&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/Microsoft+SQL+Server"&gt;Microsoft SQL Server&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/SQL+Server+2000"&gt;SQL Server 2000&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/SQL+Server+2005"&gt;SQL Server 2005&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/Life"&gt;Life&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/Work"&gt;Work&lt;/a&gt;&lt;/font&gt;
&lt;br&gt;&lt;img src="http://www.sqlservercentral.com/blogs/aggbug.aspx?PostID=1219" width="1" height="1"&gt;</description><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/SQL+Server+2000/default.aspx">SQL Server 2000</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/SQL+Server+2005/default.aspx">SQL Server 2005</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Tools/default.aspx">Tools</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/.NET/default.aspx">.NET</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Windows+Server/default.aspx">Windows Server</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Windows+Workstation/default.aspx">Windows Workstation</category></item><item><title>Windows 2000 Resource Kit Tools Available</title><link>http://www.sqlservercentral.com/blogs/brian_kelley/archive/2006/12/09/1215.aspx</link><pubDate>Sat, 09 Dec 2006 16:21:00 GMT</pubDate><guid isPermaLink="false">70975365-724d-4ce8-8d1c-45c963ab81ff:1215</guid><dc:creator>K. Brian Kelley</dc:creator><slash:comments>0</slash:comments><wfw:commentRss xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.sqlservercentral.com/blogs/brian_kelley/rsscomments.aspx?PostID=1215</wfw:commentRss><wfw:comment xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.sqlservercentral.com/blogs/brian_kelley/commentapi.aspx?PostID=1215</wfw:comment><comments>http://www.sqlservercentral.com/blogs/brian_kelley/archive/2006/12/09/1215.aspx#comments</comments><description>If you're like me and rely a lot on the resource kit tools, you may have found that it's relatively easy to find the Windows Server 2003 Resource Kit tools in searches on the Microsoft site. However, if you still have Windows 2000 computers (including Windows 2000 Active Directory domain controllers), some of the tools re-written for Windows Server 2003 may not work properly on Windows 2000 systems. Microsoft has put together a Knowledge Base article which includes all of the commonly used administrative tools in one place:&lt;br&gt;&lt;br&gt;&amp;nbsp; &lt;a href="http://support.microsoft.com/default.aspx?scid=kb;en-us;927229"&gt;Windows 2000 Resource Kit Tools for Administrative Tasks (927229)&lt;/a&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;font size="1"&gt;&lt;b&gt;Technorati Tags:&lt;/b&gt; &lt;a href="http://technorati.com/tag/Microsoft"&gt;Microsoft&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/Windows+2000"&gt;Windows 2000&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/Active+Directory"&gt;Active Directory&lt;/a&gt;&lt;/font&gt;
&lt;br&gt;&lt;img src="http://www.sqlservercentral.com/blogs/aggbug.aspx?PostID=1215" width="1" height="1"&gt;</description><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Tools/default.aspx">Tools</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Security/default.aspx">Security</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Windows+Server/default.aspx">Windows Server</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Windows+Workstation/default.aspx">Windows Workstation</category></item><item><title>SysInternals Tools Updated</title><link>http://www.sqlservercentral.com/blogs/brian_kelley/archive/2006/12/09/1214.aspx</link><pubDate>Sat, 09 Dec 2006 16:02:00 GMT</pubDate><guid isPermaLink="false">70975365-724d-4ce8-8d1c-45c963ab81ff:1214</guid><dc:creator>K. Brian Kelley</dc:creator><slash:comments>0</slash:comments><wfw:commentRss xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.sqlservercentral.com/blogs/brian_kelley/rsscomments.aspx?PostID=1214</wfw:commentRss><wfw:comment xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.sqlservercentral.com/blogs/brian_kelley/commentapi.aspx?PostID=1214</wfw:comment><comments>http://www.sqlservercentral.com/blogs/brian_kelley/archive/2006/12/09/1214.aspx#comments</comments><description>Several &lt;a href="http://www.microsoft.com/technet/sysinternals/default.mspx"&gt;SysInternals Tools&lt;/a&gt; have been updated. One of the big updates was to the &lt;a href="http://www.microsoft.com/technet/sysinternals/utilities/pstools.mspx"&gt;PSTools Suite&lt;/a&gt; - now you can pass the EULA acceptance in a command line format. When the tools first appeared on the Microsoft TechNet site, there was a &lt;a href="http://forum.sysinternals.com/forum_posts.asp?TID=8783&amp;amp;PN=1"&gt;GUI-based EULA&lt;/a&gt; that popped up when the tool was run. This broke any scripts which relied on the tools.. A new download is all of the SysInternals Tools wrapped into a single download: &lt;a href="http://www.microsoft.com/technet/sysinternals/utilities/sysinternalssuite.mspx"&gt;SysInternals Suite&lt;/a&gt;. This is great because now all the tools can be downloaded and extracted at one time into a directory where before there were a lot of little individual downloads. Even better, if the PATH variable is set to include that directory, they can be run from the command line no matter what directory you happen to be in. For command-line tool junkies like me, this is essential.&lt;br&gt;&lt;br&gt;  &lt;br&gt;&lt;br&gt;&lt;font size="1"&gt;&lt;b&gt;Technorati Tags:&lt;/b&gt; &lt;a href="http://technorati.com/tag/Microsoft"&gt;Microsoft&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/Windows+2000"&gt;Windows 2000&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/Windows+2003"&gt;Windows 2003&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/Windows+XP"&gt;Windows XP&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/Windows+Vista"&gt;Windows Vista&lt;/a&gt;&lt;/font&gt;
&lt;br&gt;&lt;img src="http://www.sqlservercentral.com/blogs/aggbug.aspx?PostID=1214" width="1" height="1"&gt;</description><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Tools/default.aspx">Tools</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Security/default.aspx">Security</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Windows+Server/default.aspx">Windows Server</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Windows+Workstation/default.aspx">Windows Workstation</category></item><item><title>Excellent post on encryption</title><link>http://www.sqlservercentral.com/blogs/brian_kelley/archive/2006/12/01/1132.aspx</link><pubDate>Fri, 01 Dec 2006 14:53:00 GMT</pubDate><guid isPermaLink="false">70975365-724d-4ce8-8d1c-45c963ab81ff:1132</guid><dc:creator>K. Brian Kelley</dc:creator><slash:comments>0</slash:comments><wfw:commentRss xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.sqlservercentral.com/blogs/brian_kelley/rsscomments.aspx?PostID=1132</wfw:commentRss><wfw:comment xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://www.sqlservercentral.com/blogs/brian_kelley/commentapi.aspx?PostID=1132</wfw:comment><comments>http://www.sqlservercentral.com/blogs/brian_kelley/archive/2006/12/01/1132.aspx#comments</comments><description>&lt;a href="http://blogs.msdn.com/lcris/default.aspx"&gt;Laurentiu Cristofor&lt;/a&gt; has an excellent blog post, &lt;a href="http://blogs.msdn.com/lcris/archive/2006/11/30/who-needs-encryption.aspx"&gt;Who needs encryption?&lt;/a&gt;, which presents some point blank facts about encryption and the correlations you can draw from those facts. This post isn't a SQL Server or even a database specific post. It's about encryption in general. &lt;br&gt;&lt;br&gt;I love his Fact #1: &lt;i&gt;&lt;b&gt;Encryption does not eliminate the need to protect some data&lt;/b&gt;&lt;/i&gt;. I was recently talking with some peers about whole disk encryption technologies. The idea behind whole disk encryption technologies is if someone were able to steal the hard drive (such as by taking a laptop), as long as the hard drive was powered off, by powering it on they wouldn't immediately get access to to the data. They would have to decrypt the hard drive. Well, there's two ways to go about this. You can either try and decrypt the whole hard drive, or you can try and decrypt the portion that stores the key to decrypt the whole hard drive. Any serious attacker is going to go after the latter because once you get it, you get the whole hard drive. And that's the point. You no longer are in the business of safeguarding &lt;u&gt;&lt;b&gt;all&lt;/b&gt;&lt;/u&gt; the data. The encryption does that for you with the exception of the key itself. You &lt;b&gt;&lt;u&gt;must &lt;/u&gt;&lt;/b&gt;safeguard it. The discussion with respect to whole disk encryption turned to wanting to make the encryption on the key weaker than on the rest of the drive because people were having to enter in too many combos of characters when they forgot their password and the admins needed to unlock the drive. My point was that whichever was weaker, that was the level to which the hard drive was &lt;u&gt;effectively&lt;/u&gt; encrypted. Therefore, weaking the encryption algorithm on the key to make it easier for customer support reps and end users to being able to unlock the hard drive in the case of a forgotten password wasn't a good idea.&lt;br&gt;&lt;br&gt;Fact #4 is a sticking point for me, too. When developers who aren't very knowledgeable on encryption say, "Hey, I'll just build an encryption algorithm because I don't feel like using one of these others. How hard can it be?"&amp;nbsp; that drives me crazy. A lot of developers understand that here laziness is the right approach. If it's a rock-solid algorithm that has undergone the scrutiny of the crypto community and survived, it's a good candidate. Just figure out how to implement it. Unless you have advanced degrees in mathematics and time in the field, it is extremely arrogant to think you can design an algorithm better than what's already out there. Granted, you might, but given some of the algorithms developed, you've wasted a lot more time doing so when you could have been doing other activities for your organization.&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;font size="1"&gt;&lt;b&gt;Technorati Tags:&lt;/b&gt; &lt;a href="http://technorati.com/tag/Security"&gt;Security&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/Database+Security"&gt;Database Security&lt;/a&gt; | 
&lt;a href="http://technorati.com/tag/Network+Security"&gt;Network Security&lt;/a&gt; |  
&lt;a href="http://technorati.com/tag/Windows+Security"&gt;Windows Security&lt;/a&gt;&lt;br&gt;&lt;/font&gt;&lt;img src="http://www.sqlservercentral.com/blogs/aggbug.aspx?PostID=1132" width="1" height="1"&gt;</description><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/MySQL/default.aspx">MySQL</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/SQL+Server+2005/default.aspx">SQL Server 2005</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Tools/default.aspx">Tools</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Architecture/default.aspx">Architecture</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Security/default.aspx">Security</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Windows+Server/default.aspx">Windows Server</category><category domain="http://www.sqlservercentral.com/blogs/brian_kelley/archive/tags/Windows+Workstation/default.aspx">Windows Workstation</category></item></channel></rss>