Get started
Bring yourself up to speed with our introductory content.
Get started
Bring yourself up to speed with our introductory content.
database administrator (DBA)
A database administrator (DBA) is the information technician responsible for directing or performing all activities related to maintaining a successful database environment. Continue Reading
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
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