Remote MSSQL…oh, you imbecil! :)

Not very often, you will get the following error: Error: The server principal “” is not able to access the database “” under the current security context. This is because the MS SQL Server is attempting to execute a SQL query to retrieve a list of databases along with  some other formation about those databases. […]

SpamBots+bad application+SQL server = PROBLEMS!

So…today I had a very interesting issue. All of a sudden Nagios went red with the message: CRITICAL : – total: 232.82 Gb – used: 212.67 Gb (91%) – free 20.15 Gb (9%) on one of our SQL server. I was like..”NO! It cannot be. I clearly remember that this machine had over 150 Gb […]

Automating backup of databases in SQL Express.

Microsoft SQL Server 2005/2008 Express is a free edition of SQL Server that is ideal for learning, developing and powering desktop, web and small server applications, and for redistribution by ISVs. Top Features Supports stored procedures, triggers, functions, and views Store all kinds of business data with native support for relational data, XML, FILESTREAM and spatial […]

Setuping a server for web hosting – part 2: Installing SQL 2008 Express

Hello there… In order to  install SQL 2008 Express, we have to download it first . Fire up your favorite browser and point it to http://www.microsoft.com/express/download/ . After that, find the box with the SQL 2008 Express, and click download. On the next step you have the option to register with Microsoft or download the […]

Installing IIS on Windows server 2008 R2 Standard – video tutorial.

Hi, last couple of days I have setuped over 10 Windows 2008 servers for hosting services for testing or production, so I am pretty bored with repeating the same stuff all over again 🙂 , but, here’s a recorded video tutorial of one installation process. Because the video is pretty straightforward, I’ve decided that there […]