There has been a lot of interest lately in NoSQL databases and, of course, many of us have strong backgrounds and experience in traditional relational "SQL" databases. For application developers this ...

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

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

Have you noticed that dynamic SQL is more popular today than ever before? There are a number of factors contributing to the success of dynamic SQL. Commercial off-the-shelf applications, such as SAP, ...

Don Boxley, CEO and Founder of DH2i, spent some time with me recently to discuss his company and DxConsole and DxTransfer. The company's goal is addressing the product limitations of Microsoft's SQL ...

SQL Server 2005&'s new integrated Visual Studio features allow solution providers, who write lines of business applications, to be more productive by giving them faster access to data and more ...

Values for SQL access should always be contained and managed only on the server side of the application, as client manipulation of any client side values is likely and dangerous. Next, appropriate ...

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

Are there any special adjustments that need to be made (on the SQL server side, or the database/query side) to accomodate for communications over a slow(er) WAN link? We have had slow performance to ...