In this quick presentation I’ll demonstrate how you can use a SSIS package in SQL Server 2008 to loop through multiple files of a certain type in order to load data into your database.
Continue reading Looping Through Multiple Files Using SSIS
Transactional replication can sometimes be a tricky high availability option to work with. Many companies are now using it more and more to offload reporting to a different server. But as we know, making schema changes to the tables in a publication is something that must be done when the application changes or different business needs must be met. The situation I have been running into more often is when one or more columns in a table need to be changed and the article needs to be updated. If it is a small publication, the change is usually done by deleting the subscription, removing the article from the publication, updating the article, re-adding the article, re-adding the subscription and reinitializing the subscription. But what happens when reintialization takes a long time to complete? Sometimes we do not have the time to follow the previous method.
Continue reading Reinitializing a Single Article in a Publication
For any SQL Server DBA who has been in the game longer than the advent of SQL Server 2005, there was one standard place to turn when you wanted to tune your database. You would turn to the profiler! If you had some experience with this, and had been burned by getting too small of a sample of throughput, you knew that you needed to run it for enough time to get a true sample of what your server was doing. You needed to get a true sample of both reads and writes so that you wouldn’t be skewed one way or the other when deciding how many indexes would be ideal.
Continue reading Finding Tuning Improvement Opportunities: The Trace or the DMVs?
Here is a way to create an SSIS that audits the transfer of data each step of the way. The main transformations used for this are:
Continue reading ETL Design for Missing Data
Recently I ran into an issue where I had a SQL Server instance that needed to have a database restored on it. A pretty simple task, right? Well, it turns out that I did not have rights on the system to do the restore. My client did not have a system administrator password and did not have a user which we could use to grant us the necessary access. But, I did have local system administrator privileges on the server. As long as we have local admin rights on the server we can get the necessary privileges from SQL Server.
Continue reading Recovering System Administrator Privileges
As a DBA who services numerous customers and clients, an issue that crops up relatively often is the need for more disk space. As an organization you do have options:
Continue reading Backup Compression in SQL Server 2008
Our blog has received a 7.8 out of 10 “Very Good” rating from the editors at Blogged. The Editor reviews are provided by professional editors who evaluate a blog based on: Frequency of Updates, Relevance of Content, Site Design and Writing Style.
Continue reading Remote DBA Experts’ Blog Receives High Rating
You got the job because you’re a quick learner, have the ability to understand complex systems, and most importantly, you can troubleshoot. However you became an Oracle Apps DBA, you’re one now, so the fun starts. I started this blog to assist young Oracle Apps DBA professionals who might need a little more detail in their solutions and good discussion into basic, fundamental Oracle architecture and other Oracle App subjects.
Continue reading Haven for the Young, and Super-Fabulous, Oracle Apps DBA Professional