SQLXpertise

SQL Server 2019 – String Truncation Error Demystified…

Before SQL Server 2019, String Truncation error is big mystery in SQL Server, especially if you have multiple String fields used in your Stored Procedure, it will hard to find out which field its failing and which value is causing the issue

See, Sample screenshot of String truncation error from SQL Server 2017 or before

In SQL Server 2019 CTP, If you enable DBCC TRACE FLAG 460, the String…

SQL Server 2019 First Public CTP Released

Microsoft has released SQL Server 2019 First Public CTP in Ignite conference today, There are lots & lots of new features are included as part of this release

For more information, Please visit below links

https://docs.microsoft.com/en-us/sql/sql-server/what-s-new-in-sql-server-ver15?view=sqlallproducts-allversions

https://cloudblogs.microsoft.com/sqlserver/2018/09/24/sql-server-2019-preview-comb…

SQL Server Management Studio v 17.8.1 is released

SQL Server Management Studio v 17.8.1 is released and available for download from below links

New Install – https://go.microsoft.com/fwlink/?linkid=875802

Upgrade from previous v 17.x – https://go.microsoft.com/fwlink/?linkid=875804

There are lot of fixes and changes in this release, for more information, Please visit

https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio…

SQL Server Management Studio v 17.7 is released

SQL Server Management Studio v 17.7 is released and available for download from below links

New Install – https://go.microsoft.com/fwlink/?linkid=870039

Upgrade from previous v 17.x – https://go.microsoft.com/fwlink/?linkid=873128

There are lot of fixes and changes in this release, for more information, Please visit

https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-s…

Vulnerability Assessment using SQL Server Management Studio

As part of SQL Server Management Studio v 17.4 release, Microsoft has released the Vulnerability Assessment tool, This is a very easy to use tool and helpful in identify the vulnerabilities at database level and tool also provides scripts and suggestions to re-mediate the vulnerabilities as well

In this article, we will see step by step how to run a vulnerability assessment, review the results…

SQL Server Management Studio v 17.6 is released

SQL Server Management Studio v 17.6 is released and available for download from below links

New Install – https://go.microsoft.com/fwlink/?linkid=870039

Upgrade from previous v 17.x – https://go.microsoft.com/fwlink/?linkid=870041

There are lot of fixes and changes in this release, for more information, Please visit

https://docs.microsoft.com/en-us/sql/ssms/sql-server-management-studio-changelog-…

SQL Server Management Studio v 17.5 is released

SQL Server Management Studio v 17.5 is released and available for download from below links

New Install – https://go.microsoft.com/fwlink/?linkid=867670

Upgrade from previous v 17.x – https://go.microsoft.com/fwlink/?linkid=867672

There are lot of fixes and changes in this release, for more information, Please visit

https://docs.microsoft.com/en-us/sql/ssms/sql-server-management-studio-changelog-…

SQL Server Management Studio v 17.4 is released and available for download from below links

New Install – https://go.microsoft.com/fwlink/?linkid=864329

Upgrade from previous v 17.x – https://go.microsoft.com/fwlink/?linkid=864331

There are lot of fixes and changes in this release, for more information, Please visit

https://docs.microsoft.com/en-us/sql/ssms/sql-server-management-studio-changelog-…

Simple Guide to restore SQL Server Backup from Azure Blog Storage using Management Studio

In previous post, we saw

1. How to implement Off-site/Cloud backup in SQL Server 2017 using Azure Blob Storage

2. How to restore SQL Server Backup from Azure Blog Storage using queries

In this post we will see how to restore SQL Server Backup from Azure Blog Storage using SQL Server Management Studio

Step 1: Open SQL Server Management Studio 2017 and connect to SQL Server on which you would like…

Simple guide to restore SQL Server Backup from Azure Blog Storage

In previous post, we saw How to implement Off-site/Cloud backup in SQL Server 2017 using Azure Blob Storage, in this post we will see how to restore SQL Server Backup from Azure Blog Storage

Step 1: Create Credential – Please use below query to create Credential to access Azure Blog Storage using Shared Access Signature, This step is optional if you already have created Credential to create backup

Simple Guide to implement Off-Site/Cloud backup in SQL Server 2017 using Azure Blob Storage in 2 Steps

In this post we will see how to implement Off-Site/Cloud backup in SQL Server 2017 using Azure Blog Storage

Requirements

1. SQL Server 2017

2. Azure Account

3. Azure Blog Storage with Container provisioned and Shared Access Signature generated

4. SQL Server Management Studio (Optional, if you prefer to run using SQLCMD)

  Step 1: Create Credential – Please use below query to create Credential to…

Monitoring Transaction Replication : Replicating On-Premise SQL Server databases to SQL Azure databases

In previous post, we saw How to setup Transactional Replication to replicate On-Premise SQL Server databases to SQL Azure databases, in this post we will how to monitor the Replication process and make changes to data in On-Premise and verify the changes in SQL Azure database

Replication Monitoring

Step 1: Right click on Replication –> Local Publications –> Launch Replication Monitor

Step 2: We…

Transactional Replication: Replicate On-Premise SQL Server databases to SQL Azure databases

Transactional replication to SQL Azure Database is now available as of Oct 23, 2017, This feature will help us in replicating/migrating data from On-Premise SQL Server databases to SQL Azure databases with minimal impact and downtime

In this post we will see the following

1. Setup new publisher and configure new distributor

2. Add SQL Azure Database as Subscriber

For this demo we are using

Tools/…

SQL Server 2017 Cumulative Update 1 is available now and Steps to install Cumulative Update in SQL Server on Ubuntu Linux

Microsoft has released SQL Server 2017 Cumulative Update 1 today, The build number for the release is 14.0.3006.16

For full list of fixes included in the release – Please use this link https://support.microsoft.com/en-us/help/4038634/cumulative-update-1-for-sql-server-2017

To download for Windows, Please use this link https://www.microsoft.com/en-us/download/details.aspx?id=56128

To update SQL…

How to import CSVs from Azure Blob Storage to SQL Server 2017 ?

SQL Server 2017 introduces option to import CSV files stored in Azure Blog Storage

In this article we will see how to implement that step by step

Step 1: Create Database Master Encryption Key

This step is optional, if you already have created your database master encryption key, Please skip this

CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'PleaseUseStrongPasswordHere'

Step 2: Create Database…

Temporal Tables – Simple Guide to implement History Tables using SQL Server 2016/2017–Part 5- Storing History data in Azure using Stretch Database

In previous posts, we saw

Part 1 – How to create Temporal Tables

Part 2 – Accessing History data from Temporal Tables

Part 3 – Modifying Temporal Tables, Disabling System versioning and why we need to disable ?

Part 4 – Managing Temporal Tables and History Data

In this post we will see how to store the history data in Azure using Stretch database

Step 1:Right click on Database name and click on…

Temporal Tables–Simple Guide to implement History Tables using SQL Server 2016/2017–Part 4–Managing Temporal Tables and History Data

In previous posts, we saw

Part 1 – How to create Temporal Tables

Part 2 – Accessing History data from Temporal Tables

Part 3 – Modifying Temporal Tables, Disabling System versioning and why we need to disable ?

In this post we will see how to manage Temporal tables and History

To get list of Temporal Tables – Snippet 1

SELECT name, object_id, temporal_type, temporal_type_desc, history_table_id,…