Useful tips for everyday
Is replication available on SQL Express? Both Snapshot and Merge replication require the SQL Server Agent. SQL Express edition does not include SQL Server Agent.…
How do I calculate when my next period will be? How do I know when my next period is due? Now that you know how…
How do I recover MySQL root password? Reset a MySQL root password Stop the MySQL service. (Ubuntu operating system and Debian) Run the following command:…
How do I add a user to a database role? Right-click Roles, click New, and then click New Database Role. In the Database Role dialog…
How to see database files in sys.master files? sys.master_files is a system wide view and will show you all the files on the instance you…
How to measure the CPU usage of a database? My solution involves creating a T-SQL scalar function in the SQL Server master database, called dbo.udf_Get_DB_Cpu_Pct…
What is exec master Xp_cmdshell? “xp_cmdshell” is an extended stored procedure provided by Microsoft and stored in the master database. This procedure allows you to…
Where do I find advanced publish settings in Visual Studio? Right click the project name in the “Solution Explorer” window and select “Publish” from the…
How do I import a .dmp file into Oracle? To import data in your 18c XE database, perform the following steps: Connect to the 18c…
How do you change the default value? Set a default value In the Navigation Pane, right-click the form that you want to change, and then…