Microsoft SQL Server installation is simple when system requirements and edition choices are planned.Choosing the right authentication mode, such as ...

Microsoft has introduced SQL Server 2012 to the world and it's time for IT professionals to start to come to speed on what's new. Microsoft has introduced SQL Server 2012 to the world and it's time ...

When it comes to working with spatial data in mobile software, the business needs can vary greatly. At a basic level, you’re probably going to be working with latitude and longitude coordinates as a ...

If you don’t have a backup of your MS SQL database, then follow the below ways to recover deleted data. Transaction log files record each change made to the ...

I'm having a disk space issue with a SQL 2000 server that has filled up the boot drive with it's log files.<BR>I caused this by limiting the amount of logfile space a ...

We are developing an asp.net web application for an internal company website. The web app makes heavy use of an SQL database and I feel that future bottlenecks will come down to SQL performance. In ...

A Java Web application often uses a SQL Server database. SQL Server now comes bundled with a reporting tool, Reporting Services. RS has generated a lot of attention among developers since it first ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Innovative software engineer with expertise ...

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

The SQL Slammer worm (w2.SQLSlammer.worm), also known as Sapphire (F-Secure), w32.SQLexp.worm (Symantec), and Helkern (Kaspersky), exploits known vulnerabilities in Microsoft SQL 2000 servers. It does ...