SSMS

Great Reads

Applying Database Principal Throughout the Server (for all Databases) for a Particular User

by Manjuke Fernando

How to give db_datareader access to a specific user across all the databases on a particular SQL Server

ASP.NET Core 2.0 & Angular 4: Build from Scratch a Web Application for Vehicles Management

by O.Nasri

ASP.NET Core 2.0 & Angular 4: through this tutorial, you will learn how to build from scratch a web application for vehicles management

Azure – Creating an Azure SQL Database

by Vivek Johari

Creating an Azure SQL Database Contents Introduction Creation of Azure SQL Database Step 1: Select Database Name Step 2: Select Azure Subscription Step 3: Choose Resource Group Step 4: Choose Database Source Step 5: Choose SQL Server Step 6: Choose Elastic Pool Option Step 7: Choose Service Tier for

Build Your Own Movie Database with SQL Server

by Aless Alessio

Use the OLE Automation Procedures to retrieve data from a Web Service and parse the JSON response into a table format

Latest Articles

Applying Database Principal Throughout the Server (for all Databases) for a Particular User

by Manjuke Fernando

How to give db_datareader access to a specific user across all the databases on a particular SQL Server

ASP.NET Core 2.0 & Angular 4: Build from Scratch a Web Application for Vehicles Management

by O.Nasri

ASP.NET Core 2.0 & Angular 4: through this tutorial, you will learn how to build from scratch a web application for vehicles management

Azure – Creating an Azure SQL Database

by Vivek Johari

Build Your Own Movie Database with SQL Server

by Aless Alessio

Use the OLE Automation Procedures to retrieve data from a Web Service and parse the JSON response into a table format

All Articles

top

SSMS

ASP.NET Core 2.0 & Angular 4: Build from Scratch a Web Application for Vehicles Management

by O.Nasri

ASP.NET Core 2.0 & Angular 4: through this tutorial, you will learn how to build from scratch a web application for vehicles management

Capture of a Typical SQL Server Database Workload

by Tomáš Bauer

Capture of a Typical SQL Server Database Workload

Create SQL Server Management Studio 12 Addin

by Bert O Neill

Develop your own SSMS ObjectExplorer\CommandBar menus, within SQL Server 12

Create Your Own SQL Server Management Studio 17 (SSMS) Extension

by Stefan Timovski

A short tutorial on how to get started with creating SSMS extensions

Data Mining: An Introduction to Neural Networks in SQL Server

by Harinder Saluja

Implement Neural Network in SQL Server

Debug Stored Procedures in Visual Studio and SSMS

by Kuv Patel

Debug stored procedures in Visual Studio and SQL Server Management Studio.

How to Create SQL Server Management Studio 18 (SSMS) Extension

by Stefan Timovski

Tutorial on how to start developing SSMS extensions

How to Migrate SQL Database to Azure SQL Database using SSMS Deploy

by Vivek Johari

This post discusses how to migrate SQL database to Azure SQL database using SSMS deploy.

How to Migrate SQL Database to Azure SQL Database using SSMS Export/Import

by Vivek Johari

Migrating SQL Database to Azure SQL Database using SSMS Export/Import Contents

How to version control a database using GitHub and SQL Source Control

by Redgate Software

This article explains some simple steps to create a GitHub database repository and get your database code in there, using SQL Source Control.

by Sanwar ranwa

How to login with Facebook and Google using Angular 8

Point In Time Restore for Azure SQL Database

by Vivek Johari

This article discusses the step by step process of point in time restore for Azure SQL database, Azure automatic backups as well as database backups retention period.

Save and Retrieve PDF from SQL DB using SSRS and ASP.NET

by inishant12

Using SSRS report, generate the PDF, save it into DB and send it through mail using C#

Searching SQL Server Databases with Red Gate’s SQL Search

by Chris_Yates

When managing a large amount of servers and databases, having an efficient way to search for objects in a particular database, SQL Server instance or the object metadata is crucial. DBA Chris Yates tells us why SQL Search from Red Gate helps him achieve this with ease, and at no cost.

spSearchTables: Search and Find Tables or Columns by Name or Value

by Federico Di Marco

spSearchTables: a helper T-SQL stored procedure for digging into (large) databases

SQL Prompt Review

by MarkDunn

I love tools that save me and my team time which ultimately translates to saving money for my employer and I’ll proceed to show you how SQL Prompt can do that for you .

Sql Server In Clause With Multiple Literal Values Performance Behaviour

by Neeraj Prasad Sharma

This article deals with performance difference with literal values

SQL Table Dependency Diagram Generator (SSMS 18,19 & 20)

by Bert O Neill

This article provides an overview for developers, on how to quickly generate a dependency Entity Relationship Diagram for a table and its immediately related tables, within SQL Server.

Strange Behavior on JSON_VALUE When Table Contains Blank and Non-blank Values (JSON Text is Not Properly Formatted. Unexpected Character '.' is...

by Manjuke Fernando

Observations made for a strange behavior on JSON_VALUE when table contains blank and non-blank values

Top 10 Exciting New Features in SQL Server Management Studio 2016

by Suvendu Shekhar Giri

Introduction of new useful features in SSMS 2016