|
|
|
|
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 » t-sql tuesday (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...
|
-
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...
|
-
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...
|
-
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...
|
-
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...
|
-
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...
|
-
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...
|
-
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...
|
-
It’s not quite a Best Practice , but it’s something that I see as very important. It makes the difference between someone who might be quite good at T-SQL, and someone who can go past the rest and become one of those people who get asked to solve other Read More...
|
-
This T-SQL Tuesday is on the topic of CTEs, and is hosted by Bob Pusateri ( @SQLBob ). For a bunch more posts on the topic, follow the link to his Invitation Post , and you’ll see a pile of them, all about CTEs. If you’re reading this and it’s still May Read More...
|
-
I could go on all day about APPLY – it really is an incredible part of T-SQL. It helps solves problems were frustratingly painful to solve otherwise. It empowers the query writer in a way that is matched by few other features. This makes it a worthy topic Read More...
|
|
|
|
|
|