Microsoft’s SQL Server may be a big dog in the enterprise database market, but its conspicuous lack of user-defined functions (UDFs) has stacked up poorly against other leaders of that pack. Oracle, ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. This article dives into the happens-before ...

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

Helping & empowering business owners for over 15 years, helping them to understand how to protect own interests, build bridges to amplify joint ventures, adapting new business practices and solutions.

Using Access to build a front end for SQL Server Your email has been sent What are the advantages of using Access as the front end to a SQL Server database? For starters, it's likely that your ...

SQL is neither the fastest nor the most elegant way to talk to databases, but it is the best way we have. Here’s why Today, Structured Query Language is the standard means of manipulating and querying ...

Welcome to the first of a two-part series. In this first part, I'll talk about the physical infrastructure that Microsoft uses to ensure availability and provide a high degree of uptime for the Azure ...

SQL Server expert Kevin Kline has kicked off a multi-continent roadshow, sharing his deep SQL knowledge and best practices at a series at a series of SQL Saturdays and SQL Server User Group meetings. ...

With the new version of its database due out by mid-2010, Microsoft is increasing its retail prices. It also is adding two new high-end editions of SQL Server 2008 R2 to its line-up. Microsoft is ...