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



Edgewood Solutions

Date and Time Conversions Using SQL Server

There are many instances when dates and times don't show up at your doorstep in the format you'd like it to be, nor does the output of a query fit the needs of the people viewing it. One option is to format the data in the application itself. Another opti

Author: Edgewood Solutions



Dale Kelly

Migrating SQL Reporting Services to a new server by moving the Reporting Services databases

I recently had a task to move SQL Reporting Services to a new server. While researching I found two methods to accomplish this task. One used a scripting tool which I wrote an article about and the other method is the one recommended by Microsoft. This me

Author: Dale Kelly



Tim Cullen

Add and Subtract Dates using DATEADD in SQL Server

Date manipulation is a common scenario when retrieving or storing data in a SQL Server database. There are several functions that are available and in this tip we look at how to use the DATEADD function.

Author: Tim Cullen



Tim Ford

Microsoft Access Pass Through Queries to SQL Server

Thus far in this tips series on Access and SQL Server we have created an ODBC Data Source Name (DSN) using the OLEDB driver, created a System DSN for the new SNAC (SQL Native Client) driver and created linked tables in Access by using the SNAC DSN. At th

Author: Tim Ford



Manvendra Singh

How to add a database file to a mirrored SQL Server database

When using Database Mirroring and if you have not placed your database files for your principle database and mirrored database on an identical path then adding a database file to the principle database is quite different than the normal process. In this c

Author: Manvendra Singh



Brady Upton

Downgrade from SQL Server Enterprise Edition to Standard Edition

I have a SQL Server that was installed as Enterprise Edition. I do not need the Enterprise features and I do not want to pay for the licensing. What is the best way to downgrade to Standard Edition? In this tip we walk through the steps.

Author: Brady Upton



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



Koen Verbeeck

T-SQL Enhancements in SQL Server 2017

In this tip we cover some of the new T-SQL enhancements in SQL Server 2017.

Author: Koen Verbeeck



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



Bhavesh Patel

SQL Server error query processor ran out of internal resources and could not produce a query plan

In this tip we take a look at SQL Server error the query processor ran out of internal resources and could not produce a query plan.

Author: Bhavesh Patel



John Miner

Introduction to Azure Cosmos DB database and the SQL API

In this tip we take a look at Azure Cosmos DB and how to get started and migrate data to Azure Cosmos DB.

Author: John Miner



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







Learn more about SQL Server tools