Performing database backups is one of the key responsibilities of any DBA, but often backup solutions are not implemented correctly. Attend this webinar to learn how to implement a better database backup solution.
There are many solutions and techniques for employing common forms of data cleansing, such as proper casing, abbreviations, search and replace patterns, and expressions. In SSIS however, it becomes tedious and complicated to achieve such routines as they typically involve the use of multiple components, and require some form of coding through script components.Learn different techniques in generalized data cleansing and how they can be easily implemented in SSIS.
In this session, Scott Walz will discuss the value of Execution/Explain Plans and how to use them effectively. He will also show how DBArtisan and DB Optimizer tools can help simplify using Execution Plans and improving database performance.
SQL Enterprise Job Manager provides comprehensive monitoring of SQL Server Agent jobs across the entire SQL Server landscape. Whether you have one instance or thousands, SQL Enterprise Job Manager provides an easier way of managing jobs. In this democast see SQL Enterprise Job Manager in action to quickly see what jobs are scheduled to run and when and get up to the minute status information. Quickly view jobs by instance or drill down into specific jobs to see alert settings, upcoming jobs, history details and more.
Providing high availability (HA) protection for SQL Server in VMware environments requires teamwork from SQL DBAs, VM Admins, and SAN admins, but each of these roles have different priorities that often put them at odds with each other. Join SQL Server MVP Dave Bermingham as he walks through common use cases that cause conflict between SQL DB Admins and VM Admins when SQL Server HA is involved and how they can be solved.
Managers run into various roadblocks when trying to identify, engage, screen and attract quality candidates to join their teams. It’s frustrating when it takes a considerable amount of time to identify strong candidates, and even more frustrating to then lose them during the process.