Resources   No resource found

• Forceseek with Execution Plan Example In SqlServer 2008May 11, 2011. In this article I will describe what is a forced seek and how to use them in SQL Server 2008 with aN execution plan
• High Performance Abstraction Layer for Non-Blocking Asynchronous Thread Safe SqlServer CallsApr 25, 2008. One of the things I find myself doing frequently is writing (and re-writing) plumbing code to execute database CRUD operations. I wrote an abstraction layer over asynchronous SqlServer calls that allows developers to correctly make async calls agains SqlServer without having to deal with any of the complex plumbing normally required. All source code is included with this article.
• Automatic SQL Server Backup Utility using Sqlserver AgentOct 06, 2006. It is a sample C# (VS2005) application for Automatic Sql server Backup Utility using sqlserveragent. I have used SQL-DMO dll. This article will show you how to create a automatic backup in Sql server 2000.
• Explore Persistence Caching In Web API Using CacheCow.Server.EntityTagStore.SqlServerApr 12, 2016. In this article you will learn how to explore Persistence Caching in Web API using CacheCow.Server.EntityTagStore.SqlServer.
• CASCADING Referential Integrity in SqlServerFeb 26, 2011. This article will explain how to delete and update Child Table records implicitly when updating or deleting a Parent Table.
• Switching Query Results in Fabric WarehouseAug 17, 2026. Learn how to run multiple SELECT statements in a Microsoft Fabric Warehouse and easily switch between their individual result sets. Using practical examples with Region, Product, and Orders tables, this article shows how multiple queries can simplify data exploration, validation, troubleshooting, and everyday SQL development in Fabric.
• Learn to Shrink a Microsoft SQL Server Database Programatically Aug 20, 2024. Shrinking a SQL Server database reduces file size by reclaiming unused space in data and log files. This can optimize disk usage, especially in storage-constrained environments. However, it can cause data fragmentation and impact performance. Use commands like DBCC SHRINKDATABASE cautiously in C#.
• Fetch Previous Row Value With Lag Function And Without Lag FunctionJun 07, 2022. In this article, you will learn how to fetch previous row value with lag function and without lag function.
• Create An Azure Devops Pipeline To Continuously Integrate And Deploy .NET 6 REST API To Azure CloudFeb 07, 2022. Create An Azure Devops Pipeline To Continuously Integrate And Deploy .NET 6 REST API To Azure Cloud.
• Insight.Database , .NET Micro ORM - Write Less Code In Data Access Layer Using Auto Interface ImplementationNov 07, 2021. In this article, you will learn about Insight.Database is a fast, lightweight, (and dare we say awesome) micro-orm for .NET. Auto Interface Implementation implements the interface for you automatically, and you can just call the method, with full type-safety and full performance of IL-generated code.
• Modern Architecture Shop - AutoscalerNov 10, 2020. Modern Architecture Shop is a clean-lightweight .NET and scalable application. Keep your eye on the Road Map (watch it on GitHub). The next version will contain a minimal feature set so that the user can add products to the basket and pay it. Recommendation service and all other AI services or features, I provide them later.
• Simplified Courier Tracking SystemJul 16, 2020. The system is used for daily activities, such as booking, nondelivery, out return, company details, hub rates, and pickup centers. It is very difficult to do this process manually. Hence it is recommended to computerize the process by developing the relative software as the world is turning into information and technology; computerization becomes a necessity in all walks of life. This process has divided into Admin, Customer, and Employee Logins. The admin will go into the Homepage and there are all the controller processes like customer, booking, cancellation. Tracking is also maintained. The customer will log in to form to view only Booking & Tracking, and her/his account information is stored. In Employee will login into a form that will display account information, and booking information is maintained. Finally, these details are stored in the Database. This project is implemented in Visual studio 2008 in a C# .NET Windows application and Back End in SQL Server 2005.
• EFCore Implementation Using .NET coreApr 22, 2020. In this article, you will learn about EFCore Implementation using .Net core.
• Exception Handling In SQL ServerMar 16, 2020. In this article, you will learn about exception handling in SQL Server.
• Sharing A Solution To Generate BillcodeOct 16, 2017. Many of systems we use will generate plenty of billcodes everyday , and most of them include date(datetime) or a prefix to show their signification , such as specifying a billcode belongs to a special day or a special type .
• Transaction In .NETOct 30, 2016. This article describes what transaction is and how it can be implemented in .NET.
• Email Name Suggestions Using Database (SQL Server)Dec 24, 2014. In this article we are learning whether or not a username exists. If the user exists in the table then some other name is suggested like Gmail.
• Creating ASP.NET MVC APP With WCF ServiceDec 27, 2013. In this article you will learn how to create ASP.NET MVC APP with WCF Service using ADO.NET Entity Data Model.
• Search Records in Windows Form From SQL ServerOct 30, 2013. In this article you will see how to search the records from the database sql-server and how to binding the table values inside the datagrid.
• Lightbox in ASP.NET Connected With SQL ServerMay 09, 2012. In my application I have a large amount of media that makes my site slow. This article explains what I did to solve the problem. I hope this will be useful for someone.
• Temporary and Global Temporary Table in SQL Server 2008Jun 09, 2011. In this article I describe the usef of Temporary and Global Temporary Tables in SQL Server and how they are created by SQL Server 2008.
• Generating a View in SQL Server 2008Jun 06, 2011. In this article I will describe what a view is, how it is usefull and how you will generate a view between more than one table.
• Left and Right Join in SQL ServerJun 01, 2011. In this article, I will describe how to perform left and right outer join between more than one tables in SQL Server 2008.
• Index in SQL Server 2008May 27, 2011. In this article I will describe how to make a Cluster Index, Unique Index and Normal Index in SQL Server 2008 Express editions.
• Activity Monitor for SQL Server 2008May 27, 2011. In this article I will describe what activity monitor is and how they are used.
• SQL Server Integration Services (SSIS) - Aggregate (MAXIMUM) Transformations Control in SSISApr 14, 2011. This is part 36 of the series of article on SSIS. In this article we are going to see how to use an Aggregate (Maximum) data flow transformation control in SSIS packaging.
• Take Backup of a DataBase By CodingJul 13, 2010. In this article, I am going to show how we can show all Data Server in a network and on selecting a Data Server, how to show all DataBase of that selected Data Server and how to take backup of selected database on a particular location by code.
• Data Components in Visual Studio .NET: Part IOct 13, 2009. In this article, I will help you in understanding using the Server Explorer for Adding a new Connection.
• Import Data from Excel to a SQL Server databaseJan 16, 2009. This article mainly describes about how to import the data from Excel sheet to the SQL Server database.
• Multi-threaded Asynchronous Programming in C#. Async Database Calls. Part III.May 14, 2007. In my last couple articles we looked at basic ways to have long-running i/o bound process be handled by the ThreadPool using the asynchronous programming model. In this article we’ll take a look at coding async calls against SqlServer which really comes in handy in production environments where our database is on another machine.
• SQL Server Backup file in standard Zip formatOct 12, 2006. This is SQL Server Backup and restore tool, the system will store the backup files in standard Zip format ,the user-friendly screen let you backup and restore SQL Server database to local harddisk or remote network driver easily and quickly.The program can restore database easily.
• User Authentication & Role Management in ASP.NET 2.0 using Sql Server 2005: Part IIAug 15, 2006. This article gives you a detailed idea of how to implement the role management in ASP.NET 2.0 using SQL Server 2005.
• Designing and Implementing a Versatile Data Access Tier Jan 16, 2003. In this tutorial, we will drill down deeper in to the design of a n-tier architecture and our focus will be on the data access tier(DAT). Our goal is to design and implement an appropriate data access tier(DAT) for scalable, reliable and interoperable web application.