SQL Server Tips, Articles and Training


John Maxwell and Ed Saenz

Next Webcast - Cross-Platform Database Performance Monitoring

Most organizations have more than one database platform, yet the challenge of finding and solving performance issues remains the same. Learn how the SolarWinds® Database Performance Analyzer (DPA) provides a unique approach to database performance.

Author: John Maxwell and Ed Saenz



Joydip Kanjilal

Entity Core Framework Query Types

In this article we look at how to use Query Types when working with Entity Framework Core.

Author: Joydip Kanjilal



Mohammed Moinudheen

Azure Storage Explorer Overview

Learn how to manage the contents of an Azure storage account using the Azure Storage Explorer.

Author: Mohammed Moinudheen



Pablo Echeverria

Find Embedded SQL Server Logins in Jobs, Linked Servers or SSISDB

In this tip we look at a script you can use to see if a login and password is embedded somewhere with in your Linked Servers, SQL Server Agent Jobs or SSISDB information.

Author: Pablo Echeverria



Fikrat Azizov

Azure Data Factory ForEach Activity Example

In this tip we look at how to use the ForEach activity when there is a need for iterative loops in Azure Data Factory.

Author: Fikrat Azizov



Koen Verbeeck

Using hash values in SSIS to determine when to insert or update rows

When you want to load data into your data warehouse, for example into one of your dimensions, you need to determine if an incoming row is either an update – a historical change – or an insert, which is a new occurrence of a record. In this tip we show how

Author: Koen Verbeeck



Koen Verbeeck

Create a basic KPI in SQL Server Reporting Services 2016

We are using SQL Server Reporting Services (SSRS) 2016. I'd like to create a key performance indicator (KPI) to track the status of my orders. I'd also like to show this KPI on any mobile device. Read this tip to learn how.

Author: Koen Verbeeck



Koen Verbeeck

Logging Level Recommendations for the SQL Server Integration Services Catalog

In this tip we will cover the different SSIS logging levels.

Author: Koen Verbeeck



Aaron Bertrand

Impact of UTF-8 support in SQL Server 2019

SQL Server 2019 introduces support for UTF-8 for data storage. In this tip we take a look at this new option and whether it is something worth considering using or not.

Author: Aaron Bertrand



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



Gauri Mahajan

How to create a table using SQL Server Management Studio

In this article we look at how to create a table using the SQL Server Management Studio Table Designer as well as how to create a primary key and foreign key relationships.

Author: Gauri Mahajan



Sadequl Hussain

Troubleshoot Slow RDS SQL Servers with Performance Insights

In this article we look at using AWS Performance Insights to help monitor and troubleshoot SQL Server performance issues when running on RDS.

Author: Sadequl Hussain



Diana Moldovan

Read Excel File in SQL Server with OPENROWSET or OPENDATASOURCE

In this tip we look at how to read an Excel file from within SQL Server using OpenRowSet and OpenDataSource along with the possible errors you may encounter and how to fix these issues.

Author: Diana Moldovan



K. Brian Kelley

How to Monitor Storage Performance with a Single Application

Learn how to monitor storage performance for your SQL Server environment with Storage Resource Monitor.

Author: K. Brian Kelley



Kenneth Igiri

Splitting a SQL Server Table Over Multiple Files

In this tip we look at how to move SQL Server tables from one filegroup to another filegroup.

Author: Kenneth Igiri



Rick Dobson

SQL Server User Defined Function Overview

In this article we look at the different types of SQL Server User Defined Functions and how they can be created and used.

Author: Rick Dobson



Eli Leiba

Script to Find SQL Server Windows Login Expiration Date

In this tip we look at a simple way to get information about when a Windows Login password will expire from within SQL Server.

Author: Eli Leiba



Alejandro Cobar

Inventory SQL Server Agent Jobs for all Instances with PowerShell

In this tip we look at a PowerShell script you can use to gather information about all SQL Server Agent jobs on all SQL Server instances in your environment for quick reporting and analysis.

Author: Alejandro Cobar



Mohammed Moinudheen

Simplify Your Azure Bill by Resource Group

Learn how to use tags in Azure to group and sort your Azure resources as well as get billing information groups based on your Azure resources.

Author: Mohammed Moinudheen



Aaron Bertrand

Get Column Attributes for all SQL Server Tables that Match Search Criteria

In this tip we look at how to query the SQL Server metadata in a database to gather things such as column names, data types, and other attributes across a large number of tables.

Author: Aaron Bertrand



Jeremy Kadlec

Find, Analyze and Optimize SQL Server Performance with SolarWinds Database Performance Analyzer

Learn about the Query Tuning and Table Tuning Advisors in SolarWinds Database Performance Analyzer to find, analyze and optimize SQL Server performance.

Author: Jeremy Kadlec



Rick Dobson

Find SQL Server Stored Procedure Create, Modified, Last Execution Date and Code

In this tip we look at different scripts you can use to find when a SQL Server stored procedure was created, modified, last executed and to also return the code for the stored procedure.

Author: Rick Dobson



Sergey Gigoyan

Create a New SQL Server Maintenance Plan with the Maintenance Plan Designer

In this tip we look at how to use the SQL Server Maintenance Designer to build maintenance plans for your databases and instance.

Author: Sergey Gigoyan



Fikrat Azizov

Azure Data Factory Filter Activity and Debugging Capabilities

In this article we look at how to use the debugging functions within Azure Data Factory to set breakpoints to help with development as well as how to use the Filter activity within a pipeline.

Author: Fikrat Azizov



Carlos Robles

Getting Started with SQL Server Azure Container Instances ACI

Learn how to quickly deploy a new SQL Server instance on Azure using Azure Container Instances ACI.

Author: Carlos Robles



Alejandro Cobar

Find SQL Server Installation Date for all Instances with PowerShell

In this tip we look at a PowerShell script you can use to gather information about the installation date for all of your SQL Servers.

Author: Alejandro Cobar



Fikrat Azizov

Azure Data Factory Lookup Activity Example

To continue our series of tips on Azure Data Factory in this tip we look at how to use the lookup activity to ready objects from a database or file system.

Author: Fikrat Azizov



Eduardo Pivaral

SQL Server Foreign Key Hierarchy Order and Dependency List Script

In this article we look at how to build a dependency tree for all SQL Server foreign key relationships in a database.

Author: Eduardo Pivaral



Brady Upton

Understanding Column Properties for a SQL Server Table

I'm creating a table in SQL Server using SSMS and I'm a little overwhelmed with all of the column properties. In this tip we explain what each property is meant for and the options.

Author: Brady Upton



Koen Verbeeck

Power BI Datasets

In this tip we look at how to work with Power BI datasets and in the next tip we will look at working with Power BI workbooks.

Author: Koen Verbeeck



Rick Dobson

SQL Server Stored Procedure Context Switching and Impersonation Example

In this tip we look at how you can impersonate other users in a database when running a SQL Server stored procedure.

Author: Rick Dobson



Aaron Bertrand

How Forced Parameterization in SQL Server Affects Filtered Indexes

In this tip we look at how turning on Forced Parameterization for a SQL Server database can impact the usefulness of Filtered Indexes in that database.

Author: Aaron Bertrand



Jeremy Kadlec

Optimize SQL Server estate monitoring with Redgate's SQL Monitor

Learn about how SQL Monitor saves significant time for operational tasks and performance monitoring for large SQL Server environments with instances on premises, in the cloud, running in virtualized environments, clusters, and Availability Groups.

Author: Jeremy Kadlec



Eli Leiba

How to Find Top N Largest Time Gaps in Date Ranges in SQL Server with T-SQL Code

In this tip we look at some simple scripts that can help identify processes with the longest gaps between steps.

Author: Eli Leiba



Mohammed Moinudheen

Locking Resources in Azure with Read Only or Delete Locks

In this article we look at how to use Azure resource locks to limit who can modify or delete Azure resources.

Author: Mohammed Moinudheen



Dinesh Asanka

Migrating On-Premises Microsoft SQL Server Business Intelligence Solution to Azure

In this article we look at things to consider when migrating your on-premises business intelligence environment to Azure.

Author: Dinesh Asanka



Ron L'Esteve

Azure Data Factory Mapping Data Flows for Big Data Lake Aggregations and Transformations

In this article we look at Azure Data Factory's Mapping Data Flow which has become a promising solution for big data lake cleansing and transformations.

Author: Ron L'Esteve



Joydip Kanjilal

Entity Framework Core Raw SQL Queries Examples

In this article we look at how to run SQL Server queries with Entity Framework Core using the DbSet.FromSql method, parameterized queries, stored procedures and using the Database.ExecuteSqlCommand property.

Author: Joydip Kanjilal



Daniel Farina

SQL Server Loop through Table Rows without Cursor

In this tip we look at a comparison of a SQL Server cursor and a While Loop to show how to perform the same operations using the two different looping mechanisms.

Author: Daniel Farina



Jeffrey Yao

Sort Alphanumeric Values in SQL Server

In this tip we look at ways to sort alphanumeric strings in SQL Server by decomposing all numeric values and sorting the string based on numeric sorting rules.

Author: Jeffrey Yao



Koen Verbeeck

How to Create a Pareto Chart in Power BI Desktop

In this tip we look at how to create a Pareto Chart which applies the Pareto principle aka the 80/20 rule using Power BI Desktop.

Author: Koen Verbeeck








download

























get free sql tips

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



Learn more about SQL Server tools