I recently come across an interesting tool called ‘SQL Server Compression Estimator’. I find this tool very interesting. This tool is a pretty decent tool and I used it on a couple of my personal server and it gave me a good estimate.
SQL SERVER – Import CSV File into Database Table Using SSIS
It is very frequent request to upload CSV file to database or Import CSV file into database. I have previously written article how one can do this using T-SQL over here SQL SERVER – Import CSV File Into SQL Server Using Bulk Insert – Load Comma Delimited File Into SQL Server.
SQL SERVER – expressor 3.2 Release Review
I have been following expressor software for some time now and they have recently released a new version of their expressor Studio desktop ETL application. I am pleased to find out that the download and installation experience of this application has been greatly simplified. expressor Studio no longer requires users to install a license key after they download and install the product. They have also eliminated a Microsoft Visio dependency from their product. Removing the license requirement and Visio dependency has made download and installation much easier.
SQL SERVER – Interview on Wait Types and Wait Queues – SQL Doctor
Earlier this year I have written a whole month on the subject SQL Server Wait Types and Wait Queues SQL SERVER – Summary of Month – Wait Type – Day 28 of 28. The focus of this series was very simple – define a problem and solve it. I learned a lot while I wrote this series. While I am writing this blog, I am very much delighted that SQL Doctor team of Idera software is very kind to implement a few of the tricks from the blog post.
SQL SERVER – CTAS – Create Table As SELECT – What is CTAS?
I have been working with the database for many years and I am aware of many common terminologies. Recently I was attending training myself and the instructor used the word ‘CTAS’ in the class. One of the attendees did not know the definition of this abbreviation. From this, I realized that not all of us come from the same background and we all have different levels and areas of expertise.
SQL SERVER – How to Use Decode in SQL Server?
One of the reader of the blog has sent me question regarding how to use DECODE function in SQL Server.
SQL SERVER – Making Database to Read Only – Changing Database to Read/Write
I recently received the following comments on my earlier blog about Making database to read only.
“Today i was trying to attach the (MDF,NDF,LDF ) sql server 2008 database which i have received from my client. After attachment the database status is showing (Read-Only) (Eg.database name (Read-Only). How do i make to normal mode for the data updation. is there any query available to resolve this problem. Your help will be highly helpful.”
Let’s learn Making Database to Read Only and Changing Database to Read/Write.