|
|
-
|
|
This paper compares SQL Azure Database with SQL Server in terms of logical administration vs. physical administration, provisioning, Transact-SQL support, data storage, SSIS, along with other features and capabilities. SQL Azure Database is a cloud-based relational database service from Microsoft. ......
|
|
-
|
|
Thursday, July 15, 2010 8:00 AM Pacific Time (US & Canada)
Unless you are dealing with a totally new Microsoft SQL Server installation, the upgrade process is clearly an important part of the installation story. In this webcast, we explain what you need to consider when upgrading to Microsoft SQL......
|
|
-
|
|
In the previous post we looked in How to Execute SQL Query or Store Procedure from SSIS and successfully created a package which execute SQL Query or Procedure on targeted SQL Server with the help of this. In this post we look in How to Load Data from text Files to SQL Server, in daily life several ......
|
|
-
|
|
This article is intended to help the people who are beginners to SSIS. In this article we will see what is SSIS? Why we use SSIS ? and how to create a package using BIDS (Business Intelligence Development Studio). The article describes this through an example which will show us how a SQL Server quer......
|
|
-
|
|
After a long period of time i am again starting blogging and try to keep it continue.I like to start a series of blog post about system store procedures used in SQL Server.To kick this series out i am picking up sp_configure system procedure. Use of sp_configure In simple words sp_configure ......
|
|
-
|
|
Some days back i was asked about Temp Tables and Table Variables the basic difference why one is better than another one and all, and i am not able to provide a satisfactory reason\answer at that time so this is the time when i studied about a lots about it and i go through several topics, it takes ......
|
|
-
|
|
This time its all about a script a backup script.Today early morning i asked to get BackUp details for some of DB’s we have, usually they ask me about the last BackUp taken so its easy for me to tell him. But this time he needs all the history of BackUp’s for some reason.So i know that i......
|
|
-
|
|
Hi All …
You all must here about T-SQL Challenges, these challenges are ideal to learn Set Based Queries using TSql. The most beneficial part of these challenges is that, through these challenges , you get a chance to see better solution to solve a given problem, T-SQL Challenges is mainly ......
|
|
-
|
|
Hi all this post is about the new features in SQL Server 2008 .. SQL Server 2008 has a power full feature called DDL triggers which uses for Auditing changes in database and this is very useful too. You will find a blog entry about auditing using transaction log here and find a example of LOGON ......
|
|
-
|
|
Hi all me again here with a post about Encryption & Decryption in Sql Server 2005.I have received a couple of questions regarding my article Encryption & Decryption in Sql Server 2005 , so i started responding through mail but because i found it really useful so here i decided to post it&hel......
|
|