SQL Server 2012

SQL Server 2012

Microsoft SQL Server logoMicrosoft® SQL Server™ is a database management and analysis system for e-commerce, line-of-business, and data warehousing solutions. In this wiki, you will find articles related to SQL Server 2012 by Features, Server Component or Management tools. You can find the full SQL Server Help documentation on the TechNet Library.

SQL Server 2012, the latest version, includes enhanced XML support, integration of .NET Framework objects in databases, improved integration with Microsoft Visual Studio and the Microsoft Office System, as well as improved analysis, reporting, and data integration services. See SQL Server Versions.



Server Component


SQL Server Database Engine

 

Analysis Services

 

Reporting Services

 

Integration Services

 

Master Data Services

Troubleshoot Installation and Configuration Issues (Master Data Services in SQL Server 2012) 


Management Tools


SQL Server Management Studio

 

SQL Server Configuration Manager

 

SQL Server Profiler

 

Database Engine Tuning Advisor

 

Data Quality Client

 

SQL Server Data Tools

 

Connectivity Components

 



Features


Cross-Box Scale Limits

 

High Availability

Demo Transcript: Configuring SQL Server 2012 AlwaysOn Failover Clustering
  Presentation Transcript: SQL Server 2012 AlwaysOn Availability Group Connectivity 

Scalability and Performance

Perform Scalar Aggregates and Still get the Benefit of Batch Processing  
  SQL Server Columnstore Index FAQ 
  SQL Server Columnstore Performance Tuning 

Security

 

Replication

 

Management Tools

How to convert Unicode Data to ASCII and back in SQL server 

RDBMS Manageability

 

Development Tools

 

Programmability

How to Check the Syntax of Dynamic SQL Before Execution  
  How to Compare Two Tables Definition / Metadata in Different Databases 
  How To Find Various Day, Current Week, Two Week, Month, Quarter, Half Year and Year In SQL Server 
  How to Put a Sequence in a Column Already filled 
  Microsoft SQL Server 2012 New Functions 
MVC 4.5 Areas and SQL Server 2012 Schemas Dichotomy 
  Using TRY_CONVERT in SQL Server 2012 

Integration Services

 

Integration Services-Advanced Adapters

 

Integration Services-Advanced Transforms

 

Master Data Services

 

Data Warehouse

 

Analysis Services

 

BI Semantic Model (Multidimensional)

 

BI Semantic Model (Tabular)

 

PowerPivot for SharePoint

 

Data Mining

 

Reporting Services

 

Business Intelligence Clients

 

Spatial and Location Services

 

Additional Database Services

 

Other Components

 



Misc


AD RMS (Windows Server 2008 R2) and SQL Server 2012 Install Steps
SharePoint 2013: Maximizing SQL Server 2012 Performance ( Free WhitePaper)
SharePoint Performance Best Practices: Limit SQL Server Memory Allocation   
SQL Server Samples Readme    



Training


Microsoft Learning Training and Certification - SQL Server 2012       
SQL Server 2012 Developer Training Kit BOM

       


Other Versions of SQL Server

SQL Server Versions

What Version of SQL Server to Use on the Backend

SQL Server 2012 (this article)

SQL Server 2008 R2

SQL Server 2008

SQL Server 2005

SQL Server 2000

SQL Server 7.0

SQL Server 6.5

 
Leave a Comment
  • Please add 7 and 8 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • Yagmoth555 edited Revision 20. Comment: fixing toc..

  • Yagmoth555 edited Revision 19. Comment: fixing toc

  • Yagmoth555 edited Revision 2. Comment: Hi, good article !, starting to add some content. I will use this page for SQL 2012's portal page

Page 1 of 1 (3 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Yagmoth555 edited Revision 2. Comment: Hi, good article !, starting to add some content. I will use this page for SQL 2012's portal page

  • Yagmoth555 edited Revision 19. Comment: fixing toc

  • Yagmoth555 edited Revision 20. Comment: fixing toc..

Page 1 of 1 (3 items)