Transact SQL :- Temporary Table & Conditional Creation

Background Transact SQL offers the best programming space of all the top tier relational database. But, there are areas one can stumble over, as well. Temporary Table Simple Let us create a simple temporary table Different Structure Objective Depending on certain conditions, our table structure might need to be different. Column 2 If @type is … Continue reading Transact SQL :- Temporary Table & Conditional Creation

Transact SQL :- Resetting Identity Value Using “DBCC CHECKIDENT”

Background Adding pretty much static data into a table and opted to use an identity column as a primary key. Noticed Noticed an inconsequential difference between the documentation and my experience. SQL DDL DML Output Here are the screenshots. Output - Initial load Output - Consequent Load Explanation The first time we loaded data, we … Continue reading Transact SQL :- Resetting Identity Value Using “DBCC CHECKIDENT”

SQL Server – Create a database with the right collation

Background Trained one of the utilities that I am evaluating against a new SQL Server Instance. Greeted with a few error messages. TroubleShooting Other Environments I have tried this same utility against other SQL Server Instances and so I know that the application itself is good. This Environment I also know that this SQL Server … Continue reading SQL Server – Create a database with the right collation

SQL Server – Database Management – File Groups & Files – v2019/CTP

Background Wanted to list out the steps to add filegroups and files to a database. And, remove them. Outline Create Database File Group Management Add Add Filegroup Add file to filegroup Remove Remove file from filegroup Remove Filegroup Drop Database Tasks Create Database SQL Syntax Sample Filegroup Management Filegroup Management - Add Filegroup Management - … Continue reading SQL Server – Database Management – File Groups & Files – v2019/CTP

SQL Server – Upgrade – v2017 to v2019/CTP – Linux

Background Let us upgrade our Microsoft SQL Server v2017 running on Linux. We will be upgrading it to v2019/RC1. Outline Repositories Current Repository List Current Repository files Map Repository Files to Repositories Update Repository Add Repository File for MS SQL Server v2019 Upgrade SQL Server Upgrade SQL Server - Engine Restart SQL Server Service Validate … Continue reading SQL Server – Upgrade – v2017 to v2019/CTP – Linux

Azure Data Studio – Extension – “sqlops-spexecutesql-to-sql” ( v1.0.1 )

Background Wanted to give a quick update on the Azure Data Studio Extension, sqlops-spexecutesql-to-sql. Lineage Azure Data Studio – Extension – "sqlops-spexecutesql-to-sql" Original Post Date Posted :- 2019-August-24th Link Bug Report Outline Filed a bug. The code is on GitHub and path way to filling a bug it to : Sojourn to GitHub Access Pejman … Continue reading Azure Data Studio – Extension – “sqlops-spexecutesql-to-sql” ( v1.0.1 )