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

 




Rajendra Gupta

SQL Server 2016 Management Studio Enhancements

Learn about SQL Server 2016 Management Studio Enhancements including code highlighting, inline search, Quick Launch, tab customization, pinning tabs and more.

Author: Rajendra Gupta



Dallas Snider

Use Sqoop to Load Data from a SQL Server Table to a Hadoop Distributed File System

Learn how to use Sqoop to Load Data from a SQL Server Table to a Hadoop Distributed File System with step by step instructions.

Author: Dallas Snider



MSSQLTips

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



Ranga Babu

Performance Issues when Updating Data with a SQL Server Linked Server

Linked servers are great to query remote databases, but when running update queries they don't always behave like they should. In this tip I will show you a situation where several queries worked fine, but a few did not behave as planned. I will also sh

Author: Ranga Babu



Rick Dobson

Faster Way to Transfer Data from SQL Server 2014 to Oracle 11g

In a prior tip we looked at using Linked Servers to transfer data between SQL Server and Oracle. Transferring data to Oracle from SQL Server was really slow and this tip shows a faster approach.

Author: Rick Dobson



SolarWinds

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



Ben Snaidero

Capture SQL Server Schema Changes Using the Default Trace

This tip will look at a way to capture any SQL Server changes that have been made to your database using the default trace.

Author: Ben Snaidero



Manvendra Singh

Database Cloning in SQL Server for Troubleshooting and Diagnostics

Microsoft released SQL Server 2014 SP2 and with this new service pack we get some new features. This update introduces database cloning in which a new database will be created that contains just the schema of all the objects and statistics from the specif

Author: Manvendra Singh



Siddharth Mehta

How to Enable Localization Support for SQL Server Analysis Services Dimension Attributes

Learn the step by step process to enable localization support for SQL Server Analysis Services dimension attributes.

Author: Siddharth Mehta



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



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

Using the SQL Server 2016 Compress Function

Learn how to use the new SQL Server COMPRESS function to compress images using Azure and PowerShell.

Author: John Miner



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





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



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



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



SolarWinds

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









Learn more about SQL Server tools