-
Grant full permission to Windows folders and files
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 various delegation mechanisms behind the scene. However, this can be a…
-
sed tricks
I helped a charity to rebuild a MySQL server and to restore a database with a lot of data of longblob type in the last two days. Fortunately there was a dump backup file for the database in question. However, tables with longblob column(s) were not defined with “ROW_FORMAT=COMPRESSED”. I’d like to restore that database…
-
Script to generate index rebuild with PAGE compression
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 without compression. We are in the process of migrating those databases to…
-
JiMetrics now gathers SQL Server startup account
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 startup account, which can be useful. If you don’t know what JiMetrics is, go to this page to…
-
Speaking at SQLSaturday Chicago
I will deliver a session for SQLSaturday this coming Saturday, April 26th. I will be discussing “Big Data”: cloud computing, distributed computing, column-store databases, in-memory OLTP databases, Hadoop, machine learning, and data analytics. Hope to see you there.