Forrards Blog

Category
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: SaaS database considerations

Utilizing given approach each client get his own database. In such case every client`s data stays isolated from others. It simplifies backing up the data, installing new clients but causes higher cost of maintenance.

Forrards
March 31, 2023
Database consultancy: tree-like structure

Subject recursion is well covered in the literature, but, nevertheless, the problem of output “tree” does not mean the client and SQL Server many baffled. So, put the problem: there is a table with the name and record id field indicating the parent identifier. Immediately fill in this table, some sort of test data:

Forrards
March 31, 2023

Let's discuss your project or resource request

                       

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

Contact Us
To let us help you

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