SQL Archives - Daniel Bs Tech Blog

New TechNet is way better than Old TechNet

29 October 20138 May 2024Daniel B

TechNet (to a lot of IT Pros out there) was THE subscription service that offered you near unlimited access to Microsoft products that allow you […]

fixes small business server SQL windows server

SBS 2008 Sqlservr.exe High Memory Usage

26 June 20103 November 2022Daniel B

Open an Administrative Command Prompt. Type: osql -E -S \.pipeMSSQL$MICROSOFT##SSEEsqlquery Now at the SQL prompt, type: 1> sp_configure ‘show advanced options’,1 2> reconfigure with override […]

command-line fixes linux SQL

Restoring entire SQL Database from file

6 June 20093 November 2022Daniel B

One night I had to restore my entire SQL database server from a SQL file, but it took me a while to find how to […]