I have a dataset where I need to find the minimum and maximum values in a SQL Server table. In the case where multiple rows contain the same minimum or maximum value I only want to select the first occurrence. Read this tip to learn how.
I have a need to get more creative with the way my SQL Server results sets are returned based on user needs. Read this tip to learn about other ways to use the ORDER BY clause to control how data is returned.
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 this webcast we will review the Amazon SQL Server Database security features on EC2 and RDS as well as compare and contrast these technologies to an on-premises installation so that you can determine how well they meet your requirements.
In this technical session we will focus on best practices around managing SQL Server indexes. We will discuss the types of indexes that can be created and how to proactively choose the right indexes for your systems, and how to find missing and inefficient indexes on an existing instances of SQL Server. The session will include a mix of discussion and demo, and will be relevant to DBA’s and Developers who want to maximize the performance of SQL Server.
Who hasn't heard this complaint? "Our system is running slowly right now." It's a universal challenge across every industry, but the solution is often unique. That's mostly because enterprise systems grow more complex by the day. That makes troubleshooting increasingly difficult. Join us to learn more about how to analyze the complete IT stack and solve today's performance issues.