This demo shows how to create an Excel 2010 PivotTable using an SQL Server 2008 R2 Analysis Services cube. The PivotTable will support interactive filtering with a slicer and incorporate calculations from the cube. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
This demo shows how to create a user-defined server role in Transact-SQL. In five minutes we'll walk through how to create a role, add members, remove a member, grant permissions to the role and change the role name. Along the way we'll validate the changes we've made using security catalog views.…
When AdvancedMD acquired their electronic medical records product, they standardized on SQL Server for their Software-as-a-Service product. Troy Young, Chief Architect at AdvancedMD, explains the decision to Bruce Kyle, ISV Architect Evangelist. AdvancedMD has been a Gold Certified Microsoft…
This demo shows how to build a data model for a Microsoft BI solution using the Microsoft Entity Framework that exposes an OData feed to support self-service analytics. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
This demonstration shows how to launch the Distributed Replay controller and client, pre-process a trace file workload, launch the workload and validate that it is running through SQL Server Profiler. Joe Sack Principal Consultant, SQLskills
Jun 03, 2011 at 2:04 AM0
Avg Rating: 0
In this presentation you will learn : 1. Very basics of transaction logs internal structure i.e. VLFs. 2. Best practices for the log files. 3. Impacts of too many VLFs Presented By:- Sakthivel Chidambaram
Jim O’Neil, Developer Evangelist, closes out his five part series covering topics on SQL Server for developers with an overview of execution plan generation. Using SQL Server Management Studio it’s easy (and fun) to watch how queries are optimized and
thereby get a better insight into…
StreamInsight 1.2 is a set of APIs and services included with SQL Server 2012 that helps database developers address real-time data processing workloads, and makes it it easy to develop standing queries over continuous event-stream data that deliver real-time insight. Dr Greg Low SQL Server MVP and…