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. Thanks, James Shropshire MCDBA, MCITP SQL Server

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 [...]

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 [...]

Many Database Administrators are aghast when they discover that SQL Server 2005 and above have a default trace that runs 24 hours a day, 7 days a week. Most of us are taught early on in our careers that extended tracing is something that should only occur on rare occasions. Before you rush out and [...]

In order to resolve this issue use the following steps: Ad hoc access to OLE DB provider ‘Microsoft.ACE.OLEDB.12.0′ has been denied. You must access this provider through a linked server. Run the Following T-SQL USE [master] GO EXEC master . dbo. sp_MSset_oledb_prop N’Microsoft.ACE.OLEDB.12.0′ , N’AllowInProcess’ , 1 GO EXEC master . dbo. sp_MSset_oledb_prop N’Microsoft.ACE.OLEDB.12.0′ , [...]

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: Row Count The row count was used to validate the number of records Conditional Split Was used to split out rows with a specific Header value. In this case [...]

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 [...]

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: Trim your data Buy new disks Truncate your data (Yeah right!!) For most organizations these are truly not options at all. With the release of [...]