book

Microsoft® SQL Server® 2008 Step by Step

by Mike Hotek

November 2008

Beginner

544 pages

14h 35m

English

Microsoft Press

Read now

Unlock full access

Who This Book Is ForHow This Book Is OrganizedFinding Your Best Starting Point in This BookConventions and Features in This BookConventionsOther FeaturesSystem RequirementsSample DatabasesPractice FilesInstalling the Practice FilesUsing the Practice FilesUninstalling the Practice FilesFind Additional Content OnlineSupport for This BookQuestions and Comments
Database EngineStorage EngineSecurity SubsystemProgramming InterfacesService BrokerSQL Server AgentReplicationHigh AvailabilityThe Relational Engine in SQL Server 2008Business IntelligenceIntegration ServicesIntegration Services in SQL Server 2008Reporting ServicesReporting Services in SQL Server 2008Analysis ServicesAnalysis Services in SQL Server 2008Chapter 1 Quick Reference
Editions of SQL Server 2008Infrastructure RequirementsService AccountsCollation SequencesAuthentication ModesSQL Server InstancesUpgrading to SQL Server 2008In-Place UpgradeSide-by-Side UpgradeUpgrade MethodsInstalling SQL Server 2008Install Sample DatabasesChapter 2 Quick Reference
SQL Server DocumentationManagement Tools in SQL Server 2008SQL Server Configuration ManagerSQL Server Management StudioDatabase MailPerformance Management ToolsProfilerDatabase Engine Tuning AdvisorPerformance StudioBusiness Intelligence ToolsBusiness Intelligence Development StudioChapter 3 Quick Reference
SQL Server System DatabasesSQL Server Database StructureDatabase FilesFilegroupsCreating a DatabaseMoving DatabasesDetaching a DatabaseAttaching a DatabaseChapter 4 Quick Reference
Naming ObjectsSchemasData TypesNumeric DataExact and Approximate Numeric Data TypesDecimal Data TypesCharacter DataFixed and Variable Length Character DataUnicode DataVarchar(max) and nvarchar(max)Date and Time DataBinary DataXMLFILESTREAM DataSpatial Data TypeHierarchyID Data TypeColumn PropertiesCreating TablesComputed ColumnsSparse ColumnsConstraintsPrimary KeysUnique ConstraintsCheck ConstraintsDefault ConstraintsForeign KeysDatabase DiagramsChapter 5 Quick Reference
Index StructureBalanced Trees (B-trees)Index levelsClustered IndexesNonclustered IndexesIndex MaintenanceIncluded ColumnsCovering IndexesFiltered IndexesOnline Index CreationIndex Management and MaintenanceIndex FragmentationFill FactorDefragmenting an IndexDisabling an indexXML IndexesSpatial IndexesChapter 6 Quick Reference

Partition FunctionsPartition SchemesFilegroupsPartitioning Tables and IndexesPartial Backup and RestoreCreating a Partitioned IndexManaging PartitionsSPLIT and MERGE OperatorsAltering a Partition SchemeIndex AlignmentSWITCH OperatorChapter 7 Quick Reference
General SELECT StatementSorting ResultsFiltering DataRetrieving from More Than One TableRetrieving Unique ResultsChapter 8 Quick Reference
General SELECT StatementAggregating DataAggregating Multiple PermutationsFiltering AggregatesRunning AggregatesCalculating Pivot TablesRanking DataAggregating Result SetsCommon Table ExpressionsQuerying XML DataChapter 9 Quick Reference
Inserting DataINSERTSELECT INTOUpdating DataDeleting DataTRUNCATEMERGE StatementOUTPUT ClauseTransaction HandlingTracking ChangesChange TrackingChange Data CaptureChapter 10 Quick Reference
Creating a ViewQuery SubstitutionModifying Data Through a ViewCreating an Indexed ViewQuery SubstitutionChapter 11 Quick Reference
Creating Stored ProceduresCommenting CodeVariables, Parameters, and Return CodesVariablesParametersReturn CodesExecuting Stored ProceduresControl Flow ConstructsError HandlingDynamic ExecutionCursorsCLR ProceduresBuilding an Administrative ProcedureChapter 12 Quick Reference
System FunctionsCreating a FunctionRetrieving Data from a FunctionChapter 13 Quick Reference
DML TriggersDDL TriggersChapter 14 Quick Reference
Creating a Database SnapshotCopy-On-Write TechnologyReverting Data Using a Database SnapshotChapter 15 Quick Reference
Service Broker ArchitectureMessaging OverviewService Broker ComponentsApplication InteractionMessage Types and ContractsMessage TypesContractsQueues and ServicesQueuesServicesConversationsSending and Receiving MessagesSending MessagesReceiving MessagesQueue ActivationPrioritizationChapter 16 Quick Reference
Full-Text CatalogsFull-Text IndexesQuerying Full-Text DataFREETEXTCONTAINSChapter 17 Quick Reference
Configuring the Attack SurfaceEndpointsEndpoint Types and PayloadsEndpoint AccessTCP EndpointsTCP Protocol ArgumentsDatabase Mirroring ArgumentsService Broker ArgumentsEncryptionPrincipals, Securables, and PermissionsPrincipalsInstance Level PrincipalsDatabase Level PrincipalsImpersonationSecurablesPermissionsOwnership ChainsMetadata SecurityCLR SecurityData EncryptionMaster KeysService Master KeyDatabase Master KeyHash AlgorithmsSymmetric KeysCertificates and Asymmetric KeysAsymmetric KeysCertificatesTransparent Data EncryptionEncryption Key ManagementChapter 18 Quick Reference
Overview of Policy-Based ManagementFacetsConditionsPolicy TargetsPoliciesPolicy CategoriesPolicy ComplianceChapter 19 Quick Reference
Database BackupsBackup TypesFull BackupsTransaction Log BackupsDifferential BackupsFilegroup BackupsPage CorruptionRecovery ModelsDatabase RestoresRestoring a Full BackupRestore PathsRestoring a Differential BackupRestoring a Transaction Log BackupChapter 20 Quick Reference
Creating JobsJobs StepsJob SchedulesOperatorsCreating Maintenance PlansCreating AlertsChapter 21 Quick Reference
Overview of DMVsRetrieving Object MetadataDatabase DiagnosticsObject SizeIndexesQuery Execution StatisticsChapter 22 Quick Reference
Failover ClusteringFailover Cluster Instance ComponentsNetwork ConfigurationDisk ConfigurationSecurity ConfigurationHealth ChecksCluster FailoverDatabase MirroringDatabase Mirroring RolesPrincipal RoleMirror RoleWitness ServerDatabase-level vs. Server-level RolesDatabase Mirroring EndpointsOperating ModesHigh Availability Operating ModeHigh Performance Operating ModeHigh Safety Operating ModeCachingTransparent Client RedirectCorrupt PagesDatabase SnapshotsInitializing Database MirroringRecovery ModelBackup and RestoreLog ShippingLog Shipping ComponentsPrimary DatabaseSecondary DatabaseMonitor ServerLog Shipping InitializationCreating JobsData Loss ExposureRestoring BackupsRestoring a Full Backup During ConfigurationReplicationReplication ComponentsArticlesPublicationsFiltersReplication RolesReplication AgentsSnapshot AgentLog Reader AgentDistribution AgentMerge AgentQueue Reader AgentReplication MethodsSnapshot ReplicationTransactional ReplicationMerge ReplicationChapter 23 Quick Reference
BIDS OverviewTasksTransformsBuilding a PackageConnectionsControl FlowData FlowData ConversionException HandlingConfigurationDeploymentChapter 24 Quick Reference
Configuring Reporting ServicesReporting Services Web SiteCreating ReportsBuilding a ReportFormattingComputationsInteractive ElementsParametersDeploy ReportsReport SubscriptionsLinked ReportsReport Caching and SnapshotsChapter 25 Quick Reference
Data Warehousing OverviewOnline Analytic Processing (OLAP)Dimensional ModelCubesDimensions, Measures, and CalculationsHierarchiesKPIs, Partitions, Perspectives, and TranslationsKey Performance Indicators (KPIs)PartitionsPerspectivesTranslationsData MiningAlgorithmsAlgorithm CategoriesSSAS Data Mining AlgorithmsMining Models and Mining StructuresData Mining DemystifiedChapter 26 Quick Reference
Visual BasicVisual C#Web DevelopmentData AccessSQL ServerOther Developer Topics
Developer Step by StepDeveloper ReferenceFocused Topics

Content preview from Microsoft® SQL Server® 2008 Step by Step

About the Author

Mike Hotek is a SQL Server expert with three decades' experience as a consultant and solution developer. He has written several books, including Microsoft SQL Server 2008 Step by Step.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Start your free trial

Microsoft® SQL Server™ 2008 Reporting Services Unleashed

Michael Lisin, Jim Joseph, Amit Goyal

Microsoft® SQL Server® 2012 Step by Step

Patrick LeBlanc

Microsoft® SQL Server® 2012 Integration Services

Rakesh Parida Wee-Hyong Tok Matt Masson, Xiaoning Ding, and Kaarthik Sivashanmugam

Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012

Dejan Sarka Itzik Ben-Gan and Ron Talmage

Publisher Resources

ISBN: 9780735626041Purchase book