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

 


Jeremy Kadlec

SQL Server Transparent Data Encryption Alternative Solution - NetLib Security Encryptionizer

Whether you are facing GDPR, HIPAA, PCI, etc. regulations, encrypting your SQL Server databases is a critical component to be compliant. SQL Server offers a few different options, but you should be aware of alternative solutions to be compliant.

Author: Jeremy Kadlec



David Klee

Next Webcast - The more things change… DBAs versus Sysadmins in cloud availability

Attend this webcast to learn tips on how to work with your system administrators to achieve a higher level of ability for your critical SQL Servers in the cloud.

Author: David Klee



Koen Verbeeck

Tutorial - Get Started with BIML

Biml or Business Intelligence Markup Language is an open-source XML dialect to generate Integration Services (SSIS) packages. Take a look at this Biml tutorial to learn how you can use Biml to generate SSIS packages.

Author: Koen Verbeeck



SIOS

Secrets to Fast, Easy High Availability for SQL Server in Amazon Web Services

Moving SQL Server from an on-premises data center to a public cloud such as AWS can enable your business to be more agile and more responsive to changing market requirements and customer needs.

Author: SIOS



Quest

Whitepaper - SQL Server DBA Trends and Challenges

To gain insight into the evolving challenges for DBAs, a study was performed to survey DBAs and those responsible for the management of the corporate data management infrastructure. The more than 200 respondents came from a wide range of industries...

Author: Quest



Tim Smith

Using Nested Switch Statements In PowerShell

In this tip we take a look at how we can use IF and SWITCH statements within our PowerShell code to process text data.

Author: Tim Smith



Rajendra Gupta

Backup and Restore Database Tasks Using SQL Operations Studio

In this tip we look at how you can use SQL Operations Studio to backup and restore your SQL Server databases.

Author: Rajendra Gupta



Arshad Ali

SQL Server CROSS APPLY and OUTER APPLY

SQL Server 2005 introduced the APPLY operator, which is very much like a join clause and which allows joining between two table expressions i.e. joining a left/outer table expression with a right/inner table expression. The difference between join and APP

Author: Arshad Ali



Ashish Kumar Mehta

Display Line Numbers in a SQL Server Management Studio Query Window

Often we see an error message from SQL Server which references a particular line number within our T-SQL code. It is a little frustrating to find the line number where the syntax error has occurred. In this tip we will take a look at how to quickly enable

Author: Ashish Kumar Mehta



Svetlana Golovko

Alerts and Notifications for SQL Server Login, Database User and Role Membership Changes

Check out these scripts to create SQL Server jobs and Alerts when a login is created or dropped, a database user is added or dropped and when logins are added or removed from server roles or users are added or removed from database roles.

Author: Svetlana Golovko



Rajendra Gupta

SQL Server Management Studio Import Wizard Improvements

In this tip we will demonstrate how the Import Flat File Wizard works and see how useful it is over the Import Data Wizard that already exists in SQL Server.

Author: Rajendra Gupta



Jugal Shah

Steps to Move SQL Server Log Shipping Secondary Database Files

With SQL Server is it possible to move the secondary database involved with Log Shipping to a different drive without disturbing the Log Shipping configuration? If so, what are the steps to accomplish this task? Check out this tip to learn more.

Author: Jugal Shah



Alan Cranfield

Identifying PII Data to Lock Down in SQL Server (Part 1 of 2)

We're pretty confident that we have locked down and encrypted our financial data, but a lot of our customer's PII (Personally Identifiable Information) data is still held in unencrypted form. This data is able to be selected directly by read only business

Author: Alan Cranfield



Aaron Nelson

PowerShell for SQL Server Analysis Services Multidimensional

In this tip we look at how you can use PowerShell for SSAS Multidimensional using the SQLAS Provider.

Author: Aaron Nelson



Siddharth Mehta

Multi-Variate Quantitative Analysis with Radar Charts in Power BI Desktop

In this tip we take a look at how to use radar charts with Power BI to compare different data metrics for multiple entities.

Author: Siddharth Mehta



Balamurugan Loganathan

Import Data Using SSIS and Transposing Columns to Rows

In this tip we look at how we can create an SSIS package to transpose multiple columns for a record and inport multiple rows into the database.

Author: Balamurugan Loganathan



Daniel Farina

How to Modify the Global DNS Configuration on Servers Using PowerShell

In this tip we look at how to change global DNS configuration settings on servers by using PowerShell.

Author: Daniel Farina



Eli Leiba

Function to quickly find the worst performing SQL Server Stored Procedures

Check out this function to quickly find the worst performing SQL Server stored procedures for a database or across the entire instance.

Author: Eli Leiba



John Martin

Migrating SQL Server Databases to Azure Managed Instances with Native Backups

In this tip we cover the steps to take a native SQL Server backup and move it to Azure and restore on an Azure SQL Database Managed Instance.

Author: John Martin



Ameena Lalani

Options to Retrieve SQL Server Temporal Table and History Data

In this tip we look at how to query SQL Server temporal tables and history tables using FOR SYSTEM_TIME including AS OF, ALL, FROM, BETWEEN and CONTAINED IN.

Author: Ameena Lalani



Makeda Waterman

What Employers Want to See in an IT resume

Learn how to make your resume stand out and be found by Applicant Tracking Systems that search for keywords.

Author: Makeda Waterman



Douglas Correa

Customize SQL Operations Studio Dashboards

In this tip we look at how you can easily customize the SQL Operations Studio Dashboards at the database and server level.

Author: Douglas Correa



Jeremy Kadlec

SQL Server Transparent Data Encryption Alternative Solution - NetLib Security Encryptionizer

Whether you are facing GDPR, HIPAA, PCI, etc. regulations, encrypting your SQL Server databases is a critical component to be compliant. SQL Server offers a few different options, but you should be aware of alternative solutions to be compliant.

Author: Jeremy Kadlec



Graham Okely

Automate SQL Server multi-file database restores on Linux

In this tip we look at how we can automatically build scripts based on SQL Server backup file contents to automate the restore process for SQL Server running on Linux servers.

Author: Graham Okely



Ben Snaidero

Surrogate Key vs Natural Key Differences and When to Use in SQL Server

In this tip we cover the pros and cons to using a surrogate key vs natural key. Check it out to learn more.

Author: Ben Snaidero



Jayendra Viswanathan

Working with SQL Server Extended Properties

In this tip we take a look at how to use SQL Server Extended Properties to assist with documenting objects with the database.

Author: Jayendra Viswanathan







Learn more about SQL Server tools