culuo4781-CSDN博客

翻译使用自定义报告改善SQL Server 2014中的性能报告–运行和修改报告

the previous part of this article, we introduced SQL Server Management Studio custom reports, showed their advantages over other native performance reporting features, and gave steps to create them. I...

2020-07-29 08:37:09 376

翻译 ansi_nulls_影响查询结果SQL Server SET选项-SET ANSI_NULLS，SET ANSI_PADDING，SET ANSI_WARNINGS和SET ARITHABORT

ansi_nulls SQL Server provides us with a number of options to control SQL Server behavior on the connection level. These session-level options are configured using the SET T-SQL command that change...

2020-07-29 08:26:30 1565

翻译图数据库 graph_通过SQL Server中的自连接了解Graph数据库相对于关系数据库的好处

图数据库 graph Earlier this year, I published several articles on SQLShack with an aim of demonstrating tools available for visualising SQL Server 2017 graph databases. I was so caught up in the excite...

2020-07-29 08:16:25 681

翻译 sql2005关闭c2审核_C2审核–使用C2审核模式SQL Server审核和通用标准合规性

sql2005关闭c2审核 This article will cover SQL Server C2 auditing using C2 audit mode including an introduction, comparison of auditing technologies, configuration and common criteria compliance 本文将介绍...

2020-07-29 08:05:42 2616

翻译使用SQL Server事务复制将SQL Server数据库迁移到Azure SQL数据库

In this guide, we’ll discuss more about migrating a SQL Server database to Azure SQL Database using SQL Server Transactional Replication. 在本指南中，我们将讨论有关使用SQL Server事务复制将SQL Server数据库迁移到Azure SQL数...

2020-07-29 07:55:36 458

翻译清空数据库事务日志_通过事务日志增长加快数据库恢复和长期运行的事务

事务日志还原数据库 In my previous article in this series Accelerated Database Recovery; Instant Rollback and Database Recovery, we talked about a potential DBA painkiller to resolve long waiting times for d...

2020-07-29 07:46:01 957

翻译如何使用损坏或删除SQL Server事务日志文件重建数据库

This is the last article, but not the least one, in the SQL Server Transaction Log series. In this series of articles (see the TOC below), we described the Transaction Log concept from four differ...

2020-07-29 07:35:33 1924

翻译 ssis sql_使用sp_help_revlogin和SSIS传输登录任务将SQL登录名传输到AG的辅助副本

ssis sql In this article, I am going to explain how we can transfer logins to the secondary replica of the Always On availability group using sp_help_revlogin and Transfer Logins Task of the SQL Se...

2020-07-29 07:25:22 5907

翻译 sql server 快照_添加新文章，删除文章，更改快照文件夹路径和SQL Server复制中的数据筛选器行

sql server 快照In the last articles, we have learned Configuring Snapshot and Transactional SQL Server replication and Configuring Peer to Peer and Merge SQL replication. Now, once we configured SQL Ser...

2020-07-29 07:15:04 835

翻译 java代码转置sql数据_SQL Server中的数据科学：数据分析和转换–使用SQL透视和转置

java代码转置sql数据 In data science, understanding and preparing data is critical, such as the use of the SQL pivot operation. In this article, in the series, we’ll discuss understanding and preparing da...

2020-07-29 07:04:23 368

翻译 SQL Server中的数据科学：数据分析和转换–分组和聚合数据I

Previously, in this Data science series, I already tacitly did quite a few aggregations over the whole dataset and aggregations over groups of data. Of course, the vast majority of the readers her...

2020-07-29 06:53:27 441

翻译 SQL Server中的数据科学：数据分析和转换–分组和聚合数据II

You might find the T-SQL GROUPING SETS I described in my previous data science article a bit complex. However, I am not done with it yet. I will show additional possibilities in this article. But be...

2020-07-29 06:44:26 299

翻译如何在SSMS（SQL Server Management Studio）中启用High-DPI –提示，技巧和问题

SQL Server Management Studio (SSMS) is getting better and better with each new release but Microsoft seems to ignore one big issue affecting a group of users that grows rapidly as the technology m...

2020-07-29 06:34:46 1516

翻译 SQL Server中的数据科学：数据分析和转换–合并连续变量

I started to explain the data preparation part of a data science project with discrete variables. As you should know by now, discrete variables can be categorical or ordinal. For ordinal, you have...

2020-07-29 06:25:33 597

翻译修复SQL Server 2016年Microsoft.AnalysisServices.AdomdClientUI.dll程序集错误的前4个选项

I’ve always been in favor of an orthodox strategy when it comes to applying SQL Server updates which often goes like: 在应用SQL Server更新时，我一直都支持正统策略，这种更新通常是这样的： Instead of installing SQL S...

2020-07-29 06:16:31 1525

翻译 sql游标 while_用SQL Server中的排名函数替换SQL While循环和游标，以提高查询性能

sql游标 while SQL While loop and cursor are the most common approach to repeat a statement on condition-based or determined limits. Loop and cursor can be utilized in a circumstance to deal with row-...

2020-07-29 06:06:56 702

翻译 SQL Server事务复制：如何使用SQL Server数据库备份重新初始化订阅

A workload management is considered as a critical aspect of SQL Server transactional replication. Replication is the oldest of the high availability technologies in SQL Server and it is available ...

2020-07-29 05:57:35 1185

翻译使用Microsoft数据迁移助手在Oracle数据库和SQL Server之间迁移的具体示例

介绍 (Introduction)Intended audience 目标听众 This document is intended for application developers and database administrators who plan to migrate an Oracle Database to Microsoft SQL Server. ...

2020-07-29 05:46:55 441

翻译如何使用中央订阅服务器和多个发布者数据库设置自定义SQL Server事务复制模型

In this data-driven era, replication is often a critical requirement for achieving a modern, agile database management environment. It is believed designing an enterprise-grade dataset is the to a...

2020-07-29 05:36:28 214

翻译 offset fetch_SQL OFFSET FETCH功能：使用SSIS使用有限的资源加载大量数据

offset fetch In this article, we illustrate how to use the OFFSET FETCH feature as a solution for loading large volumes of data from a relational database using a machine with limited memory and ...

2020-07-29 05:25:31 880

翻译 SQL Server Management Studio 17.2中的新增功能；身份验证方法，脚本选项等

SQL Server Management Studio is an integrated graphical interface that is used to configure, manage, monitor and administrate the SQL Server instances hosted on the local machine, on a remote serv...

2020-07-29 05:15:59 522

翻译 sql server死锁_如何使用扩展事件和SQL Server代理自动执行SQL Server死锁收集过程

sql server死锁介绍 (Introduction) This article is the last one of a series in which we discussed how to collect data about deadlocks so that we can not only monitor them but also build reports based ...

2020-07-29 05:06:29 528

翻译 dmv 统计数据库io_使用内置功能和动态管理视图（DMV）发现特定于数据库的信息

dmv 统计数据库io 介绍 (Introduction) In the last two articles on dynamic management views in SQL Server, Discovering SQL server instance information using system views and Discovering more SQL Server inf...

2020-07-29 04:56:32 595

翻译使用PowerShell和T-SQL在多服务器环境中规划SQL Server备份和还原策略

介绍 (Introduction) Database availability is critical to every enterprise and conversely, unavailability directly can create a severe negative impact to the business in today’s world. As database a...

2020-07-29 04:45:57 231

翻译 sp_MSforeachtable简介；遍历数据库中的所有表运行命令

介绍 (Introduction) There have always been some undocumented objects in SQL Server that are used internally by Microsoft, but they can be used by anybody that have access to it. One of those object...

2020-07-29 04:35:13 2334

翻译 sql2012 ssrs_如何在SQL Server并行数据仓库中处理SSRS多值参数过滤

sql2012 ssrs Experienced business intelligence (BI) developers would tell you that as you move from one project to another, some requirements start becoming repetitive like you have dealt with them...

2020-07-29 04:25:32 498

翻译如何连续直接将事务日志文件数据审核到SQL Server数据库中

Business transformation requires solid tools to automate complex integration to seamless deployments. In today’s modern data-rich world, nothing is more important than data management, making it c...

2020-07-29 04:15:35 273

翻译如何对两个大型SQL Server数据库中的数据进行快速估计比较，以查看它们是否相等

Bringing impactful analysis into a data always comes with challenges. In many cases, we rely on automated tools and techniques to overcome many of these challenges. 将有影响力的分析纳入数据始终会带来挑战。在许多情况下，...

2020-07-29 04:05:06 1405

翻译使用备份和还原以及SMB协议将SQL数据库从Windows迁移到Linux

In an attempt decouple systems, we may modularize them. In most cases, we would need to move databases from one server to another—sometimes, even move them from Windows to Linux. 为了尝试分离系统，我们可以将它...

2020-07-29 03:54:46 768

翻译 ssms应用程序错误_来自应用程序的查询计划与SSMS不同时的性能故障排除

ssms应用程序错误 Troubleshooting performance issues in a database is one of the main jobs of DBAs and by now most can trace the problem back to a query which is either running to slow or is causing a bl...

2020-07-29 03:44:33 513

翻译登台区无效_使用事务数据复制来重放和测试登台服务器上的生产负载

登台区无效大纲 (Outline) In this article, you’ll see how to simulate production loads on a test server with a “record and replay” type situation using the transaction log, batch scripting, PowerShell an...

2020-07-29 03:35:25 277

翻译并行循环和嵌套循环_并行嵌套循环连接–嵌套循环连接和残留谓词的内侧

并行循环和嵌套循环 This article is the second part of the Nested Loop Join Series. In the first part, Introduction of Nested Loop Join, we gave a brief introduction to Native, Indexed and Temporary Index Ne...

2020-07-29 03:26:21 1215

翻译大数据数据科学家常用面试题_面试有关数据科学，数据理解和准备的问答

大数据数据科学家常用面试题问题1：在数据科学术语中，您如何称呼所分析的数据？ (Q1: In the data science terminology, how do you call the data that you analyze?) In data science, you analyze datasets. Datasets consists of cases, which a...

2020-07-29 03:16:12 1436

翻译使用Azure Data Studio在Docker容器上使用SQL Server 2017进行备份和还原操作

In this 18th article of the series, we will discuss the concepts of database backup-and-restore of SQL Server Docker containers using Azure Data Studio. Before proceeding, you need to have Docker engi...

2020-07-29 03:06:18 806

翻译使用Microsoft数据迁移助手将Oracle数据库迁移到SQL Server –安装过程和简短概述

目标听众 (Intended audience) This document is intended for application developers and database administrators who plan to migrate an Oracle Database to Microsoft SQL Server. 本文档适用于计划将Oracle数据库迁移到...

2020-07-29 02:56:47 942

翻译 sql数据库订阅发布_如何使用中央发布者和多个订阅者数据库设置自定义SQL Server事务复制

sql数据库订阅发布 In this article, you’ll learn how to setup a simple, custom distributed database replication system. 在本文中，您将学习如何设置简单的自定义分布式数据库复制系统。介绍 (Introduction) In general, a typical setup...

2020-07-29 02:46:52 480

翻译 fn_dblog_如何使用fn_dblog和fn_dump_dblog直接在SQL Server数据库中连续读取事务日志文件数据

fn_dblog 大纲 (Outline) In this article, we’ll discuss how to read SQL Server transaction logs. This article should provide and insight into how the workload is being captured in the transaction log...

2020-07-29 02:36:53 4405

翻译 tsql_TSQL的历史

tsqlIn this article, we’ll take a look at a brief TSQL history and a few examples of loops, conditionals, and stored procedures 在本文中，我们将看一下简短的TSQL历史记录以及一些循环，条件和存储过程的示例介绍 (Introduction) TSQL a...

2020-07-29 02:27:30 1214

翻译免费的sql工具_免费SQL工具

免费的sql工具AdminerApexSQL CI/CD toolkitApexSQL CompareApexSQL CompleteApexSQL DecryptApexSQL PlanApexSQL PropagateApexSQL RefactorApexSQL SearchAzure Data Studio (Formerly SQL Operation...

2020-07-29 02:17:08 2567

翻译 sql外键_SQL外键

sql外键 In this article let us review different ways to create a SQL foreign key, rules on updates and deletes, enabling foreign key constraints, disabling foreign key constraints and not for replica...

2020-07-29 02:07:55 7067

空空如也

空空如也