Joe Sack

Joe Sack is a Principal Consultant, author and trainer at SQLskills.com.

Prior to joining SQLskills, Joe worked at Microsoft as a Premier Field Engineer for large enterprise environments. He is a SQL Server MVP and Microsoft Certified Master (MCM) for versions 2005 & 2008. For his last few years at Microsoft, he was responsible for the SQL Server MCM Program (2009 to 2011). He has written multiple books, articles and whitepapers including SQL Server 2008 Transact-SQL Recipes (Apress, 2008) and SQL Server 2005 T-SQL Recipes (Apress, 2005).

SQLServerCentral Article

Windows Server 2012 Deduplication – Should you use it with SQL Server Backups?

Windows Server 2012 introduces native deduplication functionality. While this is a promising new Windows feature for other file types and characteristics, there are some potential pitfalls that you need to be aware of when it comes to deduplication specifically for SQL Server backup files.

(24)

You rated this post out of 5. Change rating

2013-02-08

7,345 reads

SQLServerCentral Article

SQL Server 2012’s Information on Parallel Thread Usage

In the SQL Server 2012 execution plan we can see better the true thread reservations for a query and not just information on the maximum degree of parallelism and row distribution across parallel threads; thanks to the new parallel thread usage information.

(17)

You rated this post out of 5. Change rating

2012-08-09

5,761 reads

Blogs

PASS Data Community Summit 2025 Slides and Code

By

Thank you for attending my PASS Summit 2025 session Answering the Auditor’s Call with...

Tech Conferences and Expanding Your View

By

Tech conferences aren't just for networking and learning how to address a problem you're...

Managing subscribers, creating newsletters

By

When I created the website on WordPress, I was expecting all the features I...

Read the latest Blogs

Forums

Getting the Schema for Tables

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Getting the Schema for Tables

An Unexciting Exciting Release

By Steve Jones - SSC Editor

Comments posted to this topic are about the item An Unexciting Exciting Release

UNLOGGED Tables in PostgreSQL: When Speed Matters More Than Durability

By Chandan Shukla

Comments posted to this topic are about the item UNLOGGED Tables in PostgreSQL: When...

Visit the forum

Question of the Day

Getting the Schema for Tables

What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?

SELECT OBJECT_DEFINITION (OBJECT_ID(N'Person.Person')) AS [Object Definition]; 
GO 

See possible answers