My current focus is directing and managing strategic and operational aspects of Pragmatic Works, a data services organization focused on democratizing analytics and data related technologies. I built the organization from the ground up (with my co-founders) to include industry leading processes, attract and retain top industry resources and execute powerhouse partnerships with firms like Microsoft and HP to deliver the highest quality solutions in the most innovative ways.

All authors

All authors

Blogs

Lukáš Karlovský: I got the green light from management and built Fabric specialization from scratch

By

The post Lukáš Karlovský: I got the green light from management and built Fabric...

FIRST_VALUE vs. Min: #SQLNewBlogger

By

I had mentioned some new T-SQL functions for SQL Server 2022 and a commenter...

Explicitly Defining Values in an IN Clause VS Putting Them into a Temp Table and Use a Semi-Join

By

This post comes off the back of my last, where I looked at issues...

Read the latest Blogs

Forums

CPU Performance Advice in SQL Server 2005

By JoeLee

I am having problems with CPU performance on SQL Server 2005. CPU spikes frequently...

CPU Performance Advice in SQL Server 2005

By JoeLee

I am having problems with CPU performance on SQL Server 2005. CPU spikes frequently...

Duplicate Documents

By VastSQL

Hi Experts, I am trying to find duplicate documents stored in our Filestream database....

Visit the forum

Question of the Day

Subqueries II

What is wrong (if anything) with this code? 

SELECT *
 FROM Sales.SalesOrderHeader AS soh 
 WHERE customerid IN (SELECT soh.CustomerID FROM Sales.Customer AS c WHERE soh.CurrencyRateID = 1 ORDER BY c.ModifiedDate)

See possible answers