December 2011 – Page 2

December 27, 2011DataBase

SQL Query to get the MS SQL server version

SQL Query: SELECT @@VERSION Results: (No column name) Microsoft SQL Server 2008 (SP3) – 10.0.5500.0 (X64) Sep 21 2011 22:45:45 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )

December 27, 2011DataBase

An Introduction to SQL Server Service Broker

Contents Introduction Queues Dialogs Conversation Groups Activation Why Use Asynchronous, Queued Messaging? Why Use Transactional Messaging? How Service Broker Solves the Hard Problems in Messaging Message Ordering Coordination Multithreading Receiver Management Why Build Messaging into the Database? Conversation Group Locking Remote Transactional Receive Handling Common Administration Direct Sends to Receive Queue Common Language Support Single-Connection Execution Capability Enhanced Security Transmission Queue Visibility Across Databases Conclusion Introduction With Service Broker, a feature in Microsoft SQL Server 2005, internal or external processes can send and receive guaranteed, asynchronous messages by using extensions to Transact-SQL Data Manipulation Language (DML). Messages can be sent […]

December 26, 2011Active Directory

List of Active Directory Domain and Forest Functional Levels and Supported Features

Server 2008 R2: Active Directory Functional Levels MJP | Oct 06, 2009 | 8 comments Windows Server 2008 R2 was released in August, and it introduced new functional levels for Active Directory. This article takes a look back at the different functional levels of the past and what is new in the latest release of the server operating system for Active Directory (yes, a recycle bin for AD objects!). Functional levels were first introduced when Active Directory made its appearance in Windows 2000 Server. They allowed you to run different versions of domain controllers in your environment, and when all […]