C# Corner

Resources  
  • ASP.NET Core - CRUD With React.js And Entity Framework CoreApr 24, 2018. CRUD Operations in ASP.NET Core application using React.js, Web API and Entity Framework Core DB first approach with the help of VS 2017.
  • Hide And Group Columns In SSRS Using A ParameterApr 24, 2018. Ever had users come to you and request another version of a report just to add another field and group data differently? Today, was such the day for me. I really don’t like having multiple versions of the same report out there. So, I got a little fancy with the current version of the report and added a parameter then used expressions to group the data differently and hide columns. For those new to SSRS I've embedded some links to MSDN to help you along the way.
  • SQL Server Updates Tricked Me For YearsApr 24, 2018. When applying a new SQL Server cumulative update, hot fix, or upgrade to SQL Server, it doesn’t always apply all the fixes in the patch. When you upgrade the database engine in-place, databases you already had stay at their pre-upgrade compatibility level, which means they run under the older set of optimizer rules.
  • How Can We Embed Power BI Report In Classic SharePoint PageApr 24, 2018. In this article, we will talk about how one can configure Power BI report in classic SharePoint Page.
  • Creating Simple API In Node.jsApr 22, 2018. In this article, we are going to learn how to create a simple API in node js and using MS SQL as a data source on which we are going to perform CRUD operation.
  • ASP.NET Web API Using MVC And Entity Framework - Part OneApr 18, 2018. Web API concepts in different fields and Its implementation using Asp.Net MVC and Entity Framework . Web API Controller connects with Sql Server by Entity Framework. Web API Route can be used in different types of clients Like IOTs.
  • How To Configure Search Service Application Using PowerShellApr 18, 2018. In this article, we will discuss how to provision Search Service Application for SharePoint 2016 using PowerShell
  • Just Check ALL The BoxesApr 17, 2018. Today I ran into something on a client-server that unfortunately I see too often. The DBA goes through the trouble of configuring and setting up alerts/operators but doesn’t really understand what the options in the configurations mean. So, unfortunately, that means they take the CYA (cover your ass) approach and they check all of them. Now, not only have I seen this with alerts but also with things like security configurations as well. My advice is to always take a second and research what each option is before you check the little boxes, especially when it comes to security. Always follow the rule of less is more.
  • Logic Apps 101 - Inserting Data Into Multiple Tables Using SQL Connector And Trigger(SQL)Apr 17, 2018. In this article, you will learn Logic Apps 101 - Inserting Data Into Multiple Tables Using SQL Connector And Trigger(SQL).
  • Azure SQL Database - Create And Connect SQL Database In The Azure PortalApr 11, 2018. This article explains how to create and connect Azure SQL database to the Azure portal.
  • How To Upload Audio In Database And Play In GridView Using ASP.NETApr 10, 2018. In this article, we are going to discuss how to upload an audio file in our project folder and save its path in SQL server database table.
  • How To Upload Video In Database And Play In GridView Using ASP.NETApr 08, 2018. In this article we are going to learn how to upload video in project folder and save its path in SQL server database table. We will bind that table to gridview and play audio using html5 video element.
  • System-Versioned Temporal TablesMar 29, 2018. Every once in a while, I like to take a moment and learn something new about the latest SQL Server gizmos and gadgets. Today I came across system-versioned temporal tables and it piqued my interest, so I figured I’d investigate and share my findings with you.
  • Monitoring Specific Table Using SQL ProfilerMar 27, 2018. This article helps you to understand how to use the SQL Profiler, and how to trace a particular table.
  • ASP.NET Core - Two Factor Authentication Using Google AuthenticatorMar 26, 2018. We will generate a QR code in our ASP.NET Core application and use it to configure Google Authenticator app in our smartphone which will generate a six-digit time-based one-time password (TOTP) to implement two-factor authentication in our web application.
  • What Are These Backup Settings All AboutMar 23, 2018. I ran across a client the other day that had these Backup and Recovery options set like the picture below because it defaults this way.
  • File Logging And MS SQL Logging Using Serilog With ASP.NET Core 2.0Mar 22, 2018. In this article, you will learn File Logging and MS SQL Logging using Serilog with ASP.NET Core 2.0.
  • Let's Import Data To Azure SQL Data Warehouse Using SSISMar 21, 2018. We have already discussed many ways to import data in Azure DWH. Today I will discuss an OLD SCHOOL approach of data import by SQL Server Integration Services (SSIS). In my opinion, this is the most promising way to import data from different data sets/ types like SQL Server, Oracle, MySQL, Flat File, CSV, DB2 .
  • Pre-Deployment And Post-Deployment Script - SQL Database ProjectMar 20, 2018. In this article, we will learn Pre-Deployment And Post-Deployment Script on SQL Database Project.
  • Learn About SSMS Output WindowMar 17, 2018. In my experience, there have been occasions where SQL Server Management Studio (SSMS) becomes unresponsive for a length of time. In one particular case, this occurred while I was expanding the list of databases. SSMS just sat there and waited for some unknown reason and became frustrating. The client eventually did respond and life was good again.
  • Enable Output Cache Settings In SharePoint OnlineMar 16, 2018. In this article, I would like to share the steps to configure the Output cache in SharePoint online. Output cache settings is available on the SharePoint publishing sites.
  • Hide And Group Columns In SSRS Using A ParameterMar 16, 2018. Ever had users come to you and request another version of a report just to add another field and group data differently? Today, was such the day for me. I really don’t like having multiple versions of the same report out there. So, I got a little fancy with the current version of the report and added a parameter then used expressions to group the data differently and hide columns. For those new to SSRS I've embedded some links to MSDN to help you along the way.
  • WPF - Data Storage Using SQL ServerMar 15, 2018. For any development domain, be it mobile or web or desktop or service-based, data storage is an essential component whether it is done on the server side or the client side. WPF application is a client-side application and it also supports many data storage resources which depend on the business requirement or business choice.
  • Four Rules Of Right When Running A QueryMar 13, 2018. Earlier this year, I participated in the Idera #sqlchat. This is a monthly chat meeting that is organized by Idera Software and hosted by a SQL Server community member. This one was hosted by Monica Rathbun (B|T) and her topic for the month was “SQL Server Bad Habits in Configurations, Security, and Code”. It was a fun and entertaining way to spend an hour over lunch. Plus it helps to get you engaged with the SQL Server community, which is never a bad thing.
  • ASP.NET Core - CRUD Using Angular 5 And Entity Framework CoreMar 13, 2018. CRUD Operations in ASP.NET Core application using Angular 5 , Web API and Entity Framework Core DB first approach with the help of VS 2017.
  • Using SWITCH On A Single PartitionMar 12, 2018. Several months ago, I was looking at a question posted on ask.sqlservercentral.com. I discovered an answer to a question regarding how to move a large amount of data around quickly. The solution was related to an aspect of table partitioning that I was not aware of. If you aren’t familiar with partitions in SQL Server, you can “divide” up a table into different segments or partitions. Often this is found in large tables (think millions/billions of rows) in order to quickly and efficiently move data around. Moving partitions around is a meta-data operation which is what makes it so efficient.
  • How To Insert Bulk Records Into SQL Server Using XML Data TypeMar 11, 2018. Sometimes, there is a need to insert bulk records into a database. In some cases, we have multiple unique records and that all needs to be inserted into the database. Instead of hitting the database for each record, we need to insert bulk records into database.
  • Java Mail API Using GMAIL OAuth API In AndroidMar 11, 2018. In this article, we will learn how to send mail directly from Android application using Gmail API OAuth 2.0. To run the process successfully, you need to follow the steps carefully.
  • O365 Consuming Azure PAAS SQL DB Through BCSMar 03, 2018. This document explains the steps to configure BCS using Office 365 that can pull data from Azure PaaS SQL DB and also to configure firewall IP ranges and network possibilities.
  • Execute SQL Server Stored Procedure With User Parameter In Power BIFeb 28, 2018. Sometimes there is a situation in which we need to get data by consuming SQL Server stored procedure. SQL Server stored procedure has parameters which we need to pass dynamically. Power BI provides a functionality to execute Stored Procedure using Managed Parameters. During this article we will talk about, • How to create Manage Parameter • How to pass manage parameter to a Stored Procedure • Invoke Query Result and load data to Power BI Desktop
  • What Is Date Correlation Optimization?Feb 28, 2018. OK So, I am doing some digging and peaking around again in SQL Server and came across a database option called Date Correlation Optimization Enabled = False. Honestly, I had no clue what it did, so I took it as a learning opportunity to look into it and do a little research. Who knows, it may actual help me solve one of the many problems I run into day to day for clients.
  • Creating A QnA Maker FAQ Bot And Integrating It To Your Web AppFeb 26, 2018. QnAMaker FAQ API is used to train your Azure bot to answer FAQs by creating a endpoint on QnA Maker API and configuring it in your bot. In this blog, we shall learn how to create a QnA Maker FAQ Bot step by step and also learn how to integrate QnA maker API bot in your Web App.
  • Learn MongoDB With MeFeb 22, 2018. Here, we are going to do some exercises with MongoDB. We will be talking about Mongo Shell, how we can configure MongoDB, and what Indexes are in MongoDB, and more.
  • What Does This Little Check Box DoFeb 21, 2018. Ever wander around SQL Server properties and wonder what these little check boxes turn on? I do, and I get very tempted to check them. Here is one of those tempting little boxes that seems pretty handy. Use query governor to prevent long running queries.
  • VLFs - The Forgotten FoeFeb 19, 2018. How many of you check the amount of Virtual Log Files (VLFs) your transaction logs have?
  • SQL Database Query Editor In Azure Portal - An IntroductionFeb 19, 2018. Learn SQL Database Query Editor In Azure Portal.
  • Download User License Information For PowerApps And Microsoft FlowFeb 16, 2018. PowerApps is one of the services available in the Office 365 environment that enables us to create apps or forms for business and other uses without coding experience. We can connect against external data sources like SQL, SharePoint, Salesforce, etc... to develop an application. PowerApps has its own data source called Common Data Service.
  • How To Get Started With Always Encrypted For Beginners - Part ThreeFeb 15, 2018. A few weeks ago, I wrote Part 1 and 2 of this series, which was a beginner’s guide to Always Encrypted. In part 3, I am going to go over what road blocks I ran into when trying to implement this solution for a client. The goal of the project was to prevent the DBA from being able to view salary information, while still allowing the application to function without issue.
  • Publish ASP.NET Core 2.0 Application On Azure With SQL ServicesFeb 15, 2018. In this article, we will learn how to deploy or publish an Asp.Net Core 2.0 application on Azure.
  • SQL Coding Best PracticesFeb 14, 2018. While executing your procedure, the system will first scan through all system procedures and then user defined procedures. This means that the procedure might take more time for execution thus decreasing system performance.
  • Deploying VM Using ARM TemplateFeb 14, 2018. Azure Resource Manager (ARM) Templates are JSON files which define the resources which you need to deploy for your solution. ARM templates are community contributed and can be used by anyone from GitHub. This repository holds various predefined ARM templets to choose from has per your needs. But to get started with ARM templates we will be configuring a simple virtual machine deployment from scratch so we can understand easily.
  • How To Get Started With Always Encrypted For Beginners - Part TwoFeb 12, 2018. In this post we will pick up where we left off in Part 1, if you haven’t read that please go back and do so. Now that we have encrypted our columns, it’s time to take a look at how we decrypt them inside SQL Server Management Studio or through our applications. You’ll be surprised to see how easy it is.
  • Creating And Configuring A MySQL Server On The Azure PortalFeb 10, 2018. This article demonstrates how to create a MySQL database on the Azure Portal.
  • Channel Configuration - Azure Bot Service To Slack ApplicationFeb 08, 2018. This article explains how to configure Azure Bot Service to Slack Applications. We will get a clear idea about how to create a Bot Service in Azure.
  • How To Get Started With Always Encrypted For Beginners - Part OneFeb 08, 2018. Encryption has always been intriguing to me but seemed like it could be a very complex process to set up. However, SQL Server made it very simple when they introduced Always Encrypted (AE) into SQL Server 2016 and Azure SQL Database.
  • Introduction To LINQ With Entity Framework In Visual StudioFeb 08, 2018. LINQ queries are similar to SQL query created for developers to maintain standardized coding approach. It deals with the data objects therefore it is similar to OOPs.
  • Synchronous VS Asynchronous Statistics UpdatesFeb 07, 2018. Implement to help with performance is changing from Update Statistics Synchronous to Auto Update Statistics Asynchronously.
  • Cursors In SQL ServerFeb 06, 2018. A cursor is a database object which is used to retrieve data from result sets one row at a time.The cursor can be used when the data needs to be updated row by row.
  • SQL Sequence Vs Identity ColumnFeb 06, 2018. Let’s take a look at what a Sequence is in relation to an Identity Column in SQL Server. Did you know Sequence even existed? I didn’t until I was asked about them. It’s amazing how much you can skip over and never notice in SSMS. See this little folder, ever notice it under Programmability in Management Studio. Yep it’s there, SQL Server has this very handy thing called Sequences. Sequences are a relatively new feature that have only existed since SQL Server 2012, but have long existed in Oracle (where there a no identity columns).
  • Email Directly From C# .NET On Azure With No Mail ServerFeb 05, 2018. One of the background parts of most systems I write involves messaging of some kind ... more often than not, the default is email notification of one thing or another. When I need to carryout large scale mail-outs I always use one for the major Azure services, but when I only need adhoc mail operations or low volume, I use a combination of an SMTP Client and a DNS MX Lookup.
  • Performing CRUD Operations On Azure SQL Database Using SharePoint Framework Web Part And ASP.NET Web API - Part TwoJan 30, 2018. Normally, you would want to put your css classes in the .scss file (i.e. YourWebpartName.scss) and import it into the YourWebpartName.ts file (this is actually done automatically during project creation). But I decided to put it in a SharePoint list because my css selectors are grouped and I could not reference them using "styles.selector".
  • Performing CRUD Operations On Azure SQL Database Using SharePoint Framework Web Part And ASP.NET Web API - Part OneJan 24, 2018. Supposing there is an existing data in an SQL database, be it Azure or an on-premise database server, you are required to make the data available for CRUD operations in SharePoint for your users. This is a scenario where this article will be of help to you. In this article, I will show you how you can perform CRUD operations on Azure SQL database from a SharePoint web part. Note that the steps are same for on-premise SQL database except for the steps required in setting up Azure database.
  • Enabling Swagger In Your .NET Core 2.0 Application - A Step By Step GuideJan 19, 2018. If you have ever worked with APIs, then you might be familiar with Swagger. If you have not heard about Swagger, then this post will help you know the basics of Swagger and the steps to configure Swagger with your .NET Core 2.0 application.
  • SharePoint Online Search Results - Sort By TileJan 16, 2018. Search is more commonly used to display the results in SharePoint Portal based on the business needs by configuring the search query. To make more sense out of the search results, they are commonly sorted on key attributes like Modified Date, Created Date, Title, etc.
  • Comparison Of Subquery And JoinsJan 15, 2018. Here, in this article, we are comparing the SQL Join and SQL Subquery.
  • Why Dynamic Query Is BadJan 15, 2018. In this article, we will be talking about Dynamic Query and why it is bad.
  • Configure Windows Authentication In ASP.NET CoreJan 11, 2018. Using Windows authentication, users are authenticated in ASP.NET Core application with help of operating system. Windows Authentication is a very useful in intranet application where users are in same domain.
  • How To Configure User Profile Service Application Step By StepJan 10, 2018. In the last article I described about how to delete and create User profile service, today I'm demonstrating about how to configure UPA service application step by step with a screen shot. This articles applies to SharePoint 2010, 2013 and 2016.
  • How To Remove And Create User Profile Service Application In SharePointJan 09, 2018. The purpose of this article to is to delete an existing UPA service from the SP server and create the same from scratch. As we know, there are two ways to configure or delete UPA server, Using UI and SharePoint PowerShell. We are going to delete and create UPA using UI.
  • Store And Retrieve Using FILESTREAM From SQL DatabaseJan 06, 2018. Hello friends today I will explaining you regarding storing and retrieving image, video and other document files from SQL server using FILESTREAM future. If you are new to FIELSTREAM then read my previous article FILESTREAM Feature In SQL Server.
  • Availability Set, Fault Domains And Update Domains In Azure Virtual MachineJan 06, 2018. This article explains why one must plan Availability Set, Fault Domain and Update Domain while configuring Virtual Machines for Azure.
  • How To Install And Start The Reporting Services SharePoint Service In SharePointJan 05, 2018. In this article, we will learn about "How to Install and Start the Reporting Services SharePoint Service in SharePoint".
  • Azure SQL Intelligence For Database Administrator And DeveloperJan 05, 2018. When interacting with large volumes of data, Azure SQL comes into the picture. SQL Azure is a cloud database service owned by Microsoft, which is based on SQL Server database technology.
  • FILESTREAM Feature In SQL ServerJan 04, 2018. Today I am explaining what FILESTREAM is and how to use FILESTREAM in SQL server.
  • Steps To Configure A VPNJan 04, 2018. In this article I am going to show you the steps to configure a VPN.
  • R Services In SQL Server 2017Jan 02, 2018. Hello Everyone. In this article I will be demonstrating how to use R Services in SQL Server 2017. This article is intended for those who have a basic idea of R language. If you don't, still no worries. You can still go through and grab it easily. I will go into details of R language in some other article.
  • Routing And Navigation With Angular 5Jan 02, 2018. Angular routing helps navigation across the application from one view to another view, it also allows us to maintain the state, implement modules and load the modules based on the role of the user. Let’s see in this article how we configure the routing and some basic concepts with it.
  • Setting Up Add-In Development Environment In SharePoint Server 2016Dec 26, 2017. In this article, I have explained how to configure Sharepoint add-ins development environment and create a simple hello world web part in s=Sharepoint server 2016 on-premises.
  • Configure Data Gateway With SQL Server Database Using Recommended Or Enterprise ModeDec 23, 2017. In this article, we will discuss how we can configure Data Gateway for On-Premise SQL SERVER Database for Live Data Connection using Recommended Mode.
  • How To Configure Data Gateway With SQL Server Database For Live Data Connectivity Using Personal ModeDec 21, 2017. In this article, we will discuss how we can configure Data Gateway for On-Premise SQL SERVER Database for Live Data Connection using Personal Mode.
  • Querying ConsmosDB Using SQL APIDec 19, 2017. Here, we can find the first name and number of pets from child entity but to find out the last name we need to refer to family entity. To select last name along with first name we need to use join operator In DocumentDB
  • Stored Procedures Vs User Defined Functions And Choosing Which One To UseDec 19, 2017. In SQL Server, we usually come across queries, tables, views, stored procedures and functions. People often wonder what are the real differences between User Defined Functions (UDF) or simply functions and stored procedures or just procedures. There are two types of functions: Built-in and user defined. Built-in functions cannot be modified where as you can create and modify your own UDF. To utilize the full advantage of these features, we should understand their capabilities and what we can do with them and what we cannot. I am going to explain this in terms of SQL Server.
  • Getting Started With Apache SparkDec 18, 2017. In Big Data, Hadoop components such as Hive (SQL construct) , Pig ( Scripting construct), and MapReduce (Java programming) are used to perform all the data transformations and aggregation . Now with Apache Spark the same is being achieved with many more advantages like unified API performance, and support for multiple languages, 10X-100X faster than MapReduce.
  • Export SQL Result To A Text FileDec 18, 2017. This article gives an overview of how to export SQL query results to a text file.
  • Configure Identity In ASP.NET Core 2.xDec 15, 2017. Identity is a membership system that allows us to add login functionality to our application. In my previous article, I have explained about the overview of Identity in ASP.net Core. There are some default behaviors that can be overridden easily in our application in ConfigureService method of startup class.
  • Create Your First Azure SQL Database Using Azure Portal Dec 14, 2017. In this article, we will talk about how we can create a new database in Azure SQL. We will learn each step in a brief manner. Most of the time when we are beginner in Azure we always have a question how we can create a database in Azure SQL. It’s very easy and simple.
  • Versioning ASP.NET Core 2.0 Web APIDec 13, 2017. As your Web API changes, you would need to add versioning support in order for clients to continue working correctly. Adding versioning support in ASP.NET Core involves first configuring services in Startup and then choosing a versioning strategy i.e. via query string, URL or HTTP header.
  • Remove Duplicate Rows In SQL Server Using CTEDec 11, 2017. In this article, you will learn how to remove duplicate rows in SQL Server using CTE.
  • Roles And Responsibilities Of SQL Developer Dec 09, 2017. In this article, I have shared the Roles and Responsibilities of a SQL Developer.
  • How To Control SQL Injection In PHPDec 07, 2017. This is an interview question, when a person showcases himself as the FULL Stack developer, it is very important that the developer should have base knowledge on the security aspects of the applications.
  • Audit Made Easy Without Audit Log - Part OneDec 07, 2017. In Microsoft SQL Server, the activity of each of the database table is tracked in the other table and that is called the Audit trail or Audit log of the database table.
  • A Beginner's Guide To Windows Server SetupNov 29, 2017. All developers must be familiar with how to interact with a server for various project requirements. This server interaction varies depends on the project requirements. Some of may be just connecting to an SQL Server database server through an application, some of you may be hosting your application to an IIS server.
  • Configuring Log4Net With Database - A Tutorial For BeginnersNov 26, 2017. Log4Net is a framework for logging .NET applications. It is an open source library that can be used to log output for different targets like logging output in Text files, Database, Console, Mail (SMTP), Remote and others. In this article, I will explain how to log output in a database.
  • Pug Vs HTMLNov 26, 2017. In the holy wars of "Pug vs HTML", it is really confusing sometimes to realize which one of these to use. The same is true for SQL vs NoSQL, and the similar is true for Java vs Python. Then people think why not talk about Pug vs HTML as well. HTML is always the perfect language to consider, however for the case of Pug there might be a bit of confusion. Some developers don't know Pug, and some who know it, know it as a Jade framework.
  • How To Create A Stored Procedure In SQL Server Management StudioNov 25, 2017. In this article you will learn about how to create store procedure in sql server’s SQL SERVER MANAGEMENT STUDIO and very informative information and interview questions and answers about store procedure.
  • Introduction To SSISNov 24, 2017. SSIS stands for SQL Server Integration Services. It is one of the services of SQL Server and was introduced for the first time in SQL Server 2005. It’s a powerful replacement for the legacy DTS (Data Transformation Services) that exists in SQL Server 2000.
  • Use SQL Server 2017 in Docker ContainersNov 21, 2017. How to use SQL Server 2017 on Docker containers to automate deployment using VSTS
  • Creating A SQL Database And SQL Server On The Azure PortalNov 20, 2017. This article shows how to create a SQL Database and Server on the Azure Portal and also the process of configuring the threat protection to our Database.
  • Introduction To SQL Operations Studio And Connecting It With SQL ServerNov 20, 2017. Learn how to use SQL Operations Studio (preview) to connect to SQL Server, and then use Transact-SQL (T-SQL) statements.
  • Auto Complete with ngTagInput using Web API in AngularJSNov 16, 2017. AutoComplete,ngTagInput,Web API,AngularJS,AutoComplete in AngularJS using Web API
  • Configure Application Insight For .NET Core 2.0Nov 16, 2017. We developers work hard to write code, but these QA guys find bugs in our code. We don’t have any choice but to find and fix the bug ASAP. After all this hard work we push everything to production, then new questions from people arise like why is this page slow? why is this operation taking time? why this and that? To answer these questions, we need proper logging mechanism to identify and takes hours of coding and analysis. What if we have a mechanism to track this with less hours of code to analyse and more time on fix. Application insights come to picture to solve our logging work with best analysis tools.
  • What Is SQL Operations StudioNov 15, 2017. Learn and download SQL Operations Studio
  • Always Encrypted In SQL Server 2016 - Step By Step Guide - Part ThreeNov 15, 2017. This is part three of "Always Encrypted In SQL Server 2016 - Step By Step Guide" series. In this article, we are going to see how to search on encrypted column and how to deploy a certificate to a different environment.
  • SSMS 2016 - Enhanced ScrollbarNov 14, 2017. Detailed description with screenshots of the enhanced scroll bar introduced in SSMS (SQL Server Management Studio) 2016.
  • Steps To Configure Xamarin.Android Emulator Performance - Part TwoNov 14, 2017. Xamarin is a cross-platform development tool. With Xamarin, you can use C# for iOS, Android, and Universal Windows apps. And with Xamarin Forms, interface design for all three platforms can be accomplished within its XAML-based framework.
  • Server Side Custom Paging In Angular-UI Grid Using Web APINov 13, 2017. In this article, you will learn how to implement server side custom paging using Angular UI-Grid with Web API and SQL Server database and stored procedure. In this article, I will demonstrate server side paging and sorting only, Filtering we should learn in next article.
  • DROP IF EXISTS In SQL Server 2016Nov 13, 2017. With this very small but handy tip, we’ll check the enhancement that has been made to DROP statement in SQL Server 2016. Earlier, we used to write additional checking logic to make sure that the object exists to drop. If we miss writing the check and if the object is not available, then we are being served with an error message. With SQL Server 2016, now we can check the existence of the respective object without any error being generated.
  • Masking Sensitive Data With SQL Server 2016Nov 10, 2017. SQL Server 2016 has many features which you can use to make your data and application more secure, more maintained and easily retrieved as per your requirements. It has introduced both client side security such as Always Encrypted as well as server side security such as Data masking etc. In this post we’ll examine how Dynamic Data Masking can help secure our data.
  • Introduction Of New Useful Features In SSMS 2016Nov 10, 2017. This article is an effort to list out a few exciting improvements that have been made to SQL Server Management Studio 2016. I believe, most of these new features can help improve the speed of our work and are more convenient to use the SSMS.
  • Azure Data Factory - ETL Solution To Azure DB And To Azure SQL Data WarehouseNov 09, 2017. In this article we will learn how to use Azure Data Factory to Extract, Transform, Load (ETL) data especially for the data warehousing purposes.

About Configure-SQL-Mail

NA
Hire a remote developer
Looking to add more bandwidth to your software team? Web Developers, designers, testers are now available on demand. Flexible hours, very competitive rates, expert team and High Quality work.
X

Build smarter apps with Machine Learning, Bots, Cognitive Services - Start free.

Start Learning Now