|
|
|
|
Rob Farley - Owner/Principal with LobsterPot Solutions (a MS Gold Partner consulting firm), Microsoft MVP (SQL Server) and leader of the SQL User Group in Adelaide, Australia.
Browse by Tags
All Tags » sql (RSS)
-
In my last post, I showed a technique for dealing with working columns when writing T-SQL. The idea was around using APPLY to be able to push values from the existing set through calculations (but preferably not scalar functions, of course), producing Read More...
|
-
T-SQL Tuesday again and this month is on T-SQL Tips (thanks Allen !). In some ways it’s a tough topic, because there are things I don’t really consider tips that other people do, and vice-versa. This one’s legitimate though: Using CROSS APPLY for working Read More...
|
-
Little Bobby Tables’ mother says you should always sanitise your data input . Except that I think she’s wrong. The SQL Injection aspect is for another post, where I’ll show you why I think SQL Injection is the same kind of attack as many other attacks, Read More...
|
-
PASS is becoming more international, which is great. The SQL Community has always been international – it’s not as if data is only generated in North America. And while it’s easy for organisations to have a North American focus, PASS is taking steps to Read More...
|
-
Should SQL Server even have functions? (Oh yeah – this is a T-SQL Tuesday post , hosted this month by Brad Schulz ) Functions serve an important part of programming, in almost any language. A function is a piece of code that is designed to return something, Read More...
|
-
This was a proper big week. The PASS Summit ran from Tuesday night to Friday, but I’d arrived in America the Friday before. So by the time it actually started, I had that strange feeling that things were wrapping up. My calendar was ridiculously full. Read More...
|
-
The words for that song I did at the PASS Summit 2011 are as follows. On the Friday, I stopped where the bridge starts. Various recordings of it are making it to YouTube, such as here , where the song starts around 2:20 in. I should've looked the other Read More...
|
-
Hopefully my connection is slightly better during today’s keynote than it was during yesterday’s, when “Live Blogging” didn’t really cut it. The PASS staff saw the problem and have resolved it (thanks guys!). Quentin Clark has jumped on stage to talk Read More...
|
-
I’m at the PASS Summit, and announcements are coming out nice and fast. One of the big ones that has just been made is that SQL Server will work much more closely with Apache Hadoop. Amazing stuff, that I think helps people realise that Microsoft is very Read More...
|
-
I’m a guest blogger again! This trip is already several days old for me. I arrived in America on Friday, delivered two sessions at Portland SQL Saturday event, walked (on Sunday) the Portland Half Marathon as a sponsor of Leukemia and Lymphoma Society’s Read More...
|
-
I’m now doing two sessions at the SQL Saturday event in Portland . I had been scheduled to do a single session (on indexes) , but got an email yesterday asking if I could do another one as well. So now I’m going to do a session earlier in the day about Read More...
|
-
Yes, the SQL book I was involved in two years ago has a sequel . In the first book, I wrote chapters 7 and 40, and was one of 53 MVPs that contributed. And the proceeds went to War Child. Yes, none of the MVPs who wrote, edited, etc, got any royalties Read More...
|
-
Yeah, alright. I know PASS puts on heaps of free training all the time. There are meetings around the world all the time, as held by hundreds of chapters. Seriously, there’s over 240 chapters in the world. If you figure that they typically have a 2 hour Read More...
|
-
The easiest way to convince someone to use SSMS 2008 over SSMS 2005 was to right-click on a results grid. They’d see “Copy with Headers” in the context menu and be sold immediately. I’d happily show them that they could configure this option in SSMS 2005, Read More...
|
-
Until recently, I’d only done stuff with Denali on a dedicated box. But this weekend, I took the plunge and installed SSMS on a machine that has older versions of SQL Server installed on it. You can download Denali from this link . I’ve only installed Read More...
|
|
|
|
|
|