Loading
Creating a User-Defined Type Using Visually or Programmatically in SQL Server 2012
Today, I have provided an article showing you how to Creating a user-defined type using visually or programmatically in SQL Server 2012.
How to Add World Map in SQL Server 2012
This article explains how to add world map in SQL Server 2012.
How to Create Shapes in SQL Server 2012
In this article I am going to explain how to create a shape in SQL server 2012.
Deadlock in SQL Server 2012
Today, I have provided an article showing you how to handle deadlock in SQL Server 2012.
Enhanced Execute Keyword in SQL Server 2012
Today, I have provided an article showing you an improved version of the execute keyword in SQL Server 2012.
Insert Multiple Values in Table Using Single Query in SQL Server 2012
Today, I have provided an article showing you how to insert multiple values into a table using a single query in SQL Server 2012.
New Built in Functions in SQL Server 2012 : Conversion Functions
In this article, let us see how to use the 3 new builtin conversion functions of Microsoft SQL Server 2012 Release Candidate 0 with their syntax and sample queries.
Developing and Designing Queries Using Query Designer in SQL Server 2012
Today, I have provided an article showing you how to develop and design queries using the Query Designer in SQL Server 2012.
New Date and Time (Built-in Functions) Functions in SQL Server 2012
Today, I have provided an article showing you how to use the new Date and Time functions in SQL Server.
New Logical Functions in SQL Server 2012
Today, I have provided an article showing you how to utilize the two new logical functions Choose() and IIF() in SQL Server 2012.
User-Defined Sequence Object in SQL Server 2012
Today, I have provided an article showing how to use Sequence Object in SQL Server 2012. In this article we have also covered the difference between sequence and identity.
Move a Database Using Detach and Attach in SQL Server 2012
This article introduces how to Detach and Attach a database in SQL Server 2012 by using SQL Server Management Studio.
Stored Procedures in SQL
Learn how to create and execute SQL Server stored procedures, including passing parameters for SELECT and INSERT operations.
Output keyword in Sql Server 2008
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.
Concept of Exists Condition in SQL Server
Learn how to use EXISTS and NOT EXISTS in SQL Server to filter rows based on matching or nonmatching records in another table.
Using the System Function fn_listextendedproperty of SQL Server 2005 for .NET Applications: Part II
In this article, divided into two parts, I will compare the system function fn_listextendedproperty of SQL Server 2005 with the similar function of SQL Server 2000 ( Part 1 ), describe using the function for .NET applications ( Part 2 ). The examples are written using Transact-SQL and C#.
Using the System Function fn_listextendedproperty of SQL Server 2005 for .NET Applications: Part II
In this article, divided into two parts, I will compare the system function fn_listextendedproperty of SQL Server 2005 with the similar function of SQL Server 2000, describe using the function for .NET applications. The examples are written using Transact-SQL and C#.
Building Managed Code Using Common Language Runtime (CLR) Integration in SQL Server 2005
In this article I am going to talk about a cool new feature of SQL Server 2005 called CLR Integration, its advantages and how to program database objects using managed code with a simple project in Visual Studio 2005 beta 2.
SQLCLR Debugging
In SQL Server 2005, CLR integration allows you to write stored procedures, triggers, user-defined types, and user-defined functions using any .NET Framework language, including Microsoft Visual Basic .NET and Microsoft Visual C#. In this article, I will explain how to debug SQLCLR stored procedure or SQLCLR user-defined function.
SQL Server Reporting Services
This article describes how to modify the team reports generated by VSTS or BI Studio over SQL Server 2005.
SQL Server Reporting Services
SQL Server Reporting Services is a comprehensive, server-based platform for creating, managing, and delivering reports that contain data from relational and multidimensional data sources. This article explains the features that are supported by SQL Server.
Migrating from ASP.NET 1.0/SQL Server 2000 to ASP.NET 2.0/SQL Server 2005
The article provides details of various steps followed by author in upgrading ASP.Net 1.1 application to ASP.Net 2.0 and SQL Server 2000 to SQL Server 2005
Cursors in Database Management Systems
This article is intended to show the principles and uses of cursors in relational database management systems. We’re going to discuss how cursors are implemented in Microsoft SQL Server and Oracle database and how you can use it in your applications.
Understanding Database Stored Procedures
This article discusses basics of stored procedures and how to create, update, and delete stored procedures in a database.
Backup and Recovery in Database Systems
This article is intended to cover one of the most critical responsibilities of database administrators in order to maintain data integrity.
SQL Query Optimization FAQ Part 1 (With video explanation)
In this article we will first try to understand what is a SQL plan, how is it created and then we will move towards understanding how to read the SQL plan. As we read the SQL plan we will try to understand different operators like table scan, index seek scan, clustered scan, RID lookup etc. We will also look in to the best practices associated with clustered and non-clustered indexes and how they function internally. We will practically see how indexed views increase performance and in what scenarios we should use the same.
How to Connect Mysql Server with Asp.net 2005 / 2008 (C#)
Here I will discus in the easiest way to connect your asp.net web application with MYSQL Server and also how you can migrate from Microsoft SQL to MYSQL.
Wildcards in SQL Server 2005
SQL wildcards are used for searching data’s in a database, which were used with LIKE operator.
New Features in SQL Server 2008
Here are some of the new features added to SQL Server 2008.
Enable and Rename SA account in SQL Server 2005/2008
This Article shows How to Enable/Disable sa Account in SQL Server.
