When reporting service is set up there are two default databases created which are 1. ReportServer 2. ReportServerTempDB. Reportserver database contains a wide range of information which is briefly listed below. 1. Subscriptions 2. Schedules 3. Data sources 4. Folder 5. Keys 6. History 7. Notifications and much much more. I would suggest looking at… Continue reading SQL Server Reporting Services 2008 (SSRS) Databases- ReportServer & ReportServerTempDB.
Adding SQL Server Reporting Services 2008 Before installing SQL Server Reporting Services 2008 it is important that you check whether your operating system is supported ( Windows Server 2003,2008,2012, some editions of XP, Vista, 7 and 8), you have sufficient RAM ( 512mb free), your CPU is powerful enough ( 1.0GHZ ) and if you… Continue reading Adding SQL Server Reporting Services 2008
Today I was doing my daily checks on one of my biggest SQL instances which has over 1,000 databases and noticed that SQL Agent was stopped. I couldn’t see any errors and was able to simply start it without any problems but I was concerned that the daily integrity check jobs had not run and… Continue reading Easily Check Database Integrity (DBCC CHECKDB) For All Databases On A Server
SQL Server System databases SQL Server has 5 very default system databases which are Master MSDB Model TempDB Resource Master As the name implies this is one of the most important databases on the system and without it SQL Server will not start. It stores all the configuration of the instance and all other databases… Continue reading What are the SQL Server System databases?
What is Business Intelligence ( BI )? Business Intelligence Development Studio ( BIDS )? SQL Server Reporting Services ( SSRS )? SQL Server Integration Services ( SSIS )? SQL Server Analysis Services ( SSAS )? What is Business Intelligence ( BI )? Business intelligence is simply using software to manage large amounts of data to… Continue reading What is Business Intelligence ( BI )? Business Intelligence Development Studio ( BIDS )? SQL Server Reporting Services ( SSRS )? SQL Server Integration Services ( SSIS )? SQL Server Analysis Services ( SSAS )?
I was asked by someone which SQL Server version a server was running and was surprised when my DBA colleague said to run a stored procedure I had never heard of. I had not thought that there would be more than one way as the usual method I used below was so simple I didn't… Continue reading How can I find out what SQL Server version is running?