Browse by Tags

Related Posts
  • Blog Post: Installing SQL Server 2005 on Windows Server 2008

    I am in the process of installing SQL Server 2005 on a new Windows 2008 Server, and ran into the following warning about missing some required components of IIS: - IIS Feature Requirement (Warning) Messages IIS Feature Requirement Microsoft Internet Information Services (IIS) is either not installed...
  • Blog Post: Take a look under the Kimono

    Have you ever been curious how Microsoft protocols such as SMB, CIFS, BITS, IPSEC, or NTLM work behind the scenes? Perhaps you are a Computer Science student, and you want to see how thing work in a commercially available Operating System, or perhaps you are a developer that works on a product that needs...
  • Blog Post: Maintaining SharePoint's SQL Backend

    Many of Microsoft's enterprise-level applications use SQL Server on the back end to host data, content, etc. CRM, Operations Manager, Sharepoint... You get the idea. While many companies have Database Administrators (DBA's) to manage their business-critical databases (perhaps the ones holding customer...
  • Blog Post: April TechNet Magazine is up!

    Internet Explorer: What’s New in Internet Explorer 8 Everyone expects something different from their browser. Some users are most concerned with security and privacy while others are more focused on customizability. Some want full standards compatibility, and others just desire ease of use. Explore the...
  • Blog Post: 2008 Certification Posters

    I was playing around with Trika's skydrive (wait a minute, that sounded better in my head)... and see that she has uploaded three very nice looking posters showing the various courses, tests and certifications available for SQL Server 2008, Visual Studio 2008, and Windows Server 2008. Apparently she...
  • Blog Post: Free Security Courses

    I was just browsing the IT Pro course catalog over at http://www.microsoftelearning.com , and noticed that there are a TON of free courses relating to Security. There are some non-security free courses as well (related to SQL Server 2008, Windows Server 2008, and a few others), but the price is sure...
  • Blog Post: Security Best Practices

    By no means a comprehensive list, today's Best Practices are brought to you by the letter " security ". TechNet Security Home Assess Your Environment •The Security Risk Management Discipline module •The Assessing Network Security book •The SANS Security Policy Project Protect Your Network •The Deploying...
  • Blog Post: Masters of the (Reading) Universe.

    Unless you are Uber-l33t, you are probably not working on your Microsoft Certified Master certification.  This is  where the best-of-the-best come visit the better-of-the-best on the Redmond Campus to learn everything there is to know about Active Directory Services , SharePoint , OCS , SQL...
  • Blog Post: Evalu'08

    I just ran into the following contest on a banner ad of all places... It looks like if you try out any of our current line of products (Windows Server 2008, Visual Studio 2008, DPM, and the like), you are entered to win some killer prizes! https://www.microsoft.com/Infrastructure/Evalu08/ All you have...
  • Blog Post: Introducing Microsoft SQL Server 2008

    Free eBook available here: http://csna01.libredigital.com/?urss1q2we6 Learn about major new features in SQL Server 2008 including security, administration, and performance. Introducing Microsoft SQL Server 2008: Chapter 1: Security and Administration Chapter 2: Performance Chapter 3: Type System Chapter...
  • Blog Post: SQL Server 2008 Migration White Papers

    Just noticed these pop up on the Microsoft Download Center… some guides on migrating from various databases to SQL Server 2008 . Guide to Migrating from MySQL to SQL Server 2008 In this migration guide you will learn the differences between the MySQL and SQL Server 2008 database platforms, and the steps...
  • Blog Post: SQL Server 2005 Best Practices

    There's no shortage of them!!! http://technet.microsoft.com/en-us/sqlserver/bb331794.aspx Get the real-world guidelines, expert tips, and rock-solid guidance to take your SQL Server implementation to the next level. These SQL Server best practices draw on the extensive experience and expertise from respected...
  • Blog Post: Microsoft Best Practices

    What are Best Practices? According to Wikipedia : Best Practice is a management idea which asserts that there is a technique, method, process, activity, incentive or reward that is more effective at delivering a particular outcome than any other technique, method, process, etc. The idea is that with...
  • Blog Post: Business Intelligence Virtual Labs

    Ever wanted to get your feet wet with Business Intelligence, but didn't want to go through the steps of installing SQL Server, finding some sample data, figuring out how everything works...? The TechNet team has put together a series of Virtual Labs that you can play with for 90 minutes at a time (and...
  • Blog Post: SQL Server Best Practices Analyzer

    The following screenshot will give a DBA severe indigestion (although I have to imagine it is not entirely uncommon on unmanaged installations of SQL, especially those where SQL is just the black box that is installed as a prerequisite). A SQL installation with the database files, logs, and backups on...
  • Blog Post: Web Application Installer

    Wow… not sure how I missed this (especially as Scott covered it recently)!  A perfect companion to the Microsoft Web Platform Installer is the Web Application Installer .  Whereas the former installs and configures all of the plumbing (SQL, IIS, .Net, etc), the  Web Application Installer...
  • Blog Post: SQL Server 2008 Upgrade Technical Reference Guide

    Just released, and only weighing in at 490 pages.  You didn’t have anything better to do over the Thanksgiving weekend, did you? ;) Get it here. Brief Description This 490-page document covers the essential phases and steps to upgrade existing instances of SQL Server 2000 and 2005 to SQL Server...
  • Blog Post: SQL Server Best Practices

    In my last post , I lauded the SharePoint team for putting up a site covering their Best Practices, and mentioned that the other Product Groups should do the same. Ask and you shall receive… SQL Server Best Practices here: http://technet.microsoft.com/en-us/sqlserver/bb671430.aspx
  • Blog Post: Comparing Column Values in T-SQL

    Okay�� so here's the scenario. I have two different tables in a SQL Database, where I need to compare both tables, and find all values in Table B that do not exist in Table A. There are two ways to do this. One with a JOIN, and one with a "NOT EXISTS" Clause:   Method 1:   SELECT b.[ColumnName...
  • Blog Post: SharePoint Service Packs (the definitive list)

    Great list of resources below from Mitch, an Information Worker Architect for Microsoft in New York: On 12/08/07 we released SP1 for the Office System. This includes updates to both Office 2007 and MOSS 2007. We also released the IFilter Pack yesterday (12/18/07). I have included links to these service...
  • Blog Post: SQL Server 2008 Governance, Risk, and Compliance

    I was just reading through the SQL Server 2008 Compliance Guide that was just released, and it actually has some great information on taking advantage of the new features as part of your GRC program.  Transparent encryption, policy-based management, auditing reports… good stuff! Get it here.
  • Blog Post: 24 Hours of SQL Server 2008

    With the SQL Server 2008 release coming next quarter, now is a good time to start ramping up on the skills that you will need to deploy and take advantage of the new features of SQL Server 2008 . I see over on the Data Platform Insider blog that there are now 24 hours of recorded webcast sessions on...