Visual Studio is an application that is used by many developers and it has different kinds of features that can facilitate the developer’s work. Among these features, Visual Studio offers users ...

介绍 (Introduction)CSV (comma separated values) is one of the most popular formats for datasets used in machine learning and data science. MS Excel can be used for basic manipulation of data in CS...

json 转对象函数In this article, we will explore JSON_QUERY() functions in SQL Server to extract JSON objects and array from theJSON Data.在本文中，我们将探索SQL Server中的JSON_QUERY（）函数，以从JSON数据中提取JSON对...

创建jira sprintSCRUM is a great way to manage all sorts of tasks including sprints, but you don’t have to purchase expensive software packages to burn one. Excel is a great tool for rolling your own...

Microsoft recently released a new and interactive command-line query tool for SQL Server with modern features such as auto-completion and syntax highlighting. It’s called mssql-cli and this fully ...

sql server分布式 介绍 (Introduction)The Microsoft SQL Server Distributed Replay feature has been provided by Microsoft since SQL Server 2012 and it is used to replay captured traces against an upgrade...

数据文件shrinkThis article explores the usage of TempDB and different ways to shrink the TempDB database in SQL Server本文探讨了TempDB的用法以及在SQL Server中缩小TempDB数据库的不同方法Each instance of Micros...

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...

@sql 单元测试SQL unit testing is a testing method which allows us to test the smallest, atomic programmable part of a database object. SQL unit testing plays a key role in the modern database developm...

事务日志还原数据库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...