The LobsterPot Blog
Insight and opinion from our team of data platform experts.
Featured Blog
Tuning Using Window Functions
Sometimes query tuning involves taking a different approach to a problem. And given that other tuning options might be creating index(es) or redesigning tables –

Blogs

LobsterPot Blogs
Blog posts by Rob Farley and other LobsterPot Solutions team members.
Popular Blogs
Handling special characters with FOR XML PATH(”)
SARGable functions in SQL Server
The SSIS tuning tip that everyone misses
Tuning Using Window Functions
Sometimes query tuning involves taking a different approach to a problem. And given that other tuning options might be creating index(es) or redesigning tables –
How encrypted is encrypted?
Encryption is a funny thing. Since the dawn of communication, whenever people have wanted to keep their secrets secret, they’ve used some sort of encryption.
What’s wrong with SQL Trace?
This month, Grant Fritchey (@scarydba) asks us to write about Extended Events (XE). He mentions that they were a topic once before (it was in
Useful tips for designing a really great report model from Agile user stories
Are you a model designer or BI developer tasked with building a data model and/or report from a series of user requirements or Agile User
Job Titles
Josephine Bush (@hellosqlkitty) asks us about job titles this month. And it’s something I’ve often wondered about, and haven’t really had a clue about for
Creativity sparks
Code doesn’t tend to generate emotions in the same way that a painting might. The architecture of a piece of software doesn’t make us marvel