Since I started to work with GitHub (better late then never) I’ve uploaded couple of my Zabbix templates to Github. lukagros/Zabbix-templates: For my custom Zabbix templates (github.com) I’ve created couple of Zabbix templates for monitoring IBM Storwize and IBM TS3200 tape librarySystem Center Orchestrator Runbooks via MSSQLSystem Center Service Manager DWH jobs and WorkflowsWindows Updates …
I recently installed Windows 8 Enterprise in my company. During the installation, setup does not require input of serial number/key. So when Windows installs, you must go through procedure of changing the key, and activating Windows. So here it goes. On Desktop, go with your mouse to bottom left corner. When Start icon pops up, …
I tried to find out how to connect through SMSS to SQL server as another domain user. You must run SMSS as “RUN AS..” so the code is as follows: runas /netonly /user:domain\user “C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe” EDIT:!! Due to version changes: %windir%\System32\runas.exe /netonly /user:domain\user “C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe -S SERVER” EDIT!! When …
When you are working with custom software over your database, you can easily find some data you need to clean up. It can be trash from poorly written code, or users can write rubbish if no controls are established. So next couple of posts will be about searching and updating this kind of trash values. …
Few months ago, I was given a task to send some notifications via circular letter. The best thing is to send it by MS WORD. Unfortunately, after sending this, the attachment could not be read on the recipients side. Me and my colleague could not understand, is it because WORD or attachment or in the …
MSSQL has a service called Database mail and it is used from MSSQL 2005 till today. This service is predecessor of SQL Mail. I will write about Database mail, and how to set it up. First of all, you have to open a port 25 (SMTP), so you can send mail from server to the …
As I wrote earlier in my blog post Working with Batch, we had a problems connecting to all computers in our branch offices. Since we live on VPN, provided by ISP on his modems/routers, there was always war with theirs technicians. First of all, we had an old software Symantec PCAnywhere 11 which we used …
I have a little Acer Revo without a CD-ROM. External CD-ROM is expensive, so I reinstalled my little PC from USB stick. First, you have to have a stick not smaller than installation CD/DVD of Windows 7 or 8. Next, motherboard must support Boot from USB so you can boot to setup. The procedure goes …
We all need space…. Once upon a time I had a 250GB HDD, and it was back then large. Everything I needed was on that disk. But as the files grew, so did my hard got smaller. On that disk, I have lot of pictures and music, maybe some movie and bunch of documents. Suddenly …
This article shows how to create a folder for backup. The idea is to create folder with date part in its name, and then backup a specific database to that folder. First we need to create a parameters to save our SQL command in it. use master declare @sql1 nvarchar(max) declare @sql2 nvarchar(max) declare @var1 …
Sometimes its a necessity to rename a SQL server or SQL server instance. I had to rename it couple of times in my IT career. These are steps that I made. step1 : exec sp_dropserver ‘oldserver’ exec sp_addserver ‘newserver’,’local’ step2 : restart the sql server and check whether below query output is same or not …