Resources No resource found - Xamarin.Android - List View Using SQL Server DatabaseJun 21, 2017. In this article you will create a Xamarin Android List View using SQL Server.
- Automatic Daily Database Backup To Specific Database In SQL ServerJun 21, 2017. Automatic Daily Database Backup To Specific Database In SQL Server.
- Audit Log Search In Security And Compliance Center In Office 365Jun 16, 2017. Audit log search in Security and Compliance center in Office 365.
- CRUD Operation Using Stored Procedure In ASP.NET GridView Real TimeJun 16, 2017. A GridView is a graphical control element that presents a tabular view of data.
- To Get All File Details From Local File Into SQL ServerJun 14, 2017. TO Get All File Details From Local File Into SQL Server.
- Code Improvement Techniques In C#Jun 13, 2017. General code improvement technique over string.empty, string.Equals, string.Intern, StringBuilder, string.Format, case insensitive comparisons, using Block and Linq - First, FirstOrDefault, Single and SingleOrDefault. Main focus points are - what are the advantages and the purpose to use these.
- Concept Of Change Data Capture (CDC) In SQL Server - Part ThreeJun 13, 2017. Concept Of Change Data Capture (CDC) In SQL Server.
- Concept Of Change Data Capture (CDC) In SQL Server - Part TwoJun 12, 2017. Concept Of Change Data Capture (CDC) In SQL Server.
- Concept Of "Change Data Capture" (CDC) In SQL Server - Part OneJun 09, 2017. Concept Of Change Data Capture (CDC) In SQL Server 2008.
- Top Ten Things You Should Know About Optimizing SQL Server Performance - Part TwoJun 08, 2017. Top Ten Things You Should Know About Optimizing SQL Server Performance.
- Top Ten Things You Should Know About Optimizing SQL Server Performance - Part OneJun 07, 2017. Top 10 Things You Should Know About Optimizing SQL Server Performance.
- Pros And Cons Of Money DataTypeJun 02, 2017. Pros And Cons Of Money DataType.
- ALL In One DataBase Hero Script - Set OneJun 01, 2017. ALL In One DataBase Hero Script.
- How To Create Login Page In ASP.NET Web Application Using C# And SQL ServerMay 31, 2017. How to create login page In ASP.NET Web Application using C# and SQL Server.
- Analyzing The Size Of Database And Size Of TableMay 31, 2017. Analyzing The Size Of Database And Size Of Table.
- Quick Note On Azure And Azure SQL Databases For Cloud BeginnersMay 30, 2017. This article gives beginners a background on Cloud, Azure and Azure SQL database fitness in terms of cloud
- Transparent Data Encryption In SQL ServerMay 30, 2017. Transparent Data Encryption in SQL Server.
- Time And Date Query Code And Analysis - Part OneMay 30, 2017. Time and Date query code and analysis.
- Identifying Relationship Between Columns In SQLMay 30, 2017. Identifying relationship between columns in SQL.
- How To Create A Solution And What Its Uses AreMay 25, 2017. How to create a Solution and what its uses are.
- Google Map Using SQL Server Stored Procedure In ASP.NET MVC 5May 23, 2017. I will show you how to show markers on places like country, state, continent etc., using stored procedure.
- All About Primary Key And Its BasicsMay 23, 2017. All About Primary Key And Its Basics
- Move SQL Server Database To Another Location - Lesson LearnedMay 22, 2017. Fix: Unable to open the physical file. Operating system error (Access is denied.). In this article, we'll learn the best practice of moving database to another physical location on the Server.
- High Availability And Disaster Recovery In SQL Server - A Quick NoteMay 19, 2017. High Availability And Disaster Recovery - A Quick Note.
- Temporary Tables And Table Variables In SQLMay 19, 2017. In this article, I will explain the difference between temporary tables and table variables in SQL server.
- LINQ Basic To Advanced - MVC Demo ApplicationMay 16, 2017. Here, in this post, we are going to see some basic and advanced LINQ queries
- Creating Azure SQL DatabaseMay 10, 2017. This article enables you to create an Azure SQL database.
- Ten SQL Server Shortcuts You Must KnowMay 10, 2017. Ten SQL Server Shortcuts You Must Know.
- Installing SQL Server vNext On Linux - Part OneMay 09, 2017. Installing SQL Server vNext On Linux.
- Create Dynamic Tree View From Database In ASP.NET MVC 5 C#May 09, 2017. This article exhibits how to display parent child tree view in any way dynamically from the database. This is the best, easiest, and fastest way to make tree view, using ASP.NET MVC 5, C#, Razor and SQL Server 2014.
- Generate JSON Data Using Web Service And SQL Server Stored ProcedureMay 08, 2017. Generate JSON Data Using Web Service And SQL Server Stored Procedure.
- Cross Database Queries In Azure SQLMay 06, 2017. In this article, you will learn about cross database queries in Azure SQL.
- SQL Server - Execution PlansMay 01, 2017. Execution plan will be generated by Query optimizer with the help of statistics and Algebrizer/ processor tree. It is the result of Query Optimizer and tells how to do/ perform your work/ requirement.
- What Is Deferred/ Lazy Loading And Eager Loading?Apr 28, 2017. In his article, you will learn about Deferred/ Lazy Loading and Eager Loading.
- A Brief Introduction To LINQApr 27, 2017. Introduction to LINQ.
- Taking Scripts From SQL ServerApr 27, 2017. In this article, you will learn about taking scripts from SQL Server.
- Get Database Backup And Restore The Backup File In SQL ServerApr 25, 2017. In this article, we are going to learn how to get database backup from SQL Server and how to restore the backup file in SQL Server.
- Commonly Used Built In String Functions In SQL ServerApr 25, 2017. This article illustrates commonly used built in string functions in SQL Server.
- SQL Server 2016 - Getting Started With Row Level Security FeatureApr 25, 2017. This article familiarizes you with SQL Server 2016 - Getting started with Row Level Security feature.
- Creating SQL Sever Database For Authentication Using Membership And Role Provider In SharePoint Apr 24, 2017. Creating SQL Sever database for authentication, using Membership and Role Provider in SharePoint.
- LINQ Extended JoinsApr 24, 2017. This article illustrates LINQ extended joins.
- Log Parser Usage Details For IIS LogsApr 21, 2017. This article explains Log Parser usage details for IIS logs.
- Upgrading SQL Server When It Is Part Of Availability GroupApr 20, 2017. Upgrading SQL Server When It Is Part Of Availability Group.
- Generate Backup And Script File In SQL Server 2014Apr 18, 2017. In this article, we going to see about how to generate database backup, create a script file without table value and with the value.
- RANK, DENSE_RANK And ROW_NUMBER Functions In SQL ServerApr 18, 2017. RANK, DENSE_RANK And ROW_NUMBER Functions In SQL Server.
- SQL Server - HA TechnologiesApr 13, 2017. This article presents an overview of High Availability (HA), which is the solution\process\technology to make the Application\database available 24x7 under either planned or un-planned outages.
- Triggers In SQL ServerApr 13, 2017. This article helps you understand the usage of triggers in SQL Server.
- Configure SQL Server And Connect DB Engine From Another PCApr 11, 2017. This article presents an overview of configuring SQL Server and connect DB Engine from another PC.
- Aggregate Function With LINQ In C#Apr 11, 2017. In this article, we going to see about how to use the aggregate function with LINQ.
- Provision Of SQL Server And Connect By RM In AzureApr 11, 2017. This article portrays provision of SQL Server and Connect by RM in Azure.
- How To Create Simple SSRS ReportApr 10, 2017. This article presents an overview on how to create a simple SSRS report.
- SQL Server - ServicesApr 10, 2017. MS SQL Server provides services which are mandatory for database creation and maintenance.
This article shows how to start and stop Services, using different types of methods.
- Creating And Using SQL Server And SQL DatabaseApr 01, 2017. This article helps you in creating and using SQL Server and SQL database.
- Fetch Data From Azure SQL Database Using Nintex Workflow NWC (Nintex Workflow Cloud)Mar 29, 2017. Fetch data from Azure SQL database using Nintex Workflow NWC (Nintex Workflow Cloud).
- Server Side Pagination Using AngularJS, Web API And SQL ServerMar 25, 2017. In this article, we are going to learn how to do Server side pagination with the help of AngularJS, Web API and SQL Server.
- Implementing Transparent Data Encryption In Always OnMar 21, 2017. Implementing Transparent Data Encryption In Always On.
- Logging Application Block In Microsoft Enterprise Library 6.0Mar 18, 2017. Logging Application Block In Microsoft Enterprise Library 6.0.
- Logging And Tracing With Post SharpMar 17, 2017. This article enables you to understand logging and tracing with Post Sharp.
- Implement Column Level Encryption/ Decryption In SQL Server 2016Mar 17, 2017. This article familiarizes you with implementing column level encryption/decryption in SQL Server 2016.
- Working With SQL Server R Services And R Scripts In SQL Server 2016Mar 17, 2017. Working with SQL Server R Services and R Scripts in SQL Server 2016.
- Resolving "Cannot Install SQL Server 2014 Service Pack 2" ErrorMar 16, 2017. Resolving "Cannot Install SQL Server 2014 Service Pack 2" Error.
- Differentiate Connections With Colored Status BarsMar 15, 2017. This is about an old but under utilized feature of SSMS to differentiate connections using colored status bars.
- Consume REST Service From PowerShell And Update The JSON Data To SQL Server TableMar 14, 2017. Consume REST Service From PowerShell And Update The JSON Data To SQL Server Table.
- Importing FoxPro DBF File Data In SQL Server DatabaseMar 08, 2017. In this article, you will learn how to import FoxPro DBF File Data in SQL Server database.
- How to import Excel data in SQL Server 2014Mar 07, 2017. In this article, you will learn how to import data from Excel file into SQL Server database.
- Getting Started With SSRS 2016 - Part FiveMar 06, 2017. In this article, we will discuss how we can create a Shared Data Sources in SQL Server Reporting Services 2016. We have already discussed how to create a Matrix report , using Report wizard, how to deploy SSRS Report into a Reporting Server and how to run a Report Application in my previous articles.
- Configure SQL Server Session State In ASP.NET CoreMar 01, 2017. This article describes the steps required to enable SQL Server as a storage mechanism for session state in an ASP.NET Core MVC Application.
- How To Restore Northwind Database In SQL Server In One MinuteMar 01, 2017. To use Northwind database in your SQL Server, you need to restore it. In this tutorial, I will explain all the restore database steps through the images.
- Getting Started With SSRS 2016 - Part FourMar 01, 2017. In this article, we will discuss how we can create a Matrix report, using Report wizard in SQL Server Reporting Services 2016.
- Getting Started With O365 - SharePoint-Hosted Add-Ins Using JSOMFeb 28, 2017. In this article, you will learn about SharePoint-hosted add-ins, using JSOM.
- SQL Server 2016 - Bulk Import JSON File Data To TableFeb 25, 2017. In this article, you will learn about how to bulk import JSON file data to tables in SQL Server 2016.
- Deleting SharePoint-Hosted Add-In Using Napa Office 365 Development ToolFeb 23, 2017. In this article, you will learn how to delete SharePoint-Hosted Add-ins using Napa Office 365 Development Tool.
- Import Excel Data Into SQL Table Using SQLBulkCopy In C#Feb 22, 2017. In this article, you will learn how to import Excel data into SQL table, using SQLBulkCopy in C#.
- SharePoint-Hosted Add-In By Using NAPA Tools And Delete SharePoint Task List Item Using JSOMFeb 22, 2017. In this article, you will learn about SharePoint-hosted add-ins by using NAPA Tools and Delete SharePoint Task List item using JSOM.
- Getting Started With SSRS 2016 - Part ThreeFeb 21, 2017. In this article, we will discuss how we can create a table report without using report wizard in SQL Server Reporting Services 2016.
- Diagnostic Logging As Reporting In SharePoint 2013 Central AdministrationFeb 19, 2017. In this article, you will learn about Diagnostic Logging as Reporting in SharePoint 2013 Central Administration.
- Introduction To Mount Point In SQL ServerFeb 17, 2017. This article will give you brief information on SQL Server Mount Point and its benefits and you will learn how to set up a new partition.
- Creating An Azure SQL Database As A Federated Data Source In Azure Data Lake Analytics - Part TwoFeb 14, 2017. In this article, you will learn how to create an Azure SQL database as a federated data source in Azure Data Lake Analytics.
- Creating an Azure SQL Database As A Federated Data Source In Azure Data Lake AnalyticsFeb 13, 2017. In this article you will learn how to create an Azure SQL database as a federated data source in Azure data lake analytics.
- Querying With U-SQL In A TSV File On Azure Data Lake StoreFeb 13, 2017. In this article, you will learn about using a U-SQL query in a TSV file on Azure Data Lake Store.
- SharePoint 2016 Central Admin - Monitoring - Configure Diagnostic LoggingFeb 12, 2017. In this article, you will learn how to configure Diagnostic Logging in SharePoint 2016 Central Admin.
- Getting Started With SSRS 2016 - Part TwoFeb 08, 2017. In this article, we will discuss how we can create an SSRS Report using Report Wizard in SQL Server Reporting Services 2016.
- Bind Data In WebGrid Control Using Stored Procedure In ASP.NET MVC 4.0 And SQL Server 2012Feb 06, 2017. In this article, you will learn how to bind the data in WebGrid control, using stored procedure in ASP.NET MVC 4.0 & SQL Server 2012.
- Accessing SQL From Entity Framework Core Queries In ASP.NET CoreFeb 03, 2017. In this article, you will learn how to access SQL from Entity Framework Core Queries in ASP.NET Core.
- Subscribing and Connect Microsoft Azure With SQL ServerFeb 01, 2017. This brief article will show you how to connect with SQL Server Database in Microsoft Azure.
- Introduction To SQL Database Query Editor In Azure PortalFeb 01, 2017. In this article, you will learn how to use SQL Database Query Editor in Azure Portal.
- Working With Identity Column After Table Creation In SQL ServerJan 30, 2017. In this article, you will learn about working with an identity column after table creation in SQL Server.
- Getting Started With SSDT 2016 Using Visual Studio 2015Jan 27, 2017. In this article, we will discuss in detail about how to get started with SSDT 2016.
- Getting Started With SQL Server 2016Jan 27, 2017. In this article, we will discuss in detail about SQL Server 2016, the list of features available in SQL Server 2016, prerequisites, setting up the environment, and more.
- Getting Started With SSRS 2016 - Part OneJan 26, 2017. In this article, we will discuss how we can create an SSRS Report without using Report Wizard in SQL Server Reporting Services 2016.
- Create Power BI Reports Using Azure Audit LogsJan 23, 2017. In this article, you will learn how to create Power BI reports using Azure Audit Logs.
- Create Azure SQL DB And Generate Power BI Reports Using Table DataJan 20, 2017. In this article you will learn how to create Azure SQL DB and generate Power BI Reports using Table Data.
- LINQ To SQL - CRUD OperationsJan 19, 2017. In this article, we will see LINQ to SQL CRUD Operations.
- MSSQL Extension For Visual Studio CodeJan 11, 2017. In this article, you will learn about MSSQL extension for Visual Studio Code.
- Get Data From Multiple Tables Using Parameters While Combining LINQ ExpressionsJan 11, 2017. In this article, you will learn how to get data from mutliple tables using parameters when combining LINQ expressions in ASP.NET MVC 5.
- Convert DateTime To String Format Using IQueryableJan 10, 2017. In this article, you will learn how to convert DateTime to string (yyyy/mm/dd) format in ViewModel/Whatever class with IQueryable.
- How To Use Grouping In SSRSJan 10, 2017. In this article, you will learn how to use grouping in SSRS.
- Overview Of Concurrency In LINQ To SQLJan 10, 2017. In this article, you will learn about concurrency in LINQ to SQL.
- Create Azure SQL Databases And Connect To The Local SystemJan 09, 2017. In this article you will learn how to create Azure SQL Databases and connect to the local system.
- Identity Cache In LINQ To SQLJan 08, 2017. In this article, we will see what identity cache is and its impact on LINQ to SQL queries.
