Category: Articles
-
Transparent Data Encryption (TDE)
Introduction Securing each part and datas in a database is now an important task for DBAs to accomplish else the datas might be hacked. Keeping in mind Microsoft has started encryption features from SQL 2005 and its greatly improved its feature in SQL Server 2008. Lets recall the encryption features in previous versions of SQL…
-
Configuring SQL Server Reporting Services
In my previous article we have covered installing reporting service. The next step in reporting service is to configure them according to your environment. There are many options are available in reporting service configuration. You need to configure all these values with respect to your environment. There are two ways to configure reporting service a.)…
-
Installing SQL Server Reporting Service
Microsoft SQL Server Reporting Services enables organizations to transform valuable enterprise data into shared information for insightful, timely decisions at a lower total cost of ownership. In this article Im going to install SQL Server 2005 Reporting Services on Windows 2003 machine. Lets discuss about installation of reporting services.
-
SQL Server 2005 Full Text Search
We had a requirement where the user had to do a search on Overview/description field which had nvarchar (max) data type. Full text search can be used for searching against the LOB data types like nvarchar (max), text and BLOB data types like varbinary (max) and image data type. Please note that in image and…
-
SQL 2005 Transaction Replication
I have an existing publication with 10 articles configured for Transactional replication. The replication is running fine. Now I wish to add another table (article) to this publication. My requirement is to ensure that I dont need to generate a snapshot of all the articles being published, if I add a single article only that…