[Company Logo Image] 

Home Contents Coffee Break Credits Glossary Links Search

 Contents
 

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
SQL Server 2008
SQL Server 2012
Tips
Troubleshooting
Tuning


Analysis Services

bulletHow to create an analysis services cube

Azure

bulletGetting Started with Windows Azure Platform

CLR Integration

bulletEnabling CLR Integration
bulletUsing CLR Integration in SQL Server 2005

High Availability

bulletBest Practices for Clustered Environments
bulletHow many nodes exist in a SQL Server Cluster
bulletHow to set a manual failover using Database Mirroring
bulletLocation of useful log files when troubleshooting SQL Server Cluster
bullet Move Cluster Storage to a New SAN
bulletShared Drives of a SQL Failover Cluster

Performance Tuning and Optimization

bulletEnable the Lock Pages in Memory Option
bulletInformation About Resource Waits
bulletSQL Server Performance Monitor Counters are Missing
bulletSystem Stored Procedure sp_recompile  
bulletTroubleshooting I/O Bottleneck

SQL Server 2008

bullet Backup Compression Feature
bullet How to install SQL Server 2008 (Katmai) - CTP November 2007
bullet How to install SQL Server 2008 Release Candidate 0 (RC 0)
bulletHow to install SQL Server 2008 R2
bullet New Spatial Data Types
bullet Performance Data Collector
bulletPolicy Based Management - Enforcing Recovery Model Full
bullet Preventing Undesired Actions Using Policies
bullet Report Designer Preview
bullet SQL Server 2008 - New Data Types
bullet Transact-SQL Query Editor IntelliSense
bullet Transparent Data Encryption
bulletUpgrading One Edition To Another Edition

SQL Server 2012

bulletFourteen New Transact-SQL Functions and One Improved.
bullet Startup Parameters Tab.
bulletRestore - Timeline.
bulletWhat is LocalDB.

Tips

bulletBack Up the Reporting Services Encryption Key
bulletConfiguring Antivirus for MSSQL servers
bulletCreating a Linked Server to DB2
bullet Database Snapshots
bullet Determining  Server Name using T-SQL
bulletHardware Sizing Microsoft SQL Server
bulletHow to Disable SSL on Reporting Services
bullet How to install SQL Server 2005 SP3
bulletHow to install SQL Server 2008 SP2
bulletInstalling Umbraco CMS with Microsoft SQL Server
bullet Know What Sessions Were Assigned to Each Workload Groups
bulletMicrosoft Atlanta
bulletPorts and Protocols Used by Microsoft SQL Server 2000
bulletPorts and Protocols Used by Microsoft SQL Server 2005
bulletPorts and Protocols used by Microsoft SQL Server 2008
bulletRequired Drive Performance on a Database Server
bulletSpeed Up Insert Performance
bulletUsing Transact-SQL for Full-text Indexing in SQL Server 2005

Troubleshooting

bulletA fatal error occurred while reading the input stream from the network. The session will be terminated
bulletAttach Database Failed
bulletBackup failed for Server
bulletBackup Log is terminating abnormally.
bulletBuffer Cache Hit Ratio Very Low.
bullet BusinessObjects: Connection or SQL sentence error: (DA0005)
bulletCannot access the specified path or file on the server.
bulletCannot Connect to Database Master.
bulletCannot Connect to SQL Azure.
bulletCannot create a linked server to Oracle
bulletCannot create new connection because in manual or distributed transaction mode.
bulletCannot Kill Process with Status Suspended.
bulletCannot Launch Activity Monitor for a SQL SQL Server 2000 Instance
bulletCannot Open User Default Database.
bulletCannot Resolve the Collation Conflict.
bulletCannot show requested dialog (SqlMgmt)
bullet Cannot Start SQL Server Agent Service
bulletClass Not Registered (Microsoft.SqlServer.SqlTools.VSIntegration).
bullet Computer does not meet the minimum requirements.
bulletCould not connect because the Maximun Number of 1 DAC Already Exists
bulletCould not connect to the report server.
bulletCreate Database Permission Denied.
bulletDatabase <databasename> exists but it is unaccessible.
bulletDetach Database Failed for Server. (Microsoft.SqlServer.Smo)
bulletError 15457 Severity 0 State 1.
bulletError 29503 Installing SQL Server 2005.
bulletError 3205 Too Many Backup Devices Specified.
bulletError 51005: The row was not inserted in the alarm_history table.
bulletError Code is 2337.
bulletError Creating a New Job
bulletError has occurred while opening database 'DBName'.
bulletError Installing SCOM 2007 Database.
bulletError MsInstaller EventId 11706
bulletError on Data Protector Manager.
bulletError Registering Laserfiche Repository.
bulletError Reverting a Database to a DB Snapshot.
bulletEvaluation Period Has Expired.
bulletException thrown while executing SQL script.
bulletExit Message InstanceDir
bulletFailed to Create Configuration Database
bulletHow to rebuild system databases in SQL Server 2005
bulletHuge SQLAGENT.OUT log file.
bulletIndex Corruption.
bulletINSERT failed because the following SET options have incorrect settings.
bulletInvalid attempt to GetBytes on column.
bulletInvalid Input Trace File.
bulletInvalid Operations Manager Database Version.
bulletjTDS Exception Connection Refused.
bulletjTDS Exception - Connection Timed Out.
bulletKB955706 failed to install
bulletLocalDB not supported on this OS.
bulletLogin Failed for User
bulletLogin Failed for User Error 18452
bulletMS DTC was unable to start
bulletMsg 6522, Level 16, State 1, Line 3  ... Aggregate 'geometry'
bullet Msg 6522, Level 16, State 1, Line 3  ... Aggregate 'geometry' (2)
bulletMsg 7411 Linked Server
bulletMSSQLServerADHelper Event Id 100
bullet MSSQLSERVER Event ID 3041
bulletNo Features Selected for Upgrade
bullet ODBC Error Installing VMware vSphere.
bulletORA-00904 Invalid Identifier.
bulletORA-12545 Connection failed because target host or object does not exist.
bulletORA-12704 character set mismatch.
bulletPerflib. Event Id: 1023.
bulletPermissions needed to create new DB account.
bulletProperty IsLocked is not available for login
bulletProperty Owner is not available for Database.
bulletPurge job history failed for JobServer
bulletReplica is inconsistent.
bulletReporting Services Catalog Error
bulletRestart Computer Failed
bullet Restore failed for Server
bulletRule Windows PowerShell Failed
bulletSaving Changes Is Not Permitted
bulletSQLBrowser Event Id 3
bulletSQL Server 2008 setup requires .NET Framework
bulletSQL Common Language Runtime is not enabled on the server.
bulletSQL Server Express 4 GB Limit
bulletSQL Server Resource Group Failed
bulletSQL Server security mode.
bulletSQL Server Setup cannot install files
bulletSSPI handshake failed
bulletStarting Up Database
bullet Subscriber does not satisfy version compatibility
bullet Successful Installation SP3 not Applied on Server
bullet TF254027: You must correct all errors.
bulletThe conversion of a varchar data type to a datetime data type resulted in an out-of-range value
bulletThe Media Family on Device is Incorrectly Formed
bulletThe Operating System Returned Error 21
bulletThe SQLBrowser service was unable to establish Analysis Services discovery
bulletThe Transaction Manager is not available
bullet This Recordset Is Not Updatable.
bulletUnspecified Error
bulletWarning Server Agents Event Id 1123.
bulletWarning SQLSERVERAGENT Event ID 208
bulletWarning SysmonLog Event ID 2059.
 

 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.