24 Items Sort by date|Sort by title
- By Stacia MisnerApr 15, 2013
- The purpose of this chapter from Microsoft SQL Server 2012 Reporting Services is to help you think about how to prepare for the report development process. Knowing who will view reports and how they want or need to interact with reports has an impact on how you should design those reports.
- By David LeBlancFeb 15, 2013
- In this chapter from Microsoft SQL Server 2012 Step by Step, you will first learn the importance of implementing and enforcing a naming standard. From there, you will be introduced to the various data types that are supported by SQL Server. Then you will create your first table using Microsoft SQL Server Management Studio (SSMS) and Transact-SQL (T-SQL). Finally, you will use the same methods to add constraints and keys to your tables.
- By David LeBlancFeb 15, 2013
- In this chapter from Microsoft SQL Server 2012 Step by Step, you will examine the components and features of Microsoft SQL Server 2012 and determine how they fit into your installation.
- By Dejan Sarka, Itzik Ben-Gan, Ron TalmageDec 15, 2012
- Transact-SQL (T-SQL) is the main language used to manage and manipulate data in Microsoft SQL Server. This chapter lays the foundations for querying data by using T-SQL. The chapter describes the roots of this language, terminology, and the mindset you need to adopt when writing T-SQL code. It then moves on to describe one of the most important concepts you need to know about the language—logical query processing.
- By Dejan Sarka, Grega Jerkic, Matija LahDec 15, 2012
- When you are developing Microsoft SQL Server Integration Services (SSIS) packages, it is a good practice to make each task or transformation as dynamic as possible. To do this, you can use the new features in SQL Server 2012, such as parameters and project-level connection managers, or you can use the package configurations that were first made available in the package deployment model in earlier versions of SQL Server. This chapter discusses both possibilities.
- By Andrew Brust, Leonard G. LobelJul 15, 2012
- In this chapter from Programming Microsoft SQL Server 2012, you’ll learn how to use SSDT inside Visual Studio to significantly enhance your productivity as a SQL Server developer. It begins with an overview of key SSDT concepts and features, and then goes through demonstrations of various connected and disconnected scenarios.
- By Itzik Ben-GanJul 15, 2012
- This chapter from Microsoft SQL Server 2012 T-SQL Fundamentals introduces you to the SELECT statement, logical query processing, and various other aspects of single-table queries.
- By Itzik Ben-GanApr 15, 2012
- This chapter from Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions provides the background of window functions, a glimpse of solutions using them, coverage of the elements involved in window specifications, an account of the query elements supporting window functions, and a description of the standard’s solution for reusing window definitions.
- By William StanekFeb 15, 2012
- Policy-Based Management is an extensible and scalable configuration framework that you can use to manage servers, databases, and other objects in your data environments. As an administrator, you need to be very familiar with how Policy-Based Management technology works, and that’s exactly what this chapter is about.
- By William StanekFeb 15, 2012
- In this chapter from Microsoft SQL Server 2012 Pocket Consultant, you will learn how to use SQL Server Management Studio.
- By Hitachi Consulting, Scott CameronApr 15, 2009
- This chapter from Microsoft SQL Server 2008 Analysis Services Step by Step explains how Analysis Services physically processes and stores data. The explanations are simplified, but they encompass some of the most complex topics in this book. If nothing else, this chapter can give you an appreciation for the sophistication and elegance of the Analysis Services server design.
- By Itzik Ben-Gan, Steve Kass, Lubor Kollar, Dejan SarkaMar 25, 2009
- This chapter from Inside Microsoft SQL Server 2008 T-SQL Querying covers various data-aggregation techniques, including using the OVER clause with aggregate functions, tiebreakers, running aggregates, pivoting, unpivoting, custom aggregations, histograms, grouping factors, and grouping sets.
- By Kalen Delaney, Conor Cunningham, Adam Machanic, Ben Nevarez, Paul S. Randal, Kimberly L. TrippMar 11, 2009
- In general, database systems can take two approaches to managing concurrent data access: optimistic or pessimistic. Learn the basic differences between the two models, the five possible isolation levels in SQL Server 2008, and the internals of how SQL Server controls concurrent access using each model. Also learn how to control the isolation level, and understand the metadata that shows you what SQL Server is doing, in this chapter from Microsoft SQL Server 2008 Internals.
- By Stacia MisnerFeb 25, 2009
- This chapter from Microsoft SQL Server 2008 Reporting Services Step by Step shows you how to deploy reports to the report server, organize content on the report server by using folders, create a linked report on a native-mode report server, override report parameter settings, manage authentication in data sources, control report execution, and create and store report snapshots in history.
- By Bryan Smith, C. ClayFeb 25, 2009
- Analysis Services provides a number of time-based MDX functions. Using these functions, powerful metrics can be assembled. In this chapter from Microsoft SQL Server 2008 MDX Step by Step, you learn how to employ the time-based MDX functions to calculate some of the more frequently requested of these metrics.
- By Lynn Langit, Kevin S. GoffFeb 4, 2009
- In this chapter from Smart Business Intelligence Solutions with Microsoft SQL Server 2008, learn the ins and outs of some tools you’ll use when working with Microsoft SQL Server Analysis Services (SSAS) objects. After reading this chapter, you’ll be an expert in not only SQL Server Profiler but also SQL Server Management Studio (SSMS) and other tools that will make your work in SSAS very productive.