Andrew Rosca

Andrew
Rosca

Andrew Rosca, an e-commerce architect at Nextropia, has 5 years of experience in designing and developing Web applications in an IIS and SQL Server environment. His areas of interest include performance and query optimization for .NET-, ASP-, and SQL-based applications.

Articles
Server-Side Paging with SQL Server 1
Paging is necessary in most Web applications, but accessing a large number of records can create a bottleneck that cripples your system. This server-side paging technique that lets you access millions of records and still avoid performance problems.
Upcoming Conferences

Register now to get the best rate available!

From the Blogs
Jul 8, 2014
blog

Replication: Sometimes More is Less

The unconventionality of having two publications for complex, unruly databases typically ends up saving huge amounts of time over the long haul and makes replication much easier to manage....More
Red restore key on computer keyboard
Jun 24, 2014
blog

AlwaysOn Availability Groups and Third Party Log Readers

When DBAs and SysAdmins learn the ins-and-outs of AlwaysOn Availability Groups, they’re then able to address high availability and disaster recovery concerns from a single interface or set of tooling, thus providing better scalability of management....More
Microsoft Azure Machine Learning screenshot
Jun 20, 2014
blog

Microsoft Cloud Predictive Analytics Preview Coming Soon

A preview of Azure Machine Learning, or Azure ML (project code name "Passau"), will be made publicly available in July 2014....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×