Learn more about SQL Server tools


Tutorials          DBA          Dev          BI          Career          Categories          Events          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Events

DBA    Dev    BI    Categories



Guide to SQL Server Performance Management with Extended Events

Microsoft SQL Server Extended Events, a replacement for SQL Trace, provides a useful and very customizable framework for managing very technical, low-level event information about a SQL Server database and its instances. However...

Author: SolarWinds

Edgewood Solutions

MSSQLTips.com 10 Year Anniversary Celebration

On June 5, 2006 MSSQLTips.com started with just one tip in an effort to offer solutions to real world SQL Server problems. Ten years later, we never expected MSSQLTips.com to grow into a global community of millions of SQL Server Professionals.

Author: Edgewood Solutions

Dattatrey Sindol

Overview of Information Management in Cortana Intelligence Suite

This tip covers the Information Management components of the Microsoft Cortana Intelligence Suite, so you can get a better understanding of what is offered.

Author: Dattatrey Sindol

Jeffrey Yao

SQL Server Agent Job Advanced Management

When we set up a SQL Server Agent Job, from time to time, there may be some special requirements/wishes on how the jobs should behave. How can we support these needs in SQL Server?

Author: Jeffrey Yao

Daniel Calbimonte

Ways to compare and find differences for SQL Server tables and data

Sometimes we need to compare tables and/or data to know what was changed. This tip shows you different ways to compare data, datatypes and tables.

Author: Daniel Calbimonte

Jeremy Kadlec

SQL Server Cursor Example

In my T-SQL code I always use set based operations. I have been told these types of operations are what SQL Server is designed to process and it should be quicker than serial processing. I know cursors exist but I am not sure how to use them. Can you p

Author: Jeremy Kadlec

K. Brian Kelley

How to setup and use a SQL Server alias

I have an application that has a specified database connection that I either can't or don't want to change. However, I need to move the database to a new server. How can I do this easily without breaking other things that maybe using this connection and/o

Author: K. Brian Kelley

Svetlana Golovko

Create Business Rules in SQL Server Master Data Services

We are implementing our first Master Data Services (MDS) model and want to make sure that users cannot enter data that does not comply with certain business requirements. Read this tip to learn how to build business rules for MDS.

Author: Svetlana Golovko

Tim Wiseman

Max, Min, and Avg SQL Server Functions

How do I find some of the basic descriptive statistics of a column such as the maximum, minimum, and average values in SQL Server with T-SQL code? Can you provide some examples?

Author: Tim Wiseman

John Miner

New Drop If Exists Syntax in SQL Server 2016

When writing T-SQL code, we often write code to check if the database object exists first and then take some action. In this tip I cover the new and easier way to do this in SQL Server 2016.

Author: John Miner

Dallas Snider

Select min and max values along with other SQL Server columns using T-SQL

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.

Author: Dallas Snider

Percy Reyes

Script out all SQL Server Indexes in a Database using T-SQL

Sometimes as a DBA we need to generate a T-SQL script for dropping and creating indexes in our SQL Server databases. However, SQL Server Management Studio does not have an easy way via the wizard to complete these tasks all at the same time. In this tip,

Author: Percy Reyes

SIOS Technology

Whitepaper - SQL Server HA and DR: A Strategy To Reduce Costs

In this free white paper, SQL expert, Joey D’Antoni discusses the costs associated with high availability and disaster protection in a SQL Server environment.

Author: SIOS Technology

Rajendra Gupta

SQL Server 2016 Telemetry Extended Event Session

Read this tip to learn about the Telemetry Extended Events Session in SQL Server 2016.

Author: Rajendra Gupta

Tim Smith

Best Practices For Building Alerts for Using APIs with SQL Server

Read this tip to learn some ideas about how to handle and alert on irregular data coming from APIs when loading your database.

Author: Tim Smith

Daniel Calbimonte

Import data from Azure SQL to Tabular Databases

In this tip we look at the steps to import data from Azure SQL to a SQL Server Tabular Model.

Author: Daniel Calbimonte

Rick Dobson

Transferring Data Between SQL Server 2014 and Oracle 11g Databases

In this tip we look at how to transfer data between SQL Server and Oracle using a linked server.

Author: Rick Dobson


Whitepaper - SQL Server Query Tuning - A 12-Step Program

This paper demystifies query tuning by providing a rigorous 12-step process that database professionals at any level can use to systematically assess and adjust query performance, starting from the basics and moving to advanced query tuning techniques.

Author: SolarWinds

Ranga Babu

Launch SQL Server instances on AMAZON EC2

Amazon EC2 offers another option for putting SQL Server in the cloud. It is easy to setup, upgrade and you are only charged when the box is in use. Let's take a look at how to use Amazon EC2 for SQL Server.

Author: Ranga Babu

John Miner

Using the SQL Server 2016 Decompress Function

Learn about the new DECOMPRESS function in SQL Server. We will walk through examples of how to use this using PowerShell cmdlets.

Author: John Miner

Manvendra Singh

Rename logical database file name for a SQL Server database

SQL Server database files have two names: one is the logical file name and the other is the physical file name. In this tip we will look at how to see the logical database file names and also how to rename the logical files.

Author: Manvendra Singh

Erica Woods

7 Ways to Prepare for a Technical Interview

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.

Author: Erica Woods

Arshad Ali

Generating SQL Server Test Data with Visual Studio 2010

As a database developer or tester sometimes you need to have production like data in your environment for your development or testing, but you cannot have the production data because of security and privacy issues. In this tip, we look at how to use the t

Author: Arshad Ali

Koen Verbeeck

Installing new SQL Server sample databases: WideWorldImporters

With a new release of SQL Server (SQL Server 2016) comes also a new sample database. The days of AdventureWorks are over, here's Wide World Importers! This tip gives an overview of how you can install these new sample databases on your system.

Author: Koen Verbeeck

Ahmad Yaseen

Clone a SQL Server Database Using DBCC CLONEDATABASE

During your work as SQL Server DBA, you might need to create a copy of a production database to simulate testing scenarios on the production schema and statistics. Read this tip to learn about how to use DBCC CLONEDATABASE to make a database copy with jus

Author: Ahmad Yaseen


Get up to speed on SQL Server 2016

Learn about all of the new SQL Server 2016 features from the MSSQLTips.com Team.

Author: MSSQLTips

Learn more about SQL Server tools