How do I find the list of users in my server?
| mySQL | Explination | SQL Server |
| select * from mysql.user; | Gets the list of users in the server | select * from sys.syslogins; |
** Don't forget to end your mySQL query with "\G" if running from the command line, as the user table is wide
When on Windows, for taking and making screenshots for technical documentation, I love Greenshot.
Here's an image from their website, showing the UI of the application.
From time to time, I try to script a job in MSX. Very often, it fails.
When it does, I use this query to take a look at the orphans, and then I use the "delete" section to remove the orphan rows from MSX, which allows me to script the job.
This is based on code I found online, but I have lost the source.
select j.[name], *--count(*)
--delete from js
FROM msdb.dbo.sysjobservers js
INNER JOIN msdb.dbo.sysjobs j ON j.job_id = js.job_id
LEFT JOIN msdb.dbo.systargetservers ts ON ts.server_id = js.server_id
WHERE ts.server_id IS NULL
We have USERS who create things that get KILLED using COMMANDS that are EXECUTED. Within the office, we speak of MASTERS and SLAVES, and of the dark magic that is BINDINGS. In our transportation, we are rich with DRIVERS and CONTAINERS.
What is Azure Data Studio?
Azure Data Studio is a cross-platform database tool for data professionals using the Microsoft family of on-premises and cloud data platforms on Windows, MacOS, and Linux.
Previously released under the preview name SQL Operations Studio, Azure Data Studio offers a modern editor experience with Intellisense, code snippets, source control integration, and an integrated terminal. It is engineered with the data platform user in mind, with built in charting of query result sets and customizable dashboards.
We were unable to automatically populate your Visual Studio Team Services accounts. The following error was encountered:
VS30063: You are not authorized to access https://app.vssps.visualstudio.com.
