SQL

Using SQL Profiler Tool

I’ve been immersing myself in a lot of SQL work the past week or so for a project going on at work. I’ve come a long way in my knowledge of SQL up to this point and the past few days have expanded that understanding into some new areas as well. One of those areas is [...]

Suspekt...: Speaking at IPC 2008

I will present two session at this year’s International PHP Conference that has now moved from Frankfurt to Mainz. Session: Suhosin catching vulnerabilities before they hit you During the last two years the Suhosin PHP protection system has become a standard component of many PHP installations of various linux and bsd distributions. This talk will give an insight into the many features Suhosin has today and how they can be used to detect and stop yet unknown vulnerabilities in PHP and PHP app...

The PDC is showing its Hand

Yesterday a whole new bunch of sessions were published on the PDC site. http://sessions.microsoftpdc.com/public/sessions.aspx In particular there are some interesting sessions which caught my eye at the top of the list talking around Building Block Services, SQL Server Data Services and Building Live Mesh applications. Here are the sessions or go on-line. A Lap around Building Block Services Architecture [...]

Version 1.0 RTM of the SQL Server 2005 Driver for PHP is live!

Version 1.0 of the SQL Server 2005 Driver for PHP is available for download on the MSDN download site. The possibilities are endless !!!

DNS and SQL Updates

Microsoft released four security updates yesterday. The DNS update is noteworthy as it's part of a significant multi-vendor effort. There will be lots of patching going on as a result. The MS08-037 update reportedly conflicts with ZoneAlarm's firewall software. Proceed with caution if you have ZA installed. All of this month's updates are rated as important. The SQL update is of interest to us what with the recent SQL Security Advisory and the rise in Mass SQL injection attacks. Microsoft is wo...

GeoWeb 2008 Conference Dinner Cruise Photos (and SQL Server 2008 Spatial ;-)

On the Wednesday night GeoWeb 2008 dinner cruise around Vancouver harbor, several folks who had forgotten their cameras (and 1 who had broken their camera) noted that I was busy taking photos and asked if they could be made available. I am happy to report that I have successfully uploaded the photos to my [...]

A SQL Server geek?s dream

I am in Seattle this week for an internal event and got the chance to visit the SQL Server building @ Microsoft. As a real SQL Server geek I had to take this picture. My colleagues were all laughing with me but what the heck This post originated from and is provided by the MSDN [...]

Maximum performance using Telerik RadGrid client-side data-binding with LINQ to SQL

As I mentioned in one of my previous posts with RadGrid for ASP.NET AJAX Q2 2008 you can access the grid sort and filter expressions on the client. While filter expressions toString() method will create SQL syntax representing current grid filtering now you have toDynamicLinq() method which will create LINQ expression that can be used directly with Dynamic LINQ library. With few lines of code you will get minimum transfer between server and client (pure JSON): and on the server side LINQ to SQL ...

How to Debug SQL Server 2005 Stored Procedure?

Following are the steps you need to follow to accomplish above task. Open the Microsoft Visual Studio 2005. Select Server Explorer option from the View Menu. From the Data Connections node, right click and select, 'Add connection'. Fill in the details to connect to the intended SQL Server and the database using the login, which has a fixed server role, SysAdmin. Click on Test connection. Once the connection succeeds, the overall screen should look like the following. Expand the data connection j...

JungleDisk as Service on Windows Server 2003

I'm a big fan of JungleDisk, a $20 utility that makes using Amazon's S3 storage solution easy and backups cheap. I'm also a big fan of Red Gate's tools, and in particular SQL Backup, which makes backing up SQL Server databases much easier and compresses them down to almost nothing. I've been manually backing up my one server that isn't hosted with ORCS Web (who take care of such things for me quite well for the servers there) for way too long. And it has only been backed up to a separate drive i...