Learn effective and scalable database design techniques in a SQL Server environment. Pro SQL Server 2012 Relational Database Design and Implementation covers everything from design logic that business users will understand, all the way to the physical implementation of design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, Louis Davidson shows how to “get it right” in SQL Server database design and lay a solid groundwork for the future use of valuable business data....
Pro SQL Server 2012 Reporting Services opens the door to delivering customizable, web-enabled reports across your business at reasonable cost. Reporting Services is Microsoft's enterprise-level reporting platform. It is included with many editions of SQL Server, and is something you'll want to take advantage of if you're running SQL Server as your database engine.
Pro SQL Server 2012 Practices is an anthology of high-end wisdom from a group of accomplished database administrators who are quietly but relentlessly pushing the performance and feature envelope of Microsoft SQL Server 2012. With an emphasis upon performance—but also branching into release management, auditing, and other issues—the book helps you deliver the most value for your company’s investment in Microsoft’s flagship database system
SQL Server 2012 with PowerShell V3 Cookbook
Increase your productivity as a DBA, developer, or IT Pro, by using PowerShell with SQL Server to simplify database management and automate repetitive, mundane tasks.
Donabel Sntos professional expertise distilled
Donabel Santos is a SQL Server MVP and is the senior SQL Server Developer/DBA/
Trainer at QueryWorks Solutions, a consulting and training company in Vancouver, BC.
Microsoft SQL Server implements extensive support for location-based data. Pro Spatial with SQL Server 2012 introduces SQL Server’s spatial feature set, and covers everything you'll need to know to store, manipulate, and analyze information about the physical location of objects in space. You’ll learn about the geography and geometry datatypes, and how to apply them in practical situations involving the spatial relationships of people, places, and things on Earth.
At its core, the process of designing reports hasn’t changed substantially in the past 20 years. The report
designer lays out report objects, which contain data from a known source of data, in a design application
such as Reporting Services, Business Objects Reports, or Microsoft Access. He or she then tests report
execution, verifies the accuracy of the results, and distributes the report to the target audience.
Sure, there are enough differences between design applications to mean that the designer must
become familiar with each particular environment.