Blackberry Got Something Right Years Ago
Having switched from blackberry to iPhone, the one thing I can say I miss dearly is the concept of being docked. Blackberry clearly understood that when you were at your desk, you did not need to check your phone for
Blackberry Got Something Right Years Ago
Having switched from blackberry to iPhone, the one thing I can say I miss dearly is the concept of being docked. Blackberry clearly understood that when you were at your desk, you did not need to check your phone for
SSRS Identifying Reports to Tune – Top 10 Offenders
To discover reports which are candidates for tuning I use the following query to identify the reports which take the longest time to perform their data retrieval tasks. The query I use is DECLARE @ReportPath VARCHAR(MAX) SET @ReportPath = ‘%’
SSRS Identifying Reports to Tune – Top 10 Offenders
To discover reports which are candidates for tuning I use the following query to identify the reports which take the longest time to perform their data retrieval tasks. The query I use is DECLARE @ReportPath VARCHAR(MAX) SET @ReportPath = ‘%’
SSIS 2005 Description: Connect to SSIS Service on machine failed: Library not registered. Could not load package because of error 0xC00160AA.
After Applying Service Pack 4 to SQL Server 2005, I was unable to connect to SSIS from Management Studio. I was also unable to run packages from the command line using DTEXEC. Upon further investigation it see c:\windows\system32\regsvr32 “C:\Program Files\Microsoft
SSIS 2005 Description: Connect to SSIS Service on machine failed: Library not registered. Could not load package because of error 0xC00160AA.
After Applying Service Pack 4 to SQL Server 2005, I was unable to connect to SSIS from Management Studio. I was also unable to run packages from the command line using DTEXEC. Upon further investigation it see c:\windows\system32\regsvr32 “C:\Program Files\Microsoft
Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0×80004005
Check if the RetainSameConnection Option is set to true or false for your Database Connection. I was attempting to Update data by using a Data Flow Transformation OLE DB Source –> OLE DB Command When the RetainSameConnection was set to
Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0×80004005
Check if the RetainSameConnection Option is set to true or false for your Database Connection. I was attempting to Update data by using a Data Flow Transformation OLE DB Source –> OLE DB Command When the RetainSameConnection was set to
ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
Did you create a DSN, but your application cannot access the DSN? I created a DSN, but could not connect via SSIS. It seems that the DSN I created was 64-bit, while the application I was using (SSIS) could only
ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
Did you create a DSN, but your application cannot access the DSN? I created a DSN, but could not connect via SSIS. It seems that the DSN I created was 64-bit, while the application I was using (SSIS) could only
restore database and automatically drop database snapshot transact sql
To facilitate quick testing of changes on my development and test environments I leverage database snapshots greatly. The benefit of snapshots is that I can revert data to its previous state without having testers wait 30 – 40 minutes to
restore database and automatically drop database snapshot transact sql
To facilitate quick testing of changes on my development and test environments I leverage database snapshots greatly. The benefit of snapshots is that I can revert data to its previous state without having testers wait 30 – 40 minutes to
how to find stored procedures in sql server 2008 or sql server 2005 across all databases
As much as I hate searching for objects or not having complete information to troubleshoot an issue sometimes I have to go search for a stored procedure / function in a database server. To find which database contains a stored
how to find stored procedures in sql server 2008 or sql server 2005 across all databases
As much as I hate searching for objects or not having complete information to troubleshoot an issue sometimes I have to go search for a stored procedure / function in a database server. To find which database contains a stored