Microsoft has just released SQL Server Data Tools. SQL Server Data Tools provides an integrated environment for database developers to carry out all their database design work for any SQL Server platform (both on and off premise) within Visual Studio. Database developers can use the SQL Server Object Explorer in VS to easily create or edit database objects and data, or execute queries.
Got to SQL Server Data Tools for more details.
Update: A new update is available. Where the initial release used SQL Server 2012 RC0 components, now it includes SQL Server 2012 RTM components.
1/30/2012
1/25/2012
The new Analytic functions in SQL Server 2012 - SQLServerCentral
Analytic Functions
It’s hard to describe the overall purpose of the analytic functions better than how Books Online (BOL) does: “Analytic functions compute an aggregate value based on a group of rows. However, unlike aggregate functions, they can return multiple rows for each group. You can use analytic functions to compute moving averages, running totals, percentages or top-N results within a group.”
SQL Server 2012 adds eight analytic functions, all of which require the use of the OVER clause. These are LAG, LEAD, FIRST_VALUE, LAST_VALUE, CUME_DIST, PERCENT_RANK, PERCENTILE_CONT, and PERCENTILE_DISC. Ther article referenced below will look at each one of these in more detail.
The new Analytic functions in SQL Server 2012 - SQLServerCentral
It’s hard to describe the overall purpose of the analytic functions better than how Books Online (BOL) does: “Analytic functions compute an aggregate value based on a group of rows. However, unlike aggregate functions, they can return multiple rows for each group. You can use analytic functions to compute moving averages, running totals, percentages or top-N results within a group.”
SQL Server 2012 adds eight analytic functions, all of which require the use of the OVER clause. These are LAG, LEAD, FIRST_VALUE, LAST_VALUE, CUME_DIST, PERCENT_RANK, PERCENTILE_CONT, and PERCENTILE_DISC. Ther article referenced below will look at each one of these in more detail.
The new Analytic functions in SQL Server 2012 - SQLServerCentral
1/24/2012
New book: XAML Developer Reference - Microsoft Press - Site Home - MSDN Blogs
Microsoft has announced that the new Microsoft Press book XAML Developer Reference (ISBN 978-0-7356-5896-7, 340 pages), is now available for purchase.
This book covers XAML from the ground up for both Windows Presentation Foundation and Silverlight development—and of course, because XAML is a foundational technology in building Windows 8 applications, learning the information here will be useful for a long time to come.
You’ll discover practical ways to build rich, interactive user interfaces with data integration capabilities and support for multimedia, graphics, and animation. This hands-on guide is ideal for Microsoft .NET developers and web designers alike.
Written by two XAML experts, Mamta Dalal and Ashish Ghoda, this book covers all the basic XAML elements, their properties and event systems, use of templates, positioning, 2D and 3D graphics, markup extensions, data binding, and much more.
The complete Chapter 4, “Markup Extensions and Other Features,” can be read from the link below, for getting a good feel for the level of detail in this book.
New book: XAML Developer Reference - Microsoft Press - Site Home - MSDN Blogs
This book covers XAML from the ground up for both Windows Presentation Foundation and Silverlight development—and of course, because XAML is a foundational technology in building Windows 8 applications, learning the information here will be useful for a long time to come.
You’ll discover practical ways to build rich, interactive user interfaces with data integration capabilities and support for multimedia, graphics, and animation. This hands-on guide is ideal for Microsoft .NET developers and web designers alike.
Written by two XAML experts, Mamta Dalal and Ashish Ghoda, this book covers all the basic XAML elements, their properties and event systems, use of templates, positioning, 2D and 3D graphics, markup extensions, data binding, and much more.
The complete Chapter 4, “Markup Extensions and Other Features,” can be read from the link below, for getting a good feel for the level of detail in this book.
New book: XAML Developer Reference - Microsoft Press - Site Home - MSDN Blogs
1/11/2012
RTM’d today: Microsoft Manual of Style, Fourth Edition - Microsoft Press - Site Home - MSDN Blogs
RTM’d today: Microsoft Manual of Style, Fourth Edition
The Microsoft Manual of Style provides essential guidance to content creators, journalists, technical writers, editors, and everyone else who writes about computer technology. Direct from the Editorial Style Board at Microsoft—you get a comprehensive glossary of both general technology terms and those specific to Microsoft; clear, concise usage and style guidelines with helpful examples and alternatives; guidance on grammar, tone, and voice; and best practices for writing content for the web, optimizing for accessibility, and communicating to a worldwide audience. Fully updated and optimized for ease of use, the Microsoft Manual of Style is designed to help you communicate clearly, consistently, and accurately about technical topics—across a range of audiences and media.
This book will be available for purchase soon. For now, here is a list of the contents as well as an excerpt from the book’s Introduction.
Subscribe to:
Posts (Atom)
