DevSocial Articles · SQL Server articles

1801. 

      Bulk DML With SQL Server 2005 - XML Data Type

      This article explains about doing bulk DML on SQL Server 2005 using XML datatype

      Sridhar SubramanianMay 20, 201221,8831,000
1802. 

      Import Data from SQL Server 2005 to Excel Sheet and Viceversa

      This Article Shows How to Use SQL Server to Export Data from SQL Server to Excel Sheets and Viceversa.

      SSrinivasMay 20, 201242,2371,000
1803. 

      7 Simple Steps to Connect SQL Server Using WCF from SilverLight

      In this article we will look how we can do database operations using SilverLight. We will first try to understand why we cannot call ADO.NET directly from a silverlight application and then we will browse through 7 steps which we need to follow to do database operation from silverlight.

      ShivprasadMay 20, 201222,4341,000
1804. 

      Using Table Variables Instead of Temporary Tables in SQL Server

      This article demonstrates how to use Table variables in SQL Server instead of temporary tables.

      Karthika PalaniswamyMay 20, 201220,5851,000
1805. 

      Working with SQL Server Logins

      Learn how to work with logins in SQL Server programmatically and via SQL Server Management Studio.

      Mohammad ElsheimyMay 20, 201226,4951,000
1806. 

      Storing Bulk TCP Dump File into SQL Server 2005

      In this article I will explain all steps needed to load tcp dump file into SQL Server 2005.

      May 20, 201212,7901,000
1807. 

      Running the SQL Script File By Using The System.Diagnostics.Process Class

      Process Class Provides access to local and remote processes and enables you to start and stop local system processes.

      MRMadhu ReddyMay 20, 201233,0031,000
1808. 

      How to Add Product to The Basket in Commerce Server 2009

      In this article I will explain the detailed steps to add the product to the user's basket or basket of the anonymous user.

      Prasham SabadraMay 20, 201218,5271,000
1809. 

      SQL Optimization Tips

      This article lists some of the optimization tips for SQL Server development.

      Amit ChoudharyMay 20, 201224,3591,000
1810. 

      Using Report Service and Server Business Intelligence Development

      This article will show steps for using report service and Server Business Intelligence Development.

      Keyur ChauhanMay 20, 201225,6211,000
1811. 

      Publishing Your Database in SQL Server

      Let's see how we can publish our database in SQL Server.

      Venkatesan JayakanthamMay 20, 201211,3891,000
1812. 

      Read Log file in SQL Server

      In this article we will see how to read log file in SQL Server and extract information from it.

      Venkatesan JayakanthamMay 20, 201230,4221,000
1813. 

      Remove Duplicate Records in SQL Server 2005

      In this article you will learn how to Remove duplicate records in SQL Server 2005.

      SSSrividhya SridharMay 20, 201227,6021,000
1814. 

      SQL Profiler InputBuffer Events in SQL Server

      In this article we will see how to find the last execution command of your user in SQL Server.

      Venkatesan JayakanthamMay 20, 201214,1631,000
1815. 

      Dynamic Archiving of Tables and Data in MS SQL Server

      It is a common and business requirement to backup the data. The archiving is part of back ups and most of the applications and system will be following some procedure to archive the data.

      Jayachandran KMay 20, 201243,7611,000
1816. 

      Memory Handling on NULL Values Using Sparse Columns

      Sparse columns is a new feature in SQL Server 2008. Thr feature enables us to store null values effectively. Ideally, if the column is NULL, then the data won't be stored in the database and it's cost effective solution to save the space. If your table has more Null values, we can use this solution.

      Venkatesan JayakanthamMay 20, 201214,3691,000
1817. 

      Scheduling SSIS Package Using SQL Server Agent

      This article shows how to schedule a SSIS package using SQL Server Agent.

      Rajeev KumarMay 20, 201237,6251,000
1818. 

      How to Send Email Using Send Mail Task of SSIS

      In this article we will see how to send email using Send Mail Task of SSIS

      Rajeev KumarMay 20, 2012272,9631,000
1819. 

      SQL SERVER - Denali

      In this article we are going to look into the most awaited cool features called Sequence Number generation.

      Manikavelu VelayuthamMay 20, 20129,5331,000
1820. 

      SQL Server Integration Services (SSIS) - Folder Structure in SSIS

      In this article I shall describe the folder structure used in deploying the SSIS package and the usage of those folders.

      Karthikeyan AnbarasanMay 20, 201222,0261,000
1821. 

      How to Create Script for the Database Objects in SQL server 2008

      In this article you will learn how to create script for the Database objects in SQL server 2008.

      ShankeyMay 20, 201242,8901,000
1822. 

      Automatic History Using Triggers

      Here I will explain a problem I am facing in Automatic History using Triggers.

      Jean PaulMay 20, 201227,7421,000
1823. 

      Creating a Simple ASP.NET CRUD Application Using SQL CE 4 and Entity Framework Code First.

      Here you will see ASP.NET CRUD application using SQL CE 4 and Entity Framework Code First.

      Dom MillarMay 20, 201225,0051,000
1824. 

      Connection Strings for SQL Server 2005

      SQL Server 2005 includes native support for managing XML data, in addition to relational data. It introduced MARS (Multiple Active Result Sets), a method of allowing usage of database connections for multiple purposes. It also introduced data mirroring and DMVs (Dynamic Management Views).

      Nipun TomarMay 20, 201257,3361,000
1825. 

      Connection Strings for SQL Server 2008

      Learn SQL Server 2008 connection string formats for SqlConnection, OLE DB, ODBC, SQL Server Express, integrated security, mirroring, and Multiple Active Result Sets.

      Nipun TomarMay 20, 2012160,0641,000
1826. 

      How will You Get Benefits from The Newest Easy to Get SQL Server Expert Accreditation

      In this article you get benefits from the newest easy to get SQL server expert accreditation.

      MRMichele RouseMay 20, 20128,2901,000
1827. 

      Get Recursive Record from Table in Sql Server

      I am going to tell you, how to get recursive data from table in sql server.

      Blocked AccountMay 20, 201216,1341,000
1828. 

      How to Convert Excel Data to a Table in SQL Server 2005

      This article is about converting Excel data to a table. In this example I am using Ms SQL Server 2005 as the database. You can use any database by changing the connection string.

      Sudhir KumarMay 20, 201224,3131,000
1829. 

      SQL Server 2008 Recovery Models

      SQL Server is a database management system that includes several data management and analysis technologies. It includes better compression features, which also helps in improving scalability and enhancing the indexing algorithms and introduce the notion of filtered indexes.

      Nipun TomarMay 20, 201222,9991,000
1830. 

      Form Based Authentication in MOSS2010 Against SQL Server Database

      Here you will see Form Based Authentication in MOSS2010 Against SQL Server Database.

      Ravishankar SinghMay 20, 201210,2441,000

Everything on SQL Server, not only its articles: the SQL Server page →