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

Common SQL Server 2016 licensing scenarios and how they work

Microsoft software licensing can be tough to manage -- so let's analyze some of the different situations for licensing SQL Server 2016 that enterprises will likely face.

More Highlights
Definitions
  • Microsoft SQL Server Management Studio (SSMS)

    Microsoft SQL Server Management Studio (SSMS) is an integrated environment to manage a SQL Server infrastructure.

  • database (DB)

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

  • 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

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 Management Studio (SSMS)

    Microsoft SQL Server Management Studio (SSMS) is an integrated environment to manage a SQL Server infrastructure.

  • 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

  • SQL (Structured Query Language)

    SQL, short for Structured Query Language, is a programming language for relational databases. It lets users modify database structures and insert, update and query data.

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.

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

  • data mart (datamart)

    A data mart is a repository of data gathered from operational data and other sources 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

  • Microsoft SQL Server Management Studio (SSMS)

    Microsoft SQL Server Management Studio (SSMS) is an integrated environment to manage a SQL Server infrastructure.

  • 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

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

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 warehouse

    A data warehouse is a central repository for all or significant parts of the data that an enterprise's various business systems collect.

  • Microsoft SSIS (SQL Server Integration Services)

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

Highlights

More BI and Data Warehousing Topics

Back to Top

-ADS BY GOOGLE

SearchCompliance

  • PCAOB (Public Company Accounting Oversight Board)

    The Public Company Accounting Oversight Board (PCAOB) is a Congressionally-established nonprofit that assesses audits of public ...

  • cyborg anthropologist

    A cyborg anthropologist is an individual who studies the interaction between humans and technology, observing how technology can ...

  • RegTech

    RegTech, or regulatory technology, is a term used to describe technology that is used to help streamline the process of ...

SearchSecurity

  • email spam

    Email spam, or junk email, is unsolicited bulk messages sent through email with commercial, fraudulent or malicious intent.

  • distributed denial of service (DDoS) attack

    A distributed denial-of-service attack occurs when an attack originates from multiple computers or devices, usually from multiple...

  • application whitelisting

    Application whitelisting is the practice of identifying applications that have been deemed safe for execution and restricting all...

SearchHealthIT

  • athenahealth Inc.

    Based in Watertown, Mass., athenahealth Inc. is a leading vendor of cloud-based EHRs for small to medium-sized physician ...

  • Affordable Care Act (ACA or Obamacare)

    The Affordable Care Act (ACA) is legislation passed in 2010 that changed how uninsured Americans enroll in and receive healthcare...

  • HIPAA Privacy Rule

    The Standards for Privacy of Individually Identifiable Health Information, commonly known as the HIPAA Privacy Rule, establishes ...

SearchDisasterRecovery

  • disaster recovery as a service (DRaaS)

    One approach to a strong disaster recovery plan is DRaaS, where companies offload data replication and restoration ...

  • data recovery

    Data recovery restores data that has been lost, accidentally deleted, corrupted or made inaccessible. Learn how data recovery ...

  • disaster recovery plan (DRP)

    A company's disaster recovery policy is enhanced with a documented DR plan that formulates strategies, and outlines preparation ...

SearchStorage

  • virtual memory

    Virtual memory is a memory management capability of an OS that allows a computer to compensate for physical memory shortages by ...

  • yottabyte (YB)

    A yottabyte is a measure of theoretical storage capacity and is 2 to the 80th power bytes, or, in decimal, approximately 1,000 ...

  • Kilo, mega, giga, tera, peta, exa, zetta and all that

    Kilo, mega, giga, tera, peta, exa, zetta are among the list of prefixes used to denote the quantity of something, such as a byte ...

SearchSolidStateStorage

  • PCIe SSD (PCIe solid-state drive)

    A PCIe SSD (PCIe solid-state drive) is a high-speed expansion card that attaches a computer to its peripherals.

  • SSD caching

    SSD caching, also known as flash caching, is the temporary storage of data on NAND flash memory chips in a solid-state drive so ...

  • NVDIMM (Non-Volatile Dual In-line Memory Module)

    An NVDIMM (non-volatile dual in-line memory module) is hybrid computer memory that retains data during a service outage.

SearchCloudStorage

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

  • Zadara VPSA and ZIOS

    Zadara Storage provides block, file or object storage with varying levels of compute and capacity through its ZIOS and VPSA ...

Close