About
From a junior developer through Sr 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 being 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.
Testimonials
I've been using this [theme] since the start. It is by far the most attractive, feature packed and stable of...
Rhyull
I’m a huge fan of this theme. I’ve got more than 90,000 pictures in my gallery3 running on a Ubuntu...
Jklobo
First I’m new to G3. I was wanting to append my forum with a gallery and after doing a lot...
Setishock
http://www.animeappeal.comCategories
Tag Archives: sql server
Implementing Custom Security Extensions for SQL Server 2008 R2
Introduction This article has been contributed by Daniel Klionsky and based on the work we have done within our team allowing single sign-on integration of SQL Server Reporting Services within existing application. I want to mention and praise great help … Continue reading
SQL tasks automation: apply scripts from folder
You will be amazed how common this question is: I have a folder with arbitrary set of SQL scripts and want to apply them all automatically. How do I do that? In other words: Having a folder – ex: C:\AutoSQLScripts – with some … Continue reading
Posted in Fun stuff with SQL Server, Technology
Tagged apply script, apply sql script, batch file, osql, sql automation, sql script, sql server
Leave a comment
SQL Server 2008: moving forward
SQL Server 2008 has been available since Aug 6, 2008. This does not include CTP (Feb 2008) time-frame. We are close to the year milestone now. To my surprise there are still questions around if moving to a new version is … Continue reading
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