Browse Definitions :

SearchSQLServer

SearchSQLServer provides targeted news, expert advice, tips, search, learning guides, webcasts and research that cover all aspects of Windows-centric database design, development, administration and management.

View the complete archive of SQL Server Management news, research and expert advice.

Go to:  SearchSQLServer

Recently on  SearchSQLServer

Check SQL Server Query Store performance impact before using

Many IT teams are hesitant to use SQL Server Query Store due to performance concerns. Consultant Andy Warren offers advice on how to test and learn about Query Store.

More Highlights
Definitions
  • 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.

  • database (DB)

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

  • 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.

Browse SQL Server Topics

SQL Server Administration

The Microsoft SQL Server administration topics page provides resources for the enterprise SQL Server community that include the latest topics on SQL Server performance and tuning, backup and recovery, security, installation and more. Browse the SQL Server administration subtopics below to discover the latest news and expert technical advice on how to get started with SQL Server and database administration, with basic tutorials and tips on database modeling and design. More experienced SQL Server users will also find advanced resources for keeping their databases running at peak performance with our collection of articles, webcasts and white papers.

Recent Definitions

  • stored procedure

    A stored procedure is a group of statements with a specific name, which are stored inside a database, such as MySQL or Oracle.

  • 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.

  • MySQL

    MySQL is a relational database management system (RDBMS) based on SQL (Structured Query Language).

Highlights

More SQL Server Administration Topics

Back to Top

SQL Server Development

The SQL Server database development topic page provides resources for the enterprise DB development community that include the latest topics on stored procedures, SQL and T-SQL, .NET and more. You'll also find expert advice on database modeling and design for Microsoft SQL Server, as well as tips on business intelligence (BI) strategies and data warehousing. Browse the Microsoft SQL Server development subtopics below to discover the latest news, expert technical advice and more.

Recent Definitions

  • database (DB)

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

  • 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.

  • data mart (datamart)

    A data mart is a repository of data that is designed to serve a particular community of knowledge workers.

Highlights

More SQL Server Development Topics

Back to Top

SQL Server Management Issues

The Microsoft SQL Server management issues topics page provides resources for enterprise database managers including topics on SQL Server migration strategies and licensing considerations. You'll also find details on SQL Server virtualization with Microsoft Hyper-V and database consolidation. Browse the SQL Server management issues subtopics below to discover the latest news, expert technical advice, reference and white papers.

Recent Definitions

  • 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

  • Community Technology Preview (CTP)

    The Community Technology Preview (CTP) is an early version of a Microsoft product that is released to testers during the software development process. Microsoft releases several CTPs for each product, adding new features, updating pre-existing ones and fixing bugs with each release.

  • SQL Server 2014

    SQL Server 2014 is relational database management system (RDBMS) designed for the enterprise environment.

Highlights

More SQL Server Management Issues Topics

Back to Top

SQL Server Platforms

The SQL Server platform topics page provides resources for the enterprise database administration and development community covering the last three releases of Microsoft SQL Server: 2000, 2005 and 2008. Here you'll find details on the features, enhancements, service packs and upgrades for SQL Server 2005 and 2008, plus valuable advice for using Microsoft's legacy database management system, SQL Server 2000. Browse the SQL Server platform subtopics below to discover the latest news, expert technical advice and more.

Recent Definitions

  • 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.

  • MySQL

    MySQL is a relational database management system (RDBMS) based on SQL (Structured Query Language).

  • relational database

    A relational database is a set of formally described tables from which data can be accessed or reassembled in many different ways without having to reorganize the database tables.

Highlights

More SQL Server Platforms Topics

Back to Top

BI and Data Warehousing

The need for organizations to have sound business intelligence and data warehousing solutions is becoming more critical by the day. Microsoft has recognized this by adding several SQL Server Business Intelligence (BI) enhancements to the latest editions of its database management system, SQL Server. From seasoned business intelligence tools like SQL Server Analysis Services and Reporting Services, to important add-ons like SQL Server Business Intelligence Studio and Visual Studio, to brand new features like Master Data Services, there is plenty terms of business intelligence with Microsoft SQL Server. This topic page provides links to tutorials, news and other resources on data warehousing and business intelligence with Microsoft SQL Server environments. Here you'll find information on the latest BI features from Microsoft and third-parties, along with advice on implementation strategies, data visualization techniques, and more.

Recent Definitions

  • database (DB)

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

  • 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.

  • data warehouse

    A data warehouse is a federated repository for all the data collected by an enterprise's various operational systems, be they physical or logical.

Highlights

More BI and Data Warehousing Topics

Back to Top

-ADS BY GOOGLE

SearchCompliance

  • compliance audit

    A compliance audit is a comprehensive review of an organization's adherence to regulatory guidelines.

  • regulatory compliance

    Regulatory compliance is an organization's adherence to laws, regulations, guidelines and specifications relevant to its business...

  • Whistleblower Protection Act

    The Whistleblower Protection Act of 1989 is a law that protects federal government employees in the United States from ...

SearchSecurity

  • Cybercrime

    Cybercrime is any criminal activity that involves a computer, networked device or a network.

  • data breach

    A data breach is a confirmed incident in which sensitive, confidential or otherwise protected data has been accessed and/or ...

  • zero-day (computer)

    A zero-day vulnerability, also known as a computer zero day, is a flaw in software, hardware or firmware that is unknown to the ...

SearchHealthIT

SearchDisasterRecovery

  • cloud insurance

    Cloud insurance is any type of financial or data protection obtained by a cloud service provider. 

  • business continuity software

    Business continuity software is an application or suite designed to make business continuity planning/business continuity ...

  • business continuity policy

    Business continuity policy is the set of standards and guidelines an organization enforces to ensure resilience and proper risk ...

SearchStorage

  • business impact analysis (BIA)

    Business impact analysis (BIA) is a systematic process to determine and evaluate the potential effects of an interruption to ...

  • RAID (redundant array of independent disks)

    RAID (redundant array of independent disks) is a way of storing the same data in different places on multiple hard disks to ...

  • dedicated cloud

    A dedicated cloud is a single-tenant cloud infrastructure, which essentially acts as an isolated, single-tenant public cloud.

Close