$150

Black Belt for the Database Administrator

Event Information

Share this event

Date and Time

Location

Location

Hilton Garden Inn Albany/SUNY Area

1389 Washington Ave

Albany, NY 12206

View Map

Refund Policy

Refund Policy

Refunds up to 30 days before event

Event description

Description

In the modern world of information technology, SQL Server DBA tasks exceed typical Administration and T-SQL development. Each new SQL Server version brings additional technologies that help streamline and improve its functionalities. Within the last decade, SQL Server has evolved into a sophisticated Enterprise RDBMS tool, and it continues to grow by providing more functionalities to store and manipulate data reliably.

PowerShell, .NET, XML and JSON skills often appear in SQL Server DBA job requirements because the ability to work with those allow the DBA to adapt faster and more efficiently when solving different types of problems. This session designed to bring you up to speed with following technologies:

.NET integrated with SQL Server as CLR (Common Language Runtime) objects. Stored Procedures, Functions, Triggers can be coded in CLR to replace T-SQL language, especially for the processes that T-SQL is not able to complete efficiently. .NET is also widely utilized in SSIS Script Tasks.

PowerShell provides help for SQL Server DBAs to improve their daily activities, automate and simplify monitoring, patching, deployments and managing the SQL Server instances.

XML (eXtensible Markup Language) is one of the technologies that SQL Server implements not only for data manipulation but also for internal usage, such as Execution Plans, Extended Events, DDL trigger Eventdata() function, and behind-the-scenes construction for SQL Server Business Intelligence Tools (SSIS, SSRS, SSAS).

JSON (JavaScript Object Notation) for SQL Server, introduced in SQL Server 2016. JSON has many similarities to XML, however they are not the same. JSON can be thought of as a “fat-free” version of XML. In SQL Server 2017, Microsoft began implementing JSON in system objects, and in turn, DBAs and developers now take JSON more seriously.

Each attendee will receive a signed copy of my book, "XML and JSON Recipes for SQL Server"

Precon Session Content:

  1. .NET introduction for DBA
  2. What are .NET Namespaces
  3. .NET classes and functions
  4. .NET programing language
  5. ADO as a bridge to the databases
  6. Practical use-cases of CLR and Scripting Tasks for SSIS
  7. PowerShell for SQL Server DBA
  8. PowerShell Interphases
  9. Commandlets
  10. PowerShell Modules and Functions
  11. PowerShell practical use-cases
  12. XML introduction
  13. Building XML
  14. Manipulating XML files
  15. Shredding XML
  16. Modifying XML
  17. Filtering XML
  18. Improving XML performance
  19. Internal SQL Server XML
  20. JSON introduction
  21. Differences between XLM and JSON
  22. Constructing JSON
  23. Converting JSON to Row Sets
  24. Modifying JSON
  25. Work shop for JSON

Event Schedule/Logistics

8:00 am - 8:30 am : Breakfast & check-in

8:30 am - 12:00 pm : Precon (morning session)

12:00 pm - 1:00 pm : Lunch

1:00pm - 5:00 pm : Precon (afternoon session)

Breakfast and lunch are both provided by the hotel as part of your registration. Vegetarian options are included in the menu. Other dietary requests will be provided upon request by attendees.

Share with friends

Date and Time

Location

Hilton Garden Inn Albany/SUNY Area

1389 Washington Ave

Albany, NY 12206

View Map

Refund Policy

Refunds up to 30 days before event

Save This Event

Event Saved