SQL Server 2012

This demonstration creates a shared data source, uploads an existing report definition, and then relates the report's data source to the newly created data source. Then it proceeds to create a new data alert. The data alert is tested to first send no notification. Then data is modified to ensure a…

This demonstration develops a basic tabular project in Visual Studio. The project will be enhanced in the following demonstration (SQL11UPD06-DEMO-02) by adding new Data Analysis Expressions (DAX) functionality. Peter Myers Mentor, SolidQ

This module will show you how to avoid ginormous T-Logs by performing regular T-Log backups, how to have multiple copies of your backups, how to configure AlwaysOn for high availability and verify integrity of SQL Server databases. Lastly the instructors will cover SQL Server for SharePoint best…

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…

In this segment you will learn how to modify memory settings to control memory usage by SQL Server, how to change default file locations, how to leave MAXDOP at 1 for SharePoint and how to verify operating system set to 64KB allocation unit size. Get ready for some great demos and rich dialogue.…

Join Tim Huckaby, Founder of InterKnowlogy and Actus Interactive Software, and Kimberly Tripp, President/Founder of SQLskills.com, as they discuss why SQL Server and SQL Azure is important to Developers. Kimberly delves into SQL Server indexing as well as the good and bad of GUID. She also provides…

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

This presentation covers application connectivity to AlwaysOn Availability Groups using Availability Group Listeners. Jonathan Kehayias Principal Consultant, SQLskills

From MSDN: The AlwaysOn Availability Groups feature is a high-availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring. Introduced in Microsoft SQL Server 2012. AlwaysOn Availability Groups maximizes the availability of a set of user databases…

This demonstration explores two topics related to Data Analysis Expressions (DAX) improvements in SQL Server 2012. Peter Myers Mentor, SolidQ