Friday, October 25, 2013

How to find out what version of SQL you are running.

Open SQL Management Studio
Create a new query
"select * @@version"
Execute.



If you find this article useful please leave me a comment or click on an ad to show your support.

Monday, October 21, 2013

Poweshell Send-MailMessage, sending an e-mail in one line of code

In powershell 2.0 you would of had to write function to send an e-mail from powershell. Lucky for us in Powershell 3.0 it's

Poweshell 3.0 
Send-MailMessage -To $Mailto -From "XYZ@XYZ.com.au" -Subject "XYZ" -SmtpServer "XYZ" -Body "TEST" -Attachments XYZ.csv

Powershell 2.0
Sendmail
 function sendMail{
     Write-Host "Sending Email"
     #SMTP server name
     $smtpServer = "smtpXXXX"
     #Creating a Mail object
     $msg = new-object Net.Mail.MailMessage
     #Creating SMTP server object
     $smtp = new-object Net.Mail.SmtpClient($smtpServer)
     #Attachment
     $att = new-object Net.Mail.Attachment($OUTfile)
     #Email structure
     $msg.From="test@XYZ.com.au"
     $msg.ReplyTo ="test@XYZ.com.au"
     $msg.To.Add("XYZ.XYZ@XYZ.com.au")
     $msg.subject = "TEST"
     $msg.body = "This is the email Body."
     $msg.Attachments.add($att)
     #Sending email
     $smtp.Send($msg)
     $att.Dispose()

}
I like the Powershell 3.0 version better.


If you find this article useful please leave me a comment or click on an ad to show your support.

Saturday, October 19, 2013

Fix Blurry or non-smooth fonts in 8.1 and chrome

After upgrading to Windows 8 and trying to use chrome I noticed that the fonts in Chrome became very hard to read. The text was blurry.

Simple to fix
  1. Right-click on Desktop and select "Screen resolution" option.
  2. Now click on "Make text and other items larger or smaller" link.
  3. Enable "Let me choose one scaling level for all my displays" option and apply the changes.
  4. Sign out and sign back in to Windows 8 and this should resolve your issue 
If you find this article useful please leave me a comment or click on an ad to show your support.

Friday, October 11, 2013

Microsoft's Gadgeteer aims to make creating gadgets as simple as building with Lego | ZDNet

Microsoft's Gadgeteer aims to make creating gadgets as simple as building with Lego | ZDNet:

'via Blog this'

If you find this article useful please leave me a comment or click on an ad to show your support.

How to get SSRS reports working in Google Chrome


  1. On your SSRS server locate the  ReportingServices.js file. Normally you can find it in "C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportManager\js\ReportingServices.js"
  2. Edit the file, append this to the end of the file 
    function pageLoad() {    
        var element = document.getElementById("ctl31_ctl09");
        if (element) 
        {
            element.style.overflow = "visible"; 
        } }
Test a report.

Many thanks to the guys on StackOverflow for that one.
http://stackoverflow.com/questions/5428017/cannot-view-ssrs-2008-r2-ssrs-2012-reports-in-safari-chrome-but-works-fine-in

Notes: Any activex control such as Print Control and Zoom Controls will still not work in Chrome. This is because only Internet explorer will support the use of such controls.

If you find this article useful please leave me a comment or click on an ad to show your support.

Tuesday, October 08, 2013

HDD unbootable after softboot - Lenovo X230 Laptop

Problem:
If you find your HDD unbootable after softbooting ( windows reboot, task sequence reboot) on the Lenovo
X230 model laptop.

Workaround:
Cold boot the laptop (Power off/on)

Fix:
Make sure you are running the latest BIOS
http://support.lenovo.com/en_AU/research/hints-or-tips/detail.page?&DocID=HT073834


If you find this article useful please leave me a comment or click on an ad to show your support.