Useful tips for everyday
Who is executing the command XP cmdshell in SQL Server? When I call xp_cmdshell, the user executing the command is the SQL SysAdmin, i.e. the…
What does 8 characters mean in a password? Passwords must be at least 8 characters long. The password must contain at least three character categories…
In which format data is stored in SQL database? Have you ever thought about how SQL Server stores data in its data files? As you…
Is there a way to copy data from SQL Server? Copying data by using SQL or Windows authentication. As a source, retrieving data by using…
What does always on failover mean for SQL Server? Always On Failover Cluster Instances (SQL Server) As part of the SQL Server Always On offering,…
What is DBO permission in SQL Server? dbo stands for database owner. The only way to give that permission to a login is by creating…
What does too many file systems open mean? “Too many open files ” errors happen when a process needs to open more files than it…
How does Hibernate generate UUID? The Hibernate UUID assigned generator By simply omitting the identifier generator definition, Hibernate will consider the assigned identifier. This example…
Which database uses linked files? Linked servers are available in SQL Server Database Engine and Azure SQL Managed Instance. they are not enabled in Azure…
How do I export data from HeidiSQL? Create a database dump Start HeidiSQL. Connect to your Hypernode. Use Tools -> Export database as SQL. In…