- Server Management Objects (SMO) is the set of objects that exposes SQL Server’s configuration and management features for two primary purposes: scripting and programming.. - For administration scripting, PowerShell cmdlets use SMO to access SQL Server objects.. - rather, it’s used by ven- dors when developing SQL Server tools such as Management Studio or a third-party management GUI or backup utility. - New for SQL Server 2008, Filestream technology adds the ability to write or read large BLOB data to Windows files through the database, complete with transactional control.. - SQL Server Services. - The following components are client processes for SQL Server used to control, or communicate with, SQL Server.. - SQL Server Agent. - It can be configured to automatically run when the system boots, or it can be started from SQL Server Configuration Manager or Management Studio’s Object Explorer.. - The Database Mail component enables SQL Server to send mail to an external mailbox through SMTP.. - Chapter 43, ‘‘Automating Database Maintenance with SQL Server Agent. - details SQL agents and jobs, as well as the SQL Server Agent. - It also explains how to set up a mail profile for SQL Server and how to send mail.. - A Brief History of SQL Server. - SQL Server 1.0 was jointly released in 1989 by Microsoft, Sybase, and Ashton-Tate. - The product was based on Sybase SQL Server 3.0 for Unix and VMS.. - SQL Server 4.2.1 for Windows NT was released in 1993. - SQL Server 6.0 (code-named SQL 95) was released in 1995. - SQL Server 7.0 (Sphinx) was released in 1999, and was a full rewrite of the Database Engine by Microsoft.. - From a code perspective, this was the first Microsoft SQL Server. - SQL Server 7 also included English Query (Argo), OLAP Services (Plato), replication, Database Design and Query tools (DaVinci) and Full-Text Search (aptly code-named Babylon.) Data Transformation Services (DTS) is also introduced.. - SQL Server 2000 (Shiloh) 32-bit, version 8, introduced SQL Server to the enterprise with clustering, much better performance, and real OLAP. - SQL Server 2000 64-bit version for Intel Itanium (Liberty) was released in 2003, along with the first version of Reporting Services (Rosetta) and Data Mining tools (Aurum). - SQL Server 2005 (Yukon), version 9, was another rewrite of the Database Engine and pushed SQL Server further into the enterprise space. - SQL Server 2005 supported 32-bit, 64x, and Itanium CPUs. - SQL Server 2008 (Katmai), version 10, is a natural evolution of SQL Server, adding Policy-Based Management, data compression, Resource Governor, and new beyond relational data types. - Kilimanjaro, estimated availability in mid-2010 extends SQL Server’s BI suite with tighter integration with Office 14.. - SQL11 continues the strategic direction of SQL Server 2008.. - SQL Server provides a great toolset to build BI applications, which explains Microsoft’s continued gains in the growing BI market. - SQL Server includes three services designed for business intelligence: Integra- tion Services (IS, or sometimes called SSIS for SQL Server Integration Services), Reporting Services (RS), and Analysis Services (AS). - Integration Services (IS) moves data among nearly any type of data source and is SQL Server’s extract- transform-load (ETL) tool. - If any other company were marketing SSIS it would be their flagship product, but instead it’s bundled inside SQL Server without much fanfare and at no extra charge. - Whereas relational databases in SQL Server are queried using T-SQL, cubes are queried using Multidi- mensional Expressions (MDX), a set-based query language tailored to retrieving multidimensional data (see Figure 1-3). - in other words, the suite of products that support an organization’s BI efforts both inside and outside of SQL Server.. - The SQL Server products described here are the BI platform of the stack, providing the data acquisition, storage, summarization, and reporting — the basis for analysis. - Reporting Services (RS) for SQL Server 2005 is a full-featured, web-based, managed reporting solution.. - rdl files in the Reporting Services databases in SQL Server. - Reporting Services is bundled with SQL Server so there are no end-user licensing issues. - With SQL Server 2008, Reporting Services gets a facelift: slick new Dundas controls, a new Tablix con- trol, a re-written memory management system, and a direct HTTP.sys access, so IIS is no longer needed.. - SQL Server 2008 retains most of the UI feel of SQL Server 2005, with a few significant enhancements.. - SQL Server Management Studio. - At its core is the visual Object Explorer, complete with filters and the capability to browse all the SQL Server servers (Database Engine, Analysis Services, Reporting Services, etc. - SQL Server Configuration Manager. - Use the Configuration Manager to launch and control SQL Server’s many servers.. - SQL Server is capable of exposing a trace of selected events and data points. - While Profiler records large sets of details concerning SQL traffic and SQL Server events, Performance Monitor is a visual window into the current status of the selected performance counters. - When SQL Server is installed, it adds a ton of useful performance counters to Performance Monitor. - Integration Services and SQL Server. - The SQL Server documentation team did an excellent job with Books Online (BOL. - SQL Server’s mega help on steroids. - Both the Community Menu and Developer Center launch web pages that enable users to ask a question or learn more about SQL Server.. - That’s where you’ll find AdventureWorks2008, the official sample database for SQL Server 2008, along with AdventureWorksLT (a smaller version of AdventureWorks) and AdventureWorksDW (the BI companion to AdventureWorks). - SQL Server Editions. - SQL Server is available in several editions (not to be confused with versions), which differ in terms of features, hardware, and cost. - Standard Edition: The majority of medium to large production database needs will be well served by the SQL Server 2008 Standard Edition, the workhorse edition of SQL Server. - With multi-core CPUs becoming commonplace in servers, the question is, how does this affect licensing? The good news is that Microsoft is licensing SQL Server by the CPU socket, not the number of CPU cores. - This means that a dual CPU server running quad-core CPUs will function almost as if the server had eight CPUs, but you’re only paying for two CPUs’ worth of SQL Server licensing.. - Web Edition: As the name implies, the Web Edition, new for SQL Server 2008 is licensed for hosting websites.SQL Server Express Edition: This free (no upfront cost, no royalties, no redistributable fees) version of SQL Server is not simply a plug-in replacement for the Access Jet database engine. - It’s a full version of the SQL Server Database Engine intended to serve as an embedded database within an application. - I’d recommend SQL Server Express Edition for any small .NET application that needs a real database. - SQL Server Compact Edition: CE is technically a different Database Engine with a different feature set and a different set of commands. - This book does not cover SQL Server CE.. - Any new server will sport shiny, new 64-bit multi-core CPUs, and considering the smoother memory addressing and performance gains, I see no reason why SQL Server is not a 64-bit only product — except for, perhaps, Developer and Express Editions.. - Do your shop a favor and don’t even consider 32-bit SQL Server for production.
Xem thử không khả dụng, vui lòng xem tại trang nguồn hoặc xem
Tóm tắt