16 热度

SQL Server Management Studio 18.4 and sqlpackage v18.4 generally available

Today we’re announcing the release of SQL Server Management Studio (SSMS) 18.4. This update has full support for SQL Server 2019 capabilities as well as some bug fixes. You can download SQL Server Management Studio 18.4 today and review SQL Server Management Studio release notes for details.

收录时间: 2019-11-06
分类: SQL Server
贡献者: Rector
18 热度

SQL Server 2019新功能披露:为企业带来改进的智能数据体验

SQL Server 2019 正式版的发布进度有些缓慢,微软先是在 8 月份推出了候选发布(RC),然后经过了一个多星期才推送了稍微更新后的版本。好消息是,在今日召开的 Ignite 2019 大会上,该公司终于谈论了 SQL Server 2019 的大量新功能,以帮助用户更有效地从不同格式 / 来源的数据中获得见解。

收录时间: 2019-11-05
分类: SQL Server
贡献者: Rector
9 热度

SQL Server 2019 is now generally available

As you saw from our launch announcementearlier today, over a year ago at Microsoft Ignite we announcedour first preview of SQL Server 2019 and today our latest releaseis now generally available.You have told us that in today’s demanding world of massive data, wide variety of data sources, and expect...

收录时间: 2019-11-05
分类: SQL Server
贡献者: Rector
68 热度

SQL Server Management Studio is as Relevant as Ever

SQL Server Management Studio is as Relevant as EverAfter fifteen years of heavy usage by developers and DBAs, it might seem like Microsoft’s free tool, SQL Server Management Studio, is about to go out of style. SSMS is no longer the cool new kid on the block: Microsoft has shown consistent effort to...

收录时间: 2019-09-26
分类: SQL Server
贡献者: Rector
91 热度

SQL Server Management Studio 18.3 is now generally available

Today we’re announcing the release of SQL Server Management Studio (SSMS) 18.3. For this update, while we added some features, our focus was primarily on fundamentals such as stability, reliability, and performance.

收录时间: 2019-09-24
分类: SQL Server
贡献者: Rector
112 热度

Understanding SQL Server Deadlocks

This is a continuation of a series of articles I've written on SQL Server concepts.When you work with SQL Server long enough on a database with enough traffic, you're eventually going to encounter deadlocks.This article discusses what deadlocks are, how to interpret deadlock graphs, and some options...

收录时间: 2019-09-13
分类: SQL Server
贡献者: Rector
AD 友情赞助
113 热度

Released: General Availability of Microsoft.Data.SqlClient 1.0

We have released for general availability Microsoft.Data.SqlClient 1.0. This .NET Data Provider for SQL Server provides general connectivity to the database and supports all the latest SQL Server features for applications targeting .NET Framework and .NET Core. To try out the new package, add a NuGet reference to Microsoft.Data.SqlClient in your application.

收录时间: 2019-08-30
分类: SQL Server
贡献者: Rector
107 热度

Release: SQL Server Migration Assistant (SSMA) v8.3

SQL Server Migration Assistant (SSMA) for Oracle, MySQL, SAP ASE (formerly SAP Sybase ASE), DB2, and Access allows users to convert a database schema to a Microsoft SQL Server schema, upload the schema, and then migrate data to the target SQL Server (see below for supported versions).

收录时间: 2019-07-31
分类: SQL Server
贡献者: Rector
127 热度

SQL Server Management Studio 18.2 is now generally available

We are excited to announce the release of SQL Server Management Studio (SSMS) 18.2. For this update, while we added some features, our focus was dedicated to fundamentals such as stability, reliability, performance, etc.

收录时间: 2019-07-28
分类: SQL Server
贡献者: Rector
119 热度

SQL Server 2019 community technology preview 3.2 is now available

We’re excited to announce the monthly release of SQL Server 2019 community technology preview (CTP) 3.2. With this release of SQL Server 2019 community technology preview 3.2, we are announcing the public preview of Big Data Clusters for SQL Server 2019. Big Data Clusters for SQL Server enables big data analytics within SQL Server. It brings HDFS and Apache Spark™ into SQL Server for scale out compute and storage....

收录时间: 2019-07-25
分类: SQL Server
贡献者: Rector
112 热度

SQL: Using CROSS APPLY to replace multi-column predicate look-ups in T-SQL

SQL: Using CROSS APPLY to replace multi-column predicate look-ups in T-SQL...

收录时间: 2019-07-23
分类: SQL Server
贡献者: Rector
143 热度

SQLServer性能优化之---数据库级日记监控

上节回顾:https://www.cnblogs.com/dotnetcrazy/p/11029323.html4.6.6.SQLServer监控脚本示意:https://github.com/lotapp/BaseCode/tree/master/database/SQL/SQLServerPS:这些脚本都是我以前用SQLServer手写的,参考即可(现在用MySQL,下次也整理一下)之前写SQLServer监控系列文章因为换环境断篇了,只是简单演示了下基础功能,现在准备写MySQL监控相关内容了...

收录时间: 2019-07-11
分类: SQL Server
贡献者: Rector
158 热度

SQL Server温故系列(3):SQL 子查询 & 公用表表达式 CTE

子查询是一个嵌套在 SELECT、INSERT、UPDATE 或 DELETE 语句或其他子查询中的查询。通俗来讲,子查询就是嵌套在大“查询”中的小查询。子查询也称为内部查询或内部选择,而包含子查询的语句也称为外部查询或外部选择。从概念上说,子查询结果会代入外部查询(尽管这不一定是 SQL Server 实际处理带有子查询的 T-SQL 语句的方式)。所以子查询会在其父查询之前执行,以便可以将内部查询的结果传递给外部查询... 比较常见的子查询有:单行子查询、多行子查询、相关子查询、嵌套子查询等。然而并没有一种泾渭分明的子查询分类方法,换句话说,有可能某个子查询既是多行子查询,也是相关子查询,同时还是嵌套子查询。

收录时间: 2019-07-09
分类: SQL Server
贡献者: Rector
143 热度

SQL Server 2019 community technology preview 3.0 is now available

We’re excited to announce the monthly release of SQL Server 2019 community technology preview (CTP) 3.0. For customers in the Early Adoption Program, CTP 3.0 is the first release where you’re able to run SQL Server 2019 in production. To apply, please reach out to your assigned Program Manager for more information. Check out the What’s new in SQL Server 2019 preview documentation to learn more.

收录时间: 2019-05-23
分类: SQL Server
贡献者: Rector
189 热度

SQL Server 2016 + AlwaysOn 无域集群

创建集群配置集群的管理名称和管理IP等待配置完成可以查看集群报告,稍后配置文件共享见证创建文件共享见证由于我们是两个节点的故障转移集群,所以需要加上共享文件夹,如果是奇数节点,这一步是不需要做的!配置集群仲裁选择文件共享见证在集群节点之外的一台服务器上创建共享文件夹\\XIANGMU4TEST01\share,并设置 Everyone 完全控制的权限配置

收录时间: 2019-05-22
分类: SQL Server
贡献者: Rector
AD 友情赞助
462 热度

SQL Server Management Studio (SSMS) 18.0 released for general availability

When I joined the SQL Tools team as a PM back in October 2018, my top priority was to release SQL Server Management Studio (SSMS) 18. I expected a fair amount of work but didn’t realize how complicated the process would be. 6 months later, having passed several internal checks such as accessibility, privacy, security, compliance, etc. among many others, and after 5 previews, I am very excited to share that SSMS 18 is now generally available. You can download SQL Server Management Studio 18 today.

收录时间: 2019-04-25
分类: SQL Server
贡献者: Rector
227 热度

SQL Server中编写自动生成指定时间段内按小时的连续的数据列表并按每个小时统计数据的SQL语句示例

在我们编写SQL语句的时候,有可能遇到这样的场景:有一张用户信息表,里面记录和用户的一些数据,如:ID,姓名,创建时间…,为了了解每天每个时段(按小时)的用户创建量数据,我们需要从这张用户信息表的数据来统计。其中有可能用户创建时间的小时部分不是连续的,但统计出来的数据需要按小时连续,缺失的小时使用SQL自动补齐。效果展示先看一下我已经为大家准备好...

收录时间: 2019-04-18
分类: SQL Server
贡献者: Rector
417 热度

【SQL】ROW_NUMBER() OVER(partition by 分组列 order by 排序列)用法详解+经典实例

#用法说明select row_number() over(partition by A order by B ) as rowIndex from table A :为分组字段B:为分组后的排序字段。table 表的结构 多为:  多人 多条的相关数据。(比如:订单信息)此条sql语句,多用于对数据进行分组排序,并对每个组中的数据分别进行编号,编号从1开始递增,每个组内的编...

收录时间: 2019-04-04
分类: SQL Server
贡献者: Rector
183 热度

MSSQL - 最佳实践 - 如何打码隐私数据列

在SQL Server安全系列专题月报分享中,我们已经分享了:如何使用对称密钥实现SQL Server列加密技术、使用非对称密钥加密方式实现SQL Server列加密、使用混合密钥实现SQL Server列加密技术、列加密技术带来的查询性能问题以及相应解决方案和行级别安全解决方案这五篇文章,文章详情可以参见往期月报。本期月报我们分享使用SQL Server 2016 dynamic data ...

收录时间: 2019-03-28
分类: SQL Server
贡献者: Rector
353 热度

【Sql Server】SQL SERVER 递归查询

SQL SERVER 2005之前的版本只能用函数方法实现,SQL SERVER 2005之后新增了CTE功能,可以利用CTE实现递归查询;CTE:公用表达式Common Table Expression 是SQL SERVER 2005版本之后引入的一个特性;#填充测试数据1、sql1 Create table GroupInfo1([Id] int,[GroupName] nvarch...

收录时间: 2018-12-23
分类: SQL Server
贡献者: Rector
AD 友情赞助