SG SQL User Group Meetup - Aug 2015

In August 2015, we have two more volunteers for the UG event. Agenda:

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

7pm to 7:45pm - 1st session

15 minute break and networking session. Can be longer if 1st session finishes earlier.

8pm to 9:30pm - 2nd session

After 9:30pm, adjourned to Lau Pasat for supper and drinks (each person pay for yourself).

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”