Recently I got a call from an old friend I used to call “DJ”. Here is the exact conversation we had about SQLCMD.
SQL SERVER – SQL Server Compression Estimator
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.