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

How to choose the right SQL Server on Azure deployment option

There are two options for deploying SQL Server on the Azure cloud. Here's a look at how they differ to help you choose between Azure SQL Database and SQL Server on an Azure VM.

More Highlights
Definitions
  • Microsoft Azure Cosmos DB

    Azure Cosmos DB is a Microsoft cloud database that supports multiple ways of storing and processing data. As such, it is classified as a multimodel database.

  • 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

  • Microsoft SSIS (SQL Server Integration Services)

    Microsoft SSIS (SQL Server Integration Services) is an enterprise data integration, data transformation and data migration tool built into Microsoft's SQL Server database

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

  • 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

  • Microsoft SSIS (SQL Server Integration Services)

    Microsoft SSIS (SQL Server Integration Services) is an enterprise data integration, data transformation and data migration tool built into Microsoft's SQL Server database

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

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

  • foreign key

    A foreign key is a column or columns of data in one table that connects to the primary key data in the original table.

  • flat file

    A flat file contains records that have no structured interrelationship. A flat file typically consists of a text file, from which all word processing or other structure characters or markup have been removed.

  • Microsoft Visual FoxPro (Microsoft VFP)

    Microsoft Visual FoxPro (VFP) is an object-oriented programming environment with a built-in relational database engine.

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

  • Microsoft Azure Cosmos DB

    Azure Cosmos DB is a Microsoft cloud database that supports multiple ways of storing and processing data. As such, it is classified as a multimodel database.

  • 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

  • flat file

    A flat file contains records that have no structured interrelationship. A flat file typically consists of a text file, from which all word processing or other structure characters or markup have been removed.

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

  • Microsoft SSIS (SQL Server Integration Services)

    Microsoft SSIS (SQL Server Integration Services) is an enterprise data integration, data transformation and data migration tool built into Microsoft's SQL Server database

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

  • database (DB)

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

Highlights

More BI and Data Warehousing Topics

Back to Top

-ADS BY GOOGLE

SearchCompliance

  • pure risk (absolute risk)

    Pure risk, also called absolute risk, is a category of threat that is beyond human control and has only one possible outcome if ...

  • risk assessment

    Risk assessment is the identification of hazards that could negatively impact an organization's ability to conduct business.

  • audit program (audit plan)

    An audit program, also called an audit plan, is an action plan that documents what procedures an auditor will follow to validate ...

SearchSecurity

  • insider threat

    Insider threat is a generic term for a threat to an organization's security or data that comes from within.

  • ransomware

    Ransomware is a subset of malware in which the data on a victim's computer is locked, typically by encryption, and payment is ...

  • hacker

    A hacker is an individual who uses computer, networking or other skills to overcome a technical problem.

SearchHealthIT

SearchDisasterRecovery

  • business continuity and disaster recovery (BCDR)

    Business continuity and disaster recovery (BCDR) are closely related practices that describe an organization's preparation for ...

  • business continuity plan (BCP)

    A business continuity plan (BCP) is a document that consists of the critical information an organization needs to continue ...

  • call tree

    A call tree -- sometimes referred to as a phone tree -- is a telecommunications chain for notifying specific individuals of an ...

SearchStorage

SearchSolidStateStorage

  • 3D XPoint

    3D XPoint is memory storage technology jointly developed by Intel and Micron Technology Inc.

  • RRAM or ReRAM (resistive RAM)

    RRAM or ReRAM (resistive random access memory) is a form of nonvolatile storage that operates by changing the resistance of a ...

  • JEDEC

    JEDEC is a global industry group that develops open standards for microelectronics.

SearchCloudStorage

  • Google Cloud Storage

    Google Cloud Storage is an enterprise public cloud storage platform that can house large unstructured data sets.

  • RESTful API

    A RESTful application program interface breaks down a transaction to create a series of small modules, each of which addresses an...

  • cloud storage infrastructure

    Cloud storage infrastructure is the hardware and software framework that supports the computing requirements of a private or ...

Close