Presentation Tip: Change the Font Size of the Windows Command Prompt

Standard

I have researched about Presentation Tips over past few weeks, one Tip that I read again and again is that “Make Fonts larger for readability”. To that end, I just changed the font size of the command line prompt so that when I am presenting, the audience is able to see what I am typing. So If you’ve have to present to audience something via command prompt, this should be of helps:

1. Open command prompt > Right click near the Title bar > select properties

command prompt change font size

2. switch to font tab > select the font and the size. you can also change the color, layout among other things here.

command prompt change font size font color layout

3. see how it looks:

font size changed command prompt

Conclusion:

In this post, we saw how to change the Font size of the windows command prompt.

your comments are very welcome!

How to Solve: SQL Server 2012 Data Quality Services Does not allow you to export the cleansing or matching results to an Excel file if you are using 64-bit version of Excel

Standard

While I was working with DQS, I got an error that didn’t allow me to export the cleansing results to an excel file. I searched to find that it was a known issue for the 64 bit version of Excel. So based on what I found, this is how I was able to solve the error:

1. Downloaded and Installed the SQL Server 2012 SP1

Downloaded and Installed the SQL Server 2012 SP1

2. Ran the DQSInstaller.exe -upgrade command in the command prompt

Ran the DQSInsaller.exe -upgrade command in the command prompt

That’s about it. And I was able to export the cleansing results to an 64 bit version of the excel file.

Screenshot 1:

export the cleansing results to an 64 bit version of the excel file.

Screenshot 2: