Browse by Tags

SQL Server SSIS packages metadata solution pack

Published 14 April 8 3:1 AM | SSQA.net

Do you have hundreds of SSIS packages to manage? Do they run at various times to address the ETL solutions within your environment? Let's say you have to modify the base table columns, so you need to consider what kind of impact this change would...

Filed under: sql server, ssis, solution, download, report builder, etl, metadata, packages

SQL Server Audit Trace - things you need to take care!

Published 6 March 8 3:17 AM | SSQA.net

Audit trace is very helpful when you want to monitor a particular processes on your SQL Server, even for the successful logins and recent users activity on the databsaes. But the default trace would have many columns with the information and you need...

Filed under: SOX, sql server, microsoft, solution, dmv, trace, audit, tsql, trace flag, c2

Get smart with BI solutions

Published 15 June 7 3:33 PM | SSQA.net

I don't mean to say physically, but managing and mastering your data . THE ROLE OF DATA WAREHOUSING IN BI STRATEGIES We know all to well that information is King. But simply managing that data is not enough. During this on-demand program our experts...

Filed under: sql server, bi, solution

Database mail issues with maintenance plans & scheduled jobs

Published 30 April 7 9:40 AM | SqlServer-QA.net (SSQA)

Database Mail Fails For SQL Server Agent Jobs / Maintenace plans - Why ? As you are aware Database Maintenance plans are better in SQL 2005 and more better now after Service Pack 2 release with a cumulative hotfix release. Still there are few problems...

Filed under: sql server, ssms, maintenance plan, solution, database, mail