Tips & Tricks

#1 - Check if your myLittleAdmin install is up-to-date

Check if your myLittleAdmin install is up-to-date

#2 - Cannot update table content? Check that your table has a primary key!

Cannot update table content? Check that your table has a primary key!

#3 - All important info about your (hosted) SQL Server in a single page

All important info about your (hosted) SQL Server in a single page

#4 - Need to check which views, stored proc or functions depend on this table?

Need to check which views, stored proc or functions depend on this table?

#5 - Need to run a T-SQL query on a hosted or remote SQL Server?

Need to run a T-SQL query on a hosted or remote SQL Server?

#6 - Manage permissions for each object of your db from an intuitive interface

Manage permissions for each object of your db from an intuitive interface

#7 - Need to add a description to your db, your tables or your columns? Use the Extended Properties

Need to add a description to your db, your tables or your columns? Use the Extended Properties

#8 - How to browse your tables and views content using myLittleAdmin

How to browse your tables and views content using myLittleAdmin

#9 - For all actions, you can check the T-SQL statement before it is executed

For all actions, you can check the T-SQL statement before it is executed

#10 - Generate T-SQL INSERT scripts from a table content in a single click

Generate T-SQL INSERT scripts from a table content in a single click

#11 - How to display or update the T-SQL definition of a view

How to display or update the T-SQL definition of a view

#12 - Get a detailed list of all parameters of any stored procedure.

Get a detailed list of all parameters of any stored procedure.

#13 - Need to rename a highly-used object of your db? Why not creating a synonym

Need to rename a highly-used object of your db? Why not creating a synonym

#14 - Check the last Database Backup Date in a single click.

Check the last Database Backup Date in a single click.

#15 - How to include nonkey columns to a nonclustered index

How to include nonkey columns to a nonclustered index

#16 - How to get Free, Consumed and Total Allocated Space of your MSSQL Database

How to get Free, Consumed and Total Allocated Space of your MSSQL Database

#17 - How to export tables and views data (content)

How to export tables and views data (content)

#18 - User Defined Functions and Table-valued Functions with myLittleAdmin

User Defined Functions and Table-valued Functions with myLittleAdmin

#19 - How to create a Snapshot in a couple of seconds

How to create a Snapshot in a couple of seconds