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 …
When you are building or creating rudimentary BI for someone, there are always some parameters you have to embed in your query. But, almost always there is date to date parameters. So, it is very helpful to have a calendar table, where you know which days are weekends, which days are working days, what week …
Couple of years ago, we had a problem with custom software. The problem was, how to install new version of software (size around 60MB+), only on main computers in our branch offices, which are over 60 locations. Since we don’t have in house programmer, we needed a solution. Solution by now, was connecting to remote …
Ok, so let’s start with my first blog. Couple of days ago, I’ve been given a task to migrate some tables from AS400 to SQL. So first of all, you would need a connector (provider) to IBM AS400 structure. So that connector comes with IBM iSeries Access software. After quick and “select All option” installation, …
Let me introduce my idea of this blog post. This should be a little help for all you DBA and IT admins. Little tips and tricks on HOW TO.. So for now, I have to get my thoughts together and think of a couple of thing I did that made my life easier. Best regards …