Any Free Reporting Tool You Recommend?
Nov 6, 2006dun need sophisticated interactive reports, but just simple basic rigid reporting will do :D
looking for a simple tool for my end users. Crystal Reports a bit overkill.....
ADVERTISEMENT
Can Anyone Recommend A ER Graphing Tool?
May 9, 2008All- Can anyone recommend a tool that generates ER diagrams and allows for the integration of narrative text that describes tables, relationships, rules, etc?
My company uses SQL Server 2005.
Thanks.
-Kurt
Free Tool For MSSQL Admin
Jul 10, 2007I'm looking for a free tool akin to SQL Server Enterprise Admin that i can use to administrate some of my databases on remote hosting from my home PC... any recommendations?
View 2 Replies View RelatedFree Query Tool From AgileInfoSoftware
Aug 17, 2005AgileInfoSoftware LLC is proud to announce AgileInfoSoftware PowerQuery*4.1 release. PowerQuery is free database query tool to work with multiple databases simultaneously and effectively.
The key features of PowerQuery 4.1 are:
One unified user interface works with*all your databases. No need to switch from one database to another.
Easy to build and execute query.
Use native database connectivity to improve database query performance.
Graphical*table edit and commit change without writing any INSERT, UPDATE or DELETE statement.
Automatically monitor Oracle Server side activities, such as executed SQL statements, server memory usage, disk usage and many other performance measurements
To obtain free PowerQuery 4.1, go to http://ww.agileinfollc.com. After download and install the software, send the registration code (32 bytes hash string generated based on your installation time) to support@agileinfollc.com, we will send back free license code to activate the software permanently.
Free Administration Tool For SQL SERVER 6.5
Mar 30, 2004Hello,
I need an Administration tool for SQL SERVER 6.5 compatible with WINDOWS 2000.
When I try to search one with GOOGLE, I find none ...
If anyone can provide me with any solution, he (or she) will make me the most happy of the DBAs today ...
Thanks in advance
Al'
Any Free Tool To Monitor SQL I/O, Network/sec
Jun 23, 2008Hi Everyone,
I am looking for a tool which can store SQL I/O and network/sec data. According to this historical data, I can decide whether upgrade my hardware.
Is there any free tool?
SQL Stripes - Free SQL Server Monitoring Tool
Sep 25, 2003http://stripes.docmusic.com
SQL Stripes is an application that helps you, the SQL Server DBA, having complete control over your various SQL servers.
From the high-level of monitoring essential components - to the low-level of analyzing your various databases, tables etc…
This is *not* another Query-Analyzer like tool, nor does it intend to be. The idea is that each one of your servers gets a 'Stripe' which contains valuable real-time data on the selected server.
SQL Stripes is an intuitive and easy to use application, which is intended to make your DBA life a bit easier.
SQL Stripes is completely free. Please send your feedback/questions/suggestions
Thanks and enjoy!
(free) SQL Server Mgmt Tool For Linux
Apr 23, 2008I have a Linux machine here at work that I do some development on, along with a few other tasks. It's also on my primary machine at home. Is anyone aware of a SQL Server Management suite that will run (natively - not in a VM) on Linux? I've used Aqua Data Studio in the past, but I would rather not have to pay for another License just for a part-time use.I'm not looking for a full suite of graphical utilities. If I could get the basic functionality of Query Analyzer (query window, object scripting, etc..), I'll be happy.I've googled around, and the pickings have been rather slim. The only thing I've found is something called Transact-SQL Analyzer (http://sourceforge.net/projects/sqlanalyzer/). I haven't tried it yet, but I'll give it a shot. Has anyone used it before? It doesn't make mention of 2k5 support, either.
View 6 Replies View RelatedIs There A Free Intellisense Tool For SQL Server Stored Procedures?
May 14, 2008I was looking for a 'free' intellisense tool that will prompt me with options when I am writing stored procedures in SQL Server Studio. Very much like the intellisense in Visual Studio.
Does someone know about such a tool? I know there are tools of this type but they cost 600 to 1000 dollars for a single user.
Is There A FREE, Pure Web Based Backup Restore Tool ?
May 10, 2008HI
I am trying to find a pure web based backup restore tool that can be used on MS SQL 2000.
I have found a few that claim to be web based, but then it tells you to log into your MS SQL server and make some adjustments.
I know that microsoft Enterprise manager comes with a backup / restore tool. but 1) i dont want to have to install a complete copy of 2005 server, and 2) i dont hav ethe physical space to do it right now anyway. all i need to do is move 2 databases from one account to another.
thanks
Reporting Services ReportServer DB Reporting - 3rd Party Tool ?
Jan 15, 2007HI There
We are required to gather certain information regarding reporting services.
Which reports were requested, by whom , how long did they run for, what parameters were passed etc etc.
I see that the system tables do provide some of this information, is there a 3rd party tool or something we can use to gather all this type of information for us?
This is for reporting services 2000 and 2005.
Thanx
Required Free EBook On Reporting Services 2005.
Sep 20, 2007Hello Friends,
I am in need of eBook on Reporting Services 2005 for study perpose, Please guide me through any link.
Thanks,
Vishal.
Does Anyone Know Of An T-SQL Reporting Tool
Oct 7, 2002Does anyone know of a T-SQL Reporting Tool that can be attached to either SQL 7 and/or 2000 databases.
I am looking for something similar to the Oracle 'Discoverer' tool.
The requirements are that users be able to create there own reports using a GUI with the minimum of prior knowledge of T-SQL.
Thanks in advance for any replies.
David Goodman.
XML Output For A Reporting Tool
Feb 17, 2004I put a similar post on experts-exchange....
What I am looking to do is create a reporting framework that uses SQL Server and outputs as XML (only because that could be consumed by various clients).
I also want to create title, subtotals, etc., and even page breaks of I can.
I want to do this all in T-SQL so new reports can be added by DBA's rather than have the developer re-code, re-compile, re-distribute, etc.
I think on the DB side it would be as easy as creating a table that is a 'catalog' of available reports with their names, etc., and a set of stored procs that would run the reports.
Has anyone ever done anything like this, or in some better way?
Thanks.
Looking For SQL Agent Reporting Tool
Apr 3, 2001I'm looking for a tool that can read the SQL Agent tables and generate a chart or graph of when jobs are scheduled. This could be used to determine when a job can be scheduled without interfering with other jobs, or to determine
where a maintenance window might exists.
The chart could be for a particular day, or week or month. It could be for a single database or all databases on a server. The tool could also read job history and display a graph of execution time (with success and failure displayed in different colors).
I don't know of anything like this in existence. I've looked at the stored procs supplied with SQL Server that help generate the data for the Enterprise Manager's GUI. I see thinks like the job schedule frequency information hardcoded in the stored procedure, instead of table driven. That's scary!
SQL Probe software is cool, but it doesn't do the reporting I'm looking for.
Looking For A Reporting Tool For Sql Views
Jul 20, 2005Was wondering if anyone knew of a tool that you can point to a view inthe database and it graphically (or even in text) determines thedependencies. At the moment I am manually going through a swag ofviews and putting them in visio org chart but there must be a betterway !
View 1 Replies View RelatedReporting Configuration Tool
Aug 29, 2007I installed 2005 advance... install said all OK. I go to Reporting Configuration tool, try to set Report Server Virtual Directory,
set new to default... says number of errors 0 but the crashes with the "... and has to close" No details as to what the error is
and when I retry I cannot click on Report Manager Virtual Directory. Any Ideas?
Database Reporting Tool Needed
Apr 20, 2006Hi,
I need software that will write a report on the following items that I can have prepared to show our auditors. Any suggestions ??? OUr databases are SQL*Server 2000, SP 3a / SP4
1) database consistency checking
2) re-indexing
3) shrinking
4) allocation of growth boundaries
5) backup routines
6) disk space
7) table space
8) processing speed
Thanks so much,
Nancy
Reporting Services Configuration Tool
Jul 11, 2007Hello all
I am trying to configure reporting services using the Configuration Tool. I get all checks green except for Encryption Keys (Blue), Initialization (Grey), and Email Settings and Execution Account (both Yellow). I am not too worried about the yellow and blue ones because I have read that other people have the same, but I was wondering how to make Initialization available to configure. I am running SQL Server 2005 - Standard Edition.
Thanks for the help,
S.R.
Reporting Services Configuration Tool
Jul 12, 2007we just got the new server windows 2003 server, sql server 2005
- i use remote desktop connect to the server.
- i made the report services for testing,
the problem is I can't not published report.
i check the report services configuration tool.
(the page is gray. also warning come "no report server were found on
the specified machine" detail invalid namespace)
what shoul i do?
SQL Service Reporting Tool - Designer
Oct 19, 2007Is there something called SQL Service Reporting tool - "the Designer" is this product different then the Reporting Services that comes with SQL Microsoft Server standard edition?
View 1 Replies View RelatedQuery/Reporting Tool For SQL Server Tables
Oct 6, 2005Just a general question about any recommendations for a third party tool that would allow setting up a data-dictionary against SQL Server tables and a user could go in and build their own queries, reports. Perhaps they could save their query/report definitions for reuse. Other nice to haves - ability to output to PDF and export to XLS. Would prefer web interface, but can consider desktop as well. Any immediate recommendations?
Thanks.
Tool To Write RDL For Sql Server Reporting Services
Nov 20, 2005We've just rolled out Reporting services at our organisation, and the users love it. However, it's giving me a headache because, as the only developer in the company and as I have VS.NET, I'm the only one who can author the reports.
Does anyone know of a third party provider that has written a report writing tool with a straight forward UI ( a bit like the access report writer for example) that I can deploy to some users and let them run riot? It's the kind of thing that I expect someone will have done as a pet project, if anyone knows of a freeware version that would be even better.
I'd be very grateful for any pointers.
Thanks
Error Trying To Open Reporting Configuration Tool
Aug 3, 2007I just installed SQL Server 2005 Express Edition and reporting services (followed the video tutorial). Whenever I try to open the Reporting Configuration Tool, it gives me the following error:
SQL Server 2005 Reporting Configuration Tool has encountered a problem and needs to close. We are sorry for the inconvience.
My only options are to Debug or Close.
I'm not sure why I am getting this error. Can anyone help?
Thanks,
Amanda
What Do You Recommend?
Apr 8, 2004I just to learn more about writing efficient sql statements,as well as database design principles and design instances .Will you please recommend some classic books or websites on these topics?
View 3 Replies View RelatedPlease Can Someone Recommend?
Sep 6, 2007
Hi,
I was wondering if anyone could recommend some freeware code or a 3rd Party tool for identifying and logging SQL Server blocking and its cause.
Mny thanks.
Col.
Could Anyone Recommend A Tutorial For..
Mar 9, 2004I'm using VB to access MDBs, and now I want to expand my work to a SQL server. Does anyone know where someone of my needs can find a suitable tutorial?
Thanks in advence,
Chen
Recommend Some Reading
Jul 25, 2007Hi,
I've been a developer for 20 some years, but never learned the design steps of a complex database. Can you give me a book or 2 to bring me up to speed with the latest database design and data modeling techniques?
thanks.....
To Include Image In SQL Server 2005 Express Reporting Tool
Mar 13, 2007Hi, I have a field in database that keep the image location. How to display the image in the report ?
Any idea.
Thanks.
Reporting Services :: Report Designer Tool Box Items Missing
Aug 10, 2015I have a project with SQL sever reports in it. During a test upon returning to the VS 2013 Professional interface, the tool box area still had the previous information displayed and never returned to what should be there for the report design tools.I restarted VS, and the toolbox no longer looked like it did before. Specifically, the datatable tool among others was missing. I was unable to "refresh" the datatable after making changes to it.
I opened other Reports in design mode, and the tools did not show up for those either.The Report Items in the toolbox does contain things like Pointer, Text Box, Line and so forth.
Tape Backup Software Recommend?
Nov 10, 2004Hi
I am having some trouble with our Veritas Backup Exec not properly releasing db backup files, & thus interfering with the deleting of old backups.
We have other servers still needing tape backups implemented and
I wonder if anyone has a good backup software/hardware system to recommend, that is ideal for database backups, & on the hardware side is reliable?
Anyone have any to recommend?
thx
Des
Recommend A Book On SSRS 2005
Apr 24, 2007I am going to start out with covnerting reports from Sql server Reporting services 2000 to Sql server Reporting services 2005. Pl recommend a GOOD BOOK For SSRS 2005.
Thanks.
Error Received In Sql Server Reporting Services Configuration Tool When Changing Encryption Key.
Nov 6, 2007 I've SQL Server Reporting Services 2005 configured on my system, but now I'm NOT Able to start the report server. I get this error on http://<serverurl>/Reports/Home.aspx:
The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) (rsRPCError) Get Online Help
The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled)
Key not valid for use in specified state. (Exception from HRESULT: 0x8009000B)
I don't want to loose any data. Please help me resolving this error.
FYI, I've modified the SQL Reporting Services account LogOnAs info, in Properties of "SQL Server Reporting Services (MSSQLSERVER)" Service, in Windows Service Managment.
Earlier I had .useraccount as username, I modified it to domainnameuseraccount. And then suddenlt everything broke for reporting server.