最新 | 最热门 | 最高评价

+0  从 SQL Server 到 MySQL(三):愚公移山 - 开源力量

Tag: SQLServer | MySQL | DB-Migration
alswl 发于 2018年06月20日 20:18 | 点击: 352 | 展开摘要
我们用了两章文章
从 SQL Server 到 MySQL(一):异构数据库迁移
/
从 SQL Server 到 MySQL(二):在线迁移,空中换发动机
介绍我们遇到问题和解决方案。
不管是离线全量迁移还是在线无缝迁移,
核心 ETL 工具就是 yugong。

Yugong 是一个成熟工具, 在阿里巴巴去 IOE 行动中起了重要作用,
它与 Otter / Canal 都是阿里中间件团队出品。
它们三者各有分工:
Yugong 设计目标是异构数据库迁移;
Canal 设

查看全文: http://www.udpwork.com/item/16913.html

+0  从 SQL Server 到 MySQL(二):在线迁移,空中换发动机

Tag: SQLServer | MySQL | DB-Migration
alswl 发于 2018年05月21日 11:24 | 点击: 533 | 展开摘要
(image via https://pixabay.com/en/military-stealth-bomber-refueling-602729/ )

在上篇文章
从 SQL Server 到 MySQL (一):异构数据库迁移 - Log4D
中,我们给大家介绍了从 SQL Server 到 MySQL 异构数据库迁移的基本问题和全量解决方案。
全量方案可以满足一部分场景的需求,但是这个方案仍然是有缺陷的:
迁移过程中需要停机,停机的时长和数据量相关。
对于核心业务来

查看全文: http://www.udpwork.com/item/16851.html

+0  从 SQL Server 到 MySQL(一):异构数据库迁移

Tag: SQLServer | MySQL | DB-Migration
alswl 发于 2018年03月12日 21:08 | 点击: 637 | 展开摘要
背景

沪江成立于 2001 年,作为较早期的教育学习网站,
当时技术选型范围并不大:
Java 的版本是 1.2,C# 尚未诞生,MySQL 还没有被 Sun 收购,
版本号是 3.23。
工程师们选择了当时最合适的微软体系,并在日后的岁月里,
逐步从 ASP 过度到 .net,数据库也跟随 SQL Server 进行版本升级。

十几年过去了,技术社区已经发生了天翻地覆的变化。
沪江的技术栈还基本在 .net 体系上,这给业务持续发展带来了一些限制。
人才招聘、社区生态、

查看全文: http://www.udpwork.com/item/16721.html

+0  Initial impressions of SQL Server v.Next Public Preview

Tag: Linux | SQLServer | Technology
Haidong Ji 发于 2016年11月18日 11:42 | 点击: 1804 | 展开摘要
Microsoft announced its SQL Server on Linux public preview yesterday. I’m really excited to check it out. Here are some interesting things I found during my testing. I’ll write more as I play with it further.

If you want to pla

查看全文: http://www.udpwork.com/item/15928.html

+0  Changing non-nullable column to nullable in SQL Server is quick and painless

Tag: SQLServer | Technology
Haidong Ji 发于 2016年09月19日 02:35 | 点击: 838 | 展开摘要
In T-SQL, you can only ALTER COLUMN one at a time. Initially I was worried about operational cost of this change, but it turned out this change is instantaneous.

Mind you, I’m not suggesting you should do this without a good reason.

查看全文: http://www.udpwork.com/item/15834.html

+0  No 32-bit for SQL Server 2016 Express

Tag: SQLServer | Technology | Windows
Haidong Ji 发于 2016年09月01日 23:43 | 点击: 1106 | 展开摘要
I’ve learned that SQL Server 2016 Standard and Enterprise Editions no longer provide 32-bit. But I do wonder about SQL Server 2016 Express Edition. It’s different in that it’s free, and mostly geared toward lightweight usa

查看全文: http://www.udpwork.com/item/15773.html

+0  SQL Server best practice: grant permissions to per-service SID

Tag: SQLServer | Technology | Windows
Haidong Ji 发于 2016年05月20日 13:03 | 点击: 922 | 展开摘要
Since Windows Server 2008/Windows Vista, from SQL Server 2008 onward, SQL Server installation process automatically generates per-service security identifier (SID). Whenever possible, it is recommended to grant rights to this service SID fo

查看全文: http://www.udpwork.com/item/15510.html

+0  Grant full permission to Windows folders and files

Tag: PowerShell | SQLServer | Technology | Windows
Haidong Ji 发于 2015年01月21日 02:13 | 点击: 1405 | 展开摘要
For a Windows application or service, it is often necessary for either the user or service startup account to have full control to its folders and files. In most cases, this is transparent to the user. It is generally being taken care of by

查看全文: http://www.udpwork.com/item/13775.html

+0  Script to generate index rebuild with PAGE compression

Tag: SQLServer | Technology
Haidong Ji 发于 2014年08月29日 00:05 | 点击: 1140 | 展开摘要
For BI data warehouse databases, since the data does not change much and they typically require a lot of space, it makes a lot of sense to compress the indexes to save space.

I came across some BI databases whose indexes were created witho

查看全文: http://www.udpwork.com/item/13178.html

+0  JiMetrics now gathers SQL Server startup account

Tag: PowerShell | SQLServer | Technology | Windows
Haidong Ji 发于 2014年06月17日 09:26 | 点击: 1453 | 展开摘要
During the last few days, I’ve refactored JiMetrics and added a new function:

Used Pester to create more test cases for PowerShell functions I wrote;

Enhanced the design and code so JiMetrics also gathers SQL Server instance’s

查看全文: http://www.udpwork.com/item/12637.html

+0  Removing duplicate rows in small batches based on date column

Tag: SQLServer | Technology
Haidong Ji 发于 2014年04月08日 12:19 | 点击: 4251 | 展开摘要
Due to double scheduling, some duplicate rows were inserted into the Windows.TableStats table in JiMetrics. To confirm that the table has duplicates, here is the T-SQL script I used. Note that this same script should work in all other major

查看全文: http://www.udpwork.com/item/12099.html

+0  Collecting Windows BIOS and Host Serial Number

Tag: PowerShell | SQLServer | Technology | Windows
Haidong Ji 发于 2014年02月21日 09:38 | 点击: 1593 | 展开摘要
After imporving JiMetrics yesterday so it tries to determine if the host is a VM or not, I made another improvement today: collecting host server BIOS related information and serial number.

I don’t know about you, in the past when I

查看全文: http://www.udpwork.com/item/11752.html
|<<<12>>>| 一共2页, 17条记录