跟我一起学Microsoft SQL Server 2012 Internals(1.1)

目录

MS SQL Server是微软出品的企业级关系数据库软件,当前已发展至2016。然而大家从MS SQL Server 2000至今,一直对MS SQL Server数据引擎存在很多理解误区,尤其是不少开发人员与DBA未能正确的使用MS SQL Server。

本系列文章将通过学习《Microsoft SQL Server 2012 Internals》,让大家重新正确的理解并使用MS SQL Server。

注意:文章内容将涉及SQL Server数据引擎的2008R2/2012/2014

正确查询SQL Server版本

当你安装完SQL Server后,你可通过如下T-SQL正确查询SQL Server的版本:

--查询MS SQLServer版本
SELECT SERVERPROPERTY('Edition');
---------
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
作者: Jorgensen, Adam; Wort, Steven; Loforte, Ross An essential how-to guide for experienced DBAs on the most significant product release since 2005! Microsoft SQL Server 2012 will have major changes throughout the SQL Server and will impact how DBAs administer the database. With this book, a team of well-known SQL Server experts introduces the many new features of the most recent version of SQL Server and deciphers how these changes will affect the methods that administrators have been using for years. Loaded with unique tips, tricks, and workarounds for handling the most difficult SQL Server admin issues, this how-to guide deciphers topics such as performance tuning, backup and recovery, scaling and replication, clustering, and security. Serves as a must-have how-to guide on the new features of the 2012 release of Microsoft SQL Server Walks you through ways to manage and monitor SQL Server and automate administration Guides you through SQL Azure for cloud computing, data replication, and data warehouse performance improvements Addresses client-connectivity enhancements, new features that ensure high availability of mission-critical applications, and tighter integration with Excel and SharePoint for data analysis and reporting Highlights major changes to the suite of SQL Server BI tools, including integration, reporting, and analysis services Includes real-world case examples and best practices from Microsoft insiders If you're a database administrator eager to get started with the newest version of SQL Server, then this book is essential reading.

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值