skip to main
|
skip to sidebar
Manjunath C Bhat's Blog
Pages
Home
About
About
About Me
No comments:
Post a Comment
Home
Subscribe to:
Posts (Atom)
MSSQL 2000 Certified
MSSQL 2005 Certified
MSSQL 2008 Certified
Fan Page
Catch Me on FaceBook
Manjunath C Bhat
Create Your Badge
Manjunath C Bhat
Dharwad,Bangalore, Karnataka, India
View my complete profile
Subscribe via email
Enter your email address:
Delivered by
FeedBurner
Other Public Profiles Do visit once
Manjunath C Bhat
Create Your Badge
Blog Archive
2014
(1)
January
(1)
General Approach To SQL Server Performance Tuning
2013
(18)
December
(1)
November
(12)
October
(5)
2012
(1)
January
(1)
2011
(17)
November
(2)
October
(1)
August
(2)
April
(4)
March
(7)
February
(1)
2010
(21)
November
(4)
October
(3)
September
(1)
July
(6)
June
(2)
May
(3)
March
(2)
Subscribe To
Posts
Atom
Posts
All Comments
Atom
All Comments
Follow Me At
Face Book
LinkedIn
MySpace
Orkut
Twitter
Followers
Popular Posts
Backup Database Error SQL Server 2012: This BACKUP or RESTORE command is not supported on a database mirror or secondary replica. BACKUP DATABASE is terminating abnormally
Microsoft SQL Server 2012 has introduced a new feature called AlwaysOn High Availability. There are numerous resources online to get informa...
SSAS Deployment Failed - Error 3 The project could not be deployed to the '' server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0
In one of my Old Post, I posted a SSAS Deployment failed because of insufficient rights for a User to deploy the cube/project to SSAS Server...
Dropping A Role in SQL server using T-SQL
It happens so that when you drop/delete a Database Role in SQL Server Database, the Role members who were assigned to this role wont get de-...
SQL Server Agent Not getting started after a Restart of Services Post Fresh Installation:
There are times where the SQL Server and SQL Server Agent Services are running fine post installation but your SQL Server Agent might not st...
SSAS Deployment Failed - Error 3 Either the '' user does not have permission to create a new object in '', or the object does not exist. 0 0
This is one of the Most common error a user might face during deploying a SSAS(SQL Server Analysis Services) Cube. “Error 3 Either the ...
ReportServer: Deleting Encryption Key in SQL Server Reporting Services Configuration Manager
Below are the steps to Delete the Encryption Key in SQL Server Reporting Services Configuration. Before Deleting make sure you have taken ...
Logon failure: unknown user name or bad password
This is one of the very often faced error for job failure. Exact error goes as follows: Unable to start execution of step (reason: Error ...
SELECT @@SERVERNAME Showing Null
SELECT @@SERVERNAME With multiple instances of SQL Server installed, @@SERVERNAME returns the following local server name information if th...
ReportServerError: An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database.Invalid object name ''. Could not use view or function 'ExtendedCatalog' because of binding errors.
There will be often Business Needs to Have your Report Server Migrated Moved or Restored onto Different Environment. You May come up with D...
Custom Reports using Crystal Reports and MySQL
1 Introduction Reporting is one of the main important factors and features and part of IT Sector. Reports are important in various asp...
Categories
#SQLServer
#TSQL
2000-2012
active process
AlwaysOn High Availability
Associate Schema
backup
backup all databases
BRH
change collation
Change Data Capture
child table
collation
columns
completion time
Create Role
Create Schema
Credentials
Crystal Reports
CTE
Database
database backup
Database Mail
DBCC
DBCC ShrinkFile
DBCC UPDATEUSAGE
default email
default trace
Details
dmv
Edition Upgrade
Error Codes
Errors
expensive
expensive queries
extendedcatalog
failure
File ID
Fixed Drives Free Space in Percentage
full backup
group
grouping
In-row data
last activity
login creator
login information
logon
logon failure
mail box
MySQL
New Role
New Schema
Nth level
Null
parent table
performance tuning
primary column details
primary key details
primay
proxy
ReportingServices
Reports
ReportServer
ReportServerTempDB
Role
running process details
running processes
Schema
ServerName
Shrinkfile
sql
SQL 2000 Database
SQL Server
SQL Server Agent
sql server collation
SQL Server Edition Upgrade
SQL Server performance
SQL server performance tuning
SQL Server Start time
sql server tuning
SQL Server Upgrade
SQL Server Uptime
SSAS
SSAS Access
SSAS Deployment
SSAS Port Opening
Starttime
stored procedure to get most expensive queries
Stored Procedure Users Server Roles connected
sysprocesses
T-SQL
TCP/IP Port Opening
TempDB
TSQL
type In-row data
unused index on database
Upgrade
Uptime
Windows SQL Server
XML PATH
Popular Posts
Backup Database Error SQL Server 2012: This BACKUP or RESTORE command is not supported on a database mirror or secondary replica. BACKUP DATABASE is terminating abnormally
Microsoft SQL Server 2012 has introduced a new feature called AlwaysOn High Availability. There are numerous resources online to get informa...
SSAS Deployment Failed - Error 3 The project could not be deployed to the '' server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0
In one of my Old Post, I posted a SSAS Deployment failed because of insufficient rights for a User to deploy the cube/project to SSAS Server...
Dropping A Role in SQL server using T-SQL
It happens so that when you drop/delete a Database Role in SQL Server Database, the Role members who were assigned to this role wont get de-...
SQL Server Agent Not getting started after a Restart of Services Post Fresh Installation:
There are times where the SQL Server and SQL Server Agent Services are running fine post installation but your SQL Server Agent might not st...
SSAS Deployment Failed - Error 3 Either the '' user does not have permission to create a new object in '', or the object does not exist. 0 0
This is one of the Most common error a user might face during deploying a SSAS(SQL Server Analysis Services) Cube. “Error 3 Either the ...
ReportServer: Deleting Encryption Key in SQL Server Reporting Services Configuration Manager
Below are the steps to Delete the Encryption Key in SQL Server Reporting Services Configuration. Before Deleting make sure you have taken ...
Logon failure: unknown user name or bad password
This is one of the very often faced error for job failure. Exact error goes as follows: Unable to start execution of step (reason: Error ...
SELECT @@SERVERNAME Showing Null
SELECT @@SERVERNAME With multiple instances of SQL Server installed, @@SERVERNAME returns the following local server name information if th...
ReportServerError: An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database.Invalid object name ''. Could not use view or function 'ExtendedCatalog' because of binding errors.
There will be often Business Needs to Have your Report Server Migrated Moved or Restored onto Different Environment. You May come up with D...
Custom Reports using Crystal Reports and MySQL
1 Introduction Reporting is one of the main important factors and features and part of IT Sector. Reports are important in various asp...
Blog Archive
▼
2014
( 1 )
▼
January
( 1 )
General Approach To SQL Server Performance Tuning
►
2013
( 18 )
►
December
( 1 )
►
November
( 12 )
►
October
( 5 )
►
2012
( 1 )
►
January
( 1 )
►
2011
( 17 )
►
November
( 2 )
►
October
( 1 )
►
August
( 2 )
►
April
( 4 )
►
March
( 7 )
►
February
( 1 )
►
2010
( 21 )
►
November
( 4 )
►
October
( 3 )
►
September
( 1 )
►
July
( 6 )
►
June
( 2 )
►
May
( 3 )
►
March
( 2 )
No comments:
Post a Comment