2008 Resources

Share

Related resources for 2008

Database Mail Configuration in SQL Server 20089/10/2024 10:16:49 AM. 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 S
Database Mail in SQL Server 2008R29/4/2024 8:38:30 AM. Database Mail in SQL Server 2008 R2 enables sending emails directly from SQL Server using SMTP. It supports job alerts, query results, and file attachments, ensuring consistent, scalable, and secure e
Getting Started With OpenLayers 3 And Spatial Data4/18/2024 10:45:12 AM. 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 ty
Active Directory Migration Fom Windows 2008 to Windows 201612/11/2023 10:23:01 AM. Active Directory migration from Windows 2008 to Windows 2016
Generate Database Script with Table Data From SQL Server12/6/2023 9:21:33 AM. In this article, I will describe how to generate a database script for a table with all it's data, views, stored procedures, constraints, and login credentials.
Creating a Basic RogueLike Game in C# (Version 0.1)9/11/2023 11:57:03 AM. 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.
Oracle database 11g and Microsoft SQL Server 20087/31/2023 4:34:50 AM. In this article, I want to cover the new features in Oracle 11g and SQL Server 2008 database systems which are two important players always fighting for the top spot in this important market segment o
Learn Membership Services Part 1: Installing ASP.NET Membership Services Database in SQL Server 20081/31/2023 6:32:05 AM. 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 Service1/24/2023 7:09:43 AM. Windows 8 is the newest operating system from Microsoft and now it's spreading through the development systems replacing Windows 7.
Differences Between SCOPE IDENTITY, IDENT CURRENT, and IDENTITY in SQL Server1/24/2023 7:00:43 AM. In this article you will learn what is Different between SCOPE_IDENTITY, IDENT_CURRENT, and @@IDENTITY in SQL 2008
Change Tracking in SQL Server1/16/2023 8:09:35 AM. Change tracking captures rows in a table that have been changed, but do not capture the data that was changed.
How to Use SQL Server Profiler and Tuning Advisor1/3/2023 9:13:00 AM. In this article you will learn how to use SQL Profiler and database Tuning Advisor to improve the performance of a database.
Using Temp Table in SQL Server And Adding Columns Dynamically12/29/2022 8:34:12 AM. In this article we'll see how to use the Temporary tables, what are the necessary step to be taken while using them and moreover sometimes it's required to add column in Temporary tables dynam
Create RDLC Report in VS 2010 and SQL Server 200812/28/2022 11:43:23 AM. This article explains how to create a RDLC report using VS 2010 and SQL 2008.
CTE in SQL Server12/27/2022 2:16:49 AM. In this article we will learn about Common Table Expressions (CTE) in SQL SERVER 2008.
Select, Insert, Update, Delete Using Stored Procedure in SQL Server12/21/2022 7:28:05 AM. Here, we will see how to create select, insert, update, delete SQL statements in stored procedures in SQL.
Snapshot Replication (Setting up Subscriber) in SQL Server 2008: Part 32/12/2021 7:06:26 AM. This article is part three of a seried intended to shed light on setting up Publisher in Snapshot Replication.
List All Files in a Folder Based on File Extension in ASP.NET2/10/2021 10:20:58 AM. This is a very simple article on how to search and list all the files in a folder based on the file extension provided.
Entity Framework Approach To Connect To MS SQL Server 2008 Using Visual C#12/2/2020 10:35:13 PM. This article defines an Entity Framework approach to connect to Microsoft SQL Server 2008 using Visual C#.
Fetch, Insert, Update, Delete Data with “Database First Model Approach” using ADO.NET Entity Framework 3.5 and Visual Studio 2008.11/3/2020 7:39:20 AM. 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.
How to do a Windows Server in-place upgrade11/14/2019 12:40:38 PM. In this article, we will learn how to do a Windows Server in-place upgrade to Windows Server 2019.
WCF Method Overloading9/13/2019 2:12:32 AM. 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.
Inserting Image in Database Using Java7/23/2019 3:54:22 AM. This application inserts an image into a database (SQL Server using Java..
Inserting and Retrieving Images From Database Using Servlets and JSP7/19/2019 4:57:18 AM. In this article we are using Servlets and JSP to store and retrieve images from a database.
Temporary Stored Procedures in SQL Server7/18/2019 12:15:48 AM. 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 Pr
Left and Right Join in SQL Server7/15/2019 5:13:03 AM. In this article, I will describe how to perform left and right outer join between more than one tables in SQL Server 2008.
Take Backup of a DataBase By Coding7/15/2019 3:30:47 AM. 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 selecte
Differences Among SSIS 2005, 2008 and 20127/15/2019 2:07:05 AM. This article explains the basic differences among SSIS 2005, SSIS 2008 and SSIS 2012.
Date and Time Functions in SQL Server7/15/2019 1:21:18 AM. This article will list Date and Time functions shipped with SQL Server.
SQL Server 2008 End Of Support7/8/2019 9:42:42 AM. In this article, you will learn about SQL Server 2008 End Of Support.
Aggregate Functions in SQL Server7/2/2019 6:11:27 AM. What are Aggregate Functions in SQL Server? This article helps you to explore various Aggregate Functions in SQL Server.
Temporary and Global Temporary Table in SQL Server 20086/20/2019 4:48:13 AM. 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.
Create Your First CLR Trigger in SQL Server 2008 Using C#6/11/2019 6:13:01 AM. CLR Trigger for SQL Server. Here you will see how to create your first CLR Trigger for SQL Server 2008 using C#.
Data Encryption and Decryption in SQL Server 20086/11/2019 4:32:33 AM. Cryptography can be implemented in the SQL Server. This article explains about the encryption and decryption of data in SQL Server.
Passing Table Valued Parameter to Stored Procedure: Part 26/11/2019 2:18:04 AM. Here you will see how to pass a table valued parameter to a Stored Procedure.
Convert Rows to Columns in SQL Server6/10/2019 5:27:48 AM. This article will help to convert values in rows to column/fields name or headers.
Creating and Managing User Defined Functions in SQL Server 20086/6/2019 5:20:10 AM. Here you will see how to Create and manage User Defined Functions in SQL Server 2008.
Concatenate Multiple Rows Within Single Row in SQL Server 20086/6/2019 3:20:26 AM. STUFF Function in SQL Server. In this article we will learn how to concatenate multiple rows within a single row in SQL Server 2008.
Linked Servers in SQL Server6/4/2019 2:04:36 AM. This article helps you to understand the concept of Linked Servers in SQL Server 2008, 2012. I will show with an example, how to connect the two different databases using Linked Servers in SQL Server
Creating and Managing Triggers in SQL Server6/3/2019 6:00:10 AM. In this article you will see how to Create and manage Triggers in SQL Server 2005/2008.
Creating And Managing Stored Procedure In SQL Server 20086/3/2019 4:22:21 AM. In this article you will learn how to Create and Manage Stored Procedure in SQL Server 2008.
SQL Server 2008 R2 SP3 Install Errors8/14/2018 12:47:55 AM. 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,
Fix Corrupt User Profile / Temp Profile in Windows Server 2008/ 20125/25/2017 7:54:35 AM. You will see here how to fix a corrupt user profile or temp profile in Windows Server 2008/2012
How To Make SSIS Package In SQL Server 20087/21/2016 12:38:04 AM. In this article, you will learn how to make SSIS package in SQL Server 2008.
Office automation with VS 20084/13/2016 3:16:43 AM. Outlook automation has become integral part of any LOB application. MS Excel, work, outlook are getting used by most of the enterprise applications today. This article provides quick view on how t
Windows Management Instrumentation (WMI)4/13/2016 3:08:31 AM. 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).
Node.js And AngularJS With SQL Server4/5/2016 1:55:54 AM. This article explains how to use NodeJs and AngularJS with SQL Server.
Deploying Packages In SQL Server Integration Services (SSIS) 20122/1/2016 12:07:20 PM. 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 20141/15/2016 2:14:29 PM. In this article you will learn about restoring the SQL 2008 R2 database to SQL 2014.
SQL Server 2008 Installation Step By Step1/2/2016 11:40:48 AM. In this article we’ll install SQL Server 2008 on our machine step by step.
CRUD Operations In SQL Server 200810/5/2015 2:32:33 AM. In this article l will show you how to make CRUD operations in SQL Server 2008 by using simple SQL queries.
Various Approaches to Find Nth Salary in SQL Server 2008R28/28/2015 3:23:25 PM. This article describes various approaches to find the nth salary in SQL Server 2008R2.
Switch Column Value of a Table Using Cursor in SQL Server 20088/11/2015 3:40:17 PM. 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 20087/27/2015 2:38:10 AM. In this article we will learn about the FileStream in SQL Server 2008.
SQL Server Tips and Tricks6/29/2015 8:20:10 AM. This article provides some tricks we may use in our day-to-day programming life in SQL.
How to Create Database in SQL Server 20085/13/2015 7:31:53 PM. Here you will learn how to create a database in SQL Server 2008.
Create Setup in Visual Studio 20085/13/2015 5:34:44 PM. In this article you will see how to create a setup in Visual Studio 2008.
How to Create a Crystal Report5/13/2015 12:12:12 PM. In this article, we will learn how to create a Crystal Report.
Table Value Parameter in ASP.Net Using SQL Server3/28/2015 5:04:24 PM. 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 R23/25/2015 3:58:12 AM. In this article you will learn how to rebuild a master database in SQL Server.
Table Valued Parameters in SQL 20082/25/2015 11:32:45 AM. 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 R21/23/2015 4:55:53 PM. In this article you will learn about Database Table Encryption using Symmetric Key in SQL Server 2008 R2.
Snapshot Replication (Setting up Publisher) in SQL Server 2008: Part 212/17/2014 9:58:36 PM. In this article you will learn Snapshot Replication (Setting up Publisher) in SQL Server 2008.
Snapshot Replication in SQL Server 2008: Part 112/16/2014 2:26:24 PM. In this article, I will cover Snapshot Replication in SQL Server 2008.
Automated Backup Using SQL Server 200811/20/2014 2:33:46 PM. 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 200811/5/2014 6:13:04 PM. 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.
Upload and Download File Using GridView and SQL Server 20089/30/2014 11:48:33 AM. In this article you will learn how to upload and download any type of file using a GridView and SQL Server 2008.
Differences Among SQL Server 2000, 2005 and 20089/26/2014 9:19:38 AM. This article explains the main differences among SQL Server 2000, 2005 and 2008.
Introduction to Dynamic Data Web Application Model: Part I9/5/2014 5:02:38 AM. This article gives an introduction to Dynamic Data Web Application Template
How to create a COM object using VS 2008 and consume it from VB 6.0 client application: Part II9/4/2014 5:09:03 AM. In this article, we will see how to create a simple COM application in Visual Studio 2008 and how to consume it from a VB6 client application.
Introduction to Unit Testing Framework of VS 2008: Part IV9/4/2014 2:23:25 AM. This article gives an introduction to Code Coverage in VS Team System 2008.
Introduction to Unit Testing Framework of VS 2008 - Part III9/4/2014 2:13:08 AM. This article gives an introduction to creation of Test List and configuration of Test Project of VS 2008 Testing Framework.
Introduction to Unit Testing Framework of VS 2008: Part II9/4/2014 2:09:58 AM. This article gives an introduction to creation and configuration of Ordered Tests of VS 2008 Testing Framework.
Introduction to Unit Testing Framework of VS 20089/4/2014 2:07:58 AM. This article gives an introduction to in-built Unit Testing Framework of Visual Studio 2008.
Coalesce Function in SQL Server 2008 With Limitations8/26/2014 4:09:27 PM. 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 Format8/13/2014 12:42:24 PM. 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 20128/7/2014 1:17:04 PM. 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 20088/5/2014 4:24:28 PM. This article describes how to uninstall a SQL Server instance in SQL Server 2008R2 and 2008.
How to Connect ADO.NET Entity Framework With MVC in Simple Steps8/4/2014 2:36:22 PM. This article shows how to work with MVC and the ADO.NET Entity Framework together.
The Undocumented Sp_MSforeachdb Procedure in SQL Server5/27/2014 3:06:09 PM. This article explains the undocumented sp_MSforeachdb procedure in SQL server.
How To Develop Apps For Hand Held Scanner For Scanning Barcodes: Part 14/30/2014 1:38:17 PM. 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 20084/23/2014 2:48:39 PM. This article describes an undocumented physical row locator function in SQL Server 2008.
Getting Started With Reports in .NET3/26/2014 3:15:38 AM. In this article, you will see how to get started with reports in .NET using Visual Studio 2012.
C# Extension Methods: Explained2/3/2014 7:35:45 AM. The intention of the article is to give an idea of what extension methods are and their benefits.
Installing SQL Server 20081/27/2014 1:25:13 PM. Here, you will see how to install SQL Server 2008.
Create Simple Web Service in Visual Studio 2008 / 2010 /201212/6/2013 9:32:55 PM. This tutorial explains how to create simple Web Services using Visual Studio 2008 or Visual Studio 2012.
Generate Script Of Database in SQL Server 200812/5/2013 7:42:59 PM. 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 200811/3/2013 2:04:27 PM. Dear reader today we will discuss another important and well demanding topic that is replication.
Look at TCP Chimney Offload in Windows Server 200810/7/2013 2:18:59 PM. 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/20109/26/2013 1:39:37 PM. 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.
Dynamic Management Views (DMVs) in SQL Server 2008 R27/29/2013 9:40:03 PM. 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.
Change Data Capture in SQL Server 20087/7/2013 12:09:40 AM. Today I discuss the new features Change Data Capture in SQL Server 2008.
How to Implement Custom Role Provider in VS2008 and VS20107/4/2013 12:09:55 PM.
Limitations of View in SQL Server 20086/29/2013 2:44:30 PM. In this article we will see the view limitation in SQL Server 2008.
Learn SSIS Microsoft SQL Server 2008: Part16/26/2013 1:39:53 AM. This article explains SSIS, a powerful feature of Microsoft SQL server.
Logging Using Log4net in Compact Framework 2.0 in Visual Studio 20086/10/2013 12:27:44 AM. This article will show you how you can use log4net.dll to do logging in a Compact Framework 2.0 application.
Low Cost Infrastructure Design For Biztalk Server 20105/30/2013 12:02:46 PM. This document describes how to set up a low-cost high availability infrastructure for BizTalk Server 2010 in a LAN environment using only 04 server boxes (02 for BizTalk and 02 for SQL Server).
Create a Report in SSRS 20085/20/2013 4:42:14 PM. In this article you will learn how to create a report in SSRS 2008.
Change Tracking in SQL Server 20085/9/2013 10:16:16 AM. This article explains what Change Tracking in SQL Server 2008 is, what its requirements are and how to enable it.
Configure Office Web Apps For SharePoint 2013: Part II2/14/2013 5:26:34 PM. 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.

Topics