Use SQL Server row-level security for reports with predicate functions and SESSION_CONTEXT, and test every identity boundary.
SQL SERVER – Running SSIS Package From Command Line
How do you run an SSIS package from command line? Use dtexec.exe with the /F option to run the package file and see its start time, end time and progress.
geometry STAsText: Z and M Values Need a Different Export
geometry STAsText returns spatial text without the Z and M values carried by an instance. I compare it with ToString using two points. Identical XY text can hide a difference in the original payload.
SQL SERVER – FIX – ERROR – Service Logon Failure (ObjectExplorer)
Service Logon Failure (ObjectExplorer) stopped my SQL Server Agent from starting. My password had changed, so updating it in the service fixed it.
External Profiles: Keep Email Out of the Key
External profiles need a stable scoped identity key. Keep mutable email values separate and reject duplicate identities.
Checking Data Fits Before Narrowing a Column Data Type
Check existing values before narrowing a column, account for dependencies and data loss, and plan the locking cost of the change.
SQL SERVER – Attending MVP Open Day – May 2011
I am attending MVP Open Day again, May 19 to 22, 2011. Here are my tips to get the most out of this event for Asia Pacific and Greater China MVPs.