Welcome to Sign in | Join | Help

iulie 2009 - Posts

My latest MSDN column is available in the August issue and called "How Data Access Affects Performance". It was inspired by a problem that one of my DBA friends noticed in the database that could only be fixed by changing the data access code. Read More...
Copyright Remus Rusanu 2009. Visit the original article at http://rusanu.com/2009/07/26/myspace-uses-sql-server-service-broker-to-protect-integrity-of-1-petabyte-of-data/  I just found that Microsoft has published a white paper about the way Read More...
Copyright Remus Rusanu 2009. Visit the original article at http://rusanu.com/2009/07/24/fix-slow-application-startup-due-to-code-sign-validation/  Sometimes you are faced with applications that seem to take ages to start up. Usually they freeze Read More...
I really enjoyed speaking at the Portland SQL Server User Group meeting last night about SQL Server security...and I have an update. We were talking about the supposed inability of auditing to audit usage of sys.fn_get_audit_file, the system function Read More...
http://www.techcrunch.com/2009/07/19/the-anatomy-of-the-twitter-attack/ The first step of registering an old email account to receive the password from a current account was a nice and easy way to break into an email acount. After that, things pretty Read More...
Copyright Remus Rusanu 2009. Visit the original article at http://rusanu.com/2009/07/21/detect-network-connectivity-changes-in-net-applications/  A common problem for applications that use the network stack is to detect when they are connected Read More...
During a talk about spatial indexes and performance last week, I was surprised by a question about using ANSI-92 JOIN - ON syntax in spatial queries. I'd coded: SELECT * FROM geonames.dbo.geonames g JOIN Sample_USA.dbo.Counties c ON g.GEOG.STIntersects(c.geog) Read More...
Went through 2 years worth of blog entries looking for comments to approve. Sorry that I've been remiss in doing that. I have to approve every comment "by hand" and we'd been getting a lot of spam comments, so I've been putting it Read More...
Last week I attended my first-ever ESRI conference in San Diego. Although the "star of the show" was version 9.3.1 and the upcoming version 9.4 of the ARCGIS series of products, I most enjoyed the presentations about the new ESRI MapIt product. Read More...
Copyright Remus Rusanu 2009. Visit the original article at http://rusanu.com/2009/07/08/inspiration-is-perishable/  I am following the 37signals blog ever since I kinda randomly stumbled upon their Getting Real book. If you never heard about Read More...
This month I'll be presenting a session for the Portland SQL Server User Group. I'll be discussing and demonstrating the new security features in SQL Server 2008 with a post-talk Q&A about SQL Server security in general. I've also got Read More...
Copyright Remus Rusanu 2009. Visit the original article at http://rusanu.com/2009/07/07/laptop-battery-bulged-out-of-its-tray/   That is how my 17” Mac book Pro battery looks like after today it bulged out of its tray. Seems to be a fairly Read More...
Just got a mail message from an old friend who asked why I'd dropped out of sight in the past month of so. I've been in "extended partial vacation mode" for the last month or so and haven't blogged in a while. But I'm "still Read More...