A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

SQL remains the backbone of enterprise data access. Despite the rise of dashboards, semantic layers, and AI-driven analytics, ...

Today's applications want it all, and the databases powering them are forced to follow: Auto-deployment and scalability both on-premise and in the cloud, multi-cloud, hybrid cloud, plus resilience, ...

I've been tasked with doing a conversion of an Access 2000 app to SQL Server. As of right now, I'm fine with keeping the front end Access, but I wanted to put the back end tables on SQL. I used the ...

I'm new at this whole DBA thing, so maybe this is totally standard practice.<BR><BR>But we have a software vendor that wants remote access to our SQL server at an admin level to setup and install ...

Simba Technologies has partnered with Hortonworks, a commercial vendor of Apache Hadoop, to provide ODBC access to Hortonworks Data Platform. The use of Simba's Apache Hive ODBC Driver with SQL ...

Damian Black, SQLstream CEO, stopped by to introduce his company, discuss a few industry trends, and introduce the company's s-Server 3.0. Here's a summary of our interesting conversation: SQLstream ...

You don't have to give up using dynamic SQL just because you're using Entity Framework. The Entity Framework SqlQuery method will give you back the flexibility of dynamic SQL and still let you work ...