Sebastian is the SQL Stylist at sqlity.net llc. After earning his PhD in Computer Science and spending 7 years architecting DBs for a fortune 50 company, he founded sqlity.net to fully engage in his passion for SQL Server. Sebastian provides training and consulting services. He specializes in T-SQL Security, Test Driven Development (TDD) and performance tuning and shares his knowledge regularly with audiences worldwide. Sebastian is a published author and president of the Philly sqlpass chapter.
15 Aspects of SQL Server Indexes That You Might Not Know
You probably know that indexes make you queries faster. But do you know why? Knowing how the different index types work under the covers will help you make the right decisions when (re-)designing you indexing strategy. After attending this demo rich session you will be able to – Explain the differences between SQL Servers 9 “index” types – Identify the layout of SQL Server data on disk – Decide which index types are the right ones to use for a given query – Assess the impact of the Key on access speed
Getting Started with tSQLt Unit Testing in SQL Server
tSQLt allows you to implement unit tests in T-SQL. This is important as you do not have to switch between various tools to create your code and your unit tests. tSQLt also provides the following features to make it easier to create and manage unit tests:
- Tests are automatically run within transactions – this keeps tests independent and reduces any cleanup work you need
- Tests can be grouped together within a schema – allowing you to organize your tests and use common setup methods
- Output can be generated in plain text or XML – making it easier to integrate with a continuous integration tool
- Provides the ability to fake tables and views, and to create stored procedure spies – allowing you to isolate the code which you are testing
Permission Management: 12 Pitfalls & Misconceptions
SQL Server comes with a powerful built-in permission management system. However, as most powerful tools, this one too can be difficult to use and get right. This is a two-part session. During the first part, we will go through a review of SQL Server security terms and concepts, particularly the GRANT, REVOKE and DENY statements. For the second part, the audience selects topics that we will cover in detail. You will be able to choose from 12 different security pitfalls and misconceptions. All these pitfalls/misconceptions have one thing in common: If you are not aware of them, you might GRANT or DENY more permissions than you intended.
Session Level: Intermediate