Sunday, August 23, 2015

SG SQL User Group Meetup - Aug 2015

SQL Server User Group August 2015 meetup details and slide deck  provided below.

Date:   Aug 18, 2015 · 6:30 PM

6:30 pm to 7pm - Arrival/ Registration and Networking.

7pm to 7:45pm - 1st session

 8pm to 9:30pm - 2nd session

TOPIC 1: Using PowerShell with SQL Server Business Intelligence PowerShell is a command-line based scripting language used by IT Professionals to automate system administration tasks in Windows platforms. Either via built in cmdlets or an exposed API (SMO), SQL Server professionals can harness the power of PowerShell and leverage it to their organizations' advantage. In this presentation, you will learn some of the ways you can use PowerShell in SQL Server BI Administration in an enterprise environment. You will acquire practical knowledge to start utilizing PowerShell yourself. Finally, you will be inspired on how simple it is to automate those repetitive administration tasks.

About Speaker:  
Vanessa Rose Castro is a Regulatory Reports Engineer at ING Bank N.V., Singapore. On her daily job she uses Microsoft SQL Server to deliver Business Intelligence to ING branches across South East Asia. You can find solutions to BI development and administrative problems, as well as book

reviews on her space on the internet: http://vaniecastro.com/.

TOPIC 2: Transaction Log.
The SQL Transaction log is one of the most misunderstood parts of SQL Server in terms of how it works. The presentation would cover the basic terminology, logs architectural and VLF algorithm, a few undocumented commands to scan the log file(s), 3-4 domes to relate things with real time with internal details explanation. Besides these, the presentation would also cover what would be the best way to implement log files considering the number of VLFs.


About speaker:
Dharmendra Keshari has strong and in-depth experience in Database Management and its internals. Currently, working as Senior Database Administrator in one of the best Semi-Government organization in Singapore. He is an avid, regular mentor on social media, helping several enthusiast in solving problems related to Database management. He has completed certification for “Microsoft SQL Server® 2008, Implementation” and “Maintenance & Administering Microsoft SQL Server 2012 Database”


Meetup Link : http://www.meetup.com/mssgug/events/224552998/
Facebook Event Page: https://www.facebook.com/events/500883780075762/
Slides: Download here