Windows Server 2008

Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!

Remember the 33 new DMVs in SQL Server 2008 post? I was just poking around in SQL Server 2008  CTP6 and wanted to know if there were any new Dynamic Management Views since CTP5. There are 13 new DMVs in CTP6 and there are a total of 46 new Dynamic Management Views compared to SQL server 2005. The list of them is below, I think their names make clear what the dmv is supposed to do (or at least I think I know)

The 13 DMVs listed below are new in CTP6

dm_audit_actions
dm_audit_class_type_map
dm_db_persisted_sku_features
dm_exec_procedure_stats
dm_exec_trigger_stats
dm_fts_fdhosts
dm_fts_index_keywords
dm_fts_index_keywords_by_document
dm_fts_outstanding_batches
dm_fts_parser
dm_os_dispatchers
dm_os_memory_node_access_stats
dm_server_audit_status

If you want to find out what the names of all the new DMVs are by running a query on your SQL Server 2008 box and you don't have a linked server to a SQL Server 2005 box then don't worry I have prepared the query below for you.

 By Tom Henderson and Rand Dvorak, Network World Lab Alliance , Network World , 02/21/2008.

We tested Windows Server 2008 Enterprise Edition RTM on a switched Gigabit Ethernet D-Link network using primarily a Dell 1950 server equipped with a dual quad-core 1.6GHz CPU, 32GB of dynamic RAM, two Broadcom Gigabit Ethernet network interface cards connecting it to the network and a QLogic 2GB Fibre Channel card connecting it to our internal storage-area network.

To assess operating system compatibility, we also ran Windows Server 2008 on other servers including an HP585G2 with four, dual-core AMD Athlon 64 CPUs with 4GB of DRAM per card and Compaq NetIntelligent Gigabit Ethernet NICs; three Compaq DL-140 boxes (each with dual Intel Xeon CPUs running at 3GHz). The client machines used in testing included various HP and Apple workstations and notebooks running Windows XP SP2, Windows 2000 Professional, Apple 10.4.11 or 10.5.1.

We imported 100,000 users into the Active Directory using LDIFF, creating 32 groups, and seven administrative domains. After importation, we randomly checked each of the Active Directory components for signs of an accurate importation; it was successful. We then made various changes to users, groups, and policy objects and watched for the changes to appear in the new Windows 2008 AD audit logs. Despite the comparative size, changes were fast.

In terms of performance testing, we ran a series of tests where files and folder were copied using four HP PCs, each formatted with fresh copies of Windows XP SP2 first and then with fresh copies of Vista SP1. We copied identical folders containing 60MB of files (a mixture of files ranging from 1K to 17.2MB) on our Dell 1950 PowerEdge server (no antivirus software was used on clients or server) using a batch file, noting copy execution times. Vista SP1 copies were significantly faster over the Ethernet 10Base-T hub that we connected the PCs to the server with (emulating slower speed links). We also compared streaming times using MP3 files from each server.

We also tested performance between NDIS2 (Vista) and NDIS1 (Windows XP, and various SAMBA clients) for file/folder copy speed performance, and found NDIS2/VISTA clients are strongly favored in busy networks.

We measured simple disk access through file/folder copying on a server (rather than client-to-server) to be the same between Windows 2003 and Windows 2008 Server Editions. We tested iSCSI host and target software, and found it to have the same speed as R2-supported file I/O.

We also tested IIS 7 via Web get/posts using inclining concurrency of the get/posts (using static pages), and found that there was no additional performance advantage of Windows 2003 over 2008 server editions until concurrency (number of users getting and posting) was raised significantly, where Windows 2008 and IIS 7 became very fast compared with Windows 2003 and IIS 6. Both versions of IIS were running in default/unoptimized configurations.

Logon compatibility was checked between Windows 2008 Enterprise Edition with Windows 2000 Professional, XP (SP1 and SP2), Vista (with and without SP1,which was released on the same day with the RTM of Windows 2008 Server editions), MacOS 10.4.11, 10.5.1, Ubuntu Linux, Red Hat Linux Enteprise 5, and Debian Sarge. We also used Windows 2008 Enterprise Server (six instances) as a VM guest operating system under VMware ESX 3.5 with no issues. We discovered that support for Macintosh/Linux in advanced services such as Network Access Protection is absent (and can be handled as an unprotected exception), and other Macintosh services (formerly known as Microsoft Services for Macintosh) are no longer supported; these included AppleTalk cross-platform support, and secure logon (encrypted with hash using differing access methods).

http://www.networkworld.com/reviews/2008/022108-windows-2008-test-how.html

As we head into the big Heroes launch next week, Microsoft today introduced the Windows Essential Server Solutions family of products.  < ?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Available later this year, Essential Server Solutions – Windows Small Business Server 2008 and Windows Essential Business Server 2008 – will be the ideal way for small and midsized companies to realize the benefits of Windows Server 2008, Exchange Server 2007, SQL Server 2008 and other new Microsoft server technologies and services.  The goal is to make the benefits of enterprise-class IT accessible, affordable and simpler for smaller organizations.  One of our main purposes for presenting these two products within a family is to clarify for customers and partners that these are indeed integrated, “all-in-one” solutions, versus scaled down versions of Windows Server, or just various products packaged together.

In our announcement today, we unveiled details about Small Business Server 2008 (official name!), including the technologies and services that are integrated with it. A couple of the notable advancements for customers and partners (among many, outlined in the press release) are:

SBS 2008 Premium Edition is now a two-box solution, including a second copy of Windows Server 2008 and SQL Server Standard Edition, making it an ideal platform for a world of third-party business applications.  Great news for software vendors and solution providers.

SBS 2008 integrates a number of new Microsoft-hosted services, such as Office Live Small Business, Windows Live OneCare for Server and Forefront Security for Exchange Small Business Edition, as well as Windows Server Update Services. In this way, SBS 2008 represents the company’s expanding software-plus-services strategy of giving customers the right combinations of hosted services and on-premise software.

We revealed details about Essential Business Server (formerly known as “Centro”) in November.  Both products will be demonstrated at the Heroes launch in L.A. next week.

Joel Sider

There are at least 5 ways to return data from one table which is not in another table. Two of these are SQL Server 2005 and greater only. This is a post mostly for beginners but hopefully everyone will get something out of it.

Here are the 5 different ways

NOT IN
NOT EXISTS
OUTER JOIN
OUTER APPLY (2005+)
EXCEPT (2005+)

Let's see how this all works
First create these two tables with the Celko approved naming convention.

CREATE TABLE #testnulls (ID INT)

INSERT INTO #testnulls VALUES (1)

INSERT INTO #testnulls VALUES (2)

INSERT INTO #testnulls VALUES (null)

CREATE TABLE #testjoin (ID INT)

INSERT INTO #testjoin VALUES (1)

INSERT INTO #testjoin VALUES (3)

NOT IN
Run the following Code

SELECT * FROM #testjoin WHERE ID NOT IN(SELECT ID FROM #testnulls)

What happened? Nothing gets returned! The reason is because the subquery returns a NULL and you can't compare a NULL to anything

Now run this

SELECT * FROM #testjoin

WHERE ID NOT IN(SELECT ID FROM #testnulls WHERE ID IS NOT NULL)

That worked because we eliminated the NULL values in the subquery

This also works

SELECT * FROM #testjoin j

WHERE j.ID NOT IN(SELECT ID FROM #testnulls n WHERE n.ID = j.ID)

NOT EXISTS
NOT EXISTS doesn't have the problem that NOT IN has. Run the following code

SELECT * FROM #testjoin j

WHERE NOT EXISTS (SELECT 1

FROM #testnulls n

WHERE n.ID = j.ID)

Everything worked as expected

LEFT and RIGHT JOIN
Plain vanilla LEFT and RIGHT JOINS

SELECT j.* FROM #testjoin j

LEFT OUTER JOIN #testnulls n ON n.ID = j.ID

WHERE n.ID IS NULL

With a RIGHT Join you just switch the tables around

SELECT j.* FROM #testnulls n

RIGHT OUTER JOIN #testjoin j ON n.ID = j.ID

WHERE n.ID IS NULL

SELECT j.* FROM #testnulls n

FULL OUTER JOIN #testjoin j ON n.ID = j.ID

WHERE n.ID IS NULL

AND j.ID IS NOT NULL

You might wonder why we have LEFT and RIGHT Joins, here is why:
<AttemptToBeFunny>LEFT joins are for people who tend to vote for the democrats, RIGHT joins are for people who tend to vote for Republicans. FULL Joins are for independents/undecided people. </AttemptToBeFunny>

You can be real silly and do a subquery LEFT join
 

SELECT j.* FROM #testjoin j

LEFT OUTER JOIN (SELECT ID FROM #testnulls ) n ON n.ID = j.ID

WHERE n.ID IS NULL

Now let's talk about SQL 2005 and up

OUTER APPLY (SQL 2005 +)
OUTER APPLY is something that got added to SQL 2005

SELECT j.* FROM #testjoin j

OUTER APPLY

(SELECT id FROM #testnulls n

WHERE n.ID = j.ID) a

WHERE a.ID IS NULL

EXCEPT(SQL 2005 +)
EXCEPT is something that got added to SQL 2005. It basically returns everything from the top table which is not in the bottom table

SELECT * FROM #testjoin

EXCEPT

SELECT * FROM #testnulls

I am also mentioning INTERSECT since some people might not have seen it before. INTERSECT returns what ever is in both tables(like a regular join)

SELECT * FROM #testjoin

SELECT * FROM #testnulls

So there you have it, most likely you already know all these types of joins. If you learned something from this post that is a good thing also.

It’s great news when we launch new versions of our major products, so it only makes sense that one of the great names in the history of journalism will participate in the Heroes Happen Here event in Los Angeles on February 27.< ?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Tom Brokaw will be appearing and commenting on the place of digital technology in the global environment.  Mr. Brokaw is a man who hardly needs an introduction: as the anchor and managing editor of NBC Nightly News for 21 years, he is one of the most trusted and respected figures in broadcast journalism.

Appropriately, he is also an expert on unsung heroes.  As author of the best-seller The Greatest Generation, he gave voice to the many common men and women who carried America through the Great Depression and World War Two years.  In his view, their spirit and values laid the foundation for the nation’s success after the war.  It’s a spirit that lives on today – and one that we celebrate with Heroes Happen Here.

With his insight, integrity, and deep interest in technology, Tom Brokaw will bring a keen eye and a great perspective to the Heroes Happen Here event.  We couldn’t be more excited.  Please join us!