Get started
Bring yourself up to speed with our introductory content.
Get started
Bring yourself up to speed with our introductory content.
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 environments Continue Reading
data structure
A data structure is a specialized format for organizing, processing, retrieving and storing data. Continue Reading
database management system (DBMS)
If the database is a file of information, then the DBMS is the file folders, the file labels and the file cabinet.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
2 ways to attach SQL Server database files to Linux containers
SQL Server files can be stored outside of Docker containers in host directories or volumes. Here's how to set up SQL Server on Linux databases and attach them to containers.Continue Reading
Get started with SQL Operations Studio in 7 steps
Microsoft's newest tool, SQL Operations Studio, provides DBAs with a free, lightweight option for managing SQL Server and Azure databases. Use these tips when trying it out.Continue Reading
Quick start tips for using the new MSSQL-CLI SQL query tool
The new MSSQL-CLI command-line tool provides many enhancements over SQLCMD CLI that enable you to quickly write and run T-SQL queries across Linux, macOS and Windows.Continue Reading