[Company Logo Image] 

Home Contents Coffee Break Credits Glossary Links Search

 Contents
 

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
SQL Server 2008
SQL Server 2012
SQL Server 2014
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

Open Source

bulletHow to Query a SQL Server Database from Linux
bulletHow to Query a SQL Server Database from PHP.

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
bulletThree DMVs that arrived with SQL Server 2008 R2 SP1
bullet Transact-SQL Query Editor IntelliSense
bullet Transparent Data Encryption
bulletUpgrading One Edition To Another Edition

SQL Server 2012

bullet3 New Spatial Shapes.
bulletConsider Windows Server 2012 for SQL Server installations.
bulletContained Databases in SQL Server 2012.
bulletExpired Evaluation Edition / Product Key Change.
bulletFourteen New Transact-SQL Functions and One Improved.
bulletHow to install SQL Server 2012.
bulletHow to install SQL Server 2012 Express Edition.
bulletHow to Install SQL Server 2012 on Windows Server Core.
bulletHow to use Product Updates on SQL Server 2012.
bulletMigrating SQL Server databases to Azure using SSMS 2012.
bulletNew User-defined Server Roles.
bulletRestore - Timeline.
bulletSequence Objects.
bullet Startup Parameters Tab.
bulletThe Compute Clause has been Discontinued.
bulletUsing Offset and Fetch with the Order By Clause.
bulletWhat is LocalDB.
bulletWhat SQL Server components or features are installed?
bulletWITH RESULT SETS option.

SQL Server 2014

bulletBacking Up SQL Server Databases to Azure.
bulletBreaking Changes to LocalDB.
bulletBuffer Pool Extension.
bulletCompatibility 120 Level is not available on CTP1.
bulletCreating Indexes on a Create Table Statement.
bulletHow to install SQL Server 2014.
bulletMicrosoft SQL Server 2014 CTP1 Requirements.
bulletReFS is supported on SQL Server 2014.
bulletWindows Update offers to apply SQL 2102 SP1 on SQL 2014.
bulletSSDT is not available on SQL Server 2014 CTP1.

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 Add Features to a SQL Server Instance
bulletHow to Determine Edition and Platform of a SQL 2005 Media
bulletHow to Disable SSL on Reporting Services
bullet How to install SQL Server 2005 SP3
bulletHow to install SQL Server 2008 SP2
bulletHow to Use a Configuration File to Install SQL Server
bulletInstalling Umbraco CMS with Microsoft SQL Server
bullet Know What Sessions Were Assigned to Each Workload Groups
bulletMicrosoft Atlanta
bulletMicrosoft products that support SQL Server Always On
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
bulletSide Effects of Using Trace Flags
bulletSpeed Up Insert Performance
bulletSQL Server requirements for System Center 2012
bulletSQL Server support for Data Protection Manager
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
bulletAn incompatible SQL Server version was detected.
bulletAttach Database Failed
bulletBackup failed for Server
bulletBackup Log is terminating abnormally.
bulletBackups with EMC Networker Finish with Error 3041.
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 connect to WMI provider 0x8004100.
bulletCannot create a linked server to Oracle
bulletCannot create new connection because in manual or distributed transaction mode.
bulletCannot insert the value NULL into column.
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
bulletChange of safety level not allowed
bulletChange Pending State
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.
bulletDatabase mssqlsystemresource is being recovered.
bulletDetach Database Failed for Server. (Microsoft.SqlServer.Smo)
bulletError 15457 Severity 0 State 1.
bulletError 1935 Microsoft.VC90.MFCLOC.
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 7202 - Could not find server in sys.servers
bulletError Applying the Filestream Settings.
bulletError Code is 2337.
bulletError connecting to VMware vCenter Update Manager.
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.
bulletError SQL72014.
bulletError Upgrading to VMM 2012 R2.
bulletError while enabling Windows feature NetFx3.
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
bulletLogin Failed Windows Azure SQL Database.
bulletLong Path Names to Files on SQL Server Media.
bulletMaintenance Plan Job Failed
bulletMicrosoft SQL Server Error 950.
bulletMS DTC was unable to start
bulletMsg 6522, Level 16, State 1, Line 3  ... Aggregate 'geometry'
bulletMsg 6522, Level 16, State 1, Line 3  ... Aggregate 'geometry' (2)
bulletMsg 7399 Msg 7303 OPENROWSET.
bulletMsg 7411 Linked Server
bulletMSSQLServerADHelper Event Id 100
bullet MSSQLSERVER Event ID 3041
bulletNo Features Selected for Upgrade
bulletODBC 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
bulletRecord Retrieval Error ConnectionRead.
bulletReplica is inconsistent.
bulletReporting Services Catalog Error
bulletRequired permissions needed to install vCenter Server.
bulletRestart Computer Failed
bulletRestore failed for Server
bulletRestore failed Microsoft.SqlServer.Management.RelationalEngineTasks
bulletRollbackSnapshotTempDB.
bulletRule Windows PowerShell Failed
bulletRule Same Architecture Installation failed.
bulletSaving Changes Is Not Permitted
bulletService Broker Error 28054
bulletSQLBrowser Event Id 3
bulletSQL Common Language Runtime is not enabled on the server.
bulletSQL Server 2008 setup requires .NET Framework
bulletSQL Server encountered error 0x80070218
bulletSQL Server Express 4 GB Limit
bulletSQL Server Resource Group Failed
bulletSQL Server security mode.
bulletSQL Server Setup cannot install files
bulletSQL Server Setup Rules Failed.
bulletSQL Server version is not supported by SCOM 2012.
bulletSSPI handshake failed
bulletStarting Up Database
bullet Subscriber does not satisfy version compatibility
bulletSuccessful Installation SP3 not Applied on Server
bulletTF254027: 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 Project Cannot Be Debugged.
bulletThe resource governor is not available
bulletThe server version is not supported
bulletThe SQLBrowser service was unable to establish Analysis Services discovery
bulletThe system cannot find the file specified.
bulletThe Transaction Manager is not available
bulletThere are validation  errors on this page
bulletThis Recordset Is Not Updatable.
bulletTry_convert is not a recognized function.
bulletUnable to connect to the VMM database.
bulletUnable to modify table
bulletUnspecified Error
bulletVMM 2012 SP1 Setup Wizard closes unexpectedly.
bulletw3wp.exe (0x1B08).
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.