Forrards Blog

130 cents total
SQL Server 2014: parallel execution of SELECT INTO statements

In Microsoft SQL Server 2014 new in-memory options are presented. One of them is online transaction processing (OLTP) that complementing the existing business analytics and data storage options to create the most feature-rich solution for in-memory database. SQL Server 2014 also offers new cloud opportunities to simplify the process of migrating SQL databases to the cloud and discover new hybrid deployment scenarios.

Forrards
March 30, 2023
SQL Server 2014: protection against Database Administrator

Such a topic related to SQL Server 2014 CTP1 may seem a bit strange, but it was chosen not randomly. The questions like "How can I protect my data against the DBA?" appeared on forums regularly.

Forrards
March 30, 2023
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Subscribe to our blog

                             

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Database consultancy: ROW_NUMBER() function

ROW_NUMBER function numbers the rows returned by the query. You can use it to perform more complex ordering of rows in the report than the one given by the ORDER BY clause.Using the ROW_NUMBER you can:

Forrards
March 18, 2023

Let's discuss your project or resource request

                       

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.