- 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”
Monthly Archives: November 2010
Column aliases are great because you can make seemingly meaningless column names become more readable and also obfuscate the underlying database structure. They are not mandatory but did you know this… An alias can result in a logical error A … Continue reading
A client of mine had some data in a single table but wanted it split in to different identical tables based on some data type. This is a common problem often fixed with the use of dynamic sql. Basically his … Continue reading
If you start sql server 2008 R2 and open or create a job step then save it then try to open any job step in any job then you will get an error. It looks like this. This is a … Continue reading
If you are regularly using a check on the sysprocesses table to see what is slowing down your sql server, looking for that usual culprit in middle management who absolutely must have access to the database despite the fact that … Continue reading
Altering the type of a column in SQL Server I regularly come across this problem due to changing specifications. If you create a database for a development team then you will come across this issue. Here’s the sequence. • Creates … Continue reading