A quickie today regarding Microsoft Dynamics NAV 2013 Beta that was recently released for testing. I downloaded the DVD, extracted it, and ran the setup. In particular I was interested to see the Web Client in action. The installer recorded that I was missing “Windows Authentication” from my IIS setup. Once I had added this, [...]
Author Archive
Using Automation With the RoleTailored Client
Today we had a scenario where there was a lot of confusion as to where code is running in the Role Tailored Client. Is the code running on the service tier, or in the Role tailored client ? This had mainly to do with file access, and finding whether the server file or the client [...]
Script Data in SQL Server
From SQL 2008 R2 onwards, the generate scripts wizard has had the option to script data. This will generate INSERT statements for each row in the specified table. This can be used as opposed to bcp or SSIS, and is quite useful to copy objects and data in one quick step. Here is a screenshot [...]
SQL Server 2011 (CTP) AKA Denali
Tonight I installed SQL Server 2011 (CTP1) – AKA SQL Denali. It installed side by side with my SQL 2008 R2 instance. Management studio looks very similar so far some buttons seem to be smaller and different grouping, but I will post my findings as we go through it. A few new things I noticed: [...]
Logging into SQL Server when forgetting the SA password
If you ever manage to get locked out of your SQL installation, i.e. no-one knows the SA password, and even people in the Administrators group on the local PC cannot access SQL with Windows Authentication, there is a workaround to setup a new login or reset passwords.This relies on the following: Being a Local Administrator [...]
