Resources No resource found - Connecting Login Form In C# With Database For User Type AuthenticationAug 15, 2017. This article describes how to connect a Login Form designed in C# with a database so that the user gets validated based upon the password given by the administrator who has created the login database.
- Load Twitter Data Into SQL DatabaseAug 15, 2017. The requirement is to extract the data from Twitter and load extracted data into SQL Database. For this demonstration I am going to read the Indian Film actor Kamal Haasan's tweets and load that into SQL Server 2016 Database.
- Learn Azure Blob StorageAug 11, 2017. Basically, it represents the durable store in the Azure cloud. And also, it allows storing blob, tables, messages, and queues.
- SQL Azure With Entity FrameworkAug 08, 2017. Exploring SQL Azure With Entity Framework
- Create SQL Server Database Project With Visual StudioAug 08, 2017. In this article, we’re going to learn about how to we can manage our database scripts using Visual Studio’s SQL server database project.
- Understanding Azure Data Lake AnalyticsAug 07, 2017. This article will give an overview of Data Lake analytics account and create U-SQL job and execute this job to put data into the .csv file.
- How To Determine The Version And Edition Of SQL Server And Its ComponentsAug 06, 2017. For Business Intelligence features such as Integration Services, Reporting Services, and Analysis Services, you may have to install the latest service packs, cumulative updates, and hotfixes on the client-side computers to obtain the latest fixes while developing SSIS packages, SSRS reports, or Analysis Services cubes.
- Understanding SQL Azure - Part OneAug 06, 2017. This article will give a idea about creating SQL DB in Azure and using it in Visual Studio
- Understanding SQL Azure - Part TwoAug 06, 2017. This article will allow us to connect with SQL Azure and perform CRUD operations using EF.
- Compare Azure SQL Database And Azure SQL Data WarehouseAug 05, 2017. In this article, I am going to compare both Azure SQL database and Azure SQL data ware house. I was reading many articles; below is the tabular compression of both.
- Setup And Connect To Azure SQLAug 03, 2017. Microsoft Azure SQL Database (formerly known as SQL Azure) is a managed cloud database i.e. Software as a Service (SaaS) provided by Microsoft Azure. In simple words, Microsoft Azure SQL is a cloud database that runs on a cloud computing platform and access to it is provided as a Service.
- Entity Framework CRUD Operation Performed With SQL Stored Procedure Using ADO.NET Entity Data ModelJul 31, 2017. You can see my pervious article for Entity framework with Ado.Net data Model connection and how to create a new entity framework project and sql database connection maintained with created entity framework project. Also you can see how to create a class in entity framework based on data table.
- How To Use Visual Studio For Azure SQL DatabaseJul 31, 2017. This article demonstrates using Visual Studio step by step for Azure SQL Database operation.
- Combination Of Id-ParentId And HierarchyId Approaches To Hierarchical DataJul 26, 2017. How to combine the Id-ParentId and HierarchyId approaches to keep and fetch the data in hierarchical and alphabetical order.
- Learn Web API : Using SQL Helper ClassJul 25, 2017. This article demonstrates how to use Web API Using SQL Helper Class with easy to use data base access in Visual Studio 2017.
- How To Use Query Editor For Azure SQL Database In Azure PortalJul 24, 2017. Azure Portal provided Query editor for database operations, which is very good for us. We don’t need any software installation in our computer; we can access and perform the task online.
- Creating An Azure SQL Database And Connecting Through SQL Server Management StudioJul 23, 2017. This article demonstrates how to create an azure SQL Database, setting the Firewall rule and connecting through the SQL Server Management Studio.
- Taking Script From Database In SQL Server In Different ModeJul 17, 2017. This article explains how to take the script from database in SQL server in a different mode. Normally we take back up our entire database as “.bak, .mdf, .ldf” file but sometimes we need to alter, update or delete then create our database based on our database modification.
- Create SSRS Drilldown ReportJul 17, 2017. Create SSRS drill down report, add link enable/disable based on specific condition, adding download links in reports.
- ABC Of WPFJul 15, 2017. Basically I am working on .Net/Sql. For the project requirements I went through the WPF. I visited so many online tutorials and videos to get the knowledge. In this article I am going to share my understanding with you.
- Connecting And Working With Azure SQL Database Using Visual Studio 2017Jul 12, 2017. This article shows how to connect and work with the Azure SQL Database. In this article, I am going to demonstrate how to connect and work with the Azure SQL Database using Visual Studio 2017.
- Mirroring Database In SQL ServerJul 12, 2017. When there is any automatic failure we need another server that will monitor the principal server.
- Monitoring Our Database When Accessing From Outside Or Applications In SQL ServerJul 08, 2017. This article explains how to monitor our database when accessing from outside or any other applications in an easy way.
- Data Persistence Using SQLite In Xamarin.FormsJul 04, 2017. In this article, we are going to make our data persistence using SQLite in Xamarin.Forms. Firstly we will setup SQLite db for our project than make a table in it and add some data in this table. After this whenever we open our application we will see that our data is now persisted and saved in local db of application.
- Installing SQL Server vNext On Linux - Part TwoJul 04, 2017. With the release of Microsoft SQL Server on Linux, it is a huge step towards gaining markets in Database Technologies giving competition to other RDBMS software. Microsoft SQL Server is not only on Windows but it is on Linux also and people who love Linux can check the flavor of SQL Server in the Linux environment.
- Deploying An Azure SQL Database In Microsoft Azure PortalJul 03, 2017. This article shows how to create and configure the firewall and how to run sample sample queries in the SQL Database using Azure Portal.
- How To Download SQL Records In Excel Format Using MVCJul 02, 2017. I will explain how to download records in Excel format from database.
- Learn AWS With MS-SQL(DB) Using SQL ClientJul 01, 2017. You want to login to the AWS console here. If you have no login register new users in here. After registering amazon will provide one year free access.
- How To Create Azure SQL Database And Access It Through Visual Studio CodeJun 26, 2017. In this article, I’m going to cover how to create Azure SQL database and how you can access it through Visual Studio code.
- Angular Demo Application With ASP.NET Core MVC (Rent A Car)Jun 26, 2017. This project is a simple rent a car project developed in ASP.NET Core MVC and Angular with backend as SQL Server 2008 R2.
- Daily Shrink Database Log Automatically Using Jobs In SQL ServerJun 24, 2017. This article explains how to shrink database log daily using jobs in SQL server by step by step. We can shrink database logs automatically using jobs in SQL Server that we no need to run SQL Script manually.
- Learn About Bootstrap TablesJun 21, 2017. In this article we will see how to create Bootstrap tables.
- 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.
- 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.
- 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
- How To Create Multiplication Table In C# Window ApplicationMay 30, 2017. How to create multiplication table in C# Window Applications.
- 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.
- Add Table Of Contents Webpart In SharePoint Online SiteMay 23, 2017. In this article I would like to share what is Table of Contents webpart and how to add the table of contents webpart in SharePoint Site.
- 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.
- Write HTML Code In Xamarin Cross Platform With Table ExampleMay 17, 2017. You build your mobile app entirely in HTML, however those apps can suffer from performance problems when trying to accomplish complex processing or UI effects and are also limited in the platform features which they can access.
- 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.
- ASP.NET Core Identity Tables Customization With Visual Studio 2017May 09, 2017. In this article, you will be acquainted with ASP.NET Core identity tables customization with Visual Studio 2017.
- 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.
- Column Wise Filter In Web Grid By Jquery Data TableMay 07, 2017. In this article, you will be acquainted with column wise filter in Web Grid by jQuery data table.
- Add TOC (Table Of Contents) To Your Wordpress Posts Or PagesMay 07, 2017. In this post, we are going to a see how we can add Table of Contents to our WordPress posts and pages. Here, we are going to install a plugin to do this work. I have chosen this plugin because it is so simple and yet does the work very well. It doesn’t have more settings and features but the way it is created is 100% apt for what it is meant to be.
- Cross Database Queries In Azure SQLMay 06, 2017. In this article, you will learn about cross database queries in Azure SQL.
- Xamarin.Forms - Design Switch Cell With Table View Application Using Visual Studio 2017May 03, 2017. This article enlightens you on designing switch cell with Table View Application, using Visual Studio 2017.
- 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.
- Table View In Xamarin.FormsApr 28, 2017. In this article, you will learn about Table View In Xamarin.Forms.
- Update And Delete Row From Multi-Table Base Select View With MVC 5.0Apr 28, 2017. This article familiarizes you with how to update and delete row from Multi-Table Base Select View with MVC 5.0.
- 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.
- Multi-Table Base Select View in MVC 5.0 With Database First Approach Apr 24, 2017. This article presents a use of Multi-Table Base select View in MVC5.0 with Database First Approach.
- 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.
- 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.
- 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.
- 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 Azure SQL Server And Azure 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.
- 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.
- Explore Storage Account Of Azure Functions - Table ServiceMar 14, 2017. Explore Storage Account of Azure Functions – Table Service.
- 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.
- 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.
