This demonstration shows how to implement Columnstore Indexes, establish the performance impact for a standard data warehouse query and lastly show how to modify rows for a table with a Columnstore Index using partitioning. Joe Sack Principal Consultant, SQLskills
This demonstration identifies and loads unique (non-duplicate) resellers into the Reseller entity of a Master Data Services (MDS) model. It involves creating a Data Quality Services (DQS) knowledge base and matching policy, and then using this matching policy with the MDS Excel add-in. Peter Myers…
TechNet RadioOct 30, 2013 at 6:30 PM0
Avg Rating: 5
Kevin Remde welcomes Bruno Saille to the show as they discuss the SQL Server Self-Service Kit and how it works with System Center 2012 to help automate SQL Server deployments. Tune in as they discuss how the self-service kits works, which System Center components are required as well as what…
Microsoft IT improved the user experience and increased productivity by streamlining the migration from previous Windows operating systems to Windows 8 Beta. The solution leveraged a polished Modern UI featuring Windows 8 client/server technologies, USMT 5.0, Microsoft Deployment Toolkit, SQL…
DevRadioJun 10, 2013 at 6:30 AM2
Avg Rating: 5
Like what you heard? Try Windows Azure for FREE and enjoy the freedom to use your preferred OS, language, database or tool. Windows Azure can help you deploy sites to a highly scalable environment, deploy and run virtual machines, and create highly scalable applications in a rich PaaS environment.…
This demo shows how to develop a time dimension for analyzing cube data with SQL Server 2008 R2 Analysis Services. A well designed time dimension enables rich time based analysis. A product dimension will also be developed using the dimension wizard, then customized by adding hierarchies and a…
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 demo shows how to design a simple SQL Server 2008 R2 Reporting Services report using relational data for analyzing sales information that includes conditional formatting. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
This demo shows how to add interactivity to a SQL Server 2008 R2 Reporting Services report, including adding a parameter to filter the data, drilldown and drillthrough behavior, and interactive sorting. Presenter: Peter Myers, Mentor, Solid Quality Mentors.