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
Home2022

Year: 2022

MS-DOS commands

Delete Windows files recursively in cmd

January 27, 2022

How to delete files recursively in Windows cmd? I.e. how to delete all files in a folder and its subfolders. Use the del batch command line and the recursive option. The Windows delete …

MS-DOS commands

Delete a file in Windows cmd

January 26, 2022

To delete a file in Windows cmd, we use the del batch command. The delete command provides many very useful options to be in control of the deletion process. How to delete a …

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 …

Excel Tips

Download and install the OLEDB driver for Excel 2010

January 24, 2022

Download OLEDB driver for Excel 2010 to install Excel 2010 drivers and components. This set of components is called Drivers Database Access 2010 or Redistributable Microsoft Access 2010 Database Engine. It facilitates the …

Excel Tips

Download and install the Excel OLEDB 2007 driver

January 23, 2022

Download OLEDB Driver for Excel 2007 allows to read Excel files from applications using ODBC or OLEDB connections. The driver for Excel 2007 is needed for example to load Excels files from SSIS. …

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 …

MS-DOS commands

Create a text list of files in a folder in cmd

January 20, 2022

How to create a list of files and insert it into a text file with a simple command in Windows? It pretty easy, you need to add in the command to redirect the …

MS-DOS commands

Copy recursively files and folders in cmd with xcopy

January 19, 2022

To copy a single file or many files recursively with windows command prompt, use the xcopy command. The xcopy command is very similar to the copy command but it manages the recursivity and …

MS-DOS commands

Copy a file to another folder in command line

January 18, 2022

To copy a file to a different location in cmd, use the copy command line in a Windows Prompt. Two main options allows users to copy files in Windows command prompt or batch …

Posts navigation

1 2 3 »

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