See all products »
Curah! curation service
Microsoft Tech Companion App
Microsoft Technical Communities
Microsoft Virtual Academy
Server and Tools Blogs
TechNet Flash Newsletter
Cloud and Datacenter
Windows Server 2012 R2
System Center 2012 R2
Microsoft SQL Server 2012 SP1
Windows 8.1 Enterprise
See all trials »
Microsoft Download Center
TechNet Evaluation Center
Compatability & Converters
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
MCSA: Windows 8
Windows Server Certification (MCSE)
Private Cloud Certification (MCSE)
SQL Server Certification (MCSE)
Second shot for certification
Born To Learn blog
Find technical communities in your area
For small and midsize businesses
For IT professionals
For technical support
For home users
Microsoft Premier Online
Microsoft Fix It Center
Security Bulletins & Advisories
International support solutions
Log a support ticket
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums
The Sean Blog
Data Protection Manager 2010
Daylight Savings Time
Microsoft Operations Framework
Microsoft Security Essentials
Network Access Protection
Office Communication Server
Project Server 2010
System Center Essentials
Virtual Machine Manager
Windows Home Server
Windows Live Writer
Windows Server 2008
Browse by Tags
The Sean Blog
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...
26 Jul 2010
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...
25 Aug 2009
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...
12 Mar 2009
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...
9 Mar 2009
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...
9 Dec 2008
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...
26 Nov 2008
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.
15 Nov 2008
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...
29 Sep 2008
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
5 Sep 2008
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...
2 Jul 2008
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...
19 Jun 2008
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...
30 May 2008
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...
16 May 2008
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...
1 Mar 2008
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...
25 Feb 2008
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...
16 Jan 2008
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...
11 Jan 2008
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...
2 Jan 2008
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...
19 Dec 2007
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...
14 May 2007
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...
5 Apr 2007
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...
15 Dec 2006
© 2014 Microsoft Corporation.
Privacy & Cookies