Mar-2014 ~ Mind your language!! Cursors are a dirty word ~ Steve Simon

Posted by admin

[Steve Simon]

 

Presenter: Steve Simon
Topic: Mind your language!! Cursors are a dirty word

 

 

Although many SQL Server folks become irate at the thought of using cursors, like anything else in life there is a time and place. In this hands-on presentation, we shall be looking at practical cases where the utilization of a cursor can prove to be the most efficient and effective solution and THIS is based upon actual execution plans.

Biography:

Steve is a SQL Server MVP and a Senior Business Intelligence Development Engineer at Atrion Networking Corporation. He has been involved with database design and analysis for over 25 years. Steve has presented papers at eight PASS Summits and one at PASS Europe 2009 and 2010. He will be presenting a paper on Master Data Services at the PASS Amsterdam Rally Nov 2103 . He is a PASS Virtual Chapter mentor & chair of the Oracle/SQL Virtual Chapter.

Contact URL: http://www.sqlservercentral.com/blogs/simon_says/

Feb-2014 ~ Advanced Transactional Replication ~ John Flannery

Posted by admin

john_flannery

Presenter: John Flannery
Topic: Advanced Transactional Replication

We will cover several advanced topics in Transactional Replication including how to make a ddl change to one table in the publication without reinitializing the publication; how to make a ddl change to a table without having to snapshot; creating replicated tables on file systems other than Primary – including partitioned file systems; and bidirectional replication. And hint – we will be leaving the wizard in Redmond!! Bring a copy of SQL 2012 Developers Edition with AdventureWorks2012 if you want to play along.

Biography:

John is the Data Architect at Evolution 1 in Avon Connecticut – and Adjunct Professor at Quinnipiac University in Hamden, Connecticut. He has 33 years industry experience; working with SQL server since version 4.2 on OS/2, Oracle since 7.3.4. John holds a Master of Science – Computer Science degree from Rensselaer (1995). Publication List: A Strategy for Implementing SSIS in Clusters; SQL Server Magazine; March 2010, page 15.

Jan-2014 – The PowerShell Database Cookbook: Best Recipes ~ Bryan Cafferky

Posted by admin

Presenter: Bryan Cafferky
Topic: The PowerShell Database Cookbook: Best Recipes
Downloads: Presentation Bundle

Maybe you’ve heard about all the great features of PowerShell, Windows scripting language, but thought, Ok, so how do I actually put PowerShell to use? In this presentation, Bryan will walk you through some ready to use PowerShell scripts while explaining the PowerShell language and integrated development environment (IDE). We will also discuss the best places to use PowerShell and when another tool is a better choice. So whether you’re a PowerShell newbie or experienced with the language, you’ll come away with new knowledge and some handy utilities. And if you’re asking yourself, what is PowerShell, you definitely need to attend this presentation.

Biography:

Bryan is an experienced Business Intelligence engineer who has been developing solutions with SSIS since it was first released. He has been developing for and administering relational databases since 1987 and started working with SQL Server in 1998. He has written a number of articles on www.BIDN.com and leads The Rhode Island Business Intelligence User Group which he founded. Bryan currently works as Senior Business Intelligence Engineer with Smarter Travel Media, a TripAdvisor Company. He has worked in the insurance, banking, utilities, and ecommerce industries.