T-SQL: Creation date/time of tables
When you are looking for the creation date/time of certain tables, you can easily find that in the sys.tables.You can use the code below in order to list all tables, and the creation date of those tables.
SCHELSTRAETE.ORG
I.T. minded
Read More
T-SQL: Find the creation time of SQL accounts
Sometimes you need to know when a SQL login was created. The SQL code below will list the SQL logins, when this was created, and if this is enabled or disabled.
T-SQL: Find most CPU consuming statements
The t-sql code below will give you the top 10 most CPU consuming SQL statements in your database, sorted by CPU time.
T-SQL: Find most I/O heavy SQL statements
Disk I/O is most of the time the bottleneck of your SQL database, even when using SSD. The SQL statement below will show you the most heavy disk I/O statements, which you should improve.
T-SQL: Top most used stored procedures
The code below will give you the top 10 most executed stored procedures in your database, sorted by execution count.
T-SQL: show uptime of SQL server & and status of agent
Interested to see how long your SQL server agent is up and running, or you want to see if that agent is operational? You can use the t-sql code below to find out:
T-SQL: Top long running SQL statements
The SQL statement below will give you the top 100 longest running SQL statements in your database, sorted by duration.
T-SQL: Find table in complete instance
Looking for a table, but you don’t remember in which database it’s located? The code below will create a stored procedure, which you can use in order to find a table in multiple databases.
T-SQL: Show sizes of all tables in a database
You can use the t-sql code below in order display the size of each table in a specific database.
T-SQL: Kill all connections to a specific database
Sometimes you need to do maintenance on a database, and you don’t really want to use single user mode or disable accounts. In that situation you could kill all connections to a specific database.In order to achieve that, you can use the t-sql code below.
Iptables: redirect port to other IP – port
You can use the following shell commands in order to redirect a port to another port.
Linux: simulate memory usage
Using the “stress” application, you can simulate high memory usage of your system.You may use the following command line:
Mysql: script taking dump of all dbs
T-SQL: create a lock
You can create a temporary lock in T-SQL for -for example- testing:
FFmpeg: decrease size of mp4 file
With ffmpeg you can also decrease the size (aka: quality) of a mp4 file on linux command line.You can use the following example, which will generate a +/- 5Mb file :
Jpegoptim: How to Optimize and Compress JPEG in Linux Commandline
You can optimize Jpeg images on linux command line (= reduce the size to load images faster).In order to achieve that, you can make use of the ‘jpegoptim’ application.On ubuntu/debian systems: To optimize the jpeg file:
Denyhosts: Add IP to whitelist
Create a file ‘allowed-hosts’ in the ‘work_dir’ (can be found in the denyhosts.conf file), which is /var/lib/denyhosts on Ubuntu, containing the ip.See the example below: