At sometime in the afternoon today, I was alerted by the business that SQL reporting services is down. The first thing I checked was to open a report. I saw the following error message on the browser.
The report server has encountered a configuration error. Logon failed for the unattended execution account. (rsServerConfigurationError)
Log on failed. (rsLogonFailed)
The [...]
Recently the ETL load times of my Datawarehouse are increasing and so I decided to check the Indexes status on the tables . I found some fragmentation on the indexes and also some Statistics that are not being updated regularly . I searched online and found this blog by Ben Nevarez(SQL Blog).
I decided to check [...]
When Doing database Restore sometimes we may need to kill the spid’s in the database so that the connections are not open. Going through the spids in sp_who or sp_who2 can sometimes be a tedious task if there are more connections to the database. The following TSQL should generate the list of kill statements for [...]
How to get the Disk Space in SQL Server?
There are 2 ways
a. xp_fixeddrives — The Easy way
b. Ftsutil(xp_cmdshell) — If I want to know the percentage of free space in harddisk use FTSUTIL . The only thing you need to enable is the xp_cmdshell.
Click here to read how to enable XP_cmdshell
Here is the [...]
In Sql server 2008 the Surface area configuration no longer exists. you can enable the Xp_cmdshell either by the Policy based management or by using the sp_configure
Here are the List of features that are deprecated in Sql server 2008
http://msdn.microsoft.com/en-us/library/ms143729.aspx
Ran a Job yesterday to check how the SQL agent Handles the DayLight Savings
Created the following Table
Created the Following procedure to enter the current Date
and Ran the Job every minute from March 28th 2009 22:50 to Mar 29th 2009 3:00 AM
Results:
There was no 01:00 AM on March 29th !!!!. So any jobs scheduled at [...]
The Following Script will output the List of Databases in the SQL server and gets the Last Date the Databases were backed up
select Convert(Varchar(25),server_name) as ‘Server Name’
,convert(varchar(25),database_name) as ‘Database’
,max(backup_finish_date) as ‘Last_backup_date’
from msdb..backupset
Where database_name
in
(select name from master..sysdatabases)
and server_name = @@servername
group by server_name,database_name order by Last_backup_date DESC
Problem:
I was trying to configure the backups on Sql Server using the Maintenace Plan.
When I opened it . I got the following error
TITLE: Microsoft SQL Server Management Studio
——————————
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
——————————
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
——————————
Invalid column name ‘from_msx’.
Invalid column name ‘has_targets’. [...]
Policy-Based Management(PBM) is the expansion of advanced DDL trigger mechanisms on the Server. Think of the following things
a. How do I allow the users to create the table in specific naming conditions like starting only with ‘T’?
b. How about checking the availability of the latest Sql Server backups?
c. How about limiting the number of CPU [...]
My Twitter Feed
