|
|
|
|
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. Rob is also a Director of PASS, and runs training courses around the world in SQL Server and BI topics.
Browse by Tags
-
The topic for this month’s T-SQL Tuesday is about the journey. Wendy Pastrick’s choice (I’m hosting again next month!). There are a lot of journeys. There are some that just keep going, and others that seem to finish (some in success; some in failure). Read More...
|
-
Louis Davidson just asked me why I write , and now Bob Pusateri ( @sqlbob ) is asking me why I present , which is his question for this month’s T-SQL Tuesday. If you didn’t follow the link to see his actual question, you’ll need to know that he actually Read More...
|
-
Let’s start with some basics and then jump in a bit deeper, for this post to go with the 40th T-SQL Tuesday , hosted this month by Jen McCown . SQL Server holds data, and that data is stored physically in files. Of course, in the database world we think Read More...
|
-
For the blog post that I’ll publish tomorrow, I wrote a query that I thought needed a blog post all of its own. This is that post. The query was this one. Its results aren’t that interesting, it’s just a list of dates with a random number between 0 and Read More...
|
-
I mean really? Why should you spend some of your training budget to go to this thing ? Suppose you’re someone in the PASS Community who mainly looks after people’s data. That could involve database administration, performance tuning, helping developers Read More...
|
-
Every year, PowerShell increases its stranglehold on the Windows Server system and the applications that run upon it – with good reason too. Its consistent mechanisms for interaction between its scripting interface and the underlying systems make it easy Read More...
|
-
I’m not big on New Year resolutions. I can’t say I respond particularly well to “everyone’s doing something, I should too” situations. Peer pressure can be useful at times, but I also find that it can make me even more stubborn. So when Jason Brimhall Read More...
|
-
I was wrong – I passed the MCM lab last month. I know I thought I’d failed – I’m still surprised that I passed. Maybe I managed to satisfy enough of enough questions. Certainly none of the questions were beyond me, as I wrote just after I’d sat it . But Read More...
|
-
It’s very easy to get in the habit of imagining the way that a query should work based on the Logical Order of query processing – the idea that the FROM clause gets evaluated first, followed by the WHERE clause, GROUP BY, and so on – finally ending with Read More...
|
-
The last PASS board meeting for the year has happened, and the portfolio handovers are well under way. Sadly, having new board members elected means having existing board members step down, and this last board meeting was the last one for both Allen Kinsel Read More...
|
-
I spent some time explaining SQL Server Replication to someone recently. They said they hadn’t ever really understood the concepts, and that I’d managed to help. It’s inspired me to write a post that I wouldn’t normally do – a “101” post. I’m not trying Read More...
|
-
Readers of my blog , or followers on Twitter will know I took the MCM Lab exam a couple of days ago. I let people know I was doing the exam, rather than doing the ‘normal’ thing of doing it in secret and hoping no-one found out until a successful result Read More...
|
-
In two days I’ll’ve finished the MCM Lab exam, 88-971. If you do an internet search for 88-971 , it’ll tell you the answer is –883. Obviously. It’ll also give you a link to the actual exam page , which is useful too, once you’ve finished being distracted Read More...
|
-
Tables are only metadata. They don’t store data. I’ve written something about this before, but I want to take a viewpoint of this idea around the topic of joins, especially since it’s the topic for T-SQL Tuesday this month. Hosted this time by Sebastian Read More...
|
-
I took the SQL 2008 MCM Knowledge exam while in Seattle for the PASS Summit ten days ago. I wasn’t planning to do it, but I got persuaded to try. I was meaning to write this post to explain myself before the result came out, but it seems I didn’t get Read More...
|
|
|
|
|
|