MS SQL General Instance Information

SQL – Linked Server xp_prop_oledb_provider error

Windows 8 Tips & Tricks

SQL Server Reporting Service (SSRS) – Use email friendly name

I had my SSRS running smoothly, but there was one thing bothering me. That was email sender friendly name. In RS Configuration Manager you can setup e-mail settings, and enter senders e-mail address. But every time I got an email with report, the sent from stated sql@sqlreports.com. But I need an friendly name. So, I …


Windows – enabling DELETE confirmation dialog

  I don’t know why, but for some reason, my Windows 8, has disabled DELETE confirmation dialog. So this is little know how, how to enable it. Right click on Recycle Bin, then properties. And, on the bottom you can enable Display delete confirmation dialog   Good Luck


MOBILE PHONE – Prestigio PAP4300 Duo

Hi, this short post will be about my new phone, a little review after couple of weeks of owning it. LINK   This mobile phone is on Android 4.0 OS. It works with dual SIM cards, and the price is reasonable. Plus sides: Price cca 200€ – very very reasonable price SIM Manager – handles …


SQL – Getting list of jobs and their steps

How to get list of jobs an their steps. For this I will use three tables dbo.sysjobs, dbo.sysjobsteps and dbo.sysjobschedules in msdb database. You can create select from each of these tables to get relevant data. select name,enabled,description from msdb.dbo.sysjobs select job_id,step_id,step_name,command,database_name from msdb.dbo.sysjobsteps select job_id,next_run_date,next_run_time from msdb.dbo.sysjobschedules   But we can combine these three …


SQL- Creating linked server to AS400

Have you ever tried to connect to AS400. It’s been a hassle for me. But finally I got it to work, so let me share little of my wisdom with you. First create linked server, then change options to it. EXEC master.dbo.sp_addlinkedserver @server = N’AS400′, @srvproduct=N’i520′, @provider=N’IBMDA400′, @datasrc=N’AS400′, @provstr=N’User Id=USER;Password=PWD;Default Collection=DAT;’ Change option: USE [master] …


SQL – Table comparison

MSSQL – how to send notification to multiple users

Recently, I was asked a question, how to send notification to multiple users. First you must create operator in SQL Agent. In field “E-mail name:” you enter multiple e-mails, divided by semicolon (;). And then you just have to set notifications in Agent Job Good Luck


Activate Windows 8 Enterprise

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, …