SQL Server Database Recovery Models

Microsoft SQL Server 2012 has three models that database administrators can choose from when they back up and recover SQL data. All three models are built seamlessly into Microsoft's SQL Server application. While all three models allow users to make a backup of their SQL data, and restore data back to its condition when the backup was created, they differ in the way that they handle transactions that were applied to the database after the data was backed up. The Simple Model If you...

Read more »

Big Data in the Real World

You can't start to deal with the challenge of Big Data if you haven't gotten your Little Data problems under control. All of the excitement surrounding today's Big Data craze is having two huge effects on businesses worldwide:      Larger enterprises are sticking their toes into the Big Data pond, and trying to cash in on the benefits that the Big Data gurus have promised for those companies that embrace this new trend.      Companies of all sizes are acknowledging that they're...

Read more »

How To: Repair SQL

SQL is the standard programming language that is used to communicate with a database. This language is fairly complex and consists of a data definition language and a data manipulation language. The data definition is responsible for the index and table structure while the data manipulation is responsible for adding, updating, and deleting data. These languages are then sub-divided into a number of elements that include queries, statements, expressions, and more. As you can see, this is a...

Read more »