Learn more about SQL Server tools

mssqltips logo

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

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

Cost Effective SQL Server Transparent Data Encryption - Free Webinar

Jeremy Kadlec

Next Webcast - SQL Server Transparent Data Encryption Alternative

SQL Server database encryption is one critical step to securing your database and keeping your organization out of the news for the wrong reasons. Unfortunately, implementing SQL Server Transparent Data Encryption can be extremely costly...

Author: Jeremy Kadlec


Vote for your favorite MSSQLTips authors

Vote now and vote often for your favorite Rookie and Author of the Year!

Author: MSSQLTips

Graham Okely

Meeting Preparation for SQL Server Projects

Learn how to prepare for technical meetings including knowing your environment, being calm, business values, solution focus and more.

Author: Graham Okely

Pablo Echeverria

Script out SQL Server Credentials and Proxies

Learn how to script out all SQL Server Credentials and Proxies.

Author: Pablo Echeverria

Nisarg Upadhyay

SQL Server Replication Latency Alert via Email

Learn how to setup SQL Server Replication latency alerts via email with a custom stored procedure and SQL Server Agent Job.

Author: Nisarg Upadhyay

Sergey Gigoyan

Write more compact SQL Server code using new features

Learn about new functions in SQL Server 2016 and 2017 to have more readable and compact code including STRING_AGG, TRIM, TRANSLATE and DROP... IF EXISTS.

Author: Sergey Gigoyan

Haroon Ashraf

Adding a Primary Key to a Prepopulated Table using a SQL Server Integration Services Package

In this tip we look at how you can use SSIS to build a package to add a primary key to an existing table that does not already have a primary key.

Author: Haroon Ashraf

Edwin Sarmiento

Upgrade or Migrate a SQL Server Failover Clustered Instance While Using the Same Virtual Network Name and Virtual IP Address (Option 1)

In this tip we cover the steps you need to follow to upgrade or migrate an existing SQL Server failover cluster and still use the same virtual network name and virtual IP address.

Author: Edwin Sarmiento

Greg Robidoux

Execute Dynamic SQL commands in SQL Server

In this tip we look at different approaches for building dynamic SQL code.

Author: Greg Robidoux

Cate Murray

An Effective Resume vs. Job Description Review for Interview Prep

If a project, responsibility, accomplishment or technology is listed on your resume OR on the job description or list of requirements, you should be prepared to answer open-ended or pointed questions on. Learn some tips to get your prepared...

Author: Cate Murray

Dinesh Asanka

SQL Server Temporal Tables Overview

In this tip we look at what temporal tables are in SQL Server and how to use temporal tables.

Author: Dinesh Asanka

Jeffrey Yao

Make SQL Server Agent Alert Notifications Smarter and More Flexible

In this tip we look at how we can make SQL Server agent alert notifications smarter and more flexible to meet specific needs instead of the same generic alerting process for all alerts.

Author: Jeffrey Yao

Alejandro Cobar

SQL Server AlwaysOn Availability Groups Inventory and Monitoring Scripts - Part 1

In this tip we look at scripts that can be used to monitor the status of your SQL Server AlwaysOn Availability Groups across your entire environment.

Author: Alejandro Cobar

Bhavesh Patel

Character Map Transformations in SQL Server Integration Services

In this tip we look at what a character map transformation is and how this can be used in a SQL Server Integration Services package.

Author: Bhavesh Patel

Artemakis Artemiou

Querying SQL Server Tables from .NET

In this tip we look at a few examples of using .NET code to update and select data from SQL Server tables by creating a simple application and connection string to the SQL Server database.

Author: Artemakis Artemiou

Makeda Waterman

Freelancing for SQL Server Professionals

In this tip we look at somethings to consider if you are thinking about freelancing as a SQL Server professional if you are in between jobs or ready to make the move to being self-employed.

Author: Makeda Waterman

Eduardo Pivaral

Optimize Large SQL Server DML Processes by Using Batches

In this tip we look at another approach to process large SQL Server transactions in smaller batches using T-SQL code and the TOP command.

Author: Eduardo Pivaral

Learn more about SQL Server tools