If there can be a culture insensitive format for dates (yyyymmdd) then why is there no such thing as a culture insensitive format for decimals?
I suggest a use of # or ~ instead of the decimal separator in update and insert scripts only.
Read more →
I've seen this technique a few months ago on a local MS event called NT Conference presented by Slovenian MVP Dejan Sarka. However i haven't seen him blog about it yet (a shame) so after seeing this post by co blogger David Moloney here on SQLTeam blogs in this post about EAV i decided to give this little thing a go by myself.
Read more →
Ever since I discovered the ?? colaesce operator I embraced it with full force.
Today I discovered another usefull use:
// this: string[] arrayOfStrings1 = new string[] { "arr1s1", "arr1s2", "arr1s3" }; foreach (string str in (arrayOfStrings1 ?
Read more →
I usually don't do these kind of posts but for this i'll make an exception :)
This is such an awsome tool for me for one reason only: SQL Formatting
Read more →
I had so much "fun" with viewstate last weekend. I'm developing a site that has a master page Master.aspx and a few child pages (Page1.aspx, ..., pageN.aspx). Now when rendering HTML that is displayed an ASP.
Read more →
I've come accross this these articles which i think are a must read before starting to design any kind of a serious application Designing and building a robust data access layer Managing SQL exceptions in .
Read more →
DMV's are one of the most usefull features in SQL Server 2005.
There are 2 that I like more than others because they can give you information about executed SQL statements without the use of SQL Profiler tool.
Read more →
I had some fun this weekend with ASP.Net 2.0 Master pages and submit buttons when pressing Enter key. The catch here is that with the introduction of Master pages there's only one form per page which is specified in the master page.
Read more →
I've written about bulk insert methods for text files in sql server 2005. .Net 2.0 brings the SqlBulkCopy Class in System.Data.SqlClient namespace. Speed wise it can't even compare to native sql server methods but it's usefull if it's the only viable solution.
Read more →
I've come accross this white paper that explains how SQL Server 2005 can be used to support row- and cell-level security.
Preety interesting reading.
More here.
Legacy Comments
Richard Lees
2007-07-07
re: Implementing Row- and Cell-Level Security in Classified Databases Using SQL Server 2005 download whitepaper
Read more →
I came across this "little" tool today via Mike Gunderloy's The Daily Grind. Tried it out. LOVE IT. My JavaScript development from now one is only in Aptana IDE. And the coolest first observation you see is an IE and/or Firefox icon near the Javascript function you want to use that tells you if it's compatible with the browser and DOM 1 and/or DOM 2.
Read more →
In this thread it's shown how to export query results to excel File using OpenRowset. The problem with this is that you have to create an excel file with columns. For me that is simply unacceptable because i had to export any query result to excel and having to make an excel file for each query is simply ridicolous.
Read more →
Well i've done some more testing of bulk import methods i described in my previous post. The difference between previsous tests and these tests are these: 1. Database recovery model was set to Bulk logged.
Read more →
In a previous post I explained where an SSIS FastParse option can be found when importing data from Flat files. I finally had some time to explore all four of SQL Server 2005 Bulk import utilities.
Read more →
In a previous post I explained where an SSIS FastParse option can be found when importing data from Flat files. I finally had some time to explore all four of SQL Server 2005 Bulk import utilities.
Read more →
I've come across Tod Hiliton's blog via Jason Haley's Interesting finds and there i found this great little add-in for VS2005.
The add-in was created by J.T.Leigh, i've installed it and I must say it works beutifully.
Read more →
I came accross this site and i must admit i've become an instant fan :))
It's Roller has the most amazing collection of sql blogs i've found so far.
It's created by Peter DeBetta and Adam Machanic as far as i can tell.
Read more →
In my previous post i showed how a generic comparer class in .net C# 2.0 can be made with the use of reflection.
This is the version 2. Faster, preetier, better.
Read more →
In my previous post i showed how a generic comparer class in .net C# 2.0 can be made with the use of reflection.
In my constant search to optimize code and make it better i've stumbled upon this article that explaines how IL code generation can be use in this situation.
Read more →
I've been doing a "bit" of .net development lately and i had a problem where i would get a variable of type object and it's type in a string. So I wondered how to convert it to proper type at runtime.
Read more →