|
|
|
|
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
All Tags » sql (RSS)
-
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...
|
-
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 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...
|
-
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...
|
-
SQL Server Reporting Services plays nicely. You can have things in the catalogue that get shared. You can have Reports that have Links, Datasets that can be used across different reports, and Data Sources that can be used in a variety of ways too. So Read More...
|
-
Four years ago, I was preparing to speak at TechEd Australia. I’d been asked to give a session on “T-SQL Tips and Tricks”, but I’d pushed back and we’d gone with “T-SQL Tips and Techniques” instead. I hadn’t wanted to show Tricks, because despite being Read More...
|
-
MERGE is very cool. There are a ton of useful things about it – mostly around the fact that you can implement a ton of change against a table all at once. This is great for data warehousing, handling changes made to relational databases by applications, Read More...
|
-
I don’t tend to find that anything about me gets described as “Fabulous”. It’s not a word I ever use myself, so I was slightly amused to see it here . It’s going to be an interesting week (in May, Monday 14th to Saturday 19th), in which I have two stints Read More...
|
-
This coming Tuesday sees a midweek SQL Saturday hit Adelaide . LobsterPot’s a sponsor, as are a bunch of other companies . An all day event, with two tracks featuring some of the best material you’ve ever seen presented . I’m presenting too. The thing Read More...
|
|
|
|
|
|