|
|
-
|
|
In the previous post we saw that how to Load data from Text files to SQL Server Tables and successfully created a package which loads data in to SQL Server table from a flat file. In this post today we will see SSIS File Operations – Copy File, Move File, Rename File and Delete File. Several times w......
|
|
-
|
|
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 ......
|
|
-
|
|
The recommendations in this white paper provide best practices for processing in Microsoft® SQL Server™ 2005 Analysis Services. These performance optimizations are based on real-world implementations with some of our top customers and partners who use SQL Server 2005 Analysis Services Enterprise Edi......
|
|
-
|
|
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. ......
|
|
-
|
|
<p>With the introduction of transparent data encryption (TDE) in SQL Server 2008, users now have the choice between cell-level encryption as in SQL Server 2005, full database-level encryption by using TDE, or the file-level encryption options provided by Windows. TDE is the optimal choice for bulk e......
|
|
-
|
|
This white paper describes how application developers can apply query and processing performance-tuning techniques to their SQL Server 2008 Analysis Services OLAP solutions.
Because Microsoft SQL Server Analysis Services query and processing performance tuning is a fairly broad subject, this whit......
|
|
-
|
|
Using Kerberos authentication in a SQL Server 2008 Reporting Services service environment provides a mechanism for mutual authentication between client and server before a secure network connection is established. This article describes how to configure and troubleshoot a Reporting Services service ......
|
|
-
|
|
This document focuses on the technical concepts and techniques we used to implement reports with SQL Server 2008 Reporting Services, using an Analysis Services cube as the data source. Providing strong customer service has helped this customer become the largest commercial bank in Thailand. Always ......
|
|