Get started

Get started

Bring yourself up to speed with our introductory content.

• FileMaker (FMP)

  FileMaker is a relational database application in which an individual may design -- and easily share on the Internet -- a database file by starting with a blank document or implementing ready-made and customizable templates. Continue Reading

• database normalization

  Database normalization is intrinsic to most relational database schemes. It is a process that organizes data into tables so that results are always unambiguous. Continue Reading

• T-SQL (Transact-SQL)

  T-SQL (Transact-SQL) is a set of programming extensions from Sybase and Microsoft that add several features to the Structured Query Language (SQL), including transaction control, exception and error handling, row processing and declared variables. Continue Reading

• pivot table

  A pivot table is a statistics tool that summarizes and reorganizes selected columns and rows of data in a spreadsheet or database table to obtain a desired report. Continue Reading

• database (DB)

  A database is a collection of information that is organized so that it can be easily accessed, managed and updated. Continue Reading

• Definitions to Get Started

  • FileMaker (FMP)
  • database normalization
  • T-SQL (Transact-SQL)
  • pivot table

  • database (DB)
  • Microsoft SQL Server
  • data structure
  • database management system (DBMS)

  View All Definitions

• SQL Server database design best practices and tips for DBAs

  Good database design is a must to meet processing needs in SQL Server systems. In a webinar, consultant Koen Verbeeck offered advice on how to make that happen.Continue Reading

• Microsoft SQL Server

  Microsoft SQL Server is a relational database management system, or RDBMS, that supports a wide variety of transaction processing, business intelligence and analytics applications in corporate IT environmentsContinue Reading

• data structure

  A data structure is a specialized format for organizing, processing, retrieving and storing data.Continue Reading

• database management system (DBMS)

  A database management system (DBMS) is system software for creating and managing databases.Continue Reading

• Check SQL Server Query Store performance impact before using

  Many IT teams hesitate to use SQL Server Query Store due to performance concerns. Consultant Andy Warren offers tips on how to test and get started with Query Store.Continue Reading

• data mining

  Data mining is the process of sorting through large data sets to identify patterns and establish relationships to solve problems through data analysis.Continue Reading

• 5 FAQs on SQL Server containers and how to manage them

  Running SQL Server in containers creates new challenges for database administrators. The answers to these questions can guide you through some of them.Continue Reading

• The Power BI-PowerShell cmdlet cheat sheet

  DBAs can manage Power BI data sets, workspaces and reports with PowerShell. Using the two tools together makes for a more efficient and effective workflow.Continue Reading

• Azure Data Studio (formerly SQL Operations Studio)

  Azure Data Studio is a Microsoft tool, originally named SQL Operations Studio, for managing SQL Server databases and cloud-based Azure SQL Database and Azure SQL Data Warehouse systems.Continue Reading

• Microsoft Azure SQL Database nears parity with SQL Server

  Microsoft is adding functionality to Azure SQL Database to enable users to migrate more SQL Server applications to the cloud platform and run bigger databases on it.Continue Reading