- SSAS / Excel 2010 – An error was encountered in the transport layer
- The SQL Server instance specified in SSIS service configuration is not present or is not available
- Attaching the Script debugger to process ‘ iexplore.exe’ on machine ” failed. A debugger is already attached.
- SharePoint startup time very slow
- Windows Server 2008 R2 – Full or Server Core
- Sharepoint database connection string – what is it?
- SSAS: Excel Data Connection Wizard missing cube(s)
- Excel Error: There was a problem sending the command to the program
- SSIS 2008 and SSIS 2008 R2 are the same (or are they?)
- Viewing cubes when upgrading to SQL Server 2012
- Extraction from INFORMIX database using SSIS (Data warehouse ETL)
- A user name and password are being requested by http://localhost:8080. The site says: “XDB”
- IsNull versus COALESCE
- Cannot connect to SQL Server from remote machine?
- Reporting Services 2008 R2 running on local machine
- Which DMV should I use?
- SQL Server Disaster Recovery
- Missing indexes = poor performance
- Troubleshooting: string or binary data would be truncated
- SSIS export to Excel – Data type issue – “Number Stored as Text”
Category Archives: Uncategorized
Is the Amazon Kindle any good. Should you buy one of the relatively cheap items or should you buy a Sony reader or an iPad or just use your computer? Continue reading
Copy large amounts of data in the background without locks Continue reading
How to find out the number of rows in each file group in a sql server partitioned database Continue reading
Backup compression is now available in all versions of SQL Server 2008 and was only in enterprise in 2005 but is it any good? Continue reading
Database owner has total rights on a database. Who owns your databases and do they work for you? Continue reading
When installing a new SQL Server with SQL Agent, the default history for the agent is 1000 total items and 100 items per job. Is this adequate? Continue reading
Dont use default memory configuration on SQL 2008. Use sp_configure ‘max server memory (MB)’ to set a realistic maximum. Continue reading