--- title: SQL Shack posts | daily.dev description: SQLShack's platform is a resource for database professionals and SQL developers, offering insights into database management, SQL queries, and data manipulation techniques. Through articles, tutorials, and SQL scripts, SQLShack offers insights into SQL Server features, database administration tasks, and performance tuning strategies. Readers can learn about optimizing SQL queries, designing efficient database schemas, and troubleshooting common database issues to improve SQL skills and maximize database performance. canonical: https://daily.dev/sources/sqlshack twitter:card: summary_large_image twitter:site: @dailydotdev og:url: https://daily.dev/sources/sqlshack og:type: website og:site_name: daily.dev og:title: SQL Shack posts | daily.dev og:description: SQLShack's platform is a resource for database professionals and SQL developers, offering insights into database management, SQL queries, and data manipulation techniques. Through articles, tutorials, and SQL scripts, SQLShack offers insights into SQL Server features, database administration tasks, and performance tuning strategies. Readers can learn about optimizing SQL queries, designing efficient database schemas, and troubleshooting common database issues to improve SQL skills and maximize database performance. og:image: https://api.daily.dev/og/sources/sqlshack.png og:image:width: 1200 og:image:height: 630 ---  # SQL Shack Follow FollowBlock SQLShack's platform is a resource for database professionals and SQL developers, offering insights into database management, SQL queries, and data manipulation techniques. Through articles, tutorials, and SQL scripts, SQLShack offers insights into SQL Server features, database administration tasks, and performance tuning strategies. Readers can learn about optimizing SQL queries, designing efficient database schemas, and troubleshooting common database issues to improve SQL skills and maximize database performance. [Understanding PostgreSQL SUBSTRING function](/posts/understanding-postgresql-substring-function-0cvvkhbr3)[How to create and query the Python PostgreSQL database](/posts/how-to-create-and-query-the-python-postgresql-database-urgk53esj)[Different ways to identify and change compatibility levels in SQL Server](/posts/different-ways-to-identify-and-change-compatibility-levels-in-sql-server-pejtaonw3)[Oracle Substring function overview with examples](/posts/oracle-substring-function-overview-with-examples-4kds42fbw)[Configure backup storage redundancy for Azure Cosmos DB account](/posts/configure-backup-storage-redundancy-for-azure-cosmos-db-account-vpeb4w1iy)[SQL Performance Tuning tips for newbies](/posts/sql-performance-tuning-tips-for-newbies-a7s38v1el)[Understanding the SQL IN operator with examples](/posts/understanding-the-sql-in-operator-with-examples-qdf6sf2h7)[Finding Duplicates in SQL](/posts/finding-duplicates-in-sql-zcs2mmthu)[Difference between SQL SELECT UNIQUE and SELECT DISTINCT](/posts/difference-between-sql-select-unique-and-select-distinct-eexstw7dd)[An overview of SQL Server monitoring tools](/posts/an-overview-of-sql-server-monitoring-tools-tzjqxjcn3) ## Most upvoted posts from SQL Shack ## Best discussed posts from SQL Shack ## All posts from SQL Shack ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/sources/sqlshack#organization","name":"SQL Shack","url":"https://daily.dev/sources/sqlshack","logo":{"@type":"ImageObject","url":"https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/7b6468c7be7a4bb78461bce41bcb2dd3"},"description":"SQLShack's platform is a resource for database professionals and SQL developers, offering insights into database management, SQL queries, and data manipulation techniques. Through articles, tutorials, and SQL scripts, SQLShack offers insights into SQL Server features, database administration tasks, and performance tuning strategies. Readers can learn about optimizing SQL queries, designing efficient database schemas, and troubleshooting common database issues to improve SQL skills and maximize database performance."},{"@type":"CollectionPage","@id":"https://daily.dev/sources/sqlshack#page","url":"https://daily.dev/sources/sqlshack","name":"SQL Shack posts on daily.dev","description":"SQLShack's platform is a resource for database professionals and SQL developers, offering insights into database management, SQL queries, and data manipulation techniques. Through articles, tutorials, and SQL scripts, SQLShack offers insights into SQL Server features, database administration tasks, and performance tuning strategies. Readers can learn about optimizing SQL queries, designing efficient database schemas, and troubleshooting common database issues to improve SQL skills and maximize database performance.","about":{"@id":"https://daily.dev/sources/sqlshack#organization"},"isPartOf":{"@type":"WebSite","url":"https://daily.dev"}},{"@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Sources","item":"https://daily.dev/sources"},{"@type":"ListItem","position":3,"name":"SQL Shack"}]}]} ```