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



Aaron Bertrand

Simulating TRY_CONVERT() in SQL Server 2008 – Part 2

In this tip we look at how to dynamically handle conversions when trying to build TRY_CONVERT functionality in SQL Server 2008.

Author: Aaron Bertrand



Fikrat Azizov

Cross-database query performance in Azure SQL Database

In this tip we look at the performance impact and benefits of running cross database queries when working with Azure SQL Database.

Author: Fikrat Azizov



Ahmad Yaseen

Line Split Issues when Copying Data from SQL Server to Excel

Some of our developers noticed an issue a few days after celebrating our successful SQL Server 2012 upgrade. When they run a query in SSMS and copy and paste the results to Excel, each row gets split into many rows in Excel instead of one row like it used

Author: Ahmad Yaseen



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



Jugal Shah

Resolving could not open a connection to SQL Server errors

Sometimes you may have issues connecting to SQL Server and you may get messages such as "Could not open a connection to SQL Server". In this tip we look at different things you can check to resolve this issue.

Author: Jugal Shah



Ghanesh Prasad

How to read data from an Excel file starting from the nth row with SQL Server Integration Services

I have Excel files I need to read using SSIS, but the first few rows in the file are just information about the data and these rows should be ignored. Read this tip to learn how read data from the nth row.

Author: Ghanesh Prasad



Graham Okely

Creating a SQL Server Linked Server to SQLite to Import Data

You have data in SQLite databases on mobile devices you would like to import into SQL Server. In this tip we walk through the steps on how to import this data into SQL Server.

Author: Graham Okely



Ghanesh Prasad

Allow NULL value in Multi Value Report Parameter in SQL Server Reporting Services

Your report has a multi value parameter, but it doesn't show NULL in the parameter drop down along with the other parameter values. In SSRS a multi-value parameter cannot include a NULL value, so users can't filter the data for NULL values. Your requirem

Author: Ghanesh Prasad



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



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



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







Learn more about SQL Server tools