Home > Articles > Data > SQL Server

SQL Server

RSS Feed Subscribe to this topic  RSS details

178 Items

Sort by Date | Title

Creating a SQL Server Database
By Alison Balter
Nov 25, 2015
This lesson from T-SQL in One Hour a Day, Sams Teach Yourself covers how to create a SQL Server database, how to set database options, how to work with the Transaction Log, and how to attach to an existing database.
SQL Server AlwaysOn and Availability Groups
By Ray Rankins, Paul Bertucci, Chris Gallelli, Alex T. Silverstein
Jun 29, 2015
SQL Server's AlwaysOn is taking the database world by storm. This chapter from Microsoft SQL Server 2014 Unleashed dives into the AlwaysOn new features and availability groups.
Swift Development: Nobody Knows the Tuples I've Seen
By Erica Sadun
Jun 23, 2015
In the Swift programming language, tuples play specialized roles that lend power and flexibility to your development. Erica Sadun, bestselling author of The Gourmet iOS Developer's Cookbook: Even More Recipes for Better iOS App Development, explores tuples in depth.
In-Memory Optimization and the Buffer Pool Extension in SQL Server 2014
By Ray Rankins, Paul Bertucci, Chris Gallelli, Alex T. Silverstein
Jun 18, 2015
To take maximum advantage of the performance improvements that can be achieved from having your critical OLTP tables memory resident, Microsoft developed the In-Memory Optimization feature for SQL Server. Another feature introduced in SQL Server 2014 to take advantage of the lower costs and increased sizes of SSDs, is the Buffer Pool Extension feature. The authors of Microsoft SQL Server 2014 Unleashed discuss both of these exciting new features in this chapter.
Preface to Microsoft SQL Server 2014 Unleashed
By Ray Rankins, Paul Bertucci, Chris Gallelli, Alex T. Silverstein
May 26, 2015
The authors of Microsoft SQL Server 2014 Unleashed introduce their book and discuss its intended audience, what the book covers, and conventions used in the book.
Cloud Computing Reference Architecture: Data Ingress and Storage Access
By Buck Woody
Oct 24, 2012
Buck Woody, Senior Technical Specialist on Windows Azure at Microsoft, describes how to create a centralized, off-premises (cloud-based) data store that provides flexibility, security, consistency, and guards against vendor lock-in.
Administering Storage, I/O, and Partitioning in Microsoft SQL Server 2012
By Ross Mistry
Sep 27, 2012
This chapter focuses on the use and most effective configuration of storage components within a Database Engine instance of SQL Server 2012.
Synchronization with Microsoft SQL Server Analysis Services
By Baya Dewald
Feb 21, 2012
Database administration expert Baya Dewald shows how built-in synchronization works and how it compares to other approaches for distributing the querying load across multiple hosts.
Transact-SQL Improvements with SQL Server 2008, Part 2
By Baya Dewald
Oct 4, 2011
Baya Dewald concludes this two-part series on Transact-SQL by discussing functions for grouping and table-valued parameters for passing multiple data rows to a stored procedure.
Transact-SQL Improvements with SQL Server 2008, Part 1
By Baya Dewald
Sep 27, 2011
Baya Dewald discusses some of the most exciting of the new and changed functionality for working with variables, managing date and time values, and row constructors in Transact-SQL .
Monitoring and Tuning Analysis Services with SQL Profiler, Part 2
By Baya Dewald
Aug 30, 2011
Baya Dewald concludes his series on monitoring and tuning SQL Server analysis services with a discussion of how to use SQL Profiler to analyze and adjust your MDX queries and your database's processing with the goal of streamlining everything for best performance.
Monitoring and Tuning Analysis Services with SQL Profiler, Part 1
By Baya Dewald
Aug 23, 2011
Database administration expert Baya Dewald explores the possibilities of using the SQL Profiler framework to find common performance problems in your SQL Server Analysis Services (SSAS) cubes.
Examples of SQL Server Implementations
By Alex T. Silverstein, Paul Bertucci, Chris Gallelli, Ray Rankins
Sep 22, 2010
This chapter provides examples of real-life database applications running in production environments at major organizations around the world.
Recommended Practices for SQL Server Analysis Services 2005/2008 Design
By Baya Dewald
Feb 8, 2010
Baya Dewald offers recommendations for avoiding the most commonly encountered dimension/partition design pitfalls for SQL Server Analysis Services 2005 and 2008.
SQL Server Analysis Services 2005/2008 Administration
By Baya Dewald
Jan 22, 2010
Baya Dewald shows you the skills required for administering the latest versions of Analysis Services and how they compare to managing relational databases.
Deploying Merge Replication Subscribers in SQL Server
By Hilary Cotter
Sep 10, 2009
Hilary Cotter shows how to decouple your SQL Server snapshot generation from your snapshot application process for the best possible performance - all while letting you keep your sanity.
Introduction to SQL Server Reporting Services (SSRS)
By Amit Goyal, Jim Joseph, Michael Lisin
Aug 4, 2009
This chapter focuses on the features and capabilities of SSRS and how they fit into the Microsoft Business Intelligence platform.
Installing or Upgrading to the SQL Server 2008 Database Engine
By Hilary Cotter, Ross Mistry
May 28, 2009
This chapter describes the step-by-step process for installing a clean version of SQL Server 2008 Database Engine and/or upgrading an existing SQL Server Database Engine implementation to SQL Server 2008.
Microsoft SQL Server Analysis Services: Introduction to OLAP and Its Role in Business Intelligence
By Alexander Berger, Irina Gorbach, Edward Melomed
May 28, 2009
This chapter explains how SQL Server Analysis Services uses the Multidimensional Data Model to define and process data as well as interact with other data storing systems.
SQL Server Forensic Investigation Scenario
By Kevvie Fowler
Apr 13, 2009
This chapter walks through an actual forensic investigation scenario, showing the logical progression of events during an investigation.

Page 1 2 3 4 5 Next >