|
|
|
|
|
Total Hits: 15 | Today: 0
|
Author: Mohamed Abdelghani
|
Rating:
|
|
SQL Server Reporting Services (SSRS) is a very powerful tool for generating reports and one of the important features in SSRS is adding custom code and custom assemblies to it to add more functionality to your reports.I will work with SSRS 2005 , First I will add custom code to a sample report .Please note that you can only use VB.Net in adding embedded code for your reports. I will work with Visual Studio.Net 2005 ,so let’s start and open it and create a new Report Server Project from Business ...
|
|
|
|
Total Hits: 10 | Today: 0
|
Author: Ray Barley
|
Rating:
|
|
We have heard about running SQL Server Reporting Services in SharePoint Integrated Mode but are not really sure how to go about configuring this. Can you provide the details on what capabilities this provides as well as how to do it? Probably the biggest benefit of running Reporting Services in SharePoint Integrated Mode is that you can deploy and manage reports directly in SharePoint rather than the Report Manager web application. This is probably easier for our business users. As a matter o...
|
|
|
|
Total Hits: 11 | Today: 0
|
Author: Tim Ford
|
Rating:
|
|
I have a column in one of my Microsoft SQL Server 2005 databases that store date and time data relating to date of birth. I'm only interested in the date of birth, not time of day, yet the data in this field stores both date and time. There are only two options for storing this data: either datetime or smalldatetime. No matter which one I use I end up with time information when I query the database table. I've heard that SQL Server 2008 offers more options for storing date and time values. ...
|
|
|
|
Total Hits: 11 | Today: 1
|
Author: Edwin Sarmiento
|
Rating:
|
|
In a previous tip on Disaster Recovery Procedures in SQL Server 2005 Part 1, we have seen how we can come up with a disaster recovery procedure in SQL Server 2005. There are other ways to increase availability of your highly critical database in SQL Server 2005. What are those other options? To continue the series on disaster recovery scenarios in SQL Server 2005, let us look at another means to increase the availability of your highly critical databases. Isolating critical objects gives you the...
|
|
|
|
Total Hits: 10 | Today: 1
|
Author: Abhijit Jana
|
Rating:
|
|
For Distributed database application environment its always required to Synchronize different database server , backing up, copying Transactions Logs etc . If we are going to implement using application we have to put lots of efforts to build up the application. SQL Server 2005 provide a advance features called Log Shipping. Log shipping is a Automated Process for backing up, restoring , copying the transaction logs and synchronize the database for distributed database server application. Which ...
|
|
|
|
Total Hits: 10 | Today: 1
|
Author: Narayana Vyas Kondreddi
|
Rating:
|
|
Have you ever been asked to copy or clone the database permissions of one user to another database user? Or how about creating a new database role based on an existing database role? Basically, there isn't a direct command or interface for duplicating the permissions of a user or database role. One way of doing this would be to generate scripts for all objects within the database using SQL Server Enterprise Manager (SQL EM) or SQL Server Management Studio (SSMS), and then manually extract all th...
|
|
|
|
Total Hits: 18 | Today: 0
|
Author: Ashish Kumar Mehta
|
Rating:
|
|
SQL Server 2008 introduces a new feature called Table Valued Parameters. In the earlier versions of SQL Server it was not possible to pass a table variable as a parameter to a stored procedure or a function. However, in SQL Server 2008 it is now possible to pass multiple rows to SQL Server in one go by storing the values in a table variable and later passing it to a stored procedure or a function as a READONLY input parameter. This is one of the greatest performance improvements when handling la...
|
|
|
|
Total Hits: 8 | Today: 0
|
Author: Ashish Kumar Mehta
|
Rating:
|
|
SQL Server 2008 introduces a new feature called Filtered Index. A Filtered Index is an optimized form of non clustered index. It is basically useful to cover those queries which return a small percentage of data from a well defined subset of data within a table. In the earlier versions of SQL Server, Developers and Database Administrators have always faced performance issues when dealing with large amount of data in the tables. In order to get the best performance for your queries in the previo...
|
|
|
|
Total Hits: 7 | Today: 0
|
Author: Ashish Kumar Mehta
|
Rating:
|
|
SQL Server 2008 provides two types of compression namely, Database Backup Compression and Data Compression. We have already discussed the Database Backup Compression feature in my article titled How to configure and Use Database Backup Compression in SQL Server 2008. Data Compression was first introduced in SQL Server 2005 with Service Pack 2 where Microsoft introduced a new storage format called vardecimal to store decimal and numeric data types as variable length columns. In SQL Server 2008 th...
|
|
|
|
Total Hits: 6 | Today: 0
|
Author: Ashish Kumar Mehta
|
Rating:
|
|
SQL Server 2008 introduces the MERGE statement which will allow users to perform insert, update and delete operations in a single statement. In the earlier versions of SQL Server to achieve the same functionality the database developer or database administrator needed to write separate statements to perform the insert, update or delete of data in one table based on certain conditions in another table....
|
|
|
|
Total Hits: 12 | Today: 0
|
Author: Scott Mitchell
|
Rating:
|
|
In August 2008 Microsoft released the latest version of the database server software, SQL Server 2008. SQL Server 2008 includes a number of new features not found in SQL Server 2005, including: a terser T-SQL syntax; the new MERGE statement; new data types and functions; enhanced encryption and XML support. In previous versions, SQL Server had only two date-related data types: datetime and smalldatetime, both of which allow date and time values (the difference being that datetime allows for a la...
|
|
|
|
Total Hits: 10 | Today: 0
|
Author: William R. Vaughn
|
Rating:
|
|
After the nine-hour download of the real SQL Server 2008 RTM from MSDN completed, I began the task of getting it installed on my new development system. It's an Intel Quad Core Duo with (only) 4GB of RAM, so you'll get an idea about how fast it is in comparison to yours when I start talking about timings. I was initially surprised to find that the setup paradigm you've grown accustomed to in SQL Server 2000 and 2005 has been replaced (again). It's too early to pass judgment, but I can say that i...
|
|
|
|
|
|
