A common concern or response we hear post interview is I wasn't ready for that level of a technical interview or I didn't do as well on the technical questions as I would've liked. Read this tip to learn how to be prepared.
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.
Register for the webinar and join Dave Bermingham, Microsoft Clustering and Datacenter MVP, to discuss ways to protect SQL in a VMware environment without sacrificing IT flexibility or important VMware features, and whether you can have a cluster and multi-site replication with VMware. Bring your thoughts and questions to this interactive session.
Many people often refer to data as an asset, especially today. There are endless possibilities of slicing and mining every ounce of information out of it. Every security professional will tell you that it's actually a liability. Data breaches are expensive, damaging, and seen all too often. As data value of data grows the liability grows at the same rate. This webinar is focused on securing your data in SQL Server. Join me as I discuss how to secure your data and share tips on logins, roles, permissions, and more.
With SQL Server 2016, Microsoft introduced the Query Store, which promised to track statement performance over time, pinpoint regressed queries and provide a more effective way to tune. In this informative and insightful session we will look at the good, the bad and the ugly of Query Store. How well does it actually work? What if your database is read only? What if you have lots of databases to monitor? How does it handle plan changes due to schema changes? Join Anat Dror and Jason Hall, Dell SQL Server experts to explore both the limitations and the sweet spot for using Query Store and discover insightful tips on what to monitor, when to use it and how best to leverage the data it is collecting.