Joe Sack

Joe Sack

Greater Minneapolis-St. Paul Area
2K followers 500+ connections

Experience

  • Joe Sack Consulting LLC Graphic
  • -

    Minnesota, United States

  • -

  • -

    Minneapolis, Minnesota, United States

  • -

    Minnesota, United States

  • -

    Minneapolis, Minnesota, United States

  • -

Publications

  • Vector Search Essentials

    SQLskills

    This 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.

    See publication
  • Optimizing Your Query Plans with the SQL Server 2014 Cardinality Estimator

    Microsoft

    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…

    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.

    See publication
  • SQL Server: Transact-SQL Basic Data Retrieval

    Pluralsight

    Learn how to construct SELECT statements to retrieve data from SQL Server databases, applicable for developers from SQL Server 2005 onwards.

    See publication
  • SQL Server 2005 T-SQL Recipes

    Apress

    Need 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.

    See publication
  • SQL Server 2000 Fast Answers for DBAs and Developers, Signature Edition

    Apress

    SQL 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.

    See publication
  • SQL Server 2008 Transact-SQL Recipes

    Apress

    SQL 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.

    See publication

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 inventors
    See patent

Recommendations received

5 people have recommended Joe

Join now to view

View Joe’s full profile

  • See who you know in common
  • Get introduced
  • Contact Joe directly
Join to view full profile

Other similar profiles

Explore top content on LinkedIn

Find curated posts and insights for relevant topics all in one place.

View top content

Add new skills with these courses