I was trying to create a demo for one of my experiment, and I had to make create duplicate database for that purpose because I didn’t wanted to do tests on my TestDB so quickest option was to use “Copy Database” feature in SSMS, because other option like restoring backup of DB with another name
Tag: How To
SQL Server with in-memory TempDB
Today, I did some experiment with SQL Server. I have been using an awesome tool called RamDisk now and then for experiments. It allows to use RAM as a HDD !! So if you have enough RAM you can throw some RAM to this tool (free version has 4Gb max limit) and you will get
DOS: Execute and Kill Applications from Command prompt
Yes, I just refuse to use PowerShell (just yet). I know that powershell can do this and that and god MSFT knows what not but with all these bells and whistles doesn’t come at cheap price. I mean if something works just fine and smooth then why you actually need to use something new. It
Managing Orphaned database users in SQL Server
It one of the most common issue you will face when you will move/copy your database from one server to another server. You will have all finely setup SQL Server Logins and their related database users but when you copy or move your database those Server Logins will not get transferred automatically. Result is what
Change default port in Apache
This quick post is about changing default port in Apache. Say if you wanted to work with IIS and Apache both. Now, both web server uses port 80 and so you can’t have both of them at the same time. So one has to sacrifice it’s favorite port . In my case it was Apache
SSRS 101: Deploying Reort in BIDS–Part II
Ok, in first part we walked though creating basic report for SSRS using Business Intelligence Development Studio (BIDS),which was kind of an easy process I guess . Next step is every easier, which is deploying that report to report server so others (those who have permission) can access it. For deployment of report you will
SSRS 101: Creating Basic Report in BIDS–Part I
Ok, so after some initial struggling of setting up whole environment for SSRS to work smoothly and after getting some sample data I am finally ready to begin my epic journey to SSRS (it is epic for me because most of the stuff that I am going to learn will be myself and I will