Microsoft SQL Server Database Development

New & Notable

Download this free guide

Free Instant Download: Data Virtualization for Dummies

In this 67-page e-book, you’ll explore the challenges of data silos, data overload, and regulatory compliance, what data virtualization is and how it helps businesses, use cases, data virtualization in the cloud, and much more.

Corporate E-mail Address:
You forgot to provide an Email Address.
This email address doesn’t appear to be valid.
This email address is already registered. Please login.
You have exceeded the maximum character limit.
Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

Microsoft SQL Server Database Development News

September 25, 2018 25 Sep'18
SQL Server 2019 preview brings Hadoop, Spark and AI into DBMS

A SQL Server 2019 preview brings Hadoop and Spark into the fold, positioning the database as an all-purpose data portal. Azure Cosmos DB also gets an update.
June 11, 2018 11 Jun'18
Proposed Microsoft-GitHub buy confirms open source role in cloud

The looming Microsoft-GitHub pairing confirms the company's rebirth as an open source friend. Data tools on the Azure cloud are part of the motivation.
May 16, 2018 16 May'18
Azure Cosmos DB features, pricing morph with new provisioning model

The ability to provision Azure Cosmos DB throughput at the database level could come with pricing sticker shock for some users of Microsoft's multimodel database.
March 21, 2018 21 Mar'18
ObjectRocket launches Azure MongoDB service

Count ObjectRocket among those pursuing Azure MongoDB deployments. This open source NoSQL database continues to find traction on the web and in the cloud.

Microsoft SQL Server Database Development Get Started

Bring yourself up to speed with our introductory content

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. Continue Reading
Get to know Microsoft Azure Cosmos DB use cases

Organizations can deploy Cosmos DB for a range of important applications. Learn how to bolster Azure workloads with this Microsoft database service that is highly distributed and multi-model. Continue Reading
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. Continue Reading

Evaluate Microsoft SQL Server Database Development Vendors & Products

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

Storage and database innovation evolve in tandem

Faster storage means faster database operations. Discover how developments and innovation in storage improves the performance and flexibility of database technology. Continue Reading
SQL Server in Azure database choices and what they offer users

SQL Server databases can be moved to the Azure cloud in several different ways. Here's what you'll get from each of the options for migrating SQL Server to Azure. Continue Reading
How SQL Server DevOps processes help break down data silos

DevOps can help organizations dismantle data silos in SQL Server and other database systems -- and replace organizational silos with cross-functional teams. Continue Reading

Manage Microsoft SQL Server Database Development

Learn to apply best practices and optimize your operations.

SQL Server performance tuning best practices for DBAs

Tuning database performance is a complex process, but consultant Joey D'Antoni details a list of SQL Server performance tuning best practices that can make it easier. Continue Reading
Microsoft technology refresh touches SQL Server, integration tooling

Microsoft is at work on a delicate technology refresh affecting database tuning and architecture, as well as data integration and business intelligence. Continue Reading
The ins and outs of using R in SQL Server 2016 and 2017

What does the R analytics language offer to users, and how does it fit into SQL Server 2016 and 2017? Get answers to those questions and details on Microsoft's various R technologies. Continue Reading

Problem Solve Microsoft SQL Server Database Development Issues

We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.

What's the difference between DDL and DML?

What's the difference between DDL and DML? Get the answer and see examples of data manipulation language and data definition language commands for SQL databases. 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
SQL CONSTRAINT clauses: FOREIGN KEY, CHECK and DEFAULT

In SQL Server, SQL CONSTRAINT clauses let you control values entered into a column. Learn about FOREIGN KEY, CHECK and DEFAULT constraints here. Continue Reading