“I have worked with Joe for over a decade and half in variour capacities - as a collaborator, as a peer, and as his manager -- and have thoroughly enjoyed working with him in all capacities. Joe possesses deep technical knowledge in databases, has the customer pulse, and excellent inter-personal skills to navigate and communicate with a wide spectrum of audience - from strategic to technical. Joe has demonstrated flexibility and achieved success in diverse roles - from a field engineer to a product manager, from an individual contributor to a leader of product managers. I was responsible for hiring him into Microsoft for his second stint with the company, and won't blink an eyelid to do it another time, if the opportunity arises.”
Experience
Publications
-
Vector Search Essentials
SQLskills
See publicationThis online course provides a comprehensive introduction to vector search capabilities in SQL Server 2025. Designed for SQL Server DBAs and developers, you’ll learn why traditional search methods fall short for semantic queries and how vector search solves these challenges. Through detailed explanations and demonstrations using a property search scenario, you’ll gain the foundational knowledge needed to evaluate and implement vector search in your own environments.
-
Optimizing Your Query Plans with the SQL Server 2014 Cardinality Estimator
Microsoft
See publicationSQL Server 2014 introduces the first major redesign of the SQL Server Query Optimizer cardinality estimation process since version 7.0. The goal for the redesign was to improve accuracy, consistency and supportability of key areas within the cardinality estimation process, ultimately affecting average query execution plan quality and associated workload performance. This paper provides an overview of the primary changes made to the cardinality estimator functionality by the Microsoft query…
SQL Server 2014 introduces the first major redesign of the SQL Server Query Optimizer cardinality estimation process since version 7.0. The goal for the redesign was to improve accuracy, consistency and supportability of key areas within the cardinality estimation process, ultimately affecting average query execution plan quality and associated workload performance. This paper provides an overview of the primary changes made to the cardinality estimator functionality by the Microsoft query processor team, covering how to enable and disable the new cardinality estimator behavior, and showing how to troubleshoot plan-quality regressions if and when they occur.
-
SQL Server: Transact-SQL Basic Data Retrieval
Pluralsight
See publicationLearn how to construct SELECT statements to retrieve data from SQL Server databases, applicable for developers from SQL Server 2005 onwards.
-
SQL Server 2005 T-SQL Recipes
Apress
See publicationNeed to brush up on specific SQL Server tasks, procedures, or Transact-SQL commands? Not finding what you need from SQL Server books online? Or perhaps you just want to familiarize yourself with the practical application of new T-SQL related features. SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach is an ideal book, whatever your level as a DBA or developer.
-
SQL Server 2000 Fast Answers for DBAs and Developers, Signature Edition
Apress
See publicationSQL Server 2000 is the leading relational database for the Windows platform. It’s a full-featured, enterprise-class database server, but its ease of use and maintenance makes it suitable whether youre a junior, part-time, or advanced DBA or developer. SQL Server expert and author Joseph Sack covers all SQL Server 2000 features, so you’ll be able to rely on this book when you’re in the field and need quick, effective solutions.
-
SQL Server 2008 Transact-SQL Recipes
Apress
See publicationSQL Server 2008 Transact–SQL Recipes: A Problem–Solution Approach is an example–based guide to the Transact–SQL language that is at the core of SQL Server 2008. Learn to create databases, insert and update data, generate reports, secure your data, and more. Author Joseph Sack takes common Transact–SQL tasks and breaks them down into a problem/solution format that is quick and easy to read so that you can get the job done fast when the pressure is on.
Patents
-
System and method for cardinality estimation feedback loops in query processing
Issued 11334538
Methods for cardinality estimation feedback loops in query processing are performed by systems and devices. A query host executes queries against data sources via an engine based on estimated cardinalities, and query monitors generate event signals during and at completion of execution. Event signals include indicia of actual data cardinality, runtime statistics, and query parameters in query plans, and are routed to analyzers of a feedback optimizer where event signal information is analyzed…
Methods for cardinality estimation feedback loops in query processing are performed by systems and devices. A query host executes queries against data sources via an engine based on estimated cardinalities, and query monitors generate event signals during and at completion of execution. Event signals include indicia of actual data cardinality, runtime statistics, and query parameters in query plans, and are routed to analyzers of a feedback optimizer where event signal information is analyzed. The feedback optimizer utilizes analysis results to generate change recommendations as feedback for later executions of the queries, or similar queries, performed by a query optimizer of the query host. The query host stores change recommendations, and subsequent queries are monitored for the same or similar queries to which change recommendations are applied to query plans for execution and observance by the query monitors. Change recommendations are optionally viewed and selected via a user interface.
Other inventorsSee patent
Recommendations received
5 people have recommended Joe
Join now to viewOther similar profiles
Explore top content on LinkedIn
Find curated posts and insights for relevant topics all in one place.
View top content