The client has requirement that state MS SQL Server is required (namely for support reasons). The are looking to go with MS SQL Server 2012 Standard. So.

And luckily for the Internet in general, the overall impact was also limited (when compared to that of Code Red) because there aren't nearly as many instances of SQL Server as there are of IIS.

If you have accidently deleted data from database tables in MS SQL Server, you can restore the deleted data (tables) using Log Sequence Number (LSN). But for this, you need the transaction backup file ...

How it works SQL Slammer exploits the way in which MS SQL servers process input on SQL Server Resolution Service port 1434. A specially crafted packet of only 376 bytes sent over the Internet can ...

All the information in SQL Server database is stored in 8 KB-sized pages. If any page gets corrupted, server fails to read the data in the database and displays different errors. Some common errors ...

Warnings Information in this article applies to Microsoft SQL Server 2012. The instructions for earlier versions of SQL Server, including versions 2008 and 2005, are similar.

How it works SQL Slammer exploits the way in which MS SQL servers process input on SQL Server Resolution Service port 1434. A specially crafted packet of only 376 bytes sent over the Internet can ...

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 ...