Viewing 15 posts - 1 through 15 (of 15 total)
Unfortunately having a law and enforcing it are two different things. On top of that, with the current "austerity drive", law enfocement is an area where I fear...
June 6, 2011 at 4:53 am
In the UK the new Bribery Act comes into force on 1 July 2011. It can fine companies an unlimited amount, and can send people to prison. The new legislation...
June 6, 2011 at 4:34 am
Excellent question - thank you
November 16, 2009 at 6:59 am
Probably the biggest thing to learn in .Net is the framework, and this is the same in both languages.
I second that. To be productive in .NET you should become...
November 16, 2009 at 6:47 am
quick and dirty - but handy for ad-hoc use:
Set query output to text
sp_MSforeachtable @command1=" SELECT '?', COUNT(*) FROM ?"
April 9, 2009 at 6:52 am
This happens to be one of my eternal blind spots.
I have lost count of the number of times I had to correct a query because I forgot that using 'NOT...
March 23, 2009 at 10:08 am
Here are a couple of things I find useful when developing queries
Print any dynamic queries before executing them
Queries called via osql
If a query will be called via osql, I...
December 15, 2008 at 10:23 am
Automating Excel is a very useful way to solve the kind of problem you describe, but I too would be wary of doing it from within SQL Server. For example...
December 5, 2008 at 2:21 am
Just looking at the painful DOS syntax such as this fragment
makes me wince. I would suggest using PowerShell and perhaps a CSV file to feed "environment" variables to the script.
November 6, 2008 at 2:38 am
If a page is meaningless for a log file, the answer should be NULL instead of 0 - only joking
August 6, 2008 at 10:19 am
Off-topic, but something I always wondered about:
How do people who use the Arabic version of Windows manage to write C/C++/C# code? After all Arabic does not have capitals.
July 9, 2008 at 2:46 am
This is a useful solution that allows the production pakage to run while at the same time working on the development of the next version of the package -...
June 24, 2008 at 2:12 am
LOL - this made me feel as if I was on a MS certification test - none of the answers seem right so you try to choose the "least wrong" answer.
May 16, 2007 at 3:08 am
A very welcome article - even for smaller migrations it will be very useful as a template.
Can you indicate at which stage you would address differences in collation order,...
November 28, 2005 at 6:23 am
Thanks for a useful and clear article - much appreciated.
One comment: as an initial step the SQL profiler can also be useful - no coding required! Of course you cannot see how the...
November 28, 2005 at 5:07 am