Author

Creating Database Indexes

Indexes are used to speed-up query processes in a database. They are similar to an index for a book. If you need to go to a particular chapter you can go to the index, find the page number of the chapter and go directly to the page. Database index works the same way. If you... » read more

Microsoft Power Platform

Power BI Power BI is a business analytics service provided by Microsoft. It provides interactive visualizations with self-service business intelligence capabilities, where end users can create reports and dashboards by themselves, without having to depend on information technology staff or database administrators. Wikipedia Make sense of your data through interactive, real-time dashboards. PowerApps Build apps... » read more

Tableau

Tableau is business intelligence software that helps people see and understand their data. https://www.tableau.com/ https://www.tableau.com/developer

Fine Tuning Stored Procedures

1. Use SET NOCOUNT ON SQL Server return information messages when running statements thus increasing network traffic. These messages can be suppressed by setting the NOCOUNT ON to decrease network traffic. 2. Use fully qualified procedure name A fully qualified object name is server.database.schema.objectname. SQL Server can swiftly find the complied plan instead of looking... » read more

SSRS vs SSIS vs SSAS

SSRS, SSIS, and SSAS are all products/services offered by Microsoft. Different services comes in different editions. SQL Server Reporting Services (SSRS) Provide a framework of reporting mechanisms such as the Report Builder, Report Designer, Report Manager, and Report Server that work together through a web interface to enable the development of interactive reporting solutions. Report... » read more

Database Backup Options

There are two database backup options you can set for the database. Full Recovery Model Simple Recovery Model Full recovery model allows you to restore your database to the last time a transaction was made to the database by using transaction logs. Simple recovery model only allows you to restore your database since the last... » read more

Full vs Differential vs Transactional Database Backup

Full backup is a full copy of your entire data set. They are time-consuming and often require a lot of disk space. Differential backups only backup up the data that has changed since the last full backup. If you have a full backup on Sunday and differential backup every week day nights, you only need... » read more

Cluster vs Non-Cluster Indexes

Indexes are used to speed-up query processes in a database. They are similar to an index for a book. If you need to go to a particular chapter you can go to the index, find the page number of the chapter and go directly to the page. Database index works the same way. If you... » read more

Transactional vs Analytical Database

Transactional Database Analytical Database OLTP OLAP Operational Systems Data Warehousing Original source of data Data comes from varies sources Large number of transactions. Low number of transaction. Very fast query processing Queries are often very complex and involve aggregations Detailed and current data, and schema is the entity model (usually 3NF) Aggregated, historical data, stored... » read more

Service Oriented Architecture (SOA)

Service oriented architecture (SOA) is a style of software design where services are provided to other applications or components through some kind of protocol over the network. Basic Principles of SOA Independent of vendors, products, and technologies. Represents a business activity with a specified outcome. Self-contained. Black box for consumer of the service. Loose coupling... » read more