SQL Server 2005 has a lot of features and sometimes these additions are overlooked as a new way of configuring and managing your SQL Server environment.
One of these features is Peer to Peer transactional replication. In the past, people have used transactional replication for load balancing, to keep a read only version for reporting purposes or possibly for a failover solution. Continue reading Peer to peer replication in SQL Server 2005→
You have a transactional replication configured in your production environment with multiple subscribers. The business team has requested that one of the subscriptions be reinitialized, because they think there is some missing data. In this tip we look at the different options that you can use to reinitialize a subscription for transactional replication.
Solution
If we come across this requirement there are different ways by which we could achieve this. In this tip, we will accomplish this by using SQL Server Management Studio (SSMS) and Replication Monitor. Note, both options assume transactional replication is already configured in your server. Continue reading Reinitialize subscriptions in SQL Server replication→
You need to implement a high availability solution for one of your SQL Server databases, but you’re not sure of which option to implement to satisfy your company’s needs. Check out this tip to learn about the five native SQL Server High Availability options:
You have a data set about durations that you want to plot it in a graph. You need to display the minimum, maximum, average and other statistical information in a convenient way.
How can you do this using SQL Server Reporting Services (SSRS)?
While working on different database projects I usually find it very necessary to perform a data sizing exercise on all tables focusing mostly on the number of rows in order to determine a growth factor of each table. This kind of information is useful in performing long term planning of growth and scalability of the data that we are managing.
Out of an exercise like this one we can also determine future needs for data archiving.