Is there any query to find all SQL services currently running on the server including SSRS, SSIS, SSAS?
121245
This might be a simple one, but i searched a lot and unable to find one.  Is there a sql query or a way i can run on registered server to find the list of all sql related services running like, ssis , ssas, ssrs, sql, agent, broswer, etc...  Tried googling out and can find sys.dm_server_services dmv but it does not show all the services running
110898
I want to select questions that are only tagged as SQL, SQLServer, SQLSever 2008. I am not interested in questions that have anything more than these tags. How do i select such questions only ?
17784
Not sure if this is actually desired, but  is currently showing me (a SE non-dev)  results, including all queries that are being run against the DB (not talking about data-explorer queries of course, talking about site rendering queries).    New feature of  or a deployment whoops?  Edit:  I didn't realize that data was .  With that in mind, this probably isn't a security problem after all, and is in fact more likely .
4884
My boss would like me to find which (of approx 400+) stored procedures are not being used by our website any more. I'm found and reworked a script to give me the details of most recent executions, however it only goes back as far as 10:17am September 1st.  My boss assures me that (although he likes to tinker with the server in his spare time) the server has been up since May 5th.  I'm pretty new to this, so explain it like I'm a particularly simple house pet, but is there are reason why my results table only goes back 1 month, instead of the full 6? I would assume that uptime is reset if the server is restarted, but I'm not sure why I wouldn't have any history that far back.  Does viewing the procedure by using right-click -&gt; modify count as an execution?  SQL Query  SELECT qt.text AS 'SP Name', qt.dbid as 'SP DB', qs.execution_count AS 'Execution Count', qs.total_worker_time/qs.execution_count AS 'AvgWorkerTime', qs.total_worker_time AS 'TotalWorkerTime', qs.total_physical_reads AS 'PhysicalReads', qs.last_execution_time 'Last Executed' FROM sys.dm_exec_procedure_stats AS qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS qt where qs.database_id = 5 ORDER BY qs.last_execution_time asc   My question relates more to the time frame of the results. I'm finding the information I need in the month of results I have but I'm worried there are 6 months of results that aren't being found found.  This returns May 5th:  select create_date from sys.databases where name = N'tempdb';   The following returns "2015-05-05 08:27:42.080":  SELECT sqlserver_start_time FROM sys.dm_os_sys_info;   Finally, this one returns "2013-09-15 19:34:34.667":  SELECT top 1 [rs].[destination_database_name], [rs].[restore_date]  FROM msdb..restorehistory rs  where destination_database_name = '%ID%'  ORDER BY [rs].[restore_date] DESC;
86788
Is there any negative performance impact for using the same service account and agent account to run SQL Server and SQL Agent respectively for all SQL server instances running at a small company of say 35 servers? The biggest database is 0.5 GB. any suggestions are welcome. Thank you.
95996
My manager is requesting to know when was the last time a number of reports were last ran to see if they are getting used. He requested info from our vendor and the vendor if coming to me for SA level permission to dig through the relative SQL Server.   Obviously, I won't be doing that but I would like to know is there a way to track the last time a specific query has been executed?  This database resides on an old SQL Server 2008 R2 install so I am sure my options are limited if not non-existent especially since he wants to look back as far as 18 months.   Just figured I would ask in case there might be at least a partial way to go back in history and track this information.
101707
How can I profile a SQL Server 2008 database to see code that's being executed on a particular database?  I remember using the SQL Server profiler, but I don't see it in SQL Server Management Studio after downloading SQL Server 2008 R2 Express.  Where can I download that tool and install it?  Do I need the full version of SQL Server 2008 in order to see this option?
124234
There is a requirement in our project where they want to evaluate if it is possible to downgrade SQL Server from Enterprise to Standard edition and if a server can be decommissioned.  How can I identify which servers are suitable for downgrade?
54789
It seems weird here while running  service --status-all | grep mysql   why I get so many wrong result?  It works fine on Centos where i am getting:  mysql is running xxxxxxx   This is what i am getting on Ubuntu:
2165
What is a  free tool to compare two Sql Server tables (data and schema).   It would be great if the tool can script the differences found.  I also went through some older . The closest I have seen is  but I would love to try more options.
19224
I have some code to help automate checking the error logs daily on our SQL Server.  This code calls xp_readerrorlog 0 to check the error log, and xp_readerrorlog 0,1 to check the SQL Server log.  Sometimes, however, there is more than one error log I need to scan.    I would like to be able to see, by T-SQL, the date of the log or, barring that, find the number of logs that exist.  I read that we can have up to 99 archive logs, but the server throws the following error message when trying to display an error log that doesn't exist.  "xp_readerrorlog() returned error 2, 'The system cannot find the file specified."  I know the date information and number exists since SSMS displays it( see the image below.)
79359
For a security audit,I need to identify all super users and log every activity performed. Best approach for this?  By "super user" I mean sysadmin, serveradmin, securityadmin, processadmin, and dbcreator.
103237
I think it has to be a common task. We have some applications on sharepoint and we need to prepare reports with data from these applications. It would be great if we could use Reporting Services. We need to query this data with sql because we need to join with some other sources. How can I do this? Are there any 3rd party tools or any built-it mechanisms in sharepoint to use Sharepoint lists data like ms sql tables?
119075
How do I limit a SQL Server Profiler trace to a specific database? I can't see how to filter the trace to not see events for all databases on the instance I connect to.
87176
I have 50 servers. I manage them from a central management server on SQL Server 2014 Enterprise Edition. I don't use repository.  I could open a query and get result for each one at the same time. But I want to do it in an automated way, like a job, to collect data from each server and store/handle it locally.  Is this possible and if so, how?
51261
I need to know the default  port settings for the following services   SQL Server SQL Browser SQL Reporting services SQL Analysis services   I neeed to know the port settings for these services for different versions of SQL Server (2000,2005,2008)  Also let me know whether the default port setting will change based on sql server versions  Thanks in advance.
6636
I am using , and want to use it to execute the checks on all of my SQL Servers and have it write the results to a single table.   Do I need to create linked servers on the central instance to connect to the other instances, or is there some other way to input the server names into the sp_Blitz stored procedure?