最新 | 最热门 | 最高评价

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

Tag: Linux | SQLServer | Technology
Haidong Ji 发于 2016年11月18日 11:42 | 点击: 669 | 展开摘要
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 | 点击: 454 | 展开摘要
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 | 点击: 480 | 展开摘要
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 | 点击: 514 | 展开摘要
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 | 点击: 1039 | 展开摘要
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 | 点击: 920 | 展开摘要
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 | 点击: 1096 | 展开摘要
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 | 点击: 4032 | 展开摘要
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 | 点击: 1227 | 展开摘要
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

+0  Determining if a Windows host is a VM in JiMetrics

Tag: PowerShell | SQLServer | Technology | Windows
Haidong Ji 发于 2014年02月20日 12:34 | 点击: 2725 | 展开摘要
I’ve been using my own SQL Server metrics collection package called JiMetrics for a couple of years. It is easy to set up. All you need are just two things: SQL Server instance and an account that has admin access to both the servers

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

+0  Introducing JiMetrics

Tag: SQLServer | Technology | Windows
Haidong Ji 发于 2013年11月06日 11:30 | 点击: 2616 | 展开摘要
For the impatient, here is the link to JiMetrics web site, where you can get the scripts and get going. To learn why it is called JiMetrics, you will have to read all the way to the end.

During the last couple of years, I’ve been wor

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

+0  Install sqlps as a PowerShell module

Tag: PowerShell | SQLServer | Technology | Windows
Haidong Ji 发于 2013年02月16日 11:53 | 点击: 2611 | 展开摘要
Most of SQL Server automation scripts using PowerShell use SMO directly. For example, one would do something like:

[System.Reflection.Assembly]::LoadWithPartialName(“Microsoft.SqlServer.SMO”)

$MyServer = new-object (‘Mic

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