Microsoft SQL Server Database Development
SQL Server Development
RELATED TOPICS
Looking for something else?
Microsoft SQL Server Database Development News
-
November 18, 2016
18
Nov'16
Microsoft previews SQL Server on Linux, opens features across editions
Microsoft looks to broaden the horizons of SQL Server, as it moves some Enterprise features to Standard Edition and issues the first public preview of a release supporting SQL Server on Linux.
-
November 14, 2016
14
Nov'16
Cask framework aims to speed Azure HDInsight data pipeline builds
A link between Cask Data's CDAP application and integration environment and Azure HDInsight, Microsoft's Hadoop cloud service, is meant to cut development time on big data applications.
-
May 07, 2015
07
May'15
Will the R language benefit from Microsoft acquisition?
Microsoft's recent acquisition of Revolution Analytics could go a long way in solidifying the R language's hold on analytical solutions.
-
June 05, 2014
05
Jun'14
SQL Server 2014 etches itself in-memory
Microsoft's flagship database is advancing into the largely undiscovered country of in-memory OLTP platforms -- and it's hoping to conquer.
Microsoft SQL Server Database Development Get Started
Bring yourself up to speed with our introductory content
-
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. Continue Reading
-
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
Download Our Exclusive Big Data Analytics Guide
An unbiased look at real-life analytics success stories, including a Time Warner Cable case study, and tips on how to evaluate big data tools. This guide will benefit BI and analytics pros, data scientists, business execs and project managers.
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
You also agree that your personal information may be transferred and processed in the United States, and that you have read and agree to the Terms of Use and the Privacy Policy.
Evaluate Microsoft SQL Server Database Development Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
-
What is the difference between DBMS and RDBMS?
A relational database management system is the most popular type of database management system for business uses. Find out how RDBMS software differs from DBMS technology in general. Continue Reading
-
Introducing DBCC CHECKDB for Analysis Services 2016
DBCC CHECKDB, a long-awaited feature for SQL Server Analysis Services, provides the ability to perform database consistency checks against tabular and multidimensional databases. Continue Reading
-
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
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
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.
-
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
-
SQL CONSTRAINT clauses: PRIMARY KEY and UNIQUE
In SQL Server, SQL CONSTRAINT clauses let you control the kinds of values that get entered into a column. Learn about two of them here. Continue Reading
-
Set database constraints using SQL Server Management Studio Table Designer
In addition to creating tables and adding columns, SQL Server Management Studio Table Designer can also set constraints. Continue Reading