Introduction
In SQL Server Programming, we have been using Date & Time in many situations.In SQL Server 2008 the DATETIME function’s major changes is the four DATETIME data types introduced. They are DATE, TIME, DATETIMEOFFSET and DATETIME2. In this article we shall discuss about these functions in details with appropriate examples
DATE Data Type
In SQL Server [...]
Continue reading about SQL Server 2008 New DATETIME Data Types
We are in thought of only DBA’s can take backup using T-SQL, But anyone can take backup and restore backup very easily with the help of T-SQL. we can backup an entire database, transaction log, or one or more file or filegroups with the help of T-SQL.
Continue reading about Backup SQL Server database using T-SQL
‘Oraload’ is a bulk data load utility which is used to load multiple database tables with data files, with a high performance.This is a highly customizable piece of code, written in C++ using Oracle utilities, which can process 3 kinds of files mainly:
Flat files with bulk data separated by a delimiter
Files containing multiple [...]
Continue reading about ORALOAD Oracle Utility for Bulk Data Load
This article explains the step by step troubleshooting methodology for correcting the error “The report server is not responding. Verify that the report server is running and can be accessed from this computer” that occurs in SQL Server Reporting Services (SSRS 2005). SQL Server 2005 Reporting Services (SSRS 2005) allows creation of reports which can be deployed to Report Server. Configuration is required for Report Server.This article provides a stepwise procedure to configure SSRS 2005 using SQL Server Configuration Manager.
Continue reading about Troubleshooting SSRS Error “The report server is not responding”
In this article we can see URL Mapping feature that is newly Introduced in ASP.Net 2.0. Search Engine Friendly URLs can be made for ASP.Net Pages using URL Mapping Feature in ASP.Net 2.0
Introduction to URL Mapping
In practical scenario there are many cases where URL content plays big role. Take a look.
URL of [...]
Continue reading about Search Engine Friendly URL (URL Mapping) in ASP.Net 2.0
Once you are started using SQL Server database for your application, you need to start taking database backups regularly. If it may be a development database or production database, you should take backups in a timely manner. Because if your information get loss, that brings you in loss. We cannot prevent the data loss due to disk failure, file corruption, code bugs, external factors, etc.
The best practice is to take database backup and store it in an external media like tape drive and keep it in a safe place. The easiest way to take database backup is by using SQL Server Management Studio (SSMS).
Continue reading about Backup SQL Server Database using SSMS
Microsoft® SQL Server® 2008 is a database platform for large-scale online transaction processing (OLTP), data warehousing, and e-commerce applications; it is also a business intelligence platform for data integration, analysis, and reporting solutions.
Microsoft® SQL Server® 2008 provides a trusted, productive, and intelligent data platform that enables you to run your most demanding mission-critical applications, [...]
Continue reading about An Introduction to Microsoft SQL Server 2008 – Part 1
This article will completely guide you to clear the sql query cache in sql server. Consider you are running the same query one or more times in a row, the execution time may differ time to time. If your are only user on the database, then it is because of build in query cache.
In this tutorial we shall see how to implement Microsoft SQL Server 2005 Encryption Techniques. Microsoft SQL Server 2005 Encryption are a good way to encrypt sensitive and confidential fields such as passport number, credit card number, phone numbers, and other user information.
Many applications require security of important data in today’s fiercely completive business [...]
Continue reading about Encryption and Decryption in SQL Server 2005
Following are the steps to be followed to create a SQL Server Analysis Services (SSAS) Project in Microsoft SQL Server 2005 Business Intelligence Development Studio. Please follow the step by step instructions given in the tutorial to create SQL Server Analysis Services (SSAS) Project.
Continue reading about Step by Step : SQL Server 2005 Analysis Services (SSAS) Project
