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

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.

More Highlights
Definitions
  • data aggregation

    Data aggregation is any process whereby data is gathered and expressed in a summary form.

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

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

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

  • data aggregation

    Data aggregation is any process whereby data is gathered and expressed in a summary form.

  • database replication

    Database replication is the frequent electronic copying of data from a database in one computer or server to a database in another -- so that all users share the same level of information.

  • 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

  • database replication

    Database replication is the frequent electronic copying of data from a database in one computer or server to a database in another -- so that all users share the same level of information.

  • RDBMS (relational database management system)

    A relational database management system (RDBMS) is a collection of programs and capabilities that enable IT teams and others to create, update, administer and otherwise interact with a relational database.

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

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

  • relational database

    A relational database is a collection of information that organizes data points with defined relationships for easy access.

  • RDBMS (relational database management system)

    A relational database management system (RDBMS) is a collection of programs and capabilities that enable IT teams and others to create, update, administer and otherwise interact with a relational database.

  • Azure SQL Data Warehouse

    Azure SQL Data Warehouse is a managed Data Warehouse-as-a Service (DWaaS) offering provided by Microsoft Azure.

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

  • RDBMS (relational database management system)

    A relational database management system (RDBMS) is a collection of programs and capabilities that enable IT teams and others to create, update, administer and otherwise interact with a relational database.

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

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

Highlights

More BI and Data Warehousing Topics

Back to Top

-ADS BY GOOGLE

SearchCompliance

  • PCI DSS (Payment Card Industry Data Security Standard)

    The Payment Card Industry Data Security Standard (PCI DSS) is a widely accepted set of policies and procedures intended to ...

  • risk management

    Risk management is the process of identifying, assessing and controlling threats to an organization's capital and earnings.

  • compliance framework

    A compliance framework is a structured set of guidelines that details an organization's processes for maintaining accordance with...

SearchSecurity

  • Trojan horse (computing)

    In computing, a Trojan horse is a program downloaded and installed on a computer that appears harmless, but is, in fact, ...

  • identity theft

    Identity theft, also known as identity fraud, is a crime in which an imposter obtains key pieces of personally identifiable ...

  • DNS over HTTPS (DoH)

    DNS over HTTPS (DoH) is a relatively new protocol that encrypts domain name system traffic by passing DNS queries through a ...

SearchHealthIT

  • telemedicine (telehealth)

    Telemedicine is the remote delivery of healthcare services, such as health assessments or consultations, over the ...

  • Project Nightingale

    Project Nightingale is a controversial partnership between Google and Ascension, the second largest health system in the United ...

  • medical practice management (MPM) software

    Medical practice management (MPM) software is a collection of computerized services used by healthcare professionals and ...

SearchDisasterRecovery

SearchStorage

  • M.2 SSD

    An M.2 SSD is a solid-state drive (SSD) that conforms to a computer industry specification and is used in internally mounted ...

  • kilobyte (KB or Kbyte)

    A kilobyte (KB or Kbyte) is a unit of measurement for computer memory or data storage used by mathematics and computer science ...

  • virtual memory

    Virtual memory is a memory management capability of an operating system (OS) that uses hardware and software to allow a computer ...

Close