In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

It's SQL Server 7.<P>It's a few development databases, and there are 3 people that may make changes throughout the day. I'm not exactly in charge, but I don't trust the other two people that are ...

Here is a feature that I have been waiting for since I started working with SQL Server 6.5: the ability to script the data from a table. When you deploy a SQL Server database, you often need to ...

JSON has stolen some of XML's thunder with features such as human and machine readability, a lightweight, compact text structure and support for many software and hardware platforms. JSON (JavaScript ...

PolyBase, a data virtualization feature for SQL Server, allows users to seamlessly query data from various external sources directly using T-SQL (Transact-SQL) without the need for separate client ...

When it comes to Data Compression, SQL Server has one advantage over Oracle: SQL Server will compress existing tables in a single statement. In Oracle Database 11g, you have to create a new table, ...

Helping & empowering business owners for over 15 years, helping them to understand how to protect own interests, build bridges to amplify joint ventures, adapting new business practices and solutions.