LiCongMingDeShujuku

Software engineer working mainly in database technologies。

US, Singapore, HK, China, Taiwan

Pinned Repositories

Automatically-Generate-SQL-Instance-Name-For-Unattended-Config-File
自动为无人参与配置文件生成SQL实例名称
0 2 00
Compare-Local-SQL-Accounts-To-Active-Directory
比较本地SQL帐户与Active Directory
Language:PLpgSQL0 2 00
Create-Custom-SQL-Database-Mirror-Alerts
创建自定义SQL数据库镜像警报
1 2 00
Create-Import-Tables-Automatically-From-Flat-Files
从平面文件自动创建导入表
1 2 00
Does-SQL-Standard-Work-For-AlwaysOn-YES-it-does.
SQL Standard支持AlwaysOn吗？是的！
10
Find-All-Collation-Across-All-Columns
查找所有列的所有排序规则
0 2 00
Find-Last-Few-Days-Of-Query
查找最后几天的查询（Query）
0 1 00
How-To-Visualize-Database-Growth-In-SQL-Server-Using-Excel
如何在SQL Server使用Excel可视化数据库增长
2 2 00
Kill-All-Active-Sessions-In-Database
关闭数据库中的所有活跃会话
0 2 00
Track-Robocopy-Duration-Within-SQL-Server
跟踪SQL Server中的Robocopy的持续时间
0 2 00

LiCongMingDeShujuku's Repositories

LiCongMingDeShujuku/Find-And-Extract-Sharepoint-Files-With-TSQL
使用TSQL搜索并提取Sharepoint文档
Language:TSQL1 2 0
LiCongMingDeShujuku/Find-AWS-Instance-Type-For-Databases
查找数据库的AWS实例类型
1 2 0
LiCongMingDeShujuku/Find-How-Much-Memory-SQL-Server-Needs-within-AWS-Environments
查找SQL Server在AWS环境下需要多少内存
1 2 0
LiCongMingDeShujuku/Find-How-Much-Resources-An-SQL-Process-Is-Using
查找SQL Process正在使用的资源量
1 2 0
LiCongMingDeShujuku/Find-Orphaned-SQL-Data-Files
查找孤立的数据文件
1 2 0
LiCongMingDeShujuku/Find-Orphaned-Users
查找孤立用户
1 2 0
LiCongMingDeShujuku/Find-When-SSPI-Context-Error-Started
查找SSPI Context Error开始的时间
1 2 0
LiCongMingDeShujuku/Get-Alerted-When-Your-Database-Mirror-Operating-Modes-Become-Synchronous-HIGH-SAFETY-
如何在你的数据库镜像模式同步时收到提示(高安全性)
1 2 0
LiCongMingDeShujuku/Get-All-Instance-Ports-In-SQL-Server
获取SQL Server中的所有实例端口
1 2 0
LiCongMingDeShujuku/Get-DayLastAccessed-Across-All-Sharepoint-Sites-With-SQL
使用SQL在所有Sharepoint站点上获取DayLastAccessed
1 2 0
LiCongMingDeShujuku/Get-Notified-If-Your-Backups-Are-Older-Than-One-Day
关于如何做到当你的备份超过一天，你会收到通知。
1 2 0
LiCongMingDeShujuku/Get-Number-Of-Cores-In-SQL-Server
获取SQL Server中的内核数量
Language:TSQL1 2 0
LiCongMingDeShujuku/Get-SQL-Mirror-Status-Across-All-Databases
获取所有数据库的SQL镜像状态
1 2 0
LiCongMingDeShujuku/Get-Total-Database-Size-for-All-Databases-On-Server
获取服务器上所有数据库的总数据库大小
1 2 0
LiCongMingDeShujuku/Installing-Sharepoint-2016-on-Windows-Server-2012-R2-using-SQL-Server-2014-SP1-CU6-
使用SQL Server 2014 SP1-CU6第1部分在Windows Server 2012 R2上安装Sharepoint 2016
1 2 01
LiCongMingDeShujuku/Netbackup-Verification-With-SQL
SQL中的Netbackup验证
1 2 0
LiCongMingDeShujuku/Prep-For-AlwaysOn-Configurations-With-This-Restore-Logic
用这个还原逻辑为AlwaysOn配置做好准备
Language:TSQL1 2 0
LiCongMingDeShujuku/Prestage-Cluster-Configuration-Find-The-OU
Prestage群集配置 - 查找OU
1 2 0
LiCongMingDeShujuku/Query-Active-Directory-Quicky-With-ADSI-Linked-Server
使用ADSI链接服务器快速查询Active Directory
Language:TSQL1 2 0
LiCongMingDeShujuku/Restoring-SQL-Server-Databases-To-RDS-Surprise-
将SQL Server数据库还原到RDS？
1 2 0
LiCongMingDeShujuku/Setting-Default-Folder-For-CMDER-Using-Windows
使用Windows为CMDER设置默认文件夹
1 2 0
LiCongMingDeShujuku/Solution-To-Revoke-Permissions-Error
撤消权限错误的解决方案
1 2 0
LiCongMingDeShujuku/SQL-Cleanup-Task-For-Sharepoint-AuditData-Table
Sharepoint AuditData表的SQL清理任务
1 2 0
LiCongMingDeShujuku/SQL-Solution-For-Using-The-Correct-AWS-Instance-Type
使用正确的AWS实例类型的SQL解决方案
1 2 0
LiCongMingDeShujuku/Compare-Local-SQL-Accounts-To-Active-Directory
比较本地SQL帐户与Active Directory
Language:PLpgSQL0 2 00
LiCongMingDeShujuku/Find-All-Collation-Across-All-Columns
查找所有列的所有排序规则
0 2 00
LiCongMingDeShujuku/4-Ways-To-Check-Boot-Time-With-TSQL
4种用SQL检查启动时间的方法
Language:TSQL2 0
LiCongMingDeShujuku/Backup-All-Databases-To-Share-Location
备份所有数据库以共享位置
Language:TSQL2 0
LiCongMingDeShujuku/Basic-Way-To-Create-ModifedDate-Column-In-SQL
关于在SQL中创建ModifedDate列的基本方法
Language:TSQL2 0
LiCongMingDeShujuku/Find-Time-Between-Database-Create_Date-And-Restore_Date-With-SQL
查找数据库Create_Date和Restore_Date之间的时间
2 0