Configure Windows Firewall for SQL Server

After a fresh install of an SQL instance, you may find you cannot connect to it from another machine on the network. It might be that the firewall is blocking it. Try the following on the server:

- Open Windows Firewall:
– Allow programs to connect
– Add sqlbrowser and sqlserver found in
C:\Program Files\Microsoft SQL Server\MSSQL10_50.[INSTANCENAME]\MSSQL\Binn\sqlservr.exe
C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe

SQL date time formatting

When writing queries you might sometimes come across those people clients who want the dates formatted in a certain way (pesky clients *shakes fist). Don’t stress its nothing too difficult.

Take the date 20th May 2014 and you get a request to convert this to dd/mm/yyyy.

We usually work in iso dates (yyyymmdd). For the example I will cast the iso date as a string and then cast it as a datetime and work from there.

Our final product will look something as follows:

I will go through what each of the steps entail.

 

Hello dev world!

A little about me
A big hello from The Lazy developer here is Aus. Been in development for a good 10 years now and have to say there’s been a few ups and downs here and there. Started learning Java at uni and progressed in various languages throughout my studies. Have to say though was a pretty fun experience learning new languages and techniques to develop solutions.

Current
Currently been involved with silverlight, vb .net, vb6 and SQL dbs. Been at it for the last 5 years or so; so been an quite interesting learning curve.