The primary advantage of storing files in your SQL Server database is that it avoids the problems that occur when files are changed in your filesystem (which can result in broken link references stored in your db or files that are out of sync with the information in your database). The disadvantages of storing files in your db include the potentially significant increase in db size that may occur depending on the number and nature of files you plan to store, and the potential negative impact on db performance related to accessing these files (the smaller the number and size of files you plan to store in the db, the less relevant these disadvantages become). While there are many options for optimizing performance of and managing large dbs, your organization's db management and backup tools or policies may make storing files in your db impractical. It is also important to consider the application you are using to access your db since designing the application to manage the process of file changes between your filesystem and db may produce the same advantage as storing the file in the db without the disadvantages. Lastly, the FILESTREAM feature in SQL Server offers a hybrid option designed to provide the benefits of storing files in the database while actually storing files in the filesystem.

answered

Web development requires knowledge of markup languages (HTML and XHTML), client-side languages, and server-side languages. The most widely used client-side language is JavaScript - for server-side languages, it is PHP. While these are the most used languages, there are other widely used languages with ample development talent to support them that you could consider (you can see examples of other widely used languages via the links). There are also other tools you may want to consider in making your web development decisions such as whether or not your outsource developers will use a content management system (CMS) such as Wordpress (the most widely used CMS) as part of the development as that will also have implications for future support and development work.

answered

There are a wide variety of tools used by UI designers for various parts of the design process. Some of the most commonly used tools include Sketch, Adobe Photoshop and Illustrator, and InVision, but there are many other tools out there for general design and specific design-related tasks. A good place to start is Designmodo's list of the best UI design tools.

answered

While it is possible to import SQLite data into MS SQL Server via SSMS, it is much easier to access SQLite data (if that is really all you need here) using other purpose built tools such as DB Browser for SQLite or SQLite Manager (links to both below). If you actually need to import the data into an MS SQL Server database, there is a step by step tutorial (link below) on how to download and configure the appropriate drivers so that you can do this in SSMS. https://www.mssqltips.com/sqlservertip/3087/creating-a-sql-server-linked-server-to-sqlite-to-import-data/

answered