A Beginner’s Guide to SQL

Blog series

Introduction:

Storage of unstructured data has always posed many challenges in terms of maintaining consistency between structured and unstructured data, managing backup/restore procedure, performance issues, scalability. This series shall discuss the use of Filestream to store unstructured data and how to create a sequence in an SQL server.

Big Data, Cloud & DevOps
How to Use SQL Server FILESTREAM to Store Unstructured Data

In earlier versions of SQL Server, storage of unstructured data posed many challenges in terms of maintaining consistency between structured and unstructured data, managing backup/restore procedure, performance issues, scalability, etc. This post explains to you how to use SQL Server FILESTREAM to store unstructured data. Here you can also read the positive and negative sides of FILESTREAM. Here are some other SQL queries to help you use it.

6 MINUTES READ Continue Reading »

Big Data, Cloud & DevOps
What Is a Sequence? How to Use a Sequence in MS SQL Server

This post explains how Sequence works in SQL Server that has started to be used since the 2012 version. First, SEQUENCE is a separate object and is not bound to a specific table and one SEQUENCE object can be used on multiple tables in parallel. Second, SEQUENCE can be altered. Then the SEQUENCE object can define the rank etc  The SEQUENCE object is most commonly used to obtain the value for a surrogate key in tables, most commonly used in the same way as IDENTITY is used.  

4 MINUTES READ Continue Reading »

  • Top articles, research, podcasts, webinars and more delivered to you monthly.

  • Experfy Content Manager
    © 2021, Experfy Inc. All rights reserved.
    Leave a Comment
    Next Post

    Leave a Reply

    Your email address will not be published. Required fields are marked *

    More in Blog series
    Experfy Insights,Blog series
    No Data Engineers, No Problem: How a Small Data Science Team Can Standardize and Centralize Data with a Data Library

    Introduction Access to and control of data is one of the biggest challenges faced by data analysts and data scientists.  Creative, persistent analysts find ways to get access to at least some of this data but doing that efficiently in a way that is also standardized and centralized for everyone on the team is difficult.

    1 MINUTES READ Continue Reading
    Blog series
    AI in Five, Fifty, and Five Hundred Years

    Introduction Prediction is a tricky business. You have to step outside of your comfort zone, your fainted vision of the world and see it thorough across all possible dimensions. In this series, we will discuss the future of “AI”, applications that are yet unexplored.

    1 MINUTES READ Continue Reading
    Blog series
    Ethics of Emerging Technologies

    Introduction: Humans are wired to make tough decisions bringing all the context and principles to bear. Similarly, can devices apply the available information to make the right judgment calls? In this series, we shall discuss some ethical dilemmas faced by emerging technologies.

    1 MINUTES READ Continue Reading