One of the critical decisions facing companies embarking on big data projects is which database to use, and often that decision swings between SQL and NoSQL. SQL has the impressive track record, the ...

Maybe you are still getting up-to-speed with the whole concept of cloud computing. If so, I have a lot of sympathy for you because there is so much to learn and because cloud technologies advance so ...

An important aspect of database security is designing your applications to avoid SQL injection attacks. SQL injection is a form of web hacking whereby SQL statements are specified in the fields of a ...

With Extended Support for SQL Server 2008 and SQL Server 2008 R2 ending in July 2019, to be followed six months later by the end of Extended Support for Windows Server 2008 and 2008 R2 in January 2020 ...

The uses of Blockchain technology continue to proliferate. A new application for Blockchain named Catena is being implemented for SQL developers and users. Italian for “chain,” Catena is a database ...

As developers look to harness the power of AI in their applications, one of the most exciting advancements is the ability to enrich existing databases with semantic understanding through vector search ...

Microsoft SQL Server 2008 is the most recent version of the Redmond, Wash., company's data management and business intelligence platform. According to Microsoft, the version provides new capabilities ...

I have written an application that takes in a fixed-width file (thanks in no small part to advice I recieved in a seperate thread) and then dissasembles each line, runs a fairly meaty SQL SELECT query ...

Distributed transactions are one of the more powerful and important functions within SQL Server. A distributed transaction is just like any other transaction within the SQL Server database, with a ...

Microsoft is less than two weeks away from launching SQL Server 2012, the next generation of its database software, and channel partners are already deep into proof-of-concept development work and ...