PowerShell: List Installed Software on Local Computer in .CSV File

I had to collect the installed software from few computers and i used Belarc Advisor. The fun came when i started to consolidate the data :-) To make my future life easier, i wrote a PowerShell script that exports a list of the installed programs into .CSV file. Here it […]

Share

T-SQL: (Migration) Export the definition of Stored Procedures

Very often we need to bulk export database objects and move them to another server. Manually we do this by right click on the database –> Tasks –> Generate Scripts… In this example I show how we can export Stored Procedures with T-SQL and SQLCMD. This model gives us the […]

Share

Training: SQL is the top demanded programming language

Few days ago Business Insider posted a list of 8 in-demand programming languages. The big news is that SQL is number 1! Codingdojo report spots SQL as the best programming language to learn, based on the number of job postings on Indeed. Finally I decided to check the average salary for SQL Developer […]

Share

T-SQL: NVARCHAR(255) vs. NVARCHAR(MAX) Disk Space Comparison

In some scenarios like ETL or load data into a DB, we need to insert the data into a staging table, where all the columns are String data type and on the next step to cleanse and manipulate the data. I heard a discussion about the data type of the […]

Share