Most job seekers view providing references as a company requirement, but you should be viewing this as a crucial and impactful piece of your candidate marketing strategy to differentiate yourself and gain an advantage over other applicants.
One of your last lines of defense for just about any system is to have a backup in place in case there is a need to recover some or all of your data. This is also true for SQL Server. In this tutorial we will discuss selecting the correct recovery models, what backup options are available, and how to create backups using T-SQL commands and SQL Server Management Studio.
The INFORMATION_SCHEMA views allow you to retrieve metadata about the objects within a database. These views can be found in the master database under Views / System Views and be called from any database in your SQL Server instance. In this tutorial we look at some of these INFORMATION_SCHEMA views and how they can be used.
In this tutorial we will cover some of the common issues with performance such as: deadlocks, blocking, missing and unused indexes, I/O bottlenecks, poor query plans, statistics, wait stats and fragmentation.
In an ever changing SQL Server environment, efficient management and monitoring is critical. In this webcast we describe the differences between Azure DB and on-premises SQL Server database environments and show how these are managed differently by the Database Administrator.
Reporting is a critical need at every level in an organization. Unfortunately, many reporting platforms deliver their services through an interface that's confusing to the end users who need to access business essential information. What's really needed is a solution for Developers that's simple to build and gives their users access to the real time data they need to make business decisions.
Join us to learn how to monitor Always On availability groups, replicas, and databases with SQL Diagnostic Manager. View Always On health in a dedicated view, and warn about Always On issues with specialized alerts. Resolve past Always On problems with a history browser, and generate reports for Always On configuration topology and health.
Join us to explore how the new SQL Query Tuner maximizes database and application performance by quickly diagnosing and tuning poor-performing SQL queries and indexes for SQL Server. It empowers DBAs and database developers to eliminate performance bottlenecks by profiling databases with wait time analysis, optimizing complex SQL queries with visual diagrams and identifying bottlenecks with load testing.