About
From being a junior developer all the way to Development Manager position, I was always interested in new technologies. Passionate speaker, IT junky, developer, architect, team lead, and development manager - many hats, one goal - making software better and closer to people’s needs. For the most part I am using my blog as a scratch pad, writing small articles on things which I came across, was asked about more then once, and which would otherwise require additional research again and again.
Tag Archives: sql server
SQL date operations: Last 90 days, Get Date from DateTime…
I am continuing putting some common examples of operations for Microsoft SQL Server. In addition to some of the Date related code snippets published before, there are few more today:
SQL Server Collation. An enemy or a friend?
Is SQL Server Collation setting your enemy or your friend? How to change server default collation? In general, it is your friend, it will help SQL Server to figure out how to store character strings in different locale. It becomes … Continue reading
Posted in Fun stuff with SQL Server
Tagged change database collation, collation, collationname, sql server
6 Comments
Load text file data into SQL Server table
Last time we have seen how to manipulate text files from SQL Server code using Scripting object. This time we would look at “Read File As Table” operation from a different angle – using BULK INSERT operation. There are pros and … Continue reading