February 1, 2023
  • Facebook
  • Twitter
  • Youtube
Expert-Only

  • Database
    • Create database with SQL Server Management Studio
    • Create SQL database with a script
    • Drop SQL Server database script
  • Tables & views
    • Table
      • Create SQL Server table
      • Create table with primary key
      • Create customer table
      • Alter SQL table
      • Truncate SQL Server table
      • Drop SQL table
      • Check if SQL table exists
    • View
      • Create SQL Server view
      • Alter SQL view
      • Drop SQL view
      • Create SQL partitioned view
  • Procedure & functions
    • Procedure
      • Create stored procedure
      • Alter stored procedure
      • Create procedure with parameters
    • Function
      • Manage SQL function
      • Create SQL function
      • Call SQL function
      • Alter SQL function
      • Delete SQL function
  • Indexes & partitions
    • Index
      • Clustered SQL index definition
      • Create SQL index
      • Rebuild SQL index
      • Reorganize SQL index
      • Disable SQL index
      • Drop SQL index
      • List all SQL indexes
    • Partition
      • SQL Server partition definition
      • Create SQL table partition
  • MS Office tips
    • Excel tips
      • Best cell selection shortcuts for Excel
      • Display the day in all letters with Excel
      • Excel shortcut to select an entire column
      • Disable the direct edit option in Excel
      • Turn off Excel Scroll Lock option
    • Word tips
      • Create an automatic table of contents with Word
      • Delete a horizontal line in Microsoft Word
      • Insert a comment in Word margin
  • IT concepts
    • Dimension table definition in Business Intelligence
    • DSS or Decision Support System definition
    • EPM or Enterprise Performance Management definition
    • OLTP and Transactional Databases definition
  • MS-DOS commands
  • Useful SQL
    • Insert into from a select query
    • SQL Server insert or update query example
  • Time and dates
    • Display full month name in SQL Server?
    • Time difference in hours minutes
  • Strings
    • Split text after character with SQL Server Substring
    • Remove SQL line break from text
    • Split long SQL Server text in lines
  • SQL Server
    • SQL Server Abbreviations
    • SQL Server Downloads
    • SQL Server Errors
  • DAX functions
HomeIT Concepts

IT Concepts

IT or information technology or Computer Science concepts are the main ideas and theories that structure and compose the industry and best practices.

IT Concepts

Ralph Kimball’s bottom-up business intelligence modelling

January 25, 2022

Ralph Kimball’s Bottom-Up Business Intelligence Design, a renowned author and expert in the field of data warehousing. He is a proponent of a bottom-up approach to data warehouse BI design. This is the …

IT Concepts

OLTP and Transactional Databases definition

January 22, 2022

What is the definition of OLTP or On Line Transactional Processing. OLTP refers to all databases designed to manage the processing of data in a transactional and reliable manner, for management purposes in …

IT Concepts

Dimension table definition in Business Intelligence

January 21, 2022

What is a dimension table in business intelligence? Dimensions are axes of analysis. The same dimensions often come up in the same areas. A dimension is a tree, the objective is to join …

IT Concepts

EPM or Enterprise Performance Management definition

January 1, 2022

What is EPM or Enterprise Performance Management, also known as Performance Management? is a field of Business Performance Management or BPM. It considers the visibility of operations in a closed-loop model across all …

IT Concepts

DSS or Decision Support System definition

December 30, 2021

What is a DSS or Decision Support System? The definition of a DSS is an integrated IT system designed to help managers make decisions. The decision support system is a very important part …

2017 - 2022 | Expert-Only.net | Learn Microsoft IT by example © All rights reserved.