Developers love database programming tips, tricks, and workarounds—especially those that slash development time or boost application performance. Here's a collection of such nuggets for developing SQL ...

We're doing some house cleaning at work (some servers are getting moved around in the datacenter, etc etc) and so one of the test boxes I use here at work finally got moved into the datacenter. Great, ...

Use custom-built .NET Framework 4.0 classes to connect an ASP.NET Web application to a SQL Server 2012 database. In my recent article, I showed how to connect .NET 4.0 C# and Visual Basic applications ...

On Wednesday Microsoft announced the release of SQL Server 2014 Community Technology Preview 2 (CTP2). SQL Server 2014 was announced a few months ago. It continues much of the technologies of SQL ...

Horizontal partitioning isn't new to SQL Server. Horizontally partitioning SQL Server 7.0 and later tables to multiple files and filegroups improves performance by reducing average table and index ...

With connectors in Power Apps we can collect 2000 items at a time when we read data from lists and libraries. However with SQL Stored Procedures in Power Apps we have an option to avoid this limit!

eWEEK content and product recommendations are editorially independent. We may make money when you click on links to our partners. Learn More. Azure SQL is Microsoft’s bid to get enterprises to float ...