Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL   (RSS)

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

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
Posted by smearp | 0 Comments
Filed under: ,

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/

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

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

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

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

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

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
Posted by smearp | 1 Comments
Filed under: ,

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
Posted by smearp | 1 Comments
Filed under: , ,

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
Posted by smearp | 0 Comments

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,
Posted by smearp | 2 Comments
Filed under: , ,

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"
Posted by smearp | 1 Comments
Filed under:
 
Page view tracker