In SQL Server news, Pythian’s expert SQL Server team are appearing at DevTeach 2011 at the end of May.
DevTeach 2011, Montreal, QC – May 30 – June 3, 2011
|Session Title||Session ID||Speaker||Date/Time||Location||Abstract|
|Windows PowerShell for the SQL Server DBA||SQL367||Edwin Sarmiento||Wednesday, June 1 – 9:30am||St. Louis||Windows PowerShell is becoming the scripting language of choice for managing Microsoft servers and workstations. And while T-SQL is still the scripting language for DBAs to administer and manage SQL Server, there are tons of stuff that can be easily done with Windows PowerShell. In this session, learn Windows PowerShell from the ground up and how you can use it with SQL Server Management Objects (SMO) to administer and manage a SQL Server instance.|
|The wonderland of SQL Server Policy Based Management (PBM)||SQL383||Michelle Gutzait||Wednesday, June 1 – 1:30pm||St. Louis||In this session Michelle will show some tips and tricks with BPA for the database administrator. The goal is to be able to control and get alerted about changes happening in the managed SQL Server instances, especially when those are against the organization’s Best Practices.|
|Self-Service Analytics on SQL Server 2008 R2||SQL343||Edwin Sarmiento||Thursday, June 2 – 8:00am||St. Louis||We have to admit that Excel is the most popular data visualization tool there is. In this session, we’ll look at using Excel to gather data, cleanse and model that data, and then use it as a source for pivot-table and pivot-chart analysis – all in the context of self-service analytics in SQL Server 2008 R2. We’ll also look at some of the new analysis features available in Excel 2010, including slicers, improved charting, and improved pivot-table functionality.|
For more SQL Server-related events see our Q2 Speaking session post.
Interested in working with Vanessa? Schedule a tech call.