sqlserver-2008

Resources

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#.
Active Directory Migration Fom Windows 2008 to Windows 2016Dec 11, 2023. Active Directory migration from Windows 2008 to Windows 2016
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.
How to do a Windows Server in-place upgradeNov 14, 2019. In this article, we will learn how to do a Windows Server in-place upgrade to Windows Server 2019.
SQL Server 2008 End Of SupportJul 08, 2019. In this article, you will learn about SQL Server 2008 End Of Support.
SQL Server 2008 R2 SP3 Install ErrorsAug 07, 2018. Whenever it is time to install a service pack every DBA silently hopes that nothing will go wrong. I would surmise that, in most cases, installing the service pack is a non-event. No flashing lights, no fireworks, no applause and no major hiccups. This post is not about one of those times.
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.
How To Make SSIS Package In SQL Server 2008Jul 21, 2016. In this article, you will learn how to make SSIS package in SQL Server 2008.
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.
Getting Started With OpenLayers 3 And Spatial DataMar 21, 2016. Explore visualizing spatial data using OpenLayers with SQL Server 2008. Learn about the capabilities of OpenLayers for mapping, including its support for tiles and vector layers. Understand the two types of spatial data: geometry and geography, and their representation in SQL Server.
Deploying Packages In SQL Server Integration Services (SSIS) 2012Feb 01, 2016. In this article we’ll deploy the package that was created under SQL Server Integration Services (SSIS) 2008 and upgraded for SSIS 2012.
Restore The SQL Server 2008 R2 Database To SQL Server 2014Jan 15, 2016. In this article you will learn about restoring the SQL 2008 R2 database to SQL 2014.
SQL Server 2008 Installation Step By StepJan 02, 2016. In this article we’ll install SQL Server 2008 on our machine step by step.
CRUD Operations In SQL Server 2008Oct 05, 2015. In this article l will show you how to make CRUD operations in SQL Server 2008 by using simple SQL queries.
Switch Column Value of a Table Using Cursor in SQL Server 2008Aug 11, 2015. This article explains how to switch a column value of a table using a cursor in SQL Server 2008.
Introduction to SQL Server FileStream in 2008Jul 24, 2015. In this article we will learn about the FileStream in SQL Server 2008.
How to Create a Crystal ReportMay 13, 2015. In this article, we will learn how to create a Crystal Report.
Create Setup in Visual Studio 2008May 13, 2015. In this article you will see how to create a setup in Visual Studio 2008.
How to Create Database in SQL Server 2008May 13, 2015. Here you will learn how to create a database in SQL Server 2008.
Node.js And AngularJS With SQL ServerApr 14, 2015. This article explains how to use NodeJs and AngularJS with SQL Server.
CTE in SQL ServerApr 07, 2015. In this article we will learn about Common Table Expressions (CTE) in SQL SERVER 2008.
Table Value Parameter in ASP.Net Using SQL ServerMar 28, 2015. This article shows how to pass a collection of records to a database for processing. In SQL Server 2008 we make a custom data type TABLE to pass a collection of rows to a Stored Procedure.
Rebuilding SQL Server 2008 R2Mar 24, 2015. In this article you will learn how to rebuild a master database in SQL Server.
Concatenate Multiple Rows Within Single Row in SQL Server 2008Mar 14, 2015. STUFF Function in SQL Server. In this article we will learn how to concatenate multiple rows within a single row in SQL Server 2008.
Table Valued Parameters in SQL 2008Feb 23, 2015. This article describes Table Valued Parameters in SQL 2008 and how they can be used with C# code.
Database Table Encryption Using Symmetric Key in SQL Server 2008 R2Jan 23, 2015. In this article you will learn about Database Table Encryption using Symmetric Key in SQL Server 2008 R2.
Snapshot Replication (Setting up Subscriber) in SQL Server 2008: Part 3Dec 24, 2014. This article is part three of a seried intended to shed light on setting up Publisher in Snapshot Replication.
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.
Snapshot Replication (Setting up Publisher) in SQL Server 2008: Part 2Dec 17, 2014. In this article you will learn Snapshot Replication (Setting up Publisher) in SQL Server 2008.
Snapshot Replication in SQL Server 2008: Part 1Dec 16, 2014. In this article, I will cover Snapshot Replication in SQL Server 2008.
Automated Backup Using SQL Server 2008Nov 20, 2014. This article shows how to take an automatic backup and after a week delete the prior seven days of data.
Create and Schedule a Job in SQL Server 2008Nov 05, 2014. This article explains how to create a new SQL Server job, how to schedule a job and how to set an alert for a job.
SQL Server Tips and TricksOct 28, 2014. This article provides some tricks we may use in our day-to-day programming life in SQL.
Upload and Download File Using GridView and SQL Server 2008Sep 29, 2014. In this article you will learn how to upload and download any type of file using a GridView and SQL Server 2008.
Coalesce Function in SQL Server 2008 With LimitationsAug 26, 2014. This article describes the Coalesce Function in SQL Server 2008.
How to Use RDLC Local Report in ASP.Net to Download in Doc PDF and Excel FormatAug 13, 2014. This article demonstrates how to use a RDLC local report to get various downloadable file formats of reports, such as a Word or Excel document or a PDF.
How to Change Default Value For Selecting and Editing Top n Rows in SQL Server 2012Aug 07, 2014. In this article I will describe how to change a default value for selecting and editing N rows in SQL Server 2012.
How to Uninstall a SQL Server Instance in SQL Server 2008R2 and 2008Aug 05, 2014. This article describes how to uninstall a SQL Server instance in SQL Server 2008R2 and 2008.
Differences Among SSIS 2005, 2008 and 2012Aug 04, 2014. This article explains the basic differences among SSIS 2005, SSIS 2008 and SSIS 2012.
The Undocumented Sp_MSforeachdb Procedure in SQL ServerMay 27, 2014. This article explains the undocumented sp_MSforeachdb procedure in SQL server.
How To Develop Apps For Hand Held Scanner For Scanning Barcodes: Part 1Apr 29, 2014. In this article we will learn how to develop an application for Windows Mobile CE. (Pocket PC and all types of scanners and and so on.)
Undocumented Physical Row Locator Function in SQL Server 2008Apr 23, 2014. This article describes an undocumented physical row locator function in SQL Server 2008.
Installing SQL Server 2008Jan 27, 2014. Here, you will see how to install SQL Server 2008.
Getting Started With Reports in .NETJan 22, 2014. In this article, you will see how to get started with reports in .NET using Visual Studio 2012.
Inserting Image in Database Using JavaJan 02, 2014. This application inserts an image into a database (SQL Server using Java..
Inserting and Retrieving Images From Database Using Servlets and JSPJan 02, 2014. In this article we are using Servlets and JSP to store and retrieve images from a database.
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.
Create Simple Web Service in Visual Studio 2008 / 2010 /2012Dec 06, 2013. This tutorial explains how to create simple Web Services using Visual Studio 2008 or Visual Studio 2012.
Generate Script Of Database in SQL Server 2008Dec 04, 2013. In this article we learn how to generate a database script for database backup purposes and how to correspondingly restore a database using the script we created. We also regenerate an entire database using a database script.
Learn Transactional Replication SQL Server 2008Nov 03, 2013. Dear reader today we will discuss another important and well demanding topic that is replication.
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.
Look at TCP Chimney Offload in Windows Server 2008Oct 07, 2013. In this article, we will look into the TCP Chimney Offload feature, its purpose and how to enable it.
Create Setup and Deployment Project in Visual Studio 2008/2010Sep 26, 2013. In this example I will explain how to create a setup and deployment project using ClickOnce.for Windows Forms applications using Visual Studio 2005/2008/2010.
Differences Among SQL Server 2000, 2005 and 2008Aug 09, 2013. This article explains the main differences among SQL Server 2000, 2005 and 2008.
Dynamic Management Views (DMVs) in SQL Server 2008 R2Jul 29, 2013. This article explains Dynamic Management Views (DMVs) in SQL Server 2008 R2. This provides the current information about the procedures of the service and the server health.
Create RDLC Report in VS 2010 and SQL Server 2008Jul 09, 2013. This article explains how to create a RDLC report using VS 2010 and SQL 2008.
Change Data Capture in SQL Server 2008Jul 06, 2013. Today I discuss the new features Change Data Capture in SQL Server 2008.
Temporary Stored Procedures in SQL ServerJul 03, 2013. In this article, I highlight a small feature of Temporary Stored Procedures in SQL Server. Temporary Stored Procedures are similar to normal Stored Procedures, and are two kinds of temporary Stored Procedures, local and global.
Limitations of View in SQL Server 2008Jun 29, 2013. In this article we will see the view limitation in SQL Server 2008.
Learn SSIS Microsoft SQL Server 2008: Part1Jun 26, 2013. This article explains SSIS, a powerful feature of Microsoft SQL server.
Differences Between SCOPE IDENTITY, IDENT CURRENT, and IDENTITY in SQL ServerJun 24, 2013. In this article you will learn what is Different between SCOPE_IDENTITY, IDENT_CURRENT, and @@IDENTITY in SQL 2008
Entity Framework Approach To Connect To MS SQL Server 2008 Using Visual C#Jun 19, 2013. This article defines an Entity Framework approach to connect to Microsoft SQL Server 2008 using Visual C#.
Logging Using Log4net in Compact Framework 2.0 in Visual Studio 2008Jun 08, 2013. This article will show you how you can use log4net.dll to do logging in a Compact Framework 2.0 application.
How to Use SQL Server Profiler and Tuning AdvisorMay 21, 2013. In this article you will learn how to use SQL Profiler and database Tuning Advisor to improve the performance of a database.
Create a Report in SSRS 2008May 20, 2013. In this article you will learn how to create a report in SSRS 2008.
Learn Membership Services Part 1: Installing ASP.NET Membership Services Database in SQL Server 2008May 04, 2013. In this article, we create a database in SQL Server and install ASP.NET membership services then install an ASP.NET Memberships Services Database.
SQL Server 2008 R2 on Windows 8 Error 17058 When Starting the ServiceMar 08, 2013. Windows 8 is the newest operating system from Microsoft and now it's spreading through the development systems replacing Windows 7.
Fix Corrupt User Profile / Temp Profile in Windows Server 2008/ 2012Mar 01, 2013. You will see here how to fix a corrupt user profile or temp profile in Windows Server 2008/2012
Configure Office Web Apps For SharePoint 2013: Part IIFeb 14, 2013. This article is a continuation of the deployment procedures that are described in my previous article Configure Office Web apps for SharePoint 2013 Part I.
Configure Office Web Apps For SharePoint 2013: Part 1Feb 13, 2013. In this article we can learn how to deploy Office Web Apps Server.
Installing SharePoint 2013: Part 1Feb 06, 2013. Installing SharePoint 2013 is an interesting experience if you didn’t mess it up. As a first step we need to understand the hardware and software requirement for SharePoint 2013.
Fetch, Insert, Update, Delete Data with “Database First Model Approach” using ADO.NET Entity Framework 3.5 and Visual Studio 2008.Jan 21, 2013. In this article you will learn how to Fetch, Insert, Update and Delete Data using the Database First Model Approach and the ADO.NET Entity Framework 3.5 and Visual Studio 2008.
List All Files in a Folder Based on File Extension in ASP.NETJan 14, 2013. This is a very simple article on how to search and list all the files in a folder based on the file extension provided.
WCF Method OverloadingDec 26, 2012. How do you do Method Overloading in WCF? In this article,I am using Visual Studio 2008 building a WCF service and for simplicity, NET TCP Binding is used.
Using LINQ in word 2007 with VSTO and VB 2008 in VB.NETNov 09, 2012. This article shows an example of integrating LINQ and Visual Studio 2008 Tools for office to query Word documents properties, via Visual Basic code.
Test for User Group Membership in VB.NETNov 08, 2012. This article describes a simple approach to determining whether or not a logged in user is a member of a group within the context of an asp.net web based application.
Top in SQL SERVER 2008Oct 06, 2012. In this artcle you will see how to use the top keyword in a select query to get the top element from the query.
Configure and send E-Mail from SQL ServerAug 07, 2012. In this article we will discuss how to configure and send emails from SQL server 2008.
C# Extension Methods: ExplainedAug 06, 2012. The intention of the article is to give an idea of what extension methods are and their benefits.
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.
Installation and Verification of Remote Blob Storage (RBS) on SharePoint 2010Apr 21, 2012. Remote Blob Storage (RBS) facilitates storage of BLOB data outside the SQL Server Content Database onto the file system by using the FILESTREAM feature of SQL Server 2008.
Change Tracking in SQL ServerFeb 27, 2012. Change tracking captures rows in a table that have been changed, but do not capture the data that was changed.
CRUD Operations With Stored Procedures Via Entity Data Model Framework (EDM)Feb 24, 2012. Today, in this article let’s play around with one of the good interesting features, stored procedures with EDM Framework.
Creating a Basic RogueLike Game in C# (Version 0.1)Feb 01, 2012. Want to build a Roguelike game with C# in 5 minutes? The following is a really quick game I built in about 2 hours and shows how easy it is to get a simple game going.
MySQl : Web site configuration tool in Visual Studio 2008Dec 26, 2011. In this Article we have to explain the Mysql website configuration tool in visual studio 2008.
Joins Using LINQ in C#Dec 13, 2011. Today, in this article we will see how to perform join operation using LINQ queries. I have created two tables in database named ‘Candidate’. The first table name is Employee. the second table name is Student. I have used LINQ to SQL to communicate with database.
Let's play around with LINQ Queries in C#.NETDec 08, 2011. Today, we will play around using LINQ Queries in C#.NET effectively. Let’s try to use some of the predefined methods of LINQ Queries and let’s dig out and find how to write LINQ rather than traditional way of using normal Classes.
Manage Data Insertions and Retrievals with LINQ –to-SQLDec 08, 2011. Today, let’s perform simple light weighted operation using LINQ-to-SQL as retrieval and data insertion.Let’s display the data retrieved values using simple grid.Let’s pass on some LINQ queries to perform an expected operation. We are now good to go and do some practical implementations
Select, Insert, Update, Delete Using Stored Procedure in SQL ServerNov 16, 2011. Here, we will see how to create select, insert, update, delete SQL statements in stored procedures in SQL.
Output keyword in Sql Server 2008Nov 12, 2011. In a simple word we can say OUTPUT clause used with INSERT, UPDATE, or DELETE to identify the actual rows affected by these statements and also used for the auditing purpose.
Windows Management Instrumentation (WMI)Oct 15, 2011. In this article we are going to write a windows forms application that helps us to retrieve a list of services on a remote computer and operate on them(start/stop).
SSMS Performance Dashboard Reports in SQL Server to find BottlenecksSep 29, 2011. In this article you will see how to use SSMS Performance Dashboard Reports in SQL Server to find Bottlenecks.
Database Mail Configuration in SQL Server 2008Sep 14, 2011. Learn how to configure Database Mail in SQL Server 2008 with this guide. Discover step-by-step instructions for setting up email profiles, configuring SMTP settings, and managing mail settings using SQL Server Management Studio.

Tags