最新 | 最热门 | 最高评价

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

Tag: SQLServer | MySQL | DB-Migration
alswl 发于 2018年06月20日 20:18 | 点击: 2241 | 展开摘要
该系列三篇文章已经全部完成:

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

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

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

201806/refactor.png

我们用了两章文章 从 SQL Server 到 MySQL(一):异构数据库迁移 / 从 SQL Server 到 MySQL(二):在线迁移,

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

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

Tag: SQLServer | MySQL | DB-Migration
alswl 发于 2018年05月21日 11:24 | 点击: 2204 | 展开摘要
该系列三篇文章已经全部完成:

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

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

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

flying-tanker

(image via https://pixabay.com/en/military-stealth-bomber-refueling-602729/ )

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

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

Tag: SQLServer | MySQL | DB-Migration
alswl 发于 2018年03月12日 21:08 | 点击: 2250 | 展开摘要
该系列三篇文章已经全部完成:

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

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

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

201803/migration-bird.png

背景

沪江成立于 2001 年,作为较早期的教育学习网站, 当时技术选型范围并不大: Java 的版本是 1.2,C# 尚未诞生,

查看全文: 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 | 点击: 3510 | 展开摘要
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 | 点击: 2436 | 展开摘要
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 | 点击: 2607 | 展开摘要
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 | 点击: 2186 | 展开摘要
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 | 点击: 2752 | 展开摘要
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 | 点击: 2148 | 展开摘要
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 | 点击: 2928 | 展开摘要
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 | 点击: 5372 | 展开摘要
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 | 点击: 2931 | 展开摘要
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条记录