I have to admit, I’m a proud owner of the MS Surface 3 Pro running an i7 under its hood. It’s my first Windows Tablet, so I do not have references to any of the previous devices. So I’m just giving my personal opinion.
Tag: microsoft
Goodbye Windows 8
I’m fed up with Windows 8 on my Lenovo W530 and the troubles I am facing. To name a few: No support for the color calibration sensor by pantone, VMware vSphere only works with a few hacks (and doesn’t show consoles),… I have to admit, Microsoft did a few new good things with Windows 8, but all in […]
MSSQL Emergency Mode
There are a few undocumented things about the MSSQL Server 2000 missing in the knowledgebase of Microsoft. That’s a way to get a database marked as suspect into emergency mode: use[master] go execute sp_configure ‘allow updates’,1 reconfigure with override go update sysdatabases set status =32768 where name =” go
MS-SQL Recovery
There are two kinds of customers: The ones who do backups and those who didn’t have data loss yet, ignoring all good advice and best practices. However, in the end it’s always us, the IT crowd being yelled for to look at the shards and doing a miracle. A broken database at the MSSQL server is marked as […]
MSSQL vs Access via JET/ODBC
If you are dealing with a greater amount of records in a Microsoft Access database, it’s recommended to use a SQL server as a backend database to handle those and get rid of unpleasant surprises. Usually those servers are connected via JET/ODBC – and that’s where the fun starts.
Who’s connected to my MSSQL server?
Today I was trying to restore a backup of our MSSQL server when a user decided to drive me crazy by not disconnecting after telling anyone that we need to do that restore. So I fired up the management studio and had a look at the current processes by using the following query: select spid, status, loginame, hostname, […]