|
|
|
|
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 » t-sql tuesday (RSS)
-
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...
|
-
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...
|
-
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 posted a few hours ago about a reflection of the Summit , but I wanted to write another one for this month’s T-SQL Tuesday, hosted by Chris Yates . In January of this year, Adam Jorgensen and I joked around in a video that was used for the SQL Server 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...
|
-
A non-SQL MVP friend of mine, who also happens to be a client, asked me for some help again last week. I was planning on writing this up even before Rob Volk ( @sql_r ) listed his T-SQL Tuesday topic for this month. Earlier in the year, I (well, LobsterPot 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...
|
-
Some people question the ethics of writing about my company on my blog. But I don’t have a problem with it. Is it ethical to ignore the concerns of others and to just do what I want? Anyway – it’s relevant for this month’s T-SQL Tuesday, which Chris Shaw Read More...
|
-
SQL 2012 brings us a bunch of new analytic functions , together with enhancements to the OVER clause . People who have known me over the years will remember that I’m a big fan of the OVER clause and the types of things that it brings us when applied to Read More...
|
-
It’s a phrase I use often, especially when teaching, and I wish I had realised the concept years earlier. (And of course, fits with this month’s T-SQL Tuesday topic, hosted by Argenis Fernandez ) When I’m sick enough to go to the doctor, I see a GP. I Read More...
|
-
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...
|
|
|
|
|
|