When it comes to slick, highly functional sites, web designers get most of the credit. But they couldn't do what they do without the programmers, the unsung heroes of the web. If you're someone who ...

How to Restore a SQL Database From a .MDF File. Computer database software such as Microsoft's SQL Server benefits all types of businesses, as it makes recordkeeping fast, flexible and secure. SQL ...

The transaction log file contains the SQL Server transactions of the database. It basically records the database transactions and the changes made by the transactions to the database. The logs are ...

Your database may get damaged due to several reasons. A backup will help you to restore the database lost in case of disasters and problems, like hardware failure, virus attack, or others. How To ...

Recursive SQL can be very elegant and efficient. However, because of the difficulty developers can have understanding recursion, it is sometimes thought of as 'too inefficient to use frequently.' But, ...

Here is a list of common wait types and techniques that every DBA (or wannabe DBA) should know. While there are many more wait types than listed here, understanding these will give you a leg up when ...

At the recent Build conference, Microsoft announced a new database offering, which brings SQL Server capabilities to edge computing. Officially called Azure SQL Database Edge, the service runs on ...

Some of the best open source SQL Clients for Database Management are Sqlectron, SQuirrel SQL client, SQL Chat, OmniDB, HeidiSQL,Falcon, etc.

Do you need to find out where the location of your SQL Server's database is? Here's a quick tip.