|
|
Browse by Tags
All Tags » sql (RSS)
-
Of course, the one not to miss is the one I’m doing, on Fixing Queries with Advanced T-SQL Techniques , but actually, they’re all excellent. For example, Simon’s just blogged that Buck Woody’s seminar topic has changed . Instead of being on career development,...( Read More...
|
-
I received an email from someone who’s trying to decide whether or not to register for my precon at SQLBits 7 next month. He’s already coming to the event (which should be a given for anyone who can make it), but he was trying to work out a few things...( Read More...
|
-
I’m giving a pre-con seminar at SQLBits 7 on September 30 this year in York (the Old one, in Yorkshire – similar to the New one, but with different songs ). Let me quickly explain a few things about it – to help you persuade your boss to let you attend...( Read More...
|
-
So the pre-/post-con submission I made for the PASS Summit in November didn’t get picked up (although I’m still hoping to get a regular session or two), but in the meantime, I have other presentations going on. Those who participated in the 24 Hours of...( Read More...
|
-
I like to joke with Christian Bolton ( @christianbolton ) about the time when he got accused of claiming to have written Brent’s book . Of course, he didn’t write Brent’s book – Brent wrote some of Christian’s. And it’s an excellent book. For a start,...( Read More...
|
-
Displaying information on an interactive map really isn’t that hard to do. My friends John & Bronwen have been doing this stuff for ages through their company Soul Solutions , and have done lots of talks about how to do this. They have the ability...( Read More...
|
-
Interestingly, my favourite new feature of SQL Server 2008 R2 isn’t any of the obvious things. You may have read my recent posts about how much I like some of the new Reporting Services features, such as the map control. Or you may have seen my...( Read More...
|
-
The URL for attendees is https://www.livemeeting.com/cc/usergroups/join?id=ADL1005&role=attend . This meeting is with Buck Woody . If you don’t know who he is, then you ought to find out! He’s a Program Manager at Microsoft on the SQL Server team,...( Read More...
|
-
Regular readers of my blog (at sqlblog.com – please let me know if you’re reading this elsewhere) may be aware that I’ve been doing more and more with spatial data recently. With the now-available SQL Server 2008 R2 Reporting Services including maps,...( Read More...
|
-
I’m giving a presentation on May 12th at the Adelaide .Net User Group, around the topic of spatial data, and in particular, the visualization of said data. Given that it’s about one the larger types, this post should also count towards Michael Coles’...( Read More...
|
-
Tomorrow, via LiveMeeting, I’m giving two presentations about SARGability. That’s April 27th , for anyone reading this later. The first will be at the Adelaide SQL Server User Group . If you’re in Adelaide, you should definitely come along. Both meetings...( Read More...
|
-
Because I hate seeing > or & in my results… Since SQL Server 2005, we’ve been able to use FOR XML PATH('') to do string concatenation. I’ve blogged about it before several times. But I don’t think I’ve blogged about the fact that it all...( Read More...
|
-
In a recent customer engagement, I ran into an interesting situation, which I’d like to share, especially with SQL Server users using Microsoft JDBC drivers. It started with typical SQL Server performance tuning exercise to identify the most expensive Read More...
|
-
Sometimes, an SSRS subscription fails for some reason. It can be annoying, particularly as the appropriate response can be hard to see immediately. There may be a long list of jobs that failed one morning if a Mail Server is down, and trying to work out Read More...
|
-
In SQL Server, the cost of a particular plans is based largely on I/O, which makes this post a good candidate for this month’s T-SQL Tuesday , hosted by Mike Walsh who, like me, walks a straight path. In considering I/O – the movement of data generally Read More...
|
|
|
|