Microsoft SQL Server Database Development

Microsoft SQL Server Database Development Get Started

Bring yourself up to speed with our introductory content

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

• AlwaysOn Availability Groups

  AlwaysOn Availability Groups is a database mirroring technique for Microsoft SQL Server that allows administrators to pull together a group of user databases that can fail over together. Continue Reading

• AdventureWorks Database

  AdventureWorks Database is a sample OLTP database that Microsoft ships with all of its SQL Server database products. Continue Reading

Evaluate Microsoft SQL Server Database Development Vendors & Products

Weigh the pros and cons of technologies, products and projects you are considering.

• SQL Server 2016, Azure SQL Data Warehouse lead Microsoft cloud hopes

  Microsoft is working on yet another computing transformation, and its SQL Server and Azure SQL products are central thereto. But the company faces stiff competition in the cloud from Amazon. Continue Reading

• Five third-party SQL Server schema comparison tools

  Schema comparison tools let you compare object definitions in two databases. Read why they're important, and learn about five popular ones out there. Continue Reading

• Top five features in SQL Server Developer Tools

  SQL Server Developer Tools, also known as Project Juneau, made its debut in this summer’s Denali preview. Read up on five SSDT features. Continue Reading

Product Reviews

• the modules provide the fundamental processes to record scope, capture test cases, and track execution for each phase of testing.

  Powered by IT Central Station

  Valuable Features: Test Planning and Test Lab modules are the most valuable to capture test cases and track execution. Defect module for tracking...Continue Reading

  Rating:

• TAM gave us product advice that was able to save a department of 300 people roughly 4 hours a night.

  Powered by IT Central Station

  Valuable Features: Having a Technical Account Manager gives us someone who I can email about any of my questions or concerns about products,...Continue Reading

  Rating:

• Allowed us to not waste time with dead ends, better focus, and get to root cause much faster.

  Powered by IT Central Station

  Valuable Features: JIRA: Product is well liked but we have had performance issues. Premier Support: Knowledge is very good and they...Continue Reading

  Rating:

Manage Microsoft SQL Server Database Development

Learn to apply best practices and optimize your operations.

• SQL Server 2016 features boost cloud, security and analytics support

  In a podcast, SearchSQLServer's Jessica Sirkin discusses the noteworthy features in SQL Server 2016, reactions from early users and issues to consider in thinking about upgrading. Continue Reading

• Five tips to avoid a performance bottleneck or other SQL Server snares

  Basit Farooq provides five tips for SQL Server users, from avoiding a hardware performance bottleneck to dealing with database design. Continue Reading

• Microsoft SQL Server training: What you need to know

  Learn about the SQL Server database and how to make the most of SQL Server training in this essential guide. Continue Reading