Useful tips for everyday
How delete all data from table Postgres? Tip: TRUNCATE is a PostgreSQL extension that provides a faster mechanism to remove all rows from a table.…
How do I find the difference between two Datetimes in Python? Python comes with an inbuilt datetime module which helps us to solve various datetime…
How do I restore from a network drive? Find the location of the file in the shared network drive. Right-click on the file and select…
Which tool can you use to enable Always On Availability Groups on SQL Server 2012 instance? Using SQL Server PowerShell Use the Enable-SqlAlwaysOn cmdlet to…
How do you manage a large database? Get a jump on query optimization in your databases by designing tables with speed in mind. This entails…
How do I set permissions in Reporting Services? Click Home, and then click Folder settings. From there, create a new role assignment so that you…
How do I delete a column from a table only? To do this, select the row or column and then press the Delete key. Right-click…
How is a view created in SQL Server? A view is based on the result set from a query, and this command allows us to…
How do I know which Microsoft updates to install? Select Start > Settings > Update & Security > Windows Update > Windows Update, and then…
How do you find the distance between two points in PostGIS? If you want the distance in meters between two lat/lon points, use ST_Distance_Sphere. For…