Posts by william assaf

Databases 101 for the Aspiring App Dev

Target Audience: Students from high school on up, new to dealing with databases in general, or looking for a re-set of foundational database understanding. Abstract: We’ll cover what you need to know about relational databases entering a career in development, including the different kinds of databases, terminology when entering the workforce, the basics of backups,…
Read More

SQL Admin Best Practices with DMVs

Target Audience: This session will be informative and eye-opening to anyone from a junior DBA on up. Abstract: In this practical and script-focused session, with roots in SQL 2005 but updated continuously thru SQL 2019, we'll discuss many best practices regarding SQL Server administration, maintenance, optimizations and monitoring using Dynamic Management Views. DMV's are essential…
Read More

SQL Security Principals and Permissions 101

Target Audience: This session is perfect for junior DBAs, developers and system admins of on-prem and Azure-based SQL platforms. Abstract: A ground-floor introduction to SQL Server permissions starting with the basics and moving into the security implications behinds stored procedures, views, database ownership, application connections, consolidated databases, application roles and much more. Why I Want…
Read More

Certification Exams Inside Out

1 Comment
Target Audience: IT professionals of any skillset considering cert exams as a career motivator. Abstract: Preparing for Microsoft certification? Do you want insight into how certification exams are written, how questions are designed, and how to follow a logical process of elimination? We'll go through the process of item creation from an item writer's viewpoint,…
Read More

Think Like A Certification Exam

Target Audience: Any IT Abstract: Do you want insight into how certification exams are written, how questions are designed, and how to follow a logical process of elimination to aid you when taking the exams? We’ll go through the process of item creation, what rules writers must follow, and review some sample questions together. You’ll…
Read More
Menu