Browse by Tags

Data Dude gets you a great news about Visual Studio Team Edition for Database Professionals!

Published 22 August 8 3:55 AM | SSQA.net

Data Dude - if you know about these 2 words then you know what I'm talking about. Visual Studio Team Edition for Database Professionals is an excellent tools for the users to build SQL databases in a managed project environment with support for versioning...

Filed under: sql server, services, community, code, visual studio, data dude, team edition, vsts

Don't fall for SPAM - phishing email about CNN.com email alerts

Published 9 August 8 12:43 PM | SSQA.net

Do not click any of the links below: Here is the piece of advice I would like to share that do not fall for tricks played by SPAMMERS and phishing email you see below: ************************************************************************* Alert Name...

Filed under: microsoft, security, services, enterprise, alert, code, spam, email

Analysis Service error: Either the user, Domain\User, does not have access to the Database Name database, or the database does not exist.

Published 10 July 8 3:2 AM | SSQA.net

As it seems the error text on the subject looks familiar when you have installed SQL Server or working with SQL Server databases. How about getting the error on Analysis Services databases (OLAP) within your BI Platform. So in the case of handling the...

Filed under: sql server, security, services, Analysis Services, data providers, impersonation

Unable to install SQL Server 2008 RC0 Books Online

Published 26 June 8 4:54 AM | SSQA.net

In continuation with the BOL update topic on SQL2008-RC0_BOL post here I have had troubles in installing the RC0 Books Online on to my laptop. As per the error below I thought it may be problem with the Windows Installer service on my laptop (Vista Ultimate...

Filed under: sql server, services, documentation, books online, rc0, windows installer

Free! Get 5GB online storage with SkyDrive‏

Published 27 March 8 4:35 PM | SSQA.net

Well I'm not promoting any product here, but amused to see the email I have got from Microsoft on using Windows Live services. I can say this is true offerring and easy to access your files wherever you are, your data - any time any place! . Forget...

Filed under: microsoft, data, services, windows, space, storage, free, disks, files, anywhere, live, skydrive

SQL Server Clustering get pre-installation information and choose the best practices for your environment

Published 27 March 8 3:40 AM | SSQA.net

Before installing the SQL Server cluster there must be a checklist in order to ensure you haven't compromised on any hardcore requirement. In this regard Microsoft suggests the hardward that must be listed on this Windows Catalog and Hardware Compatibility...

Filed under: sql server, backup, services, windows, i/o, best practices, cluster, san, raid, setup, hcl, binaries, checklist

February CTP: SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

Published 1 March 8 7:57 AM | SSQA.net

I was happy to see that February CTP for SQL Server 2008 was ready to download for use, in coinciding with my presentation in SQLBits I wanted to work my demos on this CTP release, nothing worked out successfully!! It is fair that new release will help...

Filed under: sql server, microsoft, services, 2008, bug, connect, error log, fix, thread, spawn

SQL Server 2005 Agent XPs disabled error - how to resolve this issue?

Published 6 February 8 2:38 AM | SSQA.net

When SQL Server 2005 Management Studio's Object Browser shows the SQL Server Agent service with a red down arrow and the text Agent XP's disabled , the service is not started or disabled. This used to be a problem prior to Service Pack 2 for SQL...

Filed under: sql server, profiler, security, services, sqlagent, sa, error log, msdtc, group policy

FIX: Error message when you start a database mirroring session in SQL Server 2005: "Communications to the remote server instance 'TCP://<ComputerName>:<PortNumber>' failed before database mirroring was fully started"

Published 4 February 8 6:3 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX...

Filed under: sql server, services, kba, database mirroring, failover, endpoint, port

We wish you Happy Holidays - Merry Christmas and New Year !!!

Published 21 December 7 6:29 AM | SSQA.net

Merry Christmas .... HAPPY NEW YEAR... whatever makes your wish come true! Wish you HAPPY HOLIDAYS and be safe/have fun during this season............ Thanks for all the support and registering here.... hope you find this site useful for your tasks.....

Filed under: tuning, services, blog, website, holidays

FIX: You must restart the SQL Server service on the principal server after you resume the SQL Server service process from a debug tool in SQL Server 2005

Published 17 December 7 7:19 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New and Major Modifications FIX: You must restart the SQL Server service on the principal server after you...

Filed under: sql server, services, kba, alert, database mirroring, principal, restart, debug

Unable to install SQL Server Express - Error SQL Server service failed to start?

Published 7 November 7 1:33 PM | SSQA.net

Imagine a simple installation of SQL Server Express 2005 edition fails with an error "SQL Server service failed to start?" Whether it may be on a X64 based operating system or on a simple desktop with XP PRO, as usual you would go with default...

Filed under: sql server, microsoft, services, error, sql express, installation, encryption, build, log file, 15029

SQL Server 2005 standard query tuning options - plan guide for performance testing how to?

Published 30 October 7 10:41 PM | SSQA.net

You may be aware that plan guides will help the optimizer to perform better and a general recommendation is to use the relevant USE PLAN query hint when the other standard query tuning options are failed. It is also necessary to test through the results...

Filed under: sql server, performance, indexes, services, hotfix, planning, service pack, best practice, testing, plan guide

SQL Server MSDTC service - do you need it or not?

Published 11 October 7 7:2 AM | SSQA.net

MSDTC - Microsoft Distributed Transaction Coordinator should be installed (Service up and running) when executing the BEGIN DISTRIBUTED TRANSACTION statement that controls the completion of the transaction. So to complete this transaction with a subsequent...

Filed under: sql server, services, kba, transaction, clustering, msdtc, servers, end, begin

Description of the SQL Server Integration Services (SSIS) service and of alternatives to clustering the SSIS service

Published 9 October 7 2:50 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications Description of the SQL Server Integration...

Filed under: sql server, ssis, services, kba, clustering, servers, integration services

New drive in problem resolution by Microsoft Product Support Services - SQL Server

Published 7 September 7 5:32 AM | SSQA.net

Microsoft Product/Customer Support Services has introduced new phase of provision to address the user issues. This program has been divided into various phases such as assessment, configuration and management with a flavour of Performance & Tuning...

Filed under: sql server, microsoft, security, services, customer, support, resources, problem, product, resolution

Unable to start SQL Server service with a specific certificate?

Published 31 August 7 8:5 AM | SSQA.net

You may be aware that using SSL communications a HTTP server can have encryption for us, in this regard certificates must be authorized for server authentication. Microsoft recommends that you can do this by either obtaining an SSL certificate from a...

Filed under: sql server, performance, security, services, certificate, start, ssl, http

How many DBAs you need to manage show in multi-server environment?

Published 30 August 7 5:24 PM | SSQA.net

This sounds like a joke that "How many DBAs you need to change a light bulb?". I have come across this less technical question from SSP forum asking for recommended practices. They wanted to have information that How many servers should be managed...

Filed under: sql server, server, services, dba, edition, multiple

How to enable the SQL Server 2005 Integration Services process to generate a dump file when the process experiences exceptions

Published 30 August 7 2:56 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications How to enable the SQL Server 2005 Integration...

Filed under: sql server, integration, ssis, services, kba, process, file, dump, exception

The "SQL Server:SSIS Pipeline" performance object does not appear in the "Performance object" list after you install Integration Services from a 64-bit version of SQL Server 2005

Published 25 August 7 4:29 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications The "SQL Server:SSIS Pipeline" performance object does not appear in...

Filed under: sql server, performance, ssis, services, kba, x64, int