Continuing on my previous post Get Session Count over multiple NST’s I decided to make a little PowerShell function of it.
Sometimes you need to see for different instances how many sessions are connected. You could achieve this with piping multiple PowerShell statements into each other, but not always.
We all had our fair share of database we were locked out of, because a user added himself and no other users to a database. In that case, we have 3 options to gain access to the database. One of … Continue reading
Giving SQL Server permissions was not always secure in the past… When a user needed to be able to upload objects, they actually needed the db owner role. Which isn’t actually something that you always want. Since NAV2013 it has … Continue reading
I’m back again with one of my Bootcamp notes. This time a few points about optimizing for SQL Server. There have been a lot of changes on SQL Server. It is no longer using cursors through OLE DB to connect, … Continue reading