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 [...]
Feb
25
2010
25
2010
Oct
6
2009
6
2009
DMV Report for Index Fragmentation and Statistics Update
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 [...]
May
18
2009
18
2009
Kill the Sql server process for a Database
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 [...]
Apr
23
2009
23
2009
Disk Space in Sql server
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 [...]
Apr
21
2009
21
2009
Enabling Xp_cmdShell in Sql server 2008
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
Apr
1
2009
1
2009
Deprecated Features in SQL server 2008
Here are the List of features that are deprecated in Sql server 2008 http://msdn.microsoft.com/en-us/library/ms143729.aspx
Mar
29
2009
29
2009
DayLight Savings and Sql Agent
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 [...]
Mar
17
2009
17
2009
Backup Report on SQL SERVER Databases
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
Feb
19
2009
19
2009
Problem with Maintenance Plan in Sql server 2005 After installing SP3
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 [...]
Feb
15
2009
15
2009
Policy-based Management
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 [...]
