| Skip to content | https://github.com/XiangGe0405/sqlserver-kit/blob/master/Articles#start-of-content |
|
| https://github.com/ |
|
Sign in
| https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2FXiangGe0405%2Fsqlserver-kit%2Ftree%2Fmaster%2FArticles |
| GitHub CopilotWrite better code with AI | https://github.com/features/copilot |
| GitHub Copilot appDirect agents from issue to merge | https://github.com/features/ai/github-app |
| MCP RegistryNewIntegrate external tools | https://github.com/mcp |
| ActionsAutomate any workflow | https://github.com/features/actions |
| CodespacesInstant dev environments | https://github.com/features/codespaces |
| IssuesPlan and track work | https://github.com/features/issues |
| Code ReviewManage code changes | https://github.com/features/code-review |
| Code QualityEnforce quality at merge | https://github.com/features/code-quality |
| GitHub Advanced SecurityFind and fix vulnerabilities | https://github.com/security/advanced-security |
| Code securitySecure your code as you build | https://github.com/security/advanced-security/code-security |
| Secret protectionStop leaks before they start | https://github.com/security/advanced-security/secret-protection |
| Why GitHub | https://github.com/why-github |
| Documentation | https://docs.github.com |
| Blog | https://github.blog |
| Changelog | https://github.blog/changelog |
| Marketplace | https://github.com/marketplace |
| View all features | https://github.com/features |
| Enterprises | https://github.com/enterprise |
| Small and medium teams | https://github.com/team |
| Startups | https://github.com/enterprise/startups |
| Nonprofits | https://github.com/solutions/industry/nonprofits |
| App Modernization | https://github.com/solutions/use-case/app-modernization |
| DevSecOps | https://github.com/solutions/use-case/devsecops |
| DevOps | https://github.com/solutions/use-case/devops |
| CI/CD | https://github.com/solutions/use-case/ci-cd |
| View all use cases | https://github.com/solutions/use-case |
| Healthcare | https://github.com/solutions/industry/healthcare |
| Financial services | https://github.com/solutions/industry/financial-services |
| Manufacturing | https://github.com/solutions/industry/manufacturing |
| Government | https://github.com/solutions/industry/government |
| View all industries | https://github.com/solutions/industry |
| View all solutions | https://github.com/solutions |
| AI | https://github.com/resources/articles?topic=ai |
| Software Development | https://github.com/resources/articles?topic=software-development |
| DevOps | https://github.com/resources/articles?topic=devops |
| Security | https://github.com/resources/articles?topic=security |
| View all topics | https://github.com/resources/articles |
| Customer stories | https://github.com/customer-stories |
| Events & webinars | https://github.com/resources/events |
| Ebooks & reports | https://github.com/resources/whitepapers |
| Business insights | https://github.com/solutions/executive-insights |
| GitHub Skills | https://skills.github.com |
| Documentation | https://docs.github.com |
| Customer support | https://support.github.com |
| Community forum | https://github.com/orgs/community/discussions |
| Trust center | https://github.com/trust-center |
| Partners | https://github.com/partners |
| View all resources | https://github.com/resources |
| GitHub SponsorsFund open source developers | https://github.com/open-source/sponsors |
| Security Lab | https://securitylab.github.com |
| Maintainer Community | https://maintainers.github.com |
| Accelerator | https://github.com/open-source/accelerator |
| GitHub Stars | https://stars.github.com |
| Archive Program | https://archiveprogram.github.com |
| Topics | https://github.com/topics |
| Trending | https://github.com/trending |
| Collections | https://github.com/collections |
| Enterprise platformAI-powered developer platform | https://github.com/enterprise |
| GitHub Advanced SecurityEnterprise-grade security features | https://github.com/security/advanced-security |
| Copilot for BusinessEnterprise-grade AI features | https://github.com/features/copilot/copilot-business |
| Premium SupportEnterprise-grade 24/7 support | https://github.com/enterprise/premium-support |
| Pricing | https://github.com/pricing |
| Search syntax tips | https://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax |
| documentation | https://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax |
|
Sign in
| https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2FXiangGe0405%2Fsqlserver-kit%2Ftree%2Fmaster%2FArticles |
|
Sign up
| https://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Ffiles%2Fdisambiguate&source=header-repo&source_repo=XiangGe0405%2Fsqlserver-kit |
| Reload | https://github.com/XiangGe0405/sqlserver-kit/blob/master/Articles |
| Reload | https://github.com/XiangGe0405/sqlserver-kit/blob/master/Articles |
| Reload | https://github.com/XiangGe0405/sqlserver-kit/blob/master/Articles |
|
XiangGe0405
| https://github.com/XiangGe0405 |
| sqlserver-kit | https://github.com/XiangGe0405/sqlserver-kit |
| ktaranov/sqlserver-kit | https://github.com/ktaranov/sqlserver-kit |
|
Notifications
| https://github.com/login?return_to=%2FXiangGe0405%2Fsqlserver-kit |
|
Fork
0
| https://github.com/login?return_to=%2FXiangGe0405%2Fsqlserver-kit |
|
Star
0
| https://github.com/login?return_to=%2FXiangGe0405%2Fsqlserver-kit |
|
Code
| https://github.com/XiangGe0405/sqlserver-kit |
|
Pull requests
0
| https://github.com/XiangGe0405/sqlserver-kit/pulls |
|
Actions
| https://github.com/XiangGe0405/sqlserver-kit/actions |
|
Projects
| https://github.com/XiangGe0405/sqlserver-kit/projects |
|
Security and quality
0
| https://github.com/XiangGe0405/sqlserver-kit/security |
|
Insights
| https://github.com/XiangGe0405/sqlserver-kit/pulse |
|
Code
| https://github.com/XiangGe0405/sqlserver-kit |
|
Pull requests
| https://github.com/XiangGe0405/sqlserver-kit/pulls |
|
Actions
| https://github.com/XiangGe0405/sqlserver-kit/actions |
|
Projects
| https://github.com/XiangGe0405/sqlserver-kit/projects |
|
Security and quality
| https://github.com/XiangGe0405/sqlserver-kit/security |
|
Insights
| https://github.com/XiangGe0405/sqlserver-kit/pulse |
| https://github.com/XiangGe0405/sqlserver-kit |
| sqlserver-kit | https://github.com/XiangGe0405/sqlserver-kit/tree/master |
| History | https://github.com/XiangGe0405/sqlserver-kit/commits/master/Articles |
| https://github.com/XiangGe0405/sqlserver-kit/commits/master/Articles |
| sqlserver-kit | https://github.com/XiangGe0405/sqlserver-kit/tree/master |
| .. | https://github.com/XiangGe0405/sqlserver-kit/tree/master |
| Backup | https://github.com/XiangGe0405/sqlserver-kit/tree/master/Articles/Backup |
| Backup | https://github.com/XiangGe0405/sqlserver-kit/tree/master/Articles/Backup |
| README.md | https://github.com/XiangGe0405/sqlserver-kit/blob/master/Articles/README.md |
| README.md | https://github.com/XiangGe0405/sqlserver-kit/blob/master/Articles/README.md |
| README.md | https://github.com/XiangGe0405/sqlserver-kit/blob/master/Articles#readme |
| https://github.com/XiangGe0405/sqlserver-kit/blob/master/Articles#microsoft-sql-server-articles |
| SQL Server Common Language Runtime Integration | https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/sql-server-common-language-runtime-integration |
| SQL Server Integration Services | https://docs.microsoft.com/en-us/sql/integration-services/sql-server-integration-services |
| Extended events | https://docs.microsoft.com/en-us/sql/relational-databases/extended-events/extended-events |
| Understanding how SQL Server executes a query | http://rusanu.com/2013/08/01/understanding-how-sql-server-executes-a-query/ |
| SQL Server Index Design Guide | https://technet.microsoft.com/en-us/library/jj835095.aspx |
| SQL Server 2012 Security Best Practices - Microsoft | http://download.microsoft.com/download/8/f/a/8fabacd7-803e-40fc-adf8-355e7d218f4c/sql_server_2012_security_best_practice_whitepaper_apr2012.docx |
| Help, my database is corrupt. Now what? | http://www.sqlservercentral.com/articles/Corruption/65804/ |
| What to Do When DBCC CHECKDB Reports Corruption | https://www.brentozar.com/archive/2016/05/dbcc-checkdb-reports-corruption/ |
| Troubleshooting SQL Server CPU Performance Issues | http://sqlperformance.com/2013/05/io-subsystem/cpu-troubleshooting |
| Knee-Jerk Performance Tuning : Incorrect Use of Temporary Tables | http://sqlperformance.com/2016/04/t-sql-queries/knee-jerk-temporary-tables |
| High Performance T-SQL using Code Patterns | https://dwaincsql.com/2015/05/27/high-performance-t-sql-using-code-patterns/ |
| SQL Server Database Corruption Repair | http://stevestedman.com/2015/08/sql-server-database-corruption-repair/ |
| Basic SQL Server Performance Troubleshooting For Developers | https://www.simple-talk.com/sql/performance/basic-sql-server-performance-troubleshooting-for-developers/ |
| The Curse and Blessings of Dynamic SQL | http://sommarskog.se/dynamic_sql.html |
| Dynamic Search Conditions in T-SQL | http://www.sommarskog.se/dyn-search.html |
| Slow in the Application, Fast in SSMS | http://www.sommarskog.se/query-plan-mysteries.html |
| How to share data between stored procedures | http://www.sommarskog.se/share_data.html |
| Arrays and Lists in SQL Server 2008 | http://www.sommarskog.se/arrays-in-sql-2008.html |
| Packaging Permissions in Stored Procedures | http://www.sommarskog.se/grantperm.html |
| Error and Transaction Handling in SQL Server Part One – Jumpstart Error Handling | http://www.sommarskog.se/error_handling/Part1.html |
| Error and Transaction Handling in SQL Server Part Two – Commands and Mechanisms | http://www.sommarskog.se/error_handling/Part2.html |
| Error and Transaction Handling in SQL Server Part Three – Implementation | http://www.sommarskog.se/error_handling/Part3.html |
| Using the Bulk-Load Tools in SQL Server | http://www.sommarskog.se/bulkload.html |
| Using Table-Valued Parameters in SQL Server and .NET | http://www.sommarskog.se/arrays-in-sql-2008.html |
| SQL Server Columnstore Articles | http://www.nikoport.com/columnstore/ |
| Documentation: It Does not Suck! | https://www.brentozar.com/archive/2013/01/documentation-it-doesnt-suck/ |
| The Data Loading Performance Guide | https://msdn.microsoft.com/en-us/library/dd425070%28v=sql.100%29.aspx |
| Stop Shrinking Your Database Files. Seriously. Now. | https://www.brentozar.com/archive/2009/08/stop-shrinking-your-database-files-seriously-now/ |
| How to shrink a database in 4 easy steps | http://am2.co/2016/04/shrink-database-4-easy-steps/ |
| Introduction to the Index Operational Statistics Dynamic Management Function | http://sqlmag.com/database-performance-tuning/introduction-index-operational-statistics-dynamic-management-function |
| Updating Statistics in SQL Server: Maintenance Questions & Answers | http://www.littlekendra.com/2016/04/18/updating-statistics-in-sql-server-maintenance-answers/ |
| Overcoming Variable Limitations in SQLCmd Mode | http://www.sqlsoldier.com/wp/sqlserver/tsqltuesday65overcomingvariablelimitationsinsqlcmdmode |
| Contents of a Run Book | https://technet.microsoft.com/en-us/library/cc917702.aspx |
| Compressed and Encrypted Backups on the Cheap | https://bornsql.ca/2016/04/compressed-encrypted-backups-cheap/ |
| Curing Data-Obesity in OLTP Databases | https://www.simple-talk.com/sql/database-administration/curing-data-obesity-in-oltp-databases/ |
| Understanding GRANT, DENY, and REVOKE in SQL Server | https://www.mssqltips.com/sqlservertip/2894/understanding-grant-deny-and-revoke-in-sql-server/ |
| Monitor SQL Server Transaction Log File Free Space | https://www.mssqltips.com/sqlservertip/3617/monitor-sql-server-transaction-log-file-free-space/ |
| Dynamically Query a 100 Million Row Table-Efficiently | http://www.sqlservercentral.com/articles/T-SQL/121906/ |
| Parallel Execution Plans – Branches and Threads | http://sqlperformance.com/2013/10/sql-plan/parallel-plans-branches-threads |
| Nasty Fast PERCENT_RANK | http://www.sqlservercentral.com/articles/PERCENT_RANK/141532/ |
| Looking at VIEWs, Close Up | https://www.simple-talk.com/sql/t-sql-programming/looking-at-views,-close-up/ |
| SQL Server 2016: It Just Runs Faster | http://thomaslarock.com/2016/06/sql-server-2016-just-runs-faster/ |
| TSQL JOIN Types Poster | http://stevestedman.com/2015/05/tsql-join-types-poster-version-4-1/ |
| It is Hard To Destroy Data | http://michaeljswart.com/2015/05/its-hard-to-destroy-data/ |
| How to transfer logins and passwords between instances of SQL Server | https://support.microsoft.com/en-us/kb/918992 |
| Finding File Growths with Extended Events | http://nebraskasql.blogspot.ru/2016/06/finding-file-growths-with-extended.html |
| Questions You Should Ask About the Databases You Manage | https://www.brentozar.com/archive/2016/06/questions-ask-databases-manage/ |
| Clustered Indexes in SQL Server | http://www.sqlhammer.com/clustered-indexes-sql-server/ |
| Triage Quiz: Is Your SQL Server Safe? | https://www.brentozar.com/archive/2016/06/triage-quiz-sql-server-safe/ |
| Why Not Just Create Statistics? | https://www.brentozar.com/archive/2016/07/not-just-create-statistics/ |
| Understanding the SQL Server NOLOCK hint | https://www.mssqltips.com/sqlservertip/2470/understanding-the-sql-server-nolock-hint/ |
| Recover access to a SQL Server instance | https://www.mssqltips.com/sqlservertip/2682/recover-access-to-a-sql-server-instance/ |
| SQL Server 2016 Upgrade Planning | http://sqlmag.com/sql-server/sql-server-2016-upgrade-planning-0 |
| Graphs and Graph Algorithms in T-SQL | http://www.hansolav.net/sql/graphs.html |
| Episode 4: SQL Server R Services makes you a smarter T-SQL Developer | https://blogs.msdn.microsoft.com/sqlcat/2016/07/12/sqlsweet16-episode-4-sql-server-r-services-makes-you-a-smarter-t-sql-developer/ |
| How to Set Max Degree of Parallelism in SQL Server | http://www.littlekendra.com/2016/07/14/max-degree-of-parallelism-cost-threshold-for-parallelism/ |
| Undocumented Query Plans: Equality Comparisons | https://www.sql.kiwi/2011/06/undocumented-query-plans-equality-comparisons.html |
| Simplified Order Of Operations | http://michaeljswart.com/2016/07/simplified-order-of-operations/ |
| SQL Server Statistics Basics | https://www.simple-talk.com/sql/performance/sql-server-statistics-basics/ |
| Learn to Use sp_Blitz, sp_BlitzCache, sp_BlitzFirst, and sp_BlitzIndex with These Tutorial Videos | https://www.brentozar.com/archive/2016/09/learn-use-sp_blitz-sp_blitzcache-sp_blitzfirst-sp_blitzindex-tutorial-videos/ |
| Where is a record really located? | https://blogs.msdn.microsoft.com/sql_pfe_blog/2016/09/15/where-is-a-record-really-located/ |
| Instant File Initialization (IFI) | http://stevestedman.com/2016/09/instant-file-initialization-ifi/ |
| How to Query the StackExchange Databases | https://www.brentozar.com/archive/2014/01/how-to-query-the-stackexchange-databases/ |
| How to Troubleshoot Performance in SQL Server (Dear SQL DBA) | http://www.littlekendra.com/2016/06/02/dear-sql-dba-lost-in-performance-troubleshooting/ |
| How to Log Activity Using sp_whoisactive in a Loop | https://www.brentozar.com/responder/log-sp_whoisactive-to-a-table/ |
| Logging Activity Using sp_WhoIsActive – Take 2 | https://www.brentozar.com/archive/2016/07/logging-activity-using-sp_whoisactive-take-2/ |
| How To Fix Forwarded Records | https://www.brentozar.com/archive/2016/07/fix-forwarded-records/ |
| Should I Automate my Windows Updates for SQL Server? | http://www.littlekendra.com/2016/07/28/should-i-automate-my-windows-updates-for-sql-server-dear-sql-dba-episode-10/ |
| Finding the Right Path | http://jasonbrimhall.info/2016/08/24/finding-the-right-path/ |
| #BackToBasics : An Updated "Kitchen Sink" Example | https://www.sentryone.com/blog/aaronbertrand/backtobasics-updated-kitchen-sink-example |
| Locking and Blocking in SQL Server | https://www.brentozar.com/sql/locking-and-blocking-in-sql-server/ |
| Nested Loops Prefetching | https://www.sql.kiwi/2013/08/sql-server-internals-nested-loops-prefetching.html |
| Performance tuning backup and restore operations | http://www.sqlhammer.com/performance-tuning-backup-restore-operations/ |
| Execution Plan Analysis: The Mystery Work Table | https://www.sql.kiwi/2013/03/execution-plan-analysis-the-mystery-work-table.html |
| How to move data between File Groups in SQL Server | http://www.sqlpassion.at/archive/2016/09/26/how-to-move-data-between-file-groups-in-sql-server/ |
| Optimizing Your Query Plans with the SQL Server 2014 Cardinality Estimator | https://docs.microsoft.com/en-us/previous-versions/dn673537(v=msdn.10)?redirectedfrom=MSDN |
| Parallelism in SQL Server Query Tuning | http://sqlmag.com/sql-server/parallelism-sql-server-query-tuning |
| What You Need to Know about the Batch Mode Window Aggregate Operator in SQL Server 2016: Part 1 | http://sqlmag.com/sql-server/what-you-need-know-about-batch-mode-window-aggregate-operator-sql-server-2016-part-1 |
| What To Do If sp_BlitzFirst Warns About High Compilations | https://www.brentozar.com/archive/2016/09/what-to-do-if-sp_blitzfirst-warns-about-high-compilations/ |
| Questions You Should Be Asking About Your Backups | https://www.brentozar.com/archive/2016/10/questions-asking-backups/ |
| Evolutionary Database Design | http://martinfowler.com/articles/evodb.html |
| Implementing a custom sort | https://sqlperformance.com/2016/10/sql-plan/implementing-custom-sort |
| Deletes that Split Pages and Forwarded Ghosts | https://www.sql.kiwi/2012/08/deletes-that-split-pages-and-forwarded-ghosts.html |
| Query Optimizer Deep Dive - Part 1 | https://www.sql.kiwi/2012/04/query-optimizer-deep-dive-part-1.html |
| Query Optimizer Deep Dive - Part 2 | https://www.sql.kiwi/2012/04/query-optimizer-deep-dive-part-2.html |
| Query Optimizer Deep Dive - Part 3 | https://www.sql.kiwi/2012/04/query-optimizer-deep-dive-part-3.html |
| Query Optimizer Deep Dive - Part 4 | https://www.sql.kiwi/2012/05/query-optimizer-deep-dive-part-4.html |
| Should You Rebuild or Reorganize Indexes on Large Tables? | https://www.littlekendra.com/2016/10/13/should-you-rebuild-or-reorganize-indexes-on-large-tables-dear-sql-dba-episode-19/ |
| Retrieving SQL Server Query Execution Plans | https://www.simple-talk.com/sql/database-administration/retrieving-sql-server-query-execution-plans/ |
| Introduction to Latches in SQL Server | http://www.sqlpassion.at/archive/2014/06/23/introduction-to-latches-in-sql-server/ |
| Latch Coupling in SQL Server | https://www.sqlpassion.at/archive/2016/10/24/latch-coupling-in-sql-server/ |
| Partitioned Views? A How-To Guide | https://www.brentozar.com/archive/2016/09/partitioned-views-guide/ |
| TroubleShooting SQL Server Memory Consumption | http://www.sql-server-performance.com/2016/trouble-shooting-sql-server-ra-memory-consumption/ |
| Time Series Algorithms in SQL Server | http://www.sql-server-performance.com/2015/time-series-algorithms-sql-server/ |
| Internals of the Seven SQL Server Sorts – Part 1 | https://sqlperformance.com/2015/04/sql-plan/internals-of-the-seven-sql-server-sorts-part-1 |
| Internals of the Seven SQL Server Sorts – Part 2 | https://sqlperformance.com/2015/05/sql-plan/internals-of-the-seven-sql-server-sorts-part-2 |
| The 9 Letters That Get DBAs Fired | https://www.brentozar.com/archive/2011/12/letters-that-get-dbas-fired/ |
| Restarting SQL Server – always a good idea? | https://www.sqlpassion.at/archive/2016/08/08/restarting-sql-server-always-a-good-idea/ |
| Don’t believe everything you read: Reconfigure flushes the plan cache | https://mattsql.wordpress.com/2012/06/25/dont-believe-everything-you-read-reconfigure-flushes-the-plan-cache/ |
| How-to load data fast into SQL Server 2016 | http://henkvandervalk.com/how-to-load-data-fast-into-sql-server-2016 |
| Database Design Matters, RTO and Filegroups | http://www.sqldoubleg.com/2016/10/28/database-design-matters-rto-and-filegroups/ |
| Automate Alerting for SQL Server Suspect Database Pages | https://www.mssqltips.com/sqlservertip/4166/automate-alerting-for-sql-server-suspect-database-pages/ |
| Successful Anti-Patterns, Storage Requirements | http://www.sqldoubleg.com/2016/10/19/successful-anti-patterns-storage-requirements/ |
| SQL Server table columns under the hood | http://rusanu.com/2011/10/20/sql-server-table-columns-under-the-hood/ |
| How to analyse SQL Server performance | http://rusanu.com/2014/02/24/how-to-analyse-sql-server-performance/ |
| Asynchronous procedure execution | http://rusanu.com/2009/08/05/asynchronous-procedure-execution/ |
| What is the CXPACKET Wait Type, and How Do You Reduce It? | https://www.brentozar.com/archive/2013/08/what-is-the-cxpacket-wait-type-and-how-do-you-reduce-it/ |
| New indexes, hypothetically | https://sqlstudies.com/2016/11/02/new-indexes-hypothetically/ |
| Indexing Wide Keys in SQL Server | https://www.brentozar.com/archive/2013/05/indexing-wide-keys-in-sql-server/ |
| The Anatomy and (In)Security of Microsoft SQL Server Transparent Data Encryption (TDE), or How to Break TDE | http://simonmcauliffe.com/technology/tde/ |
| Correctly adding data files to tempdb | http://www.sqlskills.com/blogs/paul/correctly-adding-data-files-tempdb/ |
| Why You Should Test Your Queries Against Bigger Data | https://www.brentozar.com/archive/2016/11/why-you-should-test-your-queries-against-bigger-data/ |
| Tally OH! An Improved SQL 8K “CSV Splitter” Function | http://www.sqlservercentral.com/articles/Tally+Table/72993/ |
| Set Statistics… Profile? | https://www.brentozar.com/archive/2016/10/set-statistics-profile/ |
| Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets | http://www.sqlservercentral.com/articles/Hierarchy/94040/ |
| Optimizing T-SQL queries that change data | https://www.sql.kiwi/2013/01/optimizing-t-sql-queries-that-change-data.html |
| Measuring Query Duration: SSMS vs SQL Sentry Plan Explorer | https://www.littlekendra.com/2016/09/27/measuring-query-duration-ssms-vs-sql-sentry-plan-explorer/ |
| Inside the Statistics Histogram & Density Vector | http://www.sqlpassion.at/archive/2014/01/28/inside-the-statistics-histogram-density-vector/ |
| Misconceptions on parameter sniffing | https://sqlserverfast.com/blog/hugo/2016/11/misconceptions-on-parameter-sniffing/ |
| What Every Accidental DBA Needs to Know Now: Basics of SQL Security | http://sqlmag.com/database-security/what-every-accidental-dba-needs-know-now-basics-sql-security |
| SQL Server Perfmon (Performance Monitor) Best Practices | https://www.brentozar.com/archive/2006/12/dba-101-using-perfmon-for-sql-performance-tuning/ |
| Top 5 Overlooked Index Features | https://www.brentozar.com/archive/2016/11/top-5-overlooked-index-features/ |
| A Sysadmin’s Guide to Microsoft SQL Server Memory | https://www.brentozar.com/archive/2011/09/sysadmins-guide-microsoft-sql-server-memory/ |
| Searching Strings in SQL Server is Expensive | https://www.brentozar.com/archive/2016/10/searching-strings-sql-server-expensive/ |
| Altering an INT Column to a BIGINT | https://www.littlekendra.com/2016/08/04/altering-an-int-column-to-a-bigint-dear-sql-dba-episode-11/ |
| Query tuning 101: Problems with IN () | http://www.sqlservercentral.com/blogs/confessions-of-a-microsoft-addict/2016/11/10/query-tuning-101-problems-with-in-/ |
| Admin: Bulkadmin vs ADMINISTER BULK OPERATIONS | http://richbrownesq-sqlserver.blogspot.ru/2012/01/admin-bulkadmin-vs-administer-bulk.html |
| Can Indexes My Query Doesn’t Use Help My Query? | https://www.brentozar.com/archive/2016/11/can-indexes-query-doesnt-use-help-query/ |
| SQL Server Audit Walkthrough | http://www.sql-server-performance.com/2016/walkthrough-sql-server-audit/ |
| The SQL Server 2016 Query Store: Overview and Architecture | https://www.simple-talk.com/sql/database-administration/the-sql-server-2016-query-store-overview-and-architecture/ |
| Reading, Writing, and Creating SQL Server Extended Properties | https://www.simple-talk.com/sql/database-delivery/reading-writing-creating-sql-server-extended-properties/ |
| Questions About SQL Server Security and Access Control You Were Too Shy to Ask | https://www.simple-talk.com/sql/database-delivery/questions-sql-server-security-access-control-shy-ask/ |
| The Ten Commandments of SQL Server Monitoring | https://www.simple-talk.com/sql/database-administration/the-ten-commandments-of-sql-server-monitoring/ |
| Should I use NOT IN, OUTER APPLY, LEFT OUTER JOIN, EXCEPT, or NOT EXISTS? | https://sqlperformance.com/2012/12/t-sql-queries/left-anti-semi-join |
| Parameter Sniffing, Embedding, and the RECOMPILE Options | https://sqlperformance.com/2013/08/t-sql-queries/parameter-sniffing-embedding-and-the-recompile-options |
| Can comments hamper stored procedure performance? | https://sqlperformance.com/2016/11/sql-performance/comments-hamper-performance |
| SQL Server Temporary Table Caching | https://www.mssqltips.com/sqlservertip/4406/sql-server-temporary-table-caching/ |
| Techniques to Monitor SQL Server memory usage | http://www.sql-server-performance.com/2016/monitor-sql-server-memory-usage/ |
| Troubleshooting Query Regressions Caused By The New Cardinality Estimator | https://sqlserverscotsman.wordpress.com/2016/11/24/troubleshooting-query-regressions-caused-by-the-new-cardinality-estimator/ |
| Migrating Databases to Azure SQL Database | https://sqlperformance.com/2016/10/sql-performance/migrating-to-azure-sql-database |
| Solve Common SQL Server Restore Issues | https://www.mssqltips.com/sqlservertip/4110/solve-common-sql-server-restore-issues/ |
| Spills SQL Server Doesn’t Warn You About | https://www.brentozar.com/archive/2016/11/spills-sql-server-doesnt-warn/ |
| How often should I run DBCC CHECKDB? | https://www.brentozar.com/archive/2016/02/how-often-should-i-run-dbcc-checkdb/ |
| Why is My Query Faster the Second Time it Runs? | https://www.littlekendra.com/2016/11/25/why-is-my-query-faster-the-second-time-it-runs-dear-sql-dba-episode-23/ |
| Downgrading the SQL Server Edition of a Dev Environment | https://www.littlekendra.com/2016/11/15/downgrading-the-sql-server-edition-of-a-dev-environment/ |
| Date Math In The WHERE Clause | https://www.brentozar.com/archive/2016/12/date-math-clause/ |
| Why is This Partitioned Query Slower? | https://www.brentozar.com/archive/2015/09/why-is-this-partitioned-query-slower/ |
| A Beginner’s Guide to the True Order of SQL Operations | https://blog.jooq.org/2016/12/09/a-beginners-guide-to-the-true-order-of-sql-operations/ |
| Logical Query Processing: What It Is And What It Means to You | http://sqlmag.com/sql-server/logical-query-processing-what-it-and-what-it-means-you |
| Forcing a Parallel Query Execution Plan | https://www.sql.kiwi/2011/12/forcing-a-parallel-query-execution-plan.html |
| Join Containment Assumption and CE Model Variation | http://www.queryprocessor.com/ce_join_base_containment_assumption/ |
| Table Variable Tip | http://sqlmag.com/t-sql/table-variable-tip |
| Heap tables in SQL Server | http://www.sqlhammer.com/heaps-in-microsoft-sql-server/ |
| The ‘B’ in B-Tree – Indexing in SQL Server | http://www.sqlhammer.com/the-b-in-b-tree-indexing-sql-server/ |
| How to read the SQL Server Database Transaction Log | https://www.mssqltips.com/sqlservertip/3076/how-to-read-the-sql-server-database-transaction-log/ |
| Filtered Statistics Follow-up | https://www.brentozar.com/archive/2016/12/filtered-statistics-follow/ |
| SQL Server Query Optimization: No Unknown Unknowns | http://sqlmag.com/sql-server/sql-server-query-optimization-no-unknown-unknowns |
| Sync Vs Async Statistics: The Old Debate | https://sqlserverscotsman.wordpress.com/2016/12/10/sync-vs-async-statistics-the-old-debate/ |
| Recommended updates and configuration options for SQL Server 2012 and SQL Server 2014 with high-performance workloads | https://support.microsoft.com/en-gb/kb/2964518 |
| Troubleshooting SQL Server backup and restore operations | https://support.microsoft.com/en-us/kb/224071 |
| SQL Server 2016: Getting tempdb a little more right | https://www.sentryone.com/blog/aaronbertrand/sql-server-2016-tempdb-fixes |
| Practical uses of binary types | https://sqlsunday.com/2017/01/09/binary-types/ |
| Backing Up SQL Server Databases is Easier in PowerShell than T-SQL | http://www.sqlservercentral.com/articles/PowerShell/151510/ |
| Creating, detaching, re-attaching, and fixing a SUSPECT database | http://www.sqlskills.com/blogs/paul/creating-detaching-re-attaching-and-fixing-a-suspect-database/ |
| Modifying Tables Online – Part 1: Migration Strategy | http://michaeljswart.com/2012/04/modifying-tables-online-part-1-migration-strategy/ |
| Modifying Tables Online – Part 2: Implementation Example | http://michaeljswart.com/2012/04/modifying-tables-online-part-2-implementation-example/ |
| Modifying Tables Online – Part 3: Example With Error Handling | http://michaeljswart.com/2012/04/modifying-tables-online-part-3-example-with-error-handling/ |
| Modifying Tables Online – Part 4: Testing | http://michaeljswart.com/2012/04/modifying-tables-online-part-4-testing/ |
| Modifying Tables Online – Part 5: Just One More Thing | http://michaeljswart.com/2012/04/modifying-tables-online-part-5-just-one-more-thing/ |
| DATEDIFF vs. DATEADD | http://www.madeiradata.com/datediff-vs-dateadd/ |
| Disaster recovery 101: hack-attach a damaged database | http://www.sqlskills.com/blogs/paul/disaster-recovery-101-hack-attach-a-damaged-database/ |
| Bones of SQL - The Calendar Table | http://www.sqlservercentral.com/articles/calendar/145206/ |
| SQL Server 2016, Double or Nothing, Always Encrypted with temporal tables | http://www.sqldoubleg.com/2016/07/27/sql-server-2016-double-or-nothing-always-encrypted-with-temporal-tables/ |
| Reclaiming Space After Column Data Type Change | http://www.sqlservercentral.com/articles/data+type/144308/ |
| Packing Intervals with Priorities | http://sqlmag.com/sql-server/packing-intervals-priorities |
| Avoid Unnecessary Lookups when Using ROW_NUMBER for Paging | http://sqlmag.com/t-sql/avoid-unnecessary-lookups-when-using-rownumber-paging |
| Migrating a Disk-Based Table to a Memory-Optimized Table in SQL Server | https://www.simple-talk.com/sql/database-administration/migrating-disk-based-table-memory-optimized-table-sql-server/ |
| SQL Server Hardware Optimization | http://www.sql-server-performance.com/2016/sql-server-hardware-optimization/ |
| Index Types Heaps, Primary Keys, Clustered and Nonclustered Indexes | https://www.littlekendra.com/2017/02/02/index-types-heaps-primary-keys-clustered-and-nonclustered-indexes-dear-sql-dba-episode-28/ |
| Identifying Existence of Intersections in Intervals | http://sqlmag.com/sql-server/identifying-existence-intersections-intervals |
| Cheat Sheet How to Configure TempDB for Microsoft SQL Server | https://www.brentozar.com/archive/2016/01/cheat-sheet-how-to-configure-tempdb-for-microsoft-sql-server/ |
| A Tourist’s Guide to the sp_Blitz Source Code, Part 1: The Big Picture | https://www.brentozar.com/archive/2017/02/tourists-guide-sp_blitz-source-code-part-1-big-picture/ |
| SQL Server Default Configurations That You Should Change | https://www.pythian.com/blog/sql-server-default-configurations-change/ |
| Decoding Key and Page WaitResource for Deadlocks and Blocking | https://www.littlekendra.com/2016/10/17/decoding-key-and-page-waitresource-for-deadlocks-and-blocking/ |
| Security in the CLR World Inside SQL Server | http://www.codemag.com/article/0603031 |
| On the Advantages of DateTime2(n) over DateTime | http://www.sqltact.com/2012/12/on-advantages-of-datetime2n-over.html |
| Build Your Own Tools | http://michaeljswart.com/2016/09/build-your-own-tools/ |
| Enhanced T-SQL Error Handling With Extended Events | http://itsalljustelectrons.blogspot.ru/2016/09/Enhanced-TSQL-Error-Handling-With-Extended-Events.html |
| Compression and its Effects on Performance | https://sqlperformance.com/2017/01/sql-performance/compression-effect-on-performance |
| Does Truncate Table Reset Statistics | https://www.littlekendra.com/2016/12/08/does-truncate-table-reset-statistics/ |
| SQL Server Database Decommissioning Check List | https://www.mssqltips.com/sqlservertip/4333/sql-server-database-decommissioning-check-list/ |
| New SQL Server Database Request Questionnaire and Checklist | https://www.mssqltips.com/sqlservertip/3523/new-sql-server-database-request-questionnaire-and-checklist/ |
| Adding Partitions to the Lower End of a Left Based Partition Function | https://www.littlekendra.com/2017/02/21/adding-partitions-to-the-lower-end-of-a-left-based-partition-function/ |
| Don't Panic Busting a File Space Myth | http://sqlmag.com/database-administration/dont-panic-busting-file-space-myth |
| #BackToBasics : Dating Responsibly | https://www.sentryone.com/blog/aaronbertrand/backtobasics-dating-responsibly/ |
| How to Establish Dedicated Admin Connection (DAC) to SQL Server | https://www.codeproject.com/tips/1136361/how-to-establish-dedicated-admin-connection-dac-to |
| SQL and SQL only Best Practice | http://strictlysql.blogspot.ru/search/label/Best%20Practices |
| There Is No Difference Between Table Variables, Temporary Tables, and Common Table Expressions | https://dzone.com/articles/there-is-no-difference-between-table-variables-tem |
| Availability Group on SQL Server 2016 | http://www.madeiradata.com/availability-group-sql-server-2016/ |
| Using SQL Server and R Services for analyzing DBA Tasks | http://www.sqlservercentral.com/articles/R+Language/151405/ |
| SQLskills SQL101: Dealing with SQL Server corruption | https://www.sqlskills.com/blogs/paul/sqlskills-sql101-dealing-with-sql-server-corruption/ |
| Advanced Analytics with R & SQL: Part I - R Distributions | http://www.sqlservercentral.com/articles/Data+Science/146555/ |
| T-SQL Tuesday #85 STOP! Restore Time! | http://www.sqlhammer.com/t-sql-tuesday-85-stop-restore-time |
| Filtered Indexes: Rowstore vs Nonclustered Columnstore | https://www.littlekendra.com/2016/11/10/filtered-indexes-rowstore-vs-nonclustered-columnstore/ |
| ALTER SCHEMA TRANSFER for Zero Downtime Database Upgrades | http://www.davewentzel.com/content/alter-schema-transfer-zero-downtime-database-upgrades |
| Delayed Durability in SQL Server 2014 | https://sqlperformance.com/2014/04/io-subsystem/delayed-durability-in-sql-server-2014 |
| Daylight Savings end affects not only you, but your SQL Server too | http://www.sqldoubleg.com/2015/10/28/daylight-savings-end-affects-not-only-you-but-your-sql-server-too/ |
| Let’s Corrupt a SQL Server Database Together, Part 1: Clustered Indexes | https://www.brentozar.com/archive/2017/02/lets-corrupt-sql-server-database-together/ |
| Let’s Corrupt a Database Together, Part 2: Nonclustered Indexes | https://www.brentozar.com/archive/2017/02/lets-corrupt-database-together-part-2-nonclustered-indexes/ |
| The Guide SQL Server Installation Checklist (settings that increase SQL Server Performance) | https://red9.com/blog/sql-server-installation-checklist/ |
| SQL Browser, what is it good for? Absolutely something! | http://www.cjsommer.com/2017-03-01-sql-browser-what-is-it-good-for-absolutely-something/ |
| PowerShell Getting More From Generic Error Messages | https://nocolumnname.wordpress.com/2017/03/02/powershell-getting-more-from-generic-error-messages/ |
| #BackToBasics : Common Table Expressions (CTEs) | https://www.sentryone.com/blog/aaronbertrand//backtobasics-ctes/ |
| SQL VNext sp_configure on Windows and Linux with dbatools | https://sqldbawithabeard.com/2017/02/27/sql-vnext-sp_configure-on-windows-and-linux-with-dbatools/ |
| Adding a T-SQL Job Step to a SQL Agent Job with PowerShell | https://sqldbawithabeard.com/2017/02/20/adding-a-t-sql-job-step-to-a-sql-agent-job-with-powershell/ |
| Setting up Database Mail to use my Gmail account | https://mathaywardhill.com/2017/03/01/setting-up-database-mail-to-use-my-gmail-account/ |
| Using DBCC CLONEDATABASE and Query Store for Testing | https://sqlperformance.com/2017/02/sql-performance/clonedatabase-query-store-testing |
| Getting Started with Natural Earth — A SQL Server Shapefile Alternative (Geospatial Resource) | http://blog.jpries.com/2017/02/17/getting-started-with-natural-earth-sql-server/ |
| SQL Server Temporal Tables: How-To Recipes | https://www.simple-talk.com/sql/sql-training/sql-server-temporal-tables-recipes/ |
| The Migration Checklist | http://www.sqlservercentral.com/articles/Editorial/154033/ |
| Upgrading to SQL Server 2014: A Dozen Things to Check | https://thomaslarock.com/2014/06/upgrading-to-sql-server-2014-a-dozen-things-to-check/ |
| Introducing the Set-based Loop | http://www.sqlservercentral.com/articles/set-based+loop/127670/ |
| Representing Hierarchical Data for Mere Mortals | https://www.simple-talk.com/sql/database-administration/representing-hierarchical-data-for-mere-mortals/ |
| KPIs For DBAs to Show Their CIOs | https://thomaslarock.com/2017/03/kpis-dbas-show-cios/ |
| How To Forecast Database Disk Capacity If You Don’t Have A Monitoring Tool | http://www.edwinmsarmiento.com/how-to-forecast-database-disk-capacity-if-you-dont-have-a-monitoring-tool/ |
| Statistical Sampling for Verifying Database Backups | https://www.simple-talk.com/sql/database-administration/statistical-sampling-for-verifying-database-backups/ |
| Using dbatools for automated restore and CHECKDB | http://www.centinosystems.com/blog/sql/using-dbatools-for-automated-restore-and-checkdb/ |
| Bad Habits Revival | https://www.sentryone.com/blog/aaronbertrand/bad-habits-revival/ |
| Deploying Multiple SSIS Projects via PowerShell | https://www.simple-talk.com/sql/ssis/deploying-multiple-ssis-projects-via-powershell/ |
| Determining the Cost Threshold for Parallelism | http://www.scarydba.com/2017/02/28/determining-the-cost-threshold-for-parallelism/ |
| Identifying a row’s physical location | http://blog.waynesheffield.com/wayne/archive/2017/03/identifying-rows-physical-location/ |
| Split a file group into multiple data files | https://blogs.msdn.microsoft.com/sql_pfe_blog/2017/03/03/split-a-file-group-into-multiple-data-files/ |
| Why PFS pages cannot be repaired | https://www.sqlskills.com/blogs/paul/why-pfs-pages-cannot-be-repaired/ |
| ERRORLOG records max out at 2049 characters | https://www.codykonior.com/2017/03/02/errorlog-records-max-out-at-2047-characters/ |
| How to Build a SQL Server Disaster Recovery Plan with Google Compute Engine | https://www.brentozar.com/archive/2017/03/new-white-paper-build-sql-server-disaster-recovery-plan-google-compute-engine/ |
| SQL Server Performance Tuning in Google Compute Engine | https://www.brentozar.com/archive/2017/03/new-white-paper-sql-server-performance-tuning-google-compute-engine/ |
| Configuring R on SQL Server 2016 | http://sqlmag.com/sql-server/configuring-r-sql-server-2016 |
| Knee-Jerk PerfMon Counters: Page Life Expectancy | https://sqlperformance.com/2014/10/sql-performance/knee-jerk-page-life-expectancy |
| Change Management Template for SQL Server DBAs and Developers | https://www.littlekendra.com/2016/04/12/change-management-template-for-sql-server-dbas-and-deveopers/ |
| Performance Myths: Clustered vs. Non-Clustered Indexes | https://sqlperformance.com/2017/03/sql-indexes/performance-myths-clustered-vs-non-clustered |
| Bad habits: Counting rows the hard way | https://sqlperformance.com/2014/10/t-sql-queries/bad-habits-count-the-hard-way |
| Why Cost Threshold For Parallelism Shouldn’t Be Set To 5 | https://www.brentozar.com/archive/2017/03/why-cost-threshold-for-parallelism-shouldnt-be-set-to-5/ |
| Join Performance, Implicit Conversions, and Residuals | https://www.sql.kiwi/2011/07/join-performance-implicit-conversions-and-residuals.html |
| Implicit Conversions that cause Index Scans | https://www.sqlskills.com/blogs/jonathan/implicit-conversions-that-cause-index-scans/ |
| When Is It Appropriate To Store JSON in SQL Server? | https://bertwagner.com/2017/03/14/when-is-it-appropriate-to-store-json-in-sql-server/ |
| The Performance Penalty of Bookmark Lookups in SQL Server | http://www.sqlpassion.at/archive/2017/03/13/the-performance-penalty-of-bookmark-lookups-in-sql-server/ |
| Why You Should Change the Cost Threshold for Parallelism | http://www.scarydba.com/2017/03/13/change-the-cost-threshold-for-parallelism/ |
| Why Update Statistics can cause an IO storm | https://www.brentozar.com/archive/2014/01/update-statistics-the-secret-io-explosion/ |
| SQLskills SQL101 Temporary table misuse | https://www.sqlskills.com/blogs/paul/sqlskills-sql101-temporary-table-misuse/ |
| SQL Server sp_execute_external_script Stored Procedure Examples | https://www.mssqltips.com/sqlservertip/4747/sql-server-spexecuteexternalscript-stored-procedure-examples/ |
| Transparent Data Encryption and Replication | http://port1433.com/2017/03/15/transparent-data-encryption-and-replication-sql-servers-rear-window/ |
| SQL Server Installation Checklist | https://www.sqlskills.com/blogs/jonathan/sql-server-installation-checklist/ |
| Indexed Views And Data Modifications | https://www.brentozar.com/archive/2017/03/indexed-views-data-modifications/ |
| Deployment Automation for SQL Server Integration Services (SSIS) | https://www.simple-talk.com/sql/ssis/deployment-automation-for-sql-server-integration-services-ssis/ |
| Why Developers Should Consider Microsoft SQL Server | https://www.brentozar.com/archive/2017/03/developers-consider-microsoft-sql-server/ |
| SQLskills SQL101: Indexes on Foreign Keys | https://www.sqlskills.com/blogs/kimberly/sqlskills-sql101-indexes-foreign-keys/ |
| SQLskills SQL101: Updating SQL Server Statistics Part I – Automatic Updates | https://www.sqlskills.com/blogs/erin/sqlskills-sql101-updating-sql-server-statistics-part-i-automatic-updates/ |
| Processing Loops in SQL Server | https://www.codeproject.com/Articles/1177788/Processing-Loops-in-SQL-Server |
| The Mysterious Case of the Missing Default Value | http://www.sqlservercentral.com/articles/SQL+Server+internal+storage/132990/ |
| Plan Caching | https://www.sqlpassion.at/archive/2017/03/20/plan-caching/ |
| sp_executesql Is Not Faster Than an Ad Hoc Query | http://www.sqlservercentral.com/blogs/scarydba/2016/11/07/sp_executesql-is-not-faster-than-an-ad-hoc-query/ |
| Backing up SQL Server on Linux using Ola Hallengrens Maintenance Solution | https://sqldbawithabeard.com/2017/03/22/backing-up-sql-server-on-linux-using-ola-hallengrens-maintenance-solution/ |
| Delayed Durability in SQL Server 2014 Paul Randal | http://www.sqlskills.com/blogs/paul/delayed-durability-sql-server-2014/ |
| Why Is This Query Sometimes Fast and Sometimes Slow | https://www.brentozar.com/archive/2016/11/query-sometimes-fast-sometimes-slow/ |
| Using Plan Guides to Remove OPTIMIZE FOR UNKNOWN Hints | https://www.brentozar.com/archive/2016/11/using-plan-guides-remove-optimize-unknown-hints/ |
| ETL Best Practices | https://www.timmitchell.net/etl-best-practices/ |
| Resolving Key Lookup Deadlocks with Plan Explorer | https://www.sentryone.com/blog/greggonzalez/key-lookup-deadlocks-plan-explorer/ |
| Why ROWLOCK Hints Can Make Queries Slower and Blocking Worse in SQL Server | https://www.littlekendra.com/2016/02/04/why-rowlock-hints-can-make-queries-slower-and-blocking-worse-in-sql-server/ |
| Does a Clustered Index really physically store the rows in key order | http://www.sqlservercentral.com/blogs/discussionofsqlserver/2012/10/21/does-a-clustered-index-really-physically-store-the-rows-in-key-order/ |
| Ugly Pragmatism For The Win | http://michaeljswart.com/2016/02/ugly-pragmatism-for-the-win/ |
| Architecting Microsoft SQL Server on VMware vSphere | http://www.vmware.com/content/dam/digitalmarketing/vmware/en/pdf/solutions/sql-server-on-vmware-best-practices-guide.pdf |
| Hiding tables in SSMS Object Explorer | https://sqlstudies.com/2017/04/03/hiding-tables-in-ssms-object-explorer-using-extended-properties/ |
| Clustered columnstore: on-disk vs. in-mem | http://nedotter.com/archive/2017/03/clustered-columnstore-on-disk-vs-in-mem/ |
| Generating Plots Automatically From PowerShell and SQL Server Using Gnuplot | https://www.simple-talk.com/sql/database-delivery/generating-plots-automatically-powershell-sql-server-using-gnuplot/ |
| How to Benchmark Alternative SQL Queries to Find the Fastest Query | https://blog.jooq.org/2017/03/29/how-to-benchmark-alternative-sql-queries-to-find-the-fastest-query/ |
| Checking for Strange Client Settings with sys.dm_exec_sessions | https://www.brentozar.com/archive/2017/03/checking-strange-client-settings-sys-dm_exec_sessions/ |
| Decrypting Insert Query Plans | https://www.brentozar.com/archive/2017/03/decrypting-insert-query-plans/ |
| SQLskills SQL101: Partitioning | https://www.sqlskills.com/blogs/kimberly/sqlskills-sql101-partitioning/ |
| SQLskills SQL101: Switching recovery models | https://www.sqlskills.com/blogs/paul/sqlskills-sql101-switching-recovery-models/ |
| Using AT TIME ZONE to fix an old report | https://sqlperformance.com/2017/02/t-sql-queries/using-at-time-zone-to-fix-an-old-report |
| What the heck is a DTU | https://sqlperformance.com/2017/03/azure/what-the-heck-is-a-dtu |
| Hack-Attaching a SQL Server database with NORECOVERY | http://sqlblog.com/blogs/argenis_fernandez/archive/2017/01/24/hack-attaching-a-sql-server-database-with-norecovery.aspx |
| Switch in Staging Tables Instead of sp_rename | https://www.littlekendra.com/2017/01/19/why-you-should-switch-in-staging-tables-instead-of-renaming/ |
| Performance Myths: Table variables are always in-memory | https://sqlperformance.com/2017/04/performance-myths/table-variables-in-memory |
| Questions About SQL Server Collations You Were Too Shy to Ask | https://www.simple-talk.com/sql/sql-development/questions-sql-server-collations-shy-ask/ |
| NULL - The database's black hole | https://sqlserverfast.com/blog/hugo/2007/07/null-the-databases-black-hole/ |
| For The Better Developer: SQL Server Indexes | https://medium.com/sql-server-for-the-better-developer/know-your-data-base-affd6241bcac |
| #EntryLevel: Compression & Data Types | https://www.sentryone.com/blog/melissaconnors/entry-level-compression/ |
| Cardinality Estimation for a Predicate on a COUNT Expression | https://sqlperformance.com/2017/04/sql-optimizer/cardinality-count |
| Changing SQL Server Collation After Installation | https://www.mssqltips.com/sqlservertip/3519/changing-sql-server-collation-after-installation/ |
| Does a TempDB spill mean statistics are out of date? | https://www.brentozar.com/archive/2017/04/tempdb-spill-mean-statistics-date/ |
| Transaction log growth during BACKUP | https://www.am2.co/2017/04/transaction-log-growth-backup/ |
| When is a SQL function not a function? | http://blogs.lobsterpot.com.au/2011/11/08/when-is-a-sql-function-not-a-function/ |
| Introducing Batch Mode Adaptive Joins | https://blogs.msdn.microsoft.com/sqlserverstorageengine/2017/04/19/introducing-batch-mode-adaptive-joins/ |
| Investigating the proportional fill algorithm | https://www.sqlskills.com/blogs/paul/investigating-the-proportional-fill-algorithm/ |
| Understanding Logging and Recovery in SQL Server | https://technet.microsoft.com/en-us/library/2009.02.logging.aspx |
| Bad Habits to Kick: Using shorthand with date/time operations | https://sqlblog.org/2011/09/20/bad-habits-to-kick-using-shorthand-with-date-time-operations |
| Generating Charts and Drawings in SQL Server Management Studio | http://sqlmag.com/t-sql/generating-charts-and-drawings-sql-server-management-studio |
| How expensive are column-side Implicit Conversions? | https://sqlperformance.com/2013/04/t-sql-queries/implicit-conversion-costs |
| Execution Plan Basics | https://www.simple-talk.com/sql/performance/execution-plan-basics/ |
| Disabling ROW and PAGE Level Locks in SQL Server | http://www.sqlpassion.at/archive/2016/10/31/disabling-row-and-page-level-locks-in-sql-server/ |
| Fixing Cardinality Estimation Errors with Filtered Statistics | https://www.sqlpassion.at/archive/2013/10/29/fixing-cardinality-estimation-errors-with-filtered-statistics/ |
| Cardinality Estimation for Multiple Predicates | https://sqlperformance.com/2014/01/sql-plan/cardinality-estimation-for-multiple-predicates |
| Weaning yourself off of SQL Profiler (Part 1) | http://blog.waynesheffield.com/wayne/archive/2017/04/weaning-yourself-off-sql-profiler/ |
| Properly Persisted Computed Columns | https://sqlperformance.com/2017/05/sql-plan/properly-persisted-computed-columns |
| A SQL Server DBA myth a day: (17/30) page checksums | https://www.sqlskills.com/blogs/paul/a-sql-server-dba-myth-a-day-1730-page-checksums/ |
| What are different ways to replace ISNULL() in a WHERE clause that uses only literal values? | https://dba.stackexchange.com/questions/168276/what-are-different-ways-to-replace-isnull-in-a-where-clause-that-uses-only-lit |
| SQL Server 2016 enhancements – Truncate Table and Table Partitioning | https://www.sqlshack.com/sql-server-2016-enhancements-truncate-table-table-partitioning |
| SQL Server Mysteries: The Case of the Not 100% RESTORE… | https://blogs.msdn.microsoft.com/sql_server_team/sql-server-mysteries-the-case-of-the-not-100-restore/ |
| Transactional Replication and Stored Procedure Execution: Silver Bullet or Poison Pill? | http://port1433.com/2017/04/11/transactional-replication-and-stored-procedure-execution-silver-bullet-or-poison-pill/ |
| STOPAT And Date Formats | https://itsalljustelectrons.blogspot.ru/2017/07/STOPAT-And-Date-Formats.html |
| Row-count Estimates when there are no Statistics | http://www.sqlservercentral.com/blogs/matthew-mcgiffen-dba/2017/06/28/row-count-estimates-when-there-are-no-statistics/ |
| SQL Server DBA On-Boarding Checklist | https://www.mssqltips.com/sqlservertip/4871/sql-server-dba-onboarding-checklist/ |
| Be Wary of Date Formatting in T-SQL | https://bornsql.ca/2017/07/wary-date-formatting-t-sql/ |
| Statistics and Cardinality Estimation | http://www.sqlservercentral.com/blogs/matthew-mcgiffen-dba/2017/06/20/statistics-and-cardinality-estimation/ |
| Message queues for the DBA: sending data out into the world | http://port1433.com/2017/07/21/messaging-queuing-for-the-dba-sending-data-out-into-the-world/ |
| Schema-Based Access Control for SQL Server Databases | https://www.red-gate.com/simple-talk/sql/sql-training/schema-based-access-control-for-sql-server-databases/ |
| SQL Server: large RAM and DB Checkpointing | https://blogs.msdn.microsoft.com/psssql/2017/06/29/sql-server-large-ram-and-db-checkpointing/ |
| Handling SQL Server Deadlocks With Event Notifications | https://itsalljustelectrons.blogspot.ru/2017/06/Handling-SQL-Server-Deadlocks-With-Event-Notifications.html |
| SQL Server R Services: Digging into the R Language | https://www.red-gate.com/simple-talk/sql/bi/sql-server-r-services-digging-r-language/ |
| Investigating the Cause of SQL Server High CPU Load Conditions When They Happen | https://www.red-gate.com/simple-talk/sql/database-administration/investigating-cause-sql-server-high-cpu-load-conditions-happen/ |
| In-Memory Engine DURABILITY = SCHEMA_ONLY And Transaction Rollback | https://chrisadkin.io/2017/07/17/in-memory-engine-durability-schema_only-and-transaction-rollback/ |
| Builder Day: Doing a Point-in-Time Restore in Azure SQL DB | https://www.brentozar.com/archive/2017/06/builder-day-point-time-restore-azure-sql-db/ |
| Creating Continuous Integration Build Pipelines With Jenkins, Docker and SQL Server | https://chrisadkin.io/2017/07/18/creating-continuous-integration-build-pipelines-with-jenkins-docker-and-sql-server/ |
| Scale-able Windows Aggregate Functions With Row Store Object | https://chrisadkin.io/2017/07/24/scale-able-windows-aggregate-functions-with-row-store-objects/ |
| Azure DWH part 11: Data Warehouse Migration Utility | http://www.sqlservercentral.com/articles/Azure+SQL+Data+Warehouse+(ASDW)/158311/ |
| Representing a simple hierarchical list in SQL Server with JSON, YAML, XML and HTML | https://www.red-gate.com/simple-talk/blogs/71858/ |
| Advanced Analytics with R and SQL Part II - Data Science Scenarios | http://www.sqlservercentral.com/articles/Data+Science/158498/ |
| Think twice before using table variables | http://www.sqlservercentral.com/blogs/matthew-mcgiffen-dba/2017/07/11/think-twice-before-using-table-variables/ |
| ColumnStore Indexes And Recursive CTEs | https://www.brentozar.com/archive/2017/07/columnstore-indexes-recursive-ctes/ |
| CCIs and String Aggregation | https://orderbyselectnull.com/2017/07/03/ccis-and-string-aggregation/ |
| Brad’s Sure DBA Checklist | https://www.red-gate.com/simple-talk/sql/database-administration/brads-sure-dba-checklist/ |
| Query Store and Parameterization Problems | https://www.red-gate.com/simple-talk/sql/database-administration/query-store-parameterization-problems/ |
| SQL Server Event Handling: Event Notifications | https://itsalljustelectrons.blogspot.ru/2016/11/SQL-Server-Event-Handling-Event-Notifications.html |
| Identifying Deprecated Feature Usage (Part 1) | https://itsalljustelectrons.blogspot.ru/2017/07/Identifying-Deprecated-Feature-Usage-pt1.html |
| Let’s Corrupt a Database Together, Part 3: Detecting Corruption | https://www.brentozar.com/archive/2017/07/lets-corrupt-database-together-part-3-detecting-corruption/ |
| XML vs JSON Shootout: Which is Superior in SQL Server 2016? | https://bertwagner.com/2017/05/16/xml-vs-json-shootout-which-is-superior-in-sql-server-2016/ |
| One SQL Cheat Code For Amazingly Fast JSON Queries | https://bertwagner.com/2017/05/09/one-sql-cheat-code-for-amazingly-fast-json-queries/ |
| The Ultimate SQL Server JSON Cheat Sheet | https://bertwagner.com/2017/03/07/the-ultimate-sql-server-json-cheat-sheet/ |
| Are your indexes being thwarted by mismatched datatypes? | https://bertwagner.com/2017/08/01/are-your-indexes-being-thwarted-by-mismatched-datatypes/ |
| Why Missing Index Recommendations Aren’t Perfect | https://www.brentozar.com/archive/2017/08/missing-index-recommendations-arent-perfect/ |
| The Case of the Space at the End | http://www.sqlservercentral.com/articles/ANSI_PADDING/157467/ |
| SELECT…INTO in SQL Server 2017 | https://dbafromthecold.com/2017/08/02/select-into-in-sql-server-2017/ |
| Your Service Level Agreement is a Disaster | http://minionware.net/service-level-agreement-disaster/ |
| SQLskills SQL101: REBUILD vs. REORGANIZE | https://www.sqlskills.com/blogs/paul/sqlskills-sql101-rebuild-vs-reorganize/ |
| Where do the Books Online index fragmentation thresholds come from? | https://www.sqlskills.com/blogs/paul/where-do-the-books-online-index-fragmentation-thresholds-come-from/ |
| The SQL Hall of Shame | http://dataeducation.com/the-sql-hall-of-shame/ |
| A Better Way To Select Star | https://www.brentozar.com/archive/2017/07/better-way-select-star/ |
| UDP vs TCP | https://sqlstudies.com/2017/06/07/udp-vs-tcp/ |
| Lipoaspiration in your SQL Server Database | https://www.red-gate.com/simple-talk/sql/performance/lipoaspiration-in-your-sql-server-database/ |
| 13 Things You Should Know About Statistics and the Query Optimizer | https://www.red-gate.com/simple-talk/sql/t-sql-programming/13-things-you-should-know-about-statistics-and-the-query-optimizer/ |
| Creating R Stored Procedures in SQL Server 2016 Using sqlrutils | http://www.nielsberglund.com/2017/06/25/creating-r-stored-procedures-in-sql-server-2016-using-sqlrutils/ |
| A Quick start Guide to Managing SQL Server 2017 on CentOS/RHEL Using the SSH Protocol | https://www.sqlshack.com/quick-start-guide-managing-sql-server-2017-centosrhel-using-ssh-protocol/ |
| SQL Server v.Next : STRING_AGG Performance, Part 2 | https://sqlperformance.com/2017/01/sql-performance/sql-server-v-next-string_agg-performance-part-2 |
| Why Parameter Sniffing Isn’t Always A Bad Thing (But Usually Is) | https://bertwagner.com/2017/08/08/why-parameter-sniffing-isnt-always-a-bad-thing-but-usually-is/ |
| Persisting statistics sampling rate | https://blogs.msdn.microsoft.com/sql_server_team/persisting-statistics-sampling-rate/ |
| All about locking in SQL Server | https://www.sqlshack.com/locking-sql-server/ |
| All about Latches in SQL Server | https://www.sqlshack.com/all-about-latches-in-sql-server/ |
| All about SQL Server spinlocks | https://www.sqlshack.com/sql-server-spinlocks/ |
| How to monitor object space growth in SQL Server | https://www.sqlshack.com/monitor-object-space-growth-sql-server/ |
| How to Read a Transaction Log Backup | http://www.databasejournal.com/features/mssql/how-to-read-a-transaction-log-backup.html |
| How to Find Out Which Database Object Got Deleted | http://www.databasejournal.com/tips/how-to-find-out-which-database-object-got-deleted.html |
| In-Memory OLTP Enhancements in SQL Server 2016 | https://www.sqlshack.com/memory-oltp-enhancements-sql-server-2016/ |
| Sync SQL Logins and Jobs | https://blogs.msdn.microsoft.com/sql_pfe_blog/2017/08/21/sync-sql-logins-and-jobs/ |
| The Trillion Row Table | https://orderbyselectnull.com/2017/08/16/the-trillion-row-table/ |
| Dynamic Data Unmasking | https://orderbyselectnull.com/2017/08/25/dynamic-data-unmasking/ |
| Why is My Database Application so Slow? | https://www.red-gate.com/simple-talk/dotnet/net-performance/database-application-slow/ |
| Generating Concurrent Activity | http://michaeljswart.com/2014/01/generating-concurrent-activity/ |
| Required Testing for Installing SQL Server Cumulative Updates and Service Packs | http://www.littlekendra.com/2016/04/28/required-testing-for-installing-sql-server-cumulative-updates-and-service-packs/ |
| Microsoft SQL Server R Services - Internals X | http://www.nielsberglund.com/2017/08/29/microsoft-sql-server-r-services-internals-x/ |
| Clustered columnstore: on-disk vs. in-mem | http://nedotter.com/archive/2017/03/clustered-columnstore-on-disk-vs-in-mem/ |
| Hands on Full-Text Search in SQL Server | https://www.sqlshack.com/hands-full-text-search-sql-server/ |
| SQL Code Smells | https://www.red-gate.com/simple-talk/sql/t-sql-programming/sql-code-smells/ |
| Corruption demo databases and scripts | https://www.sqlskills.com/blogs/paul/corruption-demo-databases-and-scripts/ |
| Understanding Cross-Database Transactions in SQL Server | https://www.red-gate.com/simple-talk/sql/database-administration/understanding-cross-database-transactions-in-sql-server/ |
| Optional Parameters and Missing Index Requests | https://www.brentozar.com/archive/2017/09/optional-parameters-missing-index-requests/ |
| Uniquifier is a rather unique word isn’t it? | https://sqlstudies.com/2017/09/18/uniquifier-is-a-rather-unique-word-isnt-it/ |
| Importance of proper transaction log size management | https://www.sqlskills.com/blogs/paul/importance-of-proper-transaction-log-size-management/ |
| #TSQL2sDay – Starting Out with PowerShell | https://sqldbawithabeard.com/2017/09/12/tsql2sday-starting-out-with-powershell/ |
| Using native compilation to insert parent/child tables | http://nedotter.com/archive/2017/09/using-native-compilation-to-insert-parentchild-tables/ |
| Questions About RDS SQL Server You Were Too Shy to Ask | https://www.red-gate.com/simple-talk/cloud/cloud-data/questions-rds-sql-server-shy-ask/ |
| Active Directory Authentication with SQL Server on Ubuntu | http://port1433.com/2017/09/19/active-directory-authentication-with-sql-server-on-ubuntu/ |
| Temporary Tables in Stored Procedures | https://www.sql.kiwi/2012/08/temporary-tables-in-stored-procedures.html |
| SQLCLR in Practice: Creating a Better Way of Sending Email from SQL Server | https://www.red-gate.com/simple-talk/sql/sql-development/sqlclr-practice-creating-better-way-sending-email-sql-server/ |
| T-SQL commands performance comparison – NOT IN vs NOT EXISTS vs LEFT JOIN vs EXCEPT | https://www.sqlshack.com/t-sql-commands-performance-comparison-not-vs-not-exists-vs-left-join-vs-except/ |
| Clustered vs Nonclustered: Index Fundamentals You Need To Know | https://bertwagner.com/2017/09/26/clustered-vs-nonclustered-index-fundamentals-you-need-to-know/ |
| How to Write Efficient TOP N Queries in SQL | https://blog.jooq.org/2017/09/22/how-to-write-efficient-top-n-queries-in-sql/ |
| Checklist: DR Plan Sanity Check | http://sqlsoldier.net/wp/sqlserver/checklistdrplansanitycheck |
| Table level recovery for selected SQL Server tables | https://www.mssqltips.com/sqlservertip/2814/table-level-recovery-for-selected-sql-server-tables/ |
| SQL Mirroring, Preserving the Log Chain During Database Migrations | https://sqlundercover.com/2017/01/21/sql-mirroring-preserving-the-log-chain-during-database-migrations/ |
| How NOLOCK Will Block Your Queries | https://bertwagner.com/2017/10/10/how-nolock-will-block-your-queries/ |
| 8 Ways to Export SQL Results To a Text File | http://www.sqlservercentral.com/articles/Export/147145/ |
| SQL Server Installation Failed Due to Pending Restart of Server? | https://thelonedba.wordpress.com/2017/09/18/sql-server-installation-failed-due-to-pending-restart-of-server/ |
| Six Scary SQL Surprises | https://www.red-gate.com/simple-talk/sql/database-administration/six-scary-sql-surprises/ |
| How the rowversion datatype works when adding and deleting columns | http://sqlblog.com/blogs/louis_davidson/archive/2017/09/26/how-the-rowversion-datatype-works-when-adding-and-deleting-columns.aspx |
| Quick! What's the difference between RANK, DENSE_RANK, and ROW_NUMBER? | http://douglaskline.blogspot.ru/2017/10/quick-whats-difference-between-rank.html |
| A Serial Parallel Query | https://orderbyselectnull.com/2017/09/26/a-serial-parallel-query/ |
| Add or Remove IDENTITY Property From an Existing Column Efficiently | http://www.dbdelta.com/add-or-remove-identity-property-from-an-existing-column-efficiently/ |
| How Do I Analyze a SQL Server Execution Plan? | https://littlekendra.com/2017/09/22/how-do-i-analyze-a-sql-server-execution-plan/ |
| A Subtle Difference Between COALESCE and ISNULL | https://nocolumnname.wordpress.com/2017/10/09/a-subtle-difference-between-coalesce-and-isnull/ |
| Puzzle Challenge: Graph Matching with T-SQL Part 1-Concepts | http://sqlmag.com/software-development/puzzle-challenge-graph-matching-t-sql-part-1-concepts |
| Graph Matching with T-SQL Part 3: Maximum Matching | http://www.itprotoday.com/microsoft-sql-server/graph-matching-t-sql-part-3-maximum-matching |
| Running PowerShell in a SQL Agent Job | https://www.sqlhammer.com/running-powershell-in-a-sql-agent-job/ |
| Line-Continuation in T-SQL | https://sqlquantumleap.com/2017/10/27/line-continuation-in-t-sql/ |
| SQL Server 2017: Making Backups Great Again! | https://johnsterrett.com/2017/10/31/sql-server-2017-backups/ |
| Say NO to Venn Diagrams When Explaining JOINs | https://blog.jooq.org/2016/07/05/say-no-to-venn-diagrams-when-explaining-joins/ |
| Surprise Delta Stores | https://orderbyselectnull.com/2017/11/07/delta-stores/ |
| SQL 2014 Clustered Columnstore index rebuild and maintenance considerations | https://blogs.msdn.microsoft.com/sqlcat/2015/07/08/sql-2014-clustered-columnstore-index-rebuild-and-maintenance-considerations/ |
| Multiple Output Datasets With R and SQL Server | https://itsalljustelectrons.blogspot.ru/2017/11/Multiple-Output-Datasets-with-R-and-SQL-Server.html |
| How to Avoid Excessive Sorts in Window Functions | https://blog.jooq.org/2017/11/06/how-to-avoid-excessive-sorts-in-window-functions/ |
| Extracting a DAX Query Plan With Analysis Services 2016 Extended Events | https://www.mssqltips.com/sqlservertip/5106/extracting-a-dax-query-plan-with-analysis-services-2016-extended-events/ |
| What impact can different cursor options have? | https://sqlperformance.com/2012/09/t-sql-queries/cursor-options |
| SQL Smackdown!!! Cursors VS Loops | https://sqlundercover.com/2017/11/16/sql-smackdown-cursors-vs-loops/ |
| Using the OPTION (RECOMPILE) option for a statement | https://www.sqlskills.com/blogs/kimberly/using-the-option-recompile-option-for-a-statement/ |
| Execution Plan Caching and Reuse | https://msdn.microsoft.com/en-us/library/ms181055.aspx |
| Buffer Management | https://msdn.microsoft.com/en-us/library/aa337525.aspx |
| RECOMPILE Hints and Execution Plan Caching | https://www.brentozar.com/archive/2013/12/recompile-hints-and-execution-plan-caching/ |
| Improving query performance with OPTION (RECOMPILE), Constant Folding and avoiding Parameter Sniffing issues | https://blogs.msdn.microsoft.com/robinlester/2016/08/10/improving-query-performance-with-option-recompile-constant-folding-and-avoiding-parameter-sniffing-issues/ |
| Eight Different Ways to Clear the SQL Server Plan Cache | https://www.sqlskills.com/blogs/glenn/eight-different-ways-to-clear-the-sql-server-plan-cache/ |
| Introduction and FAQs about Microsoft Azure technologies | https://www.sqlshack.com/introduction-faqs-microsoft-azure-technologies/ |
| Inside the XEvent Profiler | https://www.sqlhammer.com/inside-xevent-profiler/ |
| Does The Join Order of My Tables Matter? | https://bertwagner.com/2017/11/21/does-the-join-order-of-my-tables-matter/ |
| Encrypting SQL Server connections with Let’s Encrypt certificates | https://sqlsunday.com/2017/11/22/encrypting-tds-with-letsencrypt/ |
| Start SQL Server without tempdb | https://sqlstudies.com/2016/01/20/start-sql-server-without-tempdb/ |
| How to configure database mail in SQL Server | https://www.sqlshack.com/configure-database-mail-sql-server/ |
| Understanding SQL server memory grant | https://blogs.msdn.microsoft.com/sqlqueryprocessing/2010/02/16/understanding-sql-server-memory-grant/ |
| Cleanly Uninstalling Stubborn SQL Server Components | https://www.mssqltips.com/sqlservertip/4050/cleanly-uninstalling-stubborn-sql-server-components/ |
| Hey! What's the deal with SQL Server NOCOUNT and T-SQL WHILE loops? | http://sql-sasquatch.blogspot.ru/2017/11/hey-whats-deal-with-nocount-and-t-sql.html |
| Query Store Settings | https://www.sqlskills.com/blogs/erin/query-store-settings/ |
| Using Plan Explorer with Entity Framework | https://www.sentryone.com/blog/jasonhall/using-plan-explorer-entity-framework/ |
| Overview of Encryption Tools in SQL Server | https://matthewmcgiffen.com/2017/12/05/overview-of-encryption-tools-in-sql-server/ |
| Clustered Index Uniquifier Existence and Size | https://sqlquantumleap.com/2017/09/18/clustered-index-uniquifier-existence-and-size/ |
| Understanding Logging and Recovery in SQL Server | https://technet.microsoft.com/en-us/library/2009.02.logging.aspx |
| Understanding SQL Server Backups | https://docs.microsoft.com/en-us/previous-versions/technet-magazine/dd822915(v=msdn.10) |
| Recovering from Disasters Using Backups | https://technet.microsoft.com/en-us/library/ee677581.aspx |
| Simple SQL: Handling Location Datatypes | https://www.red-gate.com/simple-talk/sql/t-sql-programming/simple-sql-handling-location-datatypes/ |
| Improve SQL Server Performance by Looking at Plan Cache (Part 1) | https://logicalread.com/sql-server-minimize-single-use-plans-tl01/ |
| Improve SQL Server Performance by Looking at Plan Cache (Part 2) | https://logicalread.com/sql-server-identifying-plans-that-need-tuning-tl01/ |
| Improve SQL Server Performance by Looking at Plan Cache (Part 3) | https://logicalread.com/sql-server-identify-similar-plans-tl01/ |
| Take Care When Scripting Batches | http://michaeljswart.com/2014/09/take-care-when-scripting-batches/ |
| When Measuring Timespans, try DATEADD instead of DATEDIFF | http://michaeljswart.com/2017/12/when-measuring-timespans-try-dateadd-instead-of-datediff/ |
| Which user function do I use? | https://sqlstudies.com/2015/06/24/which-user-function-do-i-use/ |
| What’s So Bad About Shrinking Databases with DBCC SHRINKDATABASE? | https://www.brentozar.com/archive/2017/12/whats-bad-shrinking-databases-dbcc-shrinkdatabase/ |
| Which Collation is Used to Convert NVARCHAR to VARCHAR in a WHERE Condition? (Part A of 2: “Duck”) | https://sqlquantumleap.com/2017/12/08/which-collation-is-used-to-convert-nvarchar-to-varchar-in-a-where-condition-part-a-of-2-duck/ |
| Which Collation is Used to Convert NVARCHAR to VARCHAR in a WHERE Condition? (Part B of 2: “Rabbit”) | https://sqlquantumleap.com/2017/12/11/which-collation-is-used-to-convert-nvarchar-to-varchar-in-a-where-condition-part-b-of-2-rabbit/#comments |
| Current State of the NewSQL/NoSQL Cloud Arena | https://www.red-gate.com/simple-talk/cloud/cloud-data/current-state-newsqlnosql-cloud-arena/ |
| SQL Server 2017: JSON | http://db-devs.com/blog/archive/sql-server-2017-json/ |
| Simulating Bad Networks to Test SQL Server Replication | https://www.red-gate.com/simple-talk/blogs/simulating-bad-networks-test-sql-server-replication/ |
| How to Turn on Instant File Initialization | https://www.databasejournal.com/tips/how-to-turn-on-instant-file-initialization.html |
| Bad Idea Jeans: Finding Undocumented Trace Flags | https://rebrand.ly/brent-finding-undocumented-trace-flags |
| A Method to Find Trace Flags | https://rebrand.ly/joe-finding-undocumented-trace-flags |
| Using Windows stored credentials to connect to SQL in containers | https://dbafromthecold.com/2018/01/17/using-windows-stored-credentials-to-connect-to-sql-in-containers/ |
| Step by Step Guide to Migrate SQL Server Data to SQL Server 2017 | https://www.databasejournal.com/features/mssql/step-by-step-guide-to-migrate-sql-server-data-to-sql-server-2017.html |
| Nasty Fast PERCENT_RANK | http://www.sqlservercentral.com/articles/PERCENT_RANK/141532/ |
| Administrative Logins and Users | https://sqlstudies.com/2015/11/02/administrative-logins-and-users/ |
| Parallelism in Hekaton (In-Memory OLTP) | http://www.nikoport.com/2018/01/20/parallelism-in-hekaton-in-memory-oltp/ |
| Troubleshooting THREADPOOL Waits | https://www.sqlpassion.at/archive/2011/10/25/troubleshooting-threadpool-waits/ |
| Andy’s Excellent SSIS-in-the-Cloud Adventure, Part 1 – Build an ADFv2 IR Instance | https://andyleonard.blog/2018/01/andys-excellent-ssis-in-the-cloud-adventure-part-1/ |
| PRINT vs. RAISERROR | http://sqlity.net/en/984/print-vs-raiserror/ |
| Without ORDER BY, You Can’t Depend On the Order of Results | http://michaeljswart.com/2013/09/without-order-by-you-cant-depend-on-the-order-of-results/ |
| Query Store and “in memory” | https://www.sqlskills.com/blogs/erin/query-store-and-in-memory/ |
| Setting and Identifying Row Goals in Execution Plans | https://sqlperformance.com/2018/02/sql-plan/setting-and-identifying-row-goals |
| Azure and Windows PowerShell: The Basics | https://www.red-gate.com/simple-talk/sysadmin/powershell/azure-windows-powershell-basics/ |
| Auditing Linked Servers | https://thomaslarock.com/2018/02/auditing-linked-servers/ |
| An alternative to data masking | https://sqlsunday.com/2018/02/05/an-alternative-to-data-masking/ |
| Safely and Easily Use High-Level Permissions Without Granting Them to Anyone: Server-level | https://sqlquantumleap.com/2018/02/15/safely-and-easily-use-high-level-permissions-without-granting-them-to-anyone-server-level/ |
| PLEASE, Please, please Stop Using Impersonation, TRUSTWORTHY, and Cross-DB Ownership Chaining | https://sqlquantumleap.com/2017/12/30/please-please-please-stop-using-impersonation-execute-as/ |
| Indexing and Partitioning | https://dbafromthecold.com/2018/02/21/indexing-and-partitioning/ |
| Schema Compare for SQL Server | https://thomaslarock.com/2018/02/schema-compare-for-sql-server/ |
| How to change SQL Server ERRORLOG location | https://red9.com/sql-server-error-log-location/ |
| The Uni-Code: The Search for the True List of Valid Characters for T-SQL Regular Identifiers, Part 1 | https://sqlquantumleap.com/2018/04/02/the-uni-code-the-search-for-the-true-list-of-valid-characters-for-t-sql-regular-identifiers-part-1/ |
| The Uni-Code: The Search for the True List of Valid Characters for T-SQL Regular Identifiers, Part 2 | https://sqlquantumleap.com/2018/04/04/the-uni-code-the-search-for-the-true-list-of-valid-characters-for-t-sql-regular-identifiers-part-2/ |
| What’s in a Name?: Inside the Wacky World of T-SQL Identifiers | https://sqlquantumleap.com/2018/04/09/whats-in-a-name-inside-the-wacky-world-of-t-sql-identifiers/ |
| Programming SQL Server with SQL Server Management Objects Framework | https://www.red-gate.com/simple-talk/dotnet/c-programming/programming-sql-server-sql-server-management-objects-framework/ |
| Interval Queries in SQL Server | http://www.itprotoday.com/software-development/interval-queries-sql-server |
| Dealing with date and time instead of datetime | https://sqlperformance.com/2018/03/sql-optimizer/dealing-with-date-and-time |
| Insight into the SQL Server buffer cache | https://www.sqlshack.com/insight-into-the-sql-server-buffer-cache/ |
| A concrete example of migration between an Oracle Database and SQL Server using Microsoft Data Migration Assistant | https://www.sqlshack.com/a-concrete-example-of-migration-between-an-oracle-database-and-sql-server-using-microsoft-data-migration-assistant/ |
| Audit SQL Server stop, start, restart | https://blogs.msdn.microsoft.com/skeeler/2018/03/audit-sql-server-stop-start-restart/ |
| Query tuning: Apply yourself | https://sqltechblog.com/2018/04/06/query-tuning-apply-yourself/ |
| How to identify and monitor unused indexes in SQL Server | https://www.sqlshack.com/how-to-identify-and-monitor-unused-indexes-in-sql-server/ |
| Benchmarking: 1-TB table population (part 1: the baseline) | https://www.sqlskills.com/blogs/paul/benchmarking-1-tb-table-population-part-1-the-baseline/ |
| Benchmarking: 1-TB table population (part 2: optimizing log block IO size and how log IO works) | https://www.sqlskills.com/blogs/paul/benchmarking-1-tb-table-population-part-2-optimizing-log-block-io-size-and-how-log-io-works/ |
| An overview of SQL Server database migration tools provided by Microsoft | https://www.sqlshack.com/an-overview-of-sql-server-database-migration-tools-provided-by-microsoft/ |
| Calling Http endpoints in T-SQL using CURL extension | https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/04/17/calling-http-endpoints-in-t-sql-using-curl-extension/ |
| Why Table Join Orders In Relational Databases | https://hackernoon.com/why-table-join-orders-in-relational-databases-dont-matter-6de3a35f2959 |
| Finding overlapping ranges of data | https://www.red-gate.com/simple-talk/blogs/finding-overlapping-ranges-data/ |
| Avoid use of the MONEY and SMALLMONEY datatypes | https://www.red-gate.com/hub/product-learning/sql-prompt/avoid-use-money-smallmoney-datatypes |
| Provisioning SQL Server Instances with Docker | https://www.red-gate.com/simple-talk/sysadmin/containerization/provisioning-sql-server-instances-docker/ |
| Understanding the graphical representation of the SQL Server Deadlock Graph | https://www.sqlshack.com/understanding-graphical-representation-sql-server-deadlock-graph/ |
| Digitally Signing a Stored Procedure To Allow It To Run With Elevated Permissions | https://sqlundercover.com/2018/05/02/digitally-signing-a-stored-procedure-to-allow-it-to-run-with-elevated-permissions/ |
| NOLOCK and Top Optimization | https://www.sqlshack.com/nolock-and-top-optimization/ |
| Operator Precedence versus the Confusing Constraint Translation | https://www.red-gate.com/simple-talk/blogs/operator-precedence-versus-confusing-constraint-translation/ |
| Interval Queries in SQL Server | http://www.itprotoday.com/software-development/interval-queries-sql-server |
| Query Trace Column Values | https://www.sqlshack.com/query-trace-column-values/ |
| Concurrency Week: How to Delete Just Some Rows from a Really Big Table | https://www.brentozar.com/archive/2018/04/how-to-delete-just-some-rows-from-a-really-big-table/ |
| Break large delete operations into chunks | https://sqlperformance.com/2013/03/io-subsystem/chunk-deletes |
| How to perform a page level restore in SQL Server - Jayaram | https://www.sqlshack.com/how-to-perform-a-page-level-restore-in-sql-server/ |
| Grouping dates without blocking operators | https://sqlsunday.com/2018/05/14/grouping-dates-without-blocking-operators/ |
| What’s CHECKDB doing in my database restore? | http://www.mikefal.net/2018/04/10/whats-checkdb-doing-in-my-database-restore/ |
| How To Hide An Instance Of SQL Server | https://thomaslarock.com/2018/04/how-to-hide-an-instance-of-sql-server/ |
| Troubleshooting Parameter Sniffing Issues the Right Way: Part 1 | https://www.brentozar.com/archive/2018/03/troubleshooting-parameter-sniffing-issues-the-right-way-part-1/ |
| Troubleshooting Parameter Sniffing Issues the Right Way: Part 2 | https://www.brentozar.com/archive/2018/03/troubleshooting-parameter-sniffing-issues-right-way-part-2/ |
| Troubleshooting Parameter Sniffing Issues the Right Way: Part 3 | https://www.brentozar.com/archive/2018/03/troubleshooting-parameter-sniffing-issues-the-right-way-part-3/ |
| When to use the SELECT…INTO statement | https://www.red-gate.com/hub/product-learning/sql-prompt/use-selectinto-statement |
| Temp Tables In SSIS | https://www.timmitchell.net/post/2018/05/29/temp-tables-in-ssis/ |
| Changing the Collation of the Instance, the Databases, and All Columns in All User Databases | https://sqlquantumleap.com/2018/06/11/changing-the-collation-of-the-instance-and-all-columns-across-all-user-databases-what-could-possibly-go-wrong/ |
| 10 Cool SQL Optimisations That do not Depend on the Cost Model | https://blog.jooq.org/2017/09/28/10-cool-sql-optimisations-that-do-not-depend-on-the-cost-model/ |
| Scheduling powershell tasks with sql agent | https://dbatools.io/agent/ |
| Three ways to track logins using dbatools | https://dbatools.io/track-logins/ |
| Impact of Fragmentation on Execution Plans | https://sqlperformance.com/2017/12/sql-indexes/impact-fragmentation-plans |
| How to “debug” a Linked Server from SQL Server to an Oracle Database instance | https://www.sqlshack.com/how-to-debug-a-linked-server-from-sql-server-to-an-oracle-database-instance/ |
| How to implement error handling in SQL Server | https://www.sqlshack.com/how-to-implement-error-handling-in-sql-server/ |
| SQL Server Closure Tables | https://www.red-gate.com/simple-talk/sql/t-sql-programming/sql-server-closure-tables/ |
| Deadlock victim choice in SQL Server - an exception? | http://joshthecoder.com/2018/05/10/deadlock-victim-choice-an-exception.html |
| Azure and Windows PowerShell: The Basics | https://www.red-gate.com/simple-talk/sysadmin/powershell/azure-windows-powershell-basics/ |
| Azure and Windows PowerShell: Getting Information | https://www.red-gate.com/simple-talk/sysadmin/powershell/azure-and-windows-powershell-getting-information/ |
| Be our guest, be our guest, put our database to the test | https://sqlstudies.com/2018/06/25/be-our-guest-be-our-guest-put-our-database-to-the-test/ |
| Finding code smells using SQL Prompt: the SET NOCOUNT problem (PE008 and PE009) | https://www.red-gate.com/hub/product-learning/sql-prompt/finding-code-smells-using-sql-prompt-set-nocount-problem-pe008-pe009 |
| DATABASES 101 guide for the non-technical professional | https://thomaslarock.com/2018/07/databases-101/ |
| Understanding your Azure EA Billing Data and Building a Centralized Data Storage Solution | https://www.red-gate.com/simple-talk/cloud/cloud-data/understanding-your-azure-ea-billing-data-and-building-a-centralized-data-storage-solution/ |
| READ COMMITTED SNAPSHOT ISOLATION and High version_ghost_record_count | https://www.red-gate.com/simple-talk/sql/performance/read-committed-snapshot-isolation-high-version_ghost_record_count/ |
| In-Memory OLTP Indexes – Part 1: Recommendations. | https://blogs.msdn.microsoft.com/sqlserverstorageengine/2017/11/02/in-memory-oltp-indexes-part-1-recommendations/ |
| In-Memory OLTP Indexes – Part 2: Performance Troubleshooting Guide. | https://blogs.msdn.microsoft.com/sqlserverstorageengine/2017/11/14/in-memory-oltp-indexes-part-2-performance-troubleshooting-guide/ |
| Optimization Thresholds – Grouping and Aggregating Data, Part 1 | https://sqlperformance.com/2018/04/sql-plan/grouping-and-aggregating-part-1 |
| Optimization Thresholds – Grouping and Aggregating Data, Part 2 | https://sqlperformance.com/2018/05/sql-plan/grouping-and-aggregating-part-2 |
| Optimization Thresholds – Grouping and Aggregating Data, Part 3 | https://sqlperformance.com/2018/06/sql-plan/grouping-and-aggregating-part-3 |
| Optimization Thresholds – Grouping and Aggregating Data, Part 4 | https://sqlperformance.com/2018/07/sql-performance/grouping-and-aggregating-part-4 |
| Optimization Thresholds – Grouping and Aggregating Data, Part 5 | https://sqlperformance.com/2018/08/sql-performance/grouping-and-aggregating-part-5 |
| When DBCC OpenTran doesn’t list all open transactions | https://blogs.msdn.microsoft.com/mosharaf/2013/02/17/when-dbcc-opentran-doesnt-list-all-open-transactions/ |
| How I spot not-yet-documented features in SQL Server CTPs | https://www.sentryone.com/blog/aaronbertrand/fishing-for-features-in-ctps/ |
| More ways to discover changes in new versions of SQL Server | https://www.sentryone.com/blog/aaronbertrand/more-changes-sql-server/ |
| Tail-Log Backup and Restore in SQL Server | https://www.sqlshack.com/tail-log-backup-and-restore-in-sql-server/ |
| Database Filegroup(s) and Piecemeal restores in SQL Server | https://www.sqlshack.com/database-filegroups-and-piecemeal-restores-in-sql-server/ |
| Updating Statistics with Ola Hallengren’s Script | https://www.sqlskills.com/blogs/erin/updating-statistics-with-ola-hallengrens-script/ |
| Interview questions on SQL Server database backups, restores and recovery – Part I | https://www.sqlshack.com/interview-questions-on-sql-server-database-backups-restores-and-recovery-part-i/ |
| Interview questions on SQL Server database backups, restores and recovery – Part II | https://www.sqlshack.com/interview-questions-on-sql-server-database-backups-restores-and-recovery-part-ii/ |
| Interview questions on SQL Server database backups, restores and recovery – Part III | https://www.sqlshack.com/interview-questions-on-sql-server-database-backups-restores-and-recovery-part-iii/ |
| Can Rowstore Compression Beat Columnstore Compression? | https://orderbyselectnull.com/2018/06/28/can-rowstore-compression-beat-columnstore-compression/ |
| Inside the Storage Engine: Anatomy of a record | https://www.sqlskills.com/blogs/paul/inside-the-storage-engine-anatomy-of-a-record/ |
| Inside the Storage Engine: Using DBCC PAGE and DBCC IND to find out if page splits ever roll back | http://www.sqlskills.com/blogs/paul/inside-the-storage-engine-using-dbcc-page-and-dbcc-ind-to-find-out-if-page-splits-ever-roll-back/ |
| Inside the Storage Engine: Anatomy of a page | http://www.sqlskills.com/blogs/paul/inside-the-storage-engine-anatomy-of-a-page/ |
| Inside the Storage Engine: Anatomy of an extent | https://www.sqlskills.com/blogs/paul/inside-the-storage-engine-anatomy-of-an-extent/ |
| Inside the Storage Engine: IAM pages, IAM chains, and allocation units | https://www.sqlskills.com/blogs/paul/inside-the-storage-engine-iam-pages-iam-chains-and-allocation-units/ |
| Inside The Storage Engine: GAM, SGAM, PFS and other allocation maps | https://www.sqlskills.com/blogs/paul/inside-the-storage-engine-gam-sgam-pfs-and-other-allocation-maps/ |
| Disaster recovery 101: fixing a broken boot page | https://www.sqlskills.com/blogs/paul/disaster-recovery-101-fixing-a-broken-boot-page/ |
| How to download a sqlservr.pdb symbol file | https://www.sqlskills.com/blogs/paul/how-to-download-a-sqlservr-pdb-symbol-file/ |
| A cause of high-duration ASYNC_IO_COMPLETION waits | https://www.sqlskills.com/blogs/paul/cause-high-duration-async_io_completion-waits/ |
| How to solve the Identity Crisis in SQL Server | https://www.sqlshack.com/solve-identity-crisis-sql-server/ |
| Azure SQL Database Performance and Service Tiers Explained | https://sqlperformance.com/2018/08/sql-performance/azure-sql-database-tiers |
| What To Do When Wait Stats Don’t Help | https://orderbyselectnull.com/2018/07/20/what-to-do-when-wait-stats-dont-help/ |
| SQL Server Brute Force Attack Detection: Part 1 | https://www.codeproject.com/Articles/1231882/SQL-Server-Brute-Force-Attack-Detection |
| SQL Server Brute Force Attack Detection: Part 2 | https://www.codeproject.com/Articles/1236461/SQL-Server-Brute-Force-Attack-Detection-Part-2 |
| SQL Server Brute Force Attack Detection: Part 3 | https://www.codeproject.com/Articles/1232491/SQL-Server-Brute-Force-Attack-Detection-Part-2 |
| SQLCLR vs SQL Server 2017, Part 8: Is SQLCLR Deprecated in Favor of Python or R (sp_execute_external_script)? | https://sqlquantumleap.com/2018/08/09/sqlclr-vs-sql-server-2017-part-8-is-sqlclr-deprecated-in-favor-of-python-or-r-sp_execute_external_script/ |
| Sql Server Agent For Azure Sql Database, Azure Elastic Database Pools & Azure Managed Instance | https://swyssql.wordpress.com/2018/07/20/sql-server-agent-for-azure-sql-database-azure-elastic-database-pools-azure-managed-instance/ |
| Storage performance best practices and considerations for Azure SQL DB Managed Instance (General Purpose) | https://blogs.msdn.microsoft.com/sqlcat/2018/07/20/storage-performance-best-practices-and-considerations-for-azure-sql-db-managed-instance-general-purpose/ |
| T-SQL Tuesday #017: APPLY: It Slices! It Dices! It Does It All! | http://bradsruminations.blogspot.com/2011/04/t-sql-tuesday-017-it-slices-it-dices-it.html |
| SQL Server Encryption, What’s The Key Hierarchy All About? | https://sqlundercover.com/2018/08/09/sql-server-encryption-whats-the-key-hierarchy-all-about/ |
| Overview of the SQLCMD utility in SQL Server | https://www.sqlshack.com/overview-of-the-sqlcmd-utility-in-sql-server/ |
| The BCP (Bulk Copy Program) command in action | https://www.sqlshack.com/bcp-bulk-copy-program-command-in-action/ |
| Measuring Query Execution Time | https://www.scarydba.com/2018/08/13/measuring-query-execution-time/ |
| How to Check Performance on a New SQL Server | https://www.brentozar.com/archive/2018/08/how-to-check-performance-on-a-new-sql-server/ |
| Questions About Kerberos and SQL Server That You Were Too Shy to Ask | https://www.red-gate.com/simple-talk/sql/database-administration/questions-about-kerberos-and-sql-server-that-you-were-too-shy-to-ask/ |
| SQL Server Execution Plans overview | https://www.sqlshack.com/sql-server-execution-plans-overview/ |
| SQL Server Execution Plans types | https://www.sqlshack.com/sql-server-execution-plans-types/ |
| How to Analyze SQL Execution Plan Graphical Components | https://www.sqlshack.com/how-to-analyze-sql-execution-plan-graphical-components/ |
| Query optimization techniques in SQL Server: the basics | https://www.sqlshack.com/query-optimization-techniques-in-sql-server-the-basics/ |
| Query optimization techniques in SQL Server: tips and tricks | https://www.sqlshack.com/query-optimization-techniques-in-sql-server-tips-and-tricks/ |
| Query optimization techniques in SQL Server: Database Design and Architecture | https://www.sqlshack.com/query-optimization-techniques-in-sql-server-database-design-and-architecture/ |
| SQL Query Optimization Techniques in SQL Server: Parameter Sniffing | https://www.sqlshack.com/query-optimization-techniques-in-sql-server-parameter-sniffing/ |
| Similarities and Differences among RANK, DENSE_RANK and ROW_NUMBER Functions | https://codingsight.com/similarities-and-differences-among-rank-dense_rank-and-row_number-functions/ |
| Temporal Tables Under The Covers | https://bornsql.ca/blog/temporal-tables-under-the-covers/ |
| Faking Temporal Tables with Triggers | https://bertwagner.com/2018/09/11/faking-temporal-tables-with-triggers/ |
| SQL queries to manage hierarchical or parent-child relational rows in SQL Server | https://www.codeproject.com/Articles/818694/SQL-queries-to-manage-hierarchical-or-parent-child |
| Choosing Between Table Variables and Temporary Tables | https://www.red-gate.com/hub/product-learning/sql-prompt/choosing-table-variables-temporary-tables |
| What's New in the First Public CTP of SQL Server 2019 | https://www.mssqltips.com/sqlservertip/5710/whats-new-in-the-first-public-ctp-of-sql-server-2019/ |
| SQL Server support for TLS 1.2 – Read This First! | https://www.sentryone.com/blog/aaronbertrand/tls-1-2-support-read-first/ |
| Misconceptions in SQL Server: A Trio of table variables | https://sqlinthewild.co.za/index.php/2010/10/12/a-trio-of-table-variables/ |
| Using the Same Column Twice in a SQL UPDATE Statement | https://www.sqltheater.com/blog/using-the-same-column-twice-in-an-update-statement/ |
| How to perform a performance test against a SQL Server instance | https://www.sqlshack.com/how-to-perform-a-performance-test-against-a-sql-server-instance/ |
| The Black Art Of Spatial Index Tuning In SQL Server | http://boomphisto.blogspot.com/2011/04/black-art-of-spatial-index-tuning-in.html |
| Patching SQL Server on Windows notes from the field | https://www.kevinrchant.com/2019/01/10/patching-sql-server-on-windows-notes-from-the-field/ |
| Availability Group Readable Secondaries – Just Say No | https://www.sqlskills.com/blogs/jonathan/availability-group-readable-secondaries-just-say-no/ |
| Finding the Slowest Query in a Stored Procedure | https://www.sqlskills.com/blogs/erin/slowest-query-in-a-stored-procedure/ |
| A Monumental Migration to SQL Server 2016 – Part 1 | https://flxsql.com/monumental-migration-sql-server-2016-part-1/ |
| A Monumental Migration to SQL Server 2016 – Part 2 | https://flxsql.com/monumental-migration-sql-server-2016-part-2/ |
| A unique review of SQL Server index types | https://www.kevinrchant.com/2018/10/18/a-unique-review-of-sql-server-index-types/ |
| Don’t Just Rely on Query Execution Stats for T-SQL Execution | https://matthewmcgiffen.com/2018/09/18/dont-just-rely-on-query-execution-stats-for-t-sql-execution/ |
| Posting SQL Server notifications to Slack | https://alessandroalpi.blog/2018/09/19/posting-sql-server-notifications-to-slack/ |
| How to create DACPAC file? | https://sqlplayer.net/2018/10/how-to-create-dacpac-file/ |
| Find the Next Non-NULL Row in a Series With SQL | https://blog.jooq.org/2018/09/03/find-the-next-non-null-row-in-a-series-with-sql/ |
| Calculate Percentiles to Learn About Data Set Skew in SQL | https://blog.jooq.org/2019/01/22/calculate-percentiles-to-learn-about-data-set-skew-in-sql/ |
| Comparing multiple rows insert vs single row insert with three data load methods | https://www.red-gate.com/simple-talk/sql/performance/comparing-multiple-rows-insert-vs-single-row-insert-with-three-data-load-methods/ |
| The Cause of Every Deadlock in SQL Server | https://thomaslarock.com/2018/09/the-cause-of-every-deadlock-in-sql-server/ |
| Deadlock Troubleshooting, Part 1 | https://blogs.msdn.microsoft.com/bartd/2006/09/08/deadlock-troubleshooting-part-1/ |
| Deadlock Troubleshooting, Part 2 | https://blogs.msdn.microsoft.com/bartd/2006/09/12/deadlock-troubleshooting-part-2/ |
| Deadlock Troubleshooting, Part 3 | https://blogs.msdn.microsoft.com/bartd/2006/09/25/deadlock-troubleshooting-part-3/ |
| The Good, the Bad and the Ugly of Table Variable Deferred Compilation – Part 1 | https://milossql.wordpress.com/2018/10/04/the-good-the-bad-and-the-ugly-of-table-variable-deferred-compilation-part-1/ |
| The Good, the Bad and the Ugly of Table Variable Deferred Compilation – Part 2 | https://milossql.wordpress.com/2018/10/05/the-good-the-bad-and-the-ugly-of-table-variable-deferred-compilation-part-2/ |
| The Good, the Bad and the Ugly of Table Variable Deferred Compilation – Part 3 | https://milossql.wordpress.com/2018/10/08/the-good-the-bad-and-the-ugly-of-table-variable-deferred-compilation-part-3/ |
| Creating a SQL Server 2019 Demo Environment in a Docker Container | https://www.cathrinewilhelmsen.net/2018/12/02/sql-server-2019-docker-container/ |
| Overview of Data Compression in SQL Server | https://codingsight.com/overview-of-data-compression-in-sql-server/ |
| SQL Server Hash Match Operator | https://sqlserverfast.com/epr/hash-match/ |
| How to use Microsoft Assessment and Planning (MAP) Toolkit for SQL Server | https://www.sqlshack.com/how-to-use-microsoft-assessment-and-planning-map-toolkit-for-sql-server/ |
| Improve the Performance of Your Azure SQL Database (and Save Money!) with Automatic Tuning | https://www.red-gate.com/simple-talk/sql/azure-sql-database/improve-the-performance-of-your-azure-sql-database-and-save-money-with-automatic-tuning/ |
| The Importance of Database Compatibility Level in SQL Server | https://www.sqlskills.com/blogs/glenn/the-importance-of-database-compatibility-level-in-sql-server/ |
| Azure Managed vs Unmanaged disks : The choice | https://buildwindows.wordpress.com/2017/05/31/azure-managed-vs-unmanaged-disks-the-choice/ |
| Storage options for SQL Server database files in Azure | https://www.jamesserra.com/archive/2019/01/storage-options-for-sql-server-database-files-in-azure/ |
| The Performance of Window Aggregates Revisited with SQL Server 2019 | https://www.red-gate.com/simple-talk/sql/t-sql-programming/the-performance-of-window-aggregates-revisited-with-sql-server-2019/ |
| Super Scaling Singleton Inserts | https://chrisadkin.io/2015/02/19/super-scaling-singleton-inserts/ |
| Preparation for SQL Server Installation | https://sqlplayer.net/2018/12/preparation-for-sql-server-installation/ |
| Executing xp_cmdshell with Non SysAdmin Account | http://www.lucasnotes.com/2019/01/executing-xpcmdshell-with-non-sysadmin.html |
| Generating SQL using Biml (T-SQL Tuesday #110) | https://www.cathrinewilhelmsen.net/2019/01/08/generating-sql-using-biml/ |
| Using Temporary Procedures | https://www.red-gate.com/simple-talk/blogs/using-temporary-procedures/ |
| Introduction to SQL Server Security — Part 1 | https://www.red-gate.com/simple-talk/sysadmin/data-protection-and-privacy/introduction-to-sql-server-security-part-1/ |
| Introduction to SQL Server Security — Part 2 | https://www.red-gate.com/simple-talk/sysadmin/data-protection-and-privacy/introduction-to-sql-server-security-part-2/ |
| Introduction to SQL Server Security — Part 3 | https://www.red-gate.com/simple-talk/sysadmin/data-protection-and-privacy/introduction-to-sql-server-security-part-3/ |
| Introduction to SQL Server Security — Part 4 | https://www.red-gate.com/simple-talk/sysadmin/data-protection-and-privacy/introduction-to-sql-server-security-part-4/ |
| Introduction to T-SQL Window Functions | https://www.red-gate.com/simple-talk/sql/t-sql-programming/introduction-to-t-sql-window-functions/ |
| Intro to Debugging a Memory Dump | https://blogs.msdn.microsoft.com/psssql/2012/03/15/intro-to-debugging-a-memory-dump/ |
| Considering Security with SQL Bulk Insert | https://www.sqlshack.com/considering-security-with-sql-bulk-insert/ |
| SQL Server 2012 AlwaysOn – Part 11 – Performance Aspects and Performance Monitoring I | https://blogs.msdn.microsoft.com/saponsqlserver/2013/04/21/sql-server-2012-alwayson-part-11-performance-aspects-and-performance-monitoring-i/ |
| SQL Server 2012 AlwaysOn – Part 11 – Performance Aspects and Performance Monitoring II | https://blogs.msdn.microsoft.com/saponsqlserver/2013/04/24/sql-server-2012-alwayson-part-12-performance-aspects-and-performance-monitoring-ii/ |
| Data Compression Internals | https://jesspomfret.com/data-compression-internals/ |
| SQL Server Data Compression – Crunch Time! | https://www.mlakartechtalk.com/sql-server-data-compression-crunch-time/ |
| Create a slipstream installer for SQL Server on Windows | https://bornsql.ca/blog/create-a-slipstream-installer-for-sql-server-on-windows/ |
| Temporary Tables in SQL Server | https://www.red-gate.com/simple-talk/sql/t-sql-programming/temporary-tables-in-sql-server/ |
| SQL unit testing with the tSQLt framework for beginners | https://www.sqlshack.com/sql-unit-testing-with-the-tsqlt-framework-for-beginners/ |
| Oracle vs. SQL Server Architecture | https://dbakevlar.com/2019/03/oracle-vs-sql-server-architecture/ |
| Oracle RAC vs. SQL Server AG | https://dbakevlar.com/2019/03/oracle-rac-vs-sql-server-ag/ |
| SSIS vs. Oracle GG | https://dbakevlar.com/2019/04/ssis-vs-oracle-gg/ |
| Analysis Services Telemetry: What information does SSAS submit? and how has it changed in SSAS 2019? | https://shabnamwatson.wordpress.com/2019/04/13/analysis-services-telemetry-what-information-does-ssas-submit-and-how-has-it-changed-in-ssas-2019/ |
| The Curious Case of… how to find FILESTREAM info from an MDF | https://www.sqlskills.com/blogs/paul/the-curious-case-of-how-to-find-filestream-info-from-an-md |
| Does index fragmentation matter? | http://sqlblog.karaszi.com/does-index-fragmentation-matter/ |
| How to perform a Page Level Restore in SQL Server | https://sqlperfmon.blogspot.com/2016/07/how-to-perform-page-level-restore-in.html |
| How Much Memory Does SSIS Need? | https://www.timmitchell.net/post/2019/05/02/how-much-memory-does-ssis-need/ |
| The Curious Case of… trying to find an MDF file in a RAW disk | https://www.sqlskills.com/blogs/paul/the-curious-case-of-trying-to-find-an-mdf-file-in-a-raw-disk/ |
| Understanding the SQL Server NOLOCK hint | https://www.mssqltips.com/sqlservertip/2470/understanding-the-sql-server-nolock-hint/ |
| Methods to Insert Data into SQL Server | https://www.sqlshack.com/methods-to-insert-data-into-sql-server/ |
| Batching data manipulation is great as long as you do it correctly | http://desertdba.com/batching-data-manipulation-is-great/ |
| Azure and Windows PowerShell: Using VM Extensions | https://www.red-gate.com/simple-talk/sysadmin/powershell/azure-and-windows-powershell-using-vm-extensions/ |
| Reloading fact tables with zero downtime | https://sqlsunday.com/2014/08/24/reloading-fact-tables-with-zero-downtime/ |
| Transferring Data Efficiently by Using Partition Switching | https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms191160(v=sql.105) |
| Another Difference between N'' and '' in SQL Server | https://nocolumnname.blog/2018/10/24/another-difference-between-n-and-in-sql-server/ |
| Ignoring NULLs with FIRST_VALUE | https://bertwagner.com/2018/08/28/ignoring-nulls-with-first-value/ |
| Shortchanged with International Money in SQL Server | https://bertwagner.com/2018/09/25/try-parse-convert-strings-to-numbers/ |
| Understanding database recovery with SQL Server 2016 Extended Events | https://www.mssqltips.com/sqlservertip/4339/understanding-database-recovery-with-sql-server-2016-extended-events/ |
| SQL Server 2019: Batch Mode on Rowstore | http://www.queryprocessor.com/batch-mode-on-row-store/ |
| Using Indexing To Solve Blocking and Deadlocking Issues | https://sqlundercover.com/2019/03/05/using-indexing-to-solve-blocking-and-deadlocking-issues/ |
| Change collation of existing Azure SQL database | https://blogs.msdn.microsoft.com/azuresqldbsupport/2018/11/09/change-collation-of-existing-azure-sql-database/ |
| Creating Database Maintenance Plans | https://codingsight.com/creating-database-maintenance-plans/ |
| SQL Server Upgrade Checklist | https://straightpathsql.com/archives/2019/03/sql-server-upgrade-checklist/ |
| Failing a PowerShell Sql Agent step | https://stuart-moore.com/failing-a-powershell-sql-agent-step/ |
| The Curse of Cursor Options | https://www.brentozar.com/archive/2018/11/the-curse-of-cursor-options/ |
| Accelerated Database Recovery; Instant Rollback and Database Recovery | https://www.sqlshack.com/accelerated-database-recovery-instant-rollback-and-database-recovery/ |
| Accelerated Database Recovery and Long Running Transactions with Transaction Log Growth | https://www.sqlshack.com/accelerated-database-recovery-and-long-running-transactions-with-transaction-log-growth/ |
| Using docker named volumes to persist databases in SQL Server | https://dbafromthecold.com/2019/03/21/using-docker-named-volumes-to-persist-databases-in-sql-server/ |
| T-SQL bugs, pitfalls, and best practices – determinism | https://sqlperformance.com/2019/03/t-sql-queries/bugs-pitfalls-best-practices-determinism |
| Grouped Concatenation in SQL Server | https://sqlperformance.com/2014/08/t-sql-queries/sql-server-grouped-concatenation |
| Working with tempdb in SQL Server 2005 | https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2005/administrator/cc966545(v%3dtechnet.10) |
| SQLskills SQL101: Temporary table misuse | https://www.sqlskills.com/blogs/paul/sqlskills-sql101-temporary-table-misuse/ |
| Running SQL Server on Linux on your own laptop | https://www.kevinrchant.com/2019/03/26/running-sql-server-on-linux-on-your-own-laptop/ |
| SSIS and Pentaho – A Quick Comparison | https://sqlkover.com/ssis-and-pentaho-a-quick-comparison/ |
| WinDbg and SQL Server Fun | https://blobeater.blog/2017/06/14/windbg-and-sql-server-fun/ |
| Certificates, Proxies and Jobs! Oh My! | https://sqlstudies.com/2016/04/27/certificates-proxies-and-jobs-oh-my/ |
| SQL Server: Diagnosing Intermittent Connectivity Issues | https://mitchwheat.com/2019/04/12/sql-server-diagnosing-intermittent-connectivity-issues/ |
| Difference between Identity & Sequence in SQL Server | https://www.sqlshack.com/difference-between-identity-sequence-in-sql-server/ |
| Does the Rowmodctr Update for Non-Updating Updates? | https://www.brentozar.com/archive/2019/05/does-the-rowmodctr-update-for-non-updating-updates/ |
| An Intro To Data Modeling | https://donedifferent.data.blog/2019/04/12/an-intro-to-data-modeling/ |
| On telemetry and other data collected by SQL Server | https://www.sentryone.com/blog/aaronbertrand/sql-server-telemetry/ |
| Purging data with batched deletes | https://am2.co/2019/04/purging-data-with-batched-deletes/ |
| Don’t Forget RoboCopy | https://sqlrus.com/2019/05/dont-forget-robocopy/ |
| Understanding the XML description of the Deadlock Graph in SQL Server | https://www.sqlshack.com/understanding-the-xml-description-of-the-deadlock-graph-in-sql-server/ |
| What Is The Difference Between Checkpoint And Lazy Writer | https://saurabhsinhainblogs.blogspot.com/2012/10/interview-question-checkpoint-and-lazy.html?m=1 |
| Efficiently Indexing Long Character Strings | https://voluntarydba.com/2013/07/30/efficiently-indexing-long-character-strings/ |
| SQL Server Read-only tables | https://sqlstudies.com/2019/01/21/read-only-tables/ |
| Slow inserts across a linked server? | https://www.sqlserverscience.com/performance/slow-inserts-across-linked-server/ |
| Using IGNORE NULLS With SQL Window Functions to Fill Gaps | https://blog.jooq.org/2019/04/24/using-ignore-nulls-with-sql-window-functions-to-fill-gaps/ |
| SQL Server Logical Reads | http://www.sql-server-performance.com/logical-reads/ |
| Two Words For Faster Scalar Functions | https://bertwagner.com/2018/12/04/two-words-for-faster-scalar-functions/ |
| How to Get SQL Server Dates and Times Horribly Wrong | https://www.red-gate.com/simple-talk/sql/t-sql-programming/how-to-get-sql-server-dates-and-times-horribly-wrong/ |
| Diagnosing and Resolving Spinlock Contention on SQL Server | http://download.microsoft.com/download/D/A/A/DAAD63AF-B06F-4F29-AF1D-68A78102ABF4/SQLServerSpinlockContention.pdf |
| Diagnosing and Resolving Latch Contention on SQL Server | http://download.microsoft.com/download/B/9/E/B9EDF2CD-1DBF-4954-B81E-82522880A2DC/SQLServerLatchContention.pdf |
| Advanced Nutanix: SQL Server on Nutanix Best Practices Released! | http://stevenpoitras.com/2013/11/advanced-nutanix-sql-server-nutanix-best-practices-released/ |
| Gaps and Islands Across Date Ranges | https://bertwagner.com/2019/03/12/gaps-and-islands/ |
| NOT NULL Persisted Computed Columns (And What They Allow) | https://www.red-gate.com/simple-talk/blogs/not-null-persisted-computed-columns-and-what-they-allow/ |
| How many ways are there to sort GUIDs? How much time do you have? | https://devblogs.microsoft.com/oldnewthing/20190426-00/?p=102450 |
| How do I force a SQL Login to change it’s password on next login | https://sqlstudies.com/2019/06/05/how-do-i-force-a-sql-login-to-change-its-password-on-next-login/ |
| SQL Server Performance Benchmarking with Patterns | https://www.sqlservercentral.com/articles/sql-server-performance-benchmarking-with-patterns |
| SQL Server function to convert integer date to datetime format | https://www.mssqltips.com/sqlservertip/1712/sql-server-function-to-convert-integer-date-to-datetime-format/ |
| Storing Utc Is Not A Silver Bullet | https://codeblog.jonskeet.uk/2019/03/27/storing-utc-is-not-a-silver-bullet/ |
| Logical Query Processing Part 8 : SELECT and ORDER BY | https://www.itprotoday.com/sql-server/logical-query-processing-part-8-select-and-order |
| SQL Server Common Table Expression vs Temp Table | https://www.mssqltips.com/sqlservertip/6040/sql-server-common-table-expression-vs-temp-table/ |
| Which Query Used The Most Cpu? Implementing Extended Events | https://www.scarydba.com/2019/06/03/which-query-used-the-most-cpu-implementing-extended-events/ |
| SQL Server Plan Cache Limits | https://www.sqlskills.com/blogs/erin/sql-server-plan-cache-limits/ |
| SQL Server and ReFS: Part 1 – DBCC and In Memory OLTP | https://swasheck.wordpress.com/2014/11/11/sql-server-and-refs-part-1-dbcc-and-in-memory-oltp/ |
| SQL Server and ReFS: Part 2 – FIO Benchmarking NTFS vs. ReFS | https://swasheck.wordpress.com/2014/12/18/sql-server-and-refs-part-2-fio-benchmarking-ntfs-vs-refs/ |
| Why Rolling back inserts with Identity columns is a bad idea | https://sqlundercover.com/2019/04/11/rolling-back-inserts-with-identity-columns/ |
| What’s Better, CTEs or Temp Tables? | https://www.brentozar.com/archive/2019/06/whats-better-ctes-or-temp-tables/ |
| The Difference Between SQL’s JOIN .. ON Clause and the Where Clause | https://blog.jooq.org/2019/04/09/the-difference-between-sqls-join-on-clause-and-the-where-clause/ |
| My IT department installed an antivirus with SQL Server | https://bornsql.ca/blog/my-it-department-installed-an-antivirus-with-sql-server/ |
| An Experiment with Deadlocks - ROWLOCK hint myth | http://jasonbrimhall.info/2019/03/25/an-experiment-with-deadlocks/ |
| Adding a New Transaction Log File when the Existing Log is Full | https://www.sqlserverscience.com/internals/adding-new-transaction-log-file-when-existing-log-full/ |
| Transactions Don't Start At BEGIN TRAN | https://www.joshthecoder.com/2019/06/05/transactions-dont-start-at-begin-tran.html |
| CAST/CONVERT makes expressions nullable | https://sqlsunday.com/2019/06/05/cast-convert-makes-expressions-nullable/ |
| Deciding between COALESCE and ISNULL in SQL Server | https://www.mssqltips.com/sqlservertip/2689/deciding-between-coalesce-and-isnull-in-sql-server/%5D |
| How do you choose which columns to include in your SQL Server clustered index? | https://the.agilesql.club/2019/06/how-do-you-choose-which-columns-to-include-in-your-sql-server-clustered-index/ |
| A ever-increasing Clustered Key value doesn’t scale | https://www.sqlpassion.at/archive/2014/04/15/an-ever-increasing-clustered-key-value-doesnt-scale/ |
| SQL Server Bit reversion | https://dangerousdba.blogspot.com/2011/10/bit-reversion.html |
| Troubleshooting a renamed SQL Server | https://blog.wicktech.net/troubleshooting-a-renamed-sql-server/ |
| Are Differential Backups Necessary? | https://blog.wicktech.net/differential-backups/ |
| Updating Statistics on Secondary Replicas of the Availability Groups | http://www.nikoport.com/2019/06/20/updating-statistics-on-secondary-replicas-of-the-availability-groups/ |
| It’s interesting how an OR short circuits | https://sqlstudies.com/2019/06/17/its-interesting-how-an-or-short-circuits/ |
| SQL Server NOLOCK Anomalies, Issues and Inconsistencies | https://www.mssqltips.com/sqlservertip/6072/sql-server-nolock-anomalies-issues-and-inconsistencies/ |
| Choosing a Database for Serverless Applications | https://serverless.com/blog/choosing-a-database-with-serverless/ |
| SQL Server On Linux: Forced Unit Access (Fua) Internals | http://bobsql.com/sql-server-on-linux-forced-unit-access-fua-internals/ |
| Socrates: The New SQL Server in the Cloud | https://www.microsoft.com/en-us/research/uploads/prod/2019/05/socrates.pdf |
| What permissions do temp stored procedures use? | https://sqlstudies.com/2019/06/19/what-permissions-do-temp-stored-procedures-use/ |
| Common SQL Server Mishaps | https://sqlperformance.com/2019/06/sql-performance/common-sql-server-mishaps |
| SQL Server Agent for SQL Express on Linux | https://www.sqlservercentral.com/articles/sql-server-agent-for-sql-express-on-linux |
| Trailing Spaces in SQL Server | https://bertwagner.com/2019/06/18/trailing-spaces-in-sql-server/ |
| Troubleshooting a Change in Query Performance | https://www.sqlskills.com/blogs/erin/troubleshooting-a-change-in-query-performance/ |
| The Silent Bug I Find in Most Triggers | https://www.brentozar.com/archive/2019/05/the-silent-bug-i-find-in-most-triggers/ |
| How to Copy a Table in SQL Server to Another Database | https://www.mssqltips.com/sqlservertip/6009/how-to-copy-a-table-in-sql-server-to-another-database/ |
| Configuration of SQL Server instance | https://sqlplayer.net/2019/06/configuration-of-sql-server-instance/ |
| What is the SQL Server Virtual Log file and how to monitor it | https://www.sqlshack.com/what-is-sql-server-virtual-log-file-and-how-to-monitor-it/ |
| Important change to VLF creation algorithm in SQL Server 2014 | https://www.sqlskills.com/blogs/paul/important-change-vlf-creation-algorithm-sql-server-2014/ |
| SQL Server Transaction Log Fragmentation: a Primer | https://www.red-gate.com/simple-talk/sql/database-administration/sql-server-transaction-log-fragmentation-a-primer/ |
| 8 Steps to better Transaction Log throughput | https://www.sqlskills.com/blogs/kimberly/8-steps-to-better-transaction-log-throughput/ |
| Joins With OR Clauses = 💔 | https://erikdarlingdata.com/2019/06/joins-with-or-clauses-%F0%9F%92%94/ |
| Thoughts on MAXDOP | https://erikdarlingdata.com/2019/06/thoughts-on-maxdop/ |
| What the Arrow Sizes in Query Plans Really Mean | https://www.brentozar.com/archive/2019/06/what-the-arrow-sizes-in-query-plans-really-mean/ |
| Query Store Best Practices | https://www.sqlskills.com/blogs/erin/query-store-best-practices/ |
| Introduction to Data Normalization: A Database "Best" Practice | http://agiledata.org/essays/dataNormalization.html |
| Dr. OUTPUT or: How I Learned to Stop Worrying and Love the MERGE | http://dataeducation.com/dr-output-or-how-i-learned-to-stop-worrying-and-love-the-merge/ |
| SQL Server Tipping Games – Why Non-Clustered Indexes are just ignored! | https://www.sqlpassion.at/archive/2013/06/12/sql-server-tipping-games-why-non-clustered-indexes-are-just-ignored/ |
| SQL Server Guide To NULL Handling | https://gavindraper.com//2018/11/29/SQL-Server-Guide-To-NULL-Handling/ |
| Living with SQL’s 900 Byte Index Key Length Limit | https://blogs.msdn.microsoft.com/bartd/2011/01/06/living-with-sqls-900-byte-index-key-length-limit/ |
| Memory-Optimized TempDB Metadata in SQL Server 2019 - SQLHack | https://www.sqlshack.com/memory-optimized-tempdb-metadata-in-sql-server-2019/ |
| Forcing A Plan That Has A Plan Guide | https://www.scarydba.com/2018/11/26/forcing-a-plan-that-has-a-plan-guide/ |
| Remember the Default Window | https://voiceofthedba.com/2018/08/23/remember-the-default-window/ |
| The Impact of Non-Updating Updates | https://www.sql.kiwi/2010/08/the-impact-of-non-updating-updates.html |
| What are Columnstore Indexes? | https://www.red-gate.com/simple-talk/sql/sql-development/what-are-columnstore-indexes/ |
| PolyBase in SQL Server 2019 – The End of ETL? | https://www.red-gate.com/simple-talk/sql/data-platform/polybase-in-sql-server-2019-the-end-of-etl/ |
| Overview of Service Principal Name and Kerberos authentication in SQL Server | https://www.sqlshack.com/overview-of-service-principal-name-and-kerberos-authentication-sql-server/ |
| Data Transfer Strategies between MongoDB and SQL Server | https://www.sqlservercentral.com/articles/data-transfer-strategies-between-mongodb-and-sql-server |
| SQL Server and Excel Hierarchyid Example for Organization Charts | https://www.mssqltips.com/sqlservertip/6054/sql-server-and-excel-hierarchyid-example-for-organization-charts/ |
| Difference between sp_execute and sp_executesql and exec | https://www.sqlindia.com/difference-between-sp_execute-sp_executesql-exec/ |
| EXEC and sp_executesql – how are they different? | https://www.sqlskills.com/blogs/kimberly/exec-and-sp_executesql-how-are-they-different/ |
| Little Bobby Tables, SQL Injection and EXECUTE AS | https://www.sqlskills.com/blogs/kimberly/little-bobby-tables-sql-injection-and-execute-as/ |
| Examining the Performance Impact of an Adhoc Workload | https://sqlperformance.com/2019/05/sql-plan/perf-impact-adhoc-workload |
| Backup to URL | https://blog.coeo.com/backup-to-url |
| Spotting Unauthorized Configuration Settings in SQL Server | https://www.red-gate.com/hub/product-learning/sql-monitor/spotting-unauthorized-configuration-settings-sql-server |
| Window Functions in SQL Server | https://www.red-gate.com/simple-talk/sql/learn-sql-server/window-functions-in-sql-server/ |
| Window Functions in SQL Server: Part 2-The Frame | https://www.red-gate.com/simple-talk/sql/learn-sql-server/window-functions-in-sql-server-part-2-the-frame/ |
| An Intro to SQL Window Functions | https://www.toptal.com/sql/intro-to-sql-windows-functions |
| SQL Database Performance Tuning for Developers | https://www.toptal.com/sql-server/sql-database-tuning-for-developers |
| “But NOLOCK Is Okay When The Data Isn’t Changing, Right?” | https://www.brentozar.com/archive/2019/08/but-nolock-is-okay-when-the-data-isnt-changing-right/ |
| tempdb Enhancements in SQL Server 2019 | https://sqlperformance.com/2019/08/tempdb/tempdb-enhancements-in-sql-server-2019 |
| Feature Restrictions in SQL Server 2019 are Worse Than Useless: a False Sense of Security And Wasted Opportunity | https://sqlquantumleap.com/2019/08/05/feature-restrictions-in-sql-server-2019-are-worse-than-useless-a-false-sense-of-security-and-wasted-opportunity/ |
| How to get SQL Server Sysadmin Privileges as a Local Admin with PowerUpSQL | https://blog.netspi.com/get-sql-server-sysadmin-privileges-local-admin-powerupsql/ |
| Views of the Same Problem: Network Admin, DBA, and Developer | https://blog.serverfault.com/2011/03/16/views-of-the-same-problem-network-admin-dba-and-developer/ |
| Finding Max Concurrent Operations With T-SQL (Part 1) | https://36chambers.wordpress.com/2019/01/02/finding-max-concurrent-operations-with-t-sql-part-1/ |
| Finding Max Concurrent Operations With T-SQL (Part 2) | https://36chambers.wordpress.com/2019/01/03/finding-max-concurrent-operations-with-t-sql-part-2/ |
| Stack Overflow: The Architecture - 2016 Edition | https://nickcraver.com/blog/2016/02/17/stack-overflow-the-architecture-2016-edition/ |
| Stack Overflow: The Hardware - 2016 Edition | https://nickcraver.com/blog/2016/03/29/stack-overflow-the-hardware-2016-edition/ |
| Stack Overflow: How We Do Deployment - 2016 Edition | https://nickcraver.com/blog/2016/05/03/stack-overflow-how-we-do-deployment-2016-edition/ |
| Stack Overflow: How We Do Monitoring - 2018 Edition | https://nickcraver.com/blog/2018/11/29/stack-overflow-how-we-do-monitoring/ |
| Stack Overflow: How We Do App Caching - 2019 Edition | https://nickcraver.com/blog/2019/08/06/stack-overflow-how-we-do-app-caching/ |
| Adding a Missing Index Killed Performance | https://www.sqlrx.com/missing-index-killed-performance/ |
| Corruption in TempDB | https://stevestedman.com/2019/08/corruption-in-tempdb/ |
| Corruption recovery using DBCC WRITEPAGE | https://www.sqlskills.com/blogs/paul/corruption-recovery-using-dbcc-writepage/ |
| Why DBCC CHECKDB can miss memory corruption | https://www.sqlskills.com/blogs/paul/sqlskills-sql101-why-dbcc-checkdb-can-miss-memory-corruption/ |
| Fixing Cardinality Estimation Errors with Filtered Statistics | https://www.sqlpassion.at/archive/2013/10/29/fixing-cardinality-estimation-errors-with-filtered-statistics/ |
| Plan Stitch: Harnessing the Best of Many Plans | https://www.microsoft.com/en-us/research/publication/plan-stitch-harnessing-the-best-of-many-plans-2/ |
| Query and Resource Optimization: Bridging the Gap | https://www.microsoft.com/en-us/research/publication/query-resource-optimization-bridging-gap/ |
| Cuttlefish: A Lightweight Primitive for Adaptive Query Processing | https://www.microsoft.com/en-us/research/publication/cuttlefish-a-lightweight-primitive-for-adaptive-query-processing/ |
| Leveraging Re-costing for Online Optimization of Parameterized Queries with Guarantees | https://www.microsoft.com/en-us/research/publication/leveraging-re-costing-online-optimization-parameterized-queries-guarantees/ |
| How to choose antivirus software to run on computers that are running SQL Server | https://support.microsoft.com/help/309422 |
| Why is SYSDATETIME() slower than SYSUTCDATETIME()? | https://erikdarlingdata.com/2019/05/why-is-sysdatetime-slower-than-sysutcdatetime/ |
| Constant Time Recovery in Azure SQL Database | https://www.microsoft.com/en-us/research/publication/constant-time-recovery-in-azure-sql-database/ |
| Improving Optimistic Concurrency Control Through Transaction Batching and Operation Reordering | https://www.microsoft.com/en-us/research/publication/improving-optimistic-concurrency-control-through-transaction-batching-and-operation-reordering/ |
| An Empirical Evaluation of In-Memory Multi-Version Concurrency Control | https://www.cs.cmu.edu/~pavlo/papers/p781-wu.pdf |
| Automatically Indexing Millions of Databases in Microsoft Azure SQL Database | https://www.microsoft.com/en-us/research/publication/automatically-indexing-millions-of-databases-in-microsoft-azure-sql-database/ |
| Adding a Column with a Default Constraint | https://matthewmcgiffen.com/2019/07/16/adding-a-column-with-a-default-constraint/ |
| A Hidden Value Of Apply | https://erikdarlingdata.com/2019/06/a-hidden-value-of-apply/ |
| Improve Performance of UDFs with NULL ON NULL INPUT | https://sqlperformance.com/2018/12/sql-performance/improve-udfs-null-on-null-input |
| The ‘= NULL’ Mistake and other SQL NULL Heresies | https://www.red-gate.com/hub/product-learning/sql-prompt/the-null-mistake-and-other-sql-null-heresies |
| How to Corrupt a Database | https://www.sqlserverscience.com/tools/how-to-corrupt-a-database/ |
| SQL Server Page Types | http://www.sqlnotes.info/2011/10/31/page-type/ |
| SQL Server Index Maintenance – You’re Doing It Wrong | http://www.seangallardy.com/sql-server-index-maintenance-youre-doing-it-wrong/ |
| Stop Worrying About SQL Server Fragmentation | https://www.brentozar.com/archive/2012/08/sql-server-index-fragmentation/ |
| How much will it cost or save to rebuild that index? | https://www.sqlservercentral.com/articles/rebuild-index |
| To BLOB or Not To BLOB: Large Object Storage in a Database or a Filesystem? | https://www.microsoft.com/en-us/research/wp-content/uploads/2006/04/tr-2006-45.pdf |
| SQL Server UPSERT Patterns and Antipatterns | https://michaeljswart.com/2017/07/sql-server-upsert-patterns-and-antipatterns/ |
| Use Caution with SQL Server's MERGE Statement | https://www.mssqltips.com/sqlservertip/3074/use-caution-with-sql-servers-merge-statement/ |
| “UPSERT” Race Condition With MERGE | https://weblogs.sqlteam.com/dang/2009/01/31/upsert-race-condition-with-merge/ |
| Checking for potential constraint violations before entering SQL Server TRY and CATCH logic | https://www.mssqltips.com/sqlservertip/2632/checking-for-potential-constraint-violations-before-entering-sql-server-try-and-catch-logic/ |
| Performance impact of different error handling techniques | https://sqlperformance.com/2012/08/t-sql-queries/error-handling |
| Backup and Restore Databases with CHECKSUM and VERIFYONLY | https://www.sqlrx.com/backup-and-restore-databases-with-checksum-and-verifyonly/ |
| dm_db_database_page_allocations | https://www.sqlserverscience.com/sys/dm_db_database_page_allocations/ |
| Compress Big Tables | https://www.sqlserverscience.com/performance/compress-big-tables/ |
| Hardening SQL Server Security | https://mitchwheat.com/2019/08/21/hardening-sql-server-security/ |
| Splitting Strings With OPENJSON | https://itsalljustelectrons.blogspot.com/2019/05/Splitting-Strings-With-OPENJSON.html |
| How to migrate to Amazon RDS for SQL Server using transactional replication | https://aws.amazon.com/ru/blogs/database/how-to-migrate-to-amazon-rds-for-sql-server-using-transactional-replication/ |
| The Hardest Part Of Query Tuning: Logical Equivalence | https://erikdarlingdata.com/2019/08/the-hardest-part-of-query-tuning-logical-equivalence/ |
| SQL Injection: What is it? Causes and exploits | https://www.sqlshack.com/sql-injection-what-is-it-causes-and-exploits/ |
| SQL Injection: Detection and prevention | https://www.sqlshack.com/sql-injection-detection-and-prevention/ |
| Some T-SQL INSERTs DO Follow the Fill Factor! | https://www.sqlservercentral.com/articles/some-t-sql-inserts-do-follow-the-fill-factor-sql-oolie |
| Install SQL Server 2019 Big Data Cluster using Azure Data Studio | https://nielsberglund.com/2019/09/11/install-sql-server-2019-big-data-cluster-using-azure-data-studio/ |
| Indirect Checkpoint and tempdb – the good, the bad and the non-yielding scheduler | https://docs.microsoft.com/en-gb/archive/blogs/sql_server_team/indirect-checkpoint-and-tempdb-the-good-the-bad-and-the-non-yielding-scheduler |
| Ghost Records in SQL Server… Now whats that ???? | https://www.sqlservergeeks.com/sql-server-ghost-records-in-sql-server-now-whats-that/ |
| Transaction Isolation Levels and sp_executesql | https://www.sqlserverscience.com/basics/stored-procedure-dynamic-sql-execute-as/ |
| Batch Mode Bitmaps in SQL Server | https://sqlperformance.com/2019/08/sql-performance/batch-mode-bitmaps-in-sql-server |
| Transparent Data Encryption (TDE) on Azure SQL database | https://www.sqlshack.com/transparent-data-encryption-tde-on-the-azure-sql-database/ |
| Analyzing Estimates from the CSelCalcAscendingKeyFilter Calculator | https://www.joshthecoder.com/2019/08/21/analyzing-estimates-cselcalcascendingkeyfilter-calculator.html |
| Building Storage for SQL Server (and other database) Virtual Machines in the Cloud | https://joeydantoni.com/2019/09/18/building-storage-for-sql-server-and-other-database-virtual-machines-in-the-cloud/ |
| SQL Server Simple and Forced Parameterization | https://www.mssqltips.com/sqlservertip/2935/sql-server-simple-and-forced-parameterization/ |
| How to use a SQL Server Plan Guide to Tune Queries | https://www.mssqltips.com/sqlservertip/1630/how-to-use-a-sql-server-plan-guide-to-tune-queries/ |
| Neglecting to Use, or Misusing, the RETURN Keyword (BP016) | https://www.red-gate.com/hub/product-learning/sql-prompt/neglecting-to-use-or-misusing-the-return-keyword-bp016 |
| Defensive Error Handling | https://www.red-gate.com/simple-talk/sql/t-sql-programming/defensive-error-handling/ |
| A Self-Tuning Fill Factor Technique for SQL Server – Part 1 | https://www.sqlservercentral.com/articles/a-self-tuning-fill-factor-technique-for-sql-server-part-1 |
| A Self-Tuning Fill Factor Technique for SQL Server – Part 2 | https://www.sqlservercentral.com/articles/a-self-tuning-fill-factor-technique-for-sql-server-part-2 |
| SQL: Been told you can't access master database system views in Azure SQL Database? Not true! | https://blog.greglow.com/2019/09/17/sql-told-cannot-access-master-database-system-views-azure-sql-database-not-true/ |
| How to increase SQL Database Full Backup speed using compression and Solid State Disks | http://henkvandervalk.com/how-to-increase-sql-database-full-backup-speed-using-compression-and-solid-state-disks |
| Troubleshooting NUMA Node Imbalance Problems (HammerDB Benchmark) | https://www.sqlpassion.at/archive/2019/09/23/troubleshooting-numa-node-inbalance-problems/ |
| SQL Server Unequal NUMA CPU engagement | https://sql-sasquatch.blogspot.com/2019/09/sql-server-numa-cpu-engagement.html |
| SSIS Connection Managers: OLE DB vs ODBC vs ADO.NET | https://www.sqlshack.com/ssis-connection-managers-ole-db-vs-odbc-vs-ado-net/ |
| SSIS Data Flows – ADO.NET vs. OLE DB vs. ODBC | https://datatellblog.wordpress.com/2015/01/13/ssis-data-flows-ado-net-vs-ole-db-vs-odbc/ |
| SSIS – Fastest data flow task item for transferring data over the network | https://gqbi.wordpress.com/2013/06/19/ssis-fastest-data-flow-task-item-for-transferring-data-over-the-network/ |
| The Case of the Vanishing Index Compression | https://github.com/XiangGe0405/sqlserver-kit/blob/master/Articles/red-gate.com/simple-talk/blogs/the-case-of-the-vanishing-index-compression |
| Migrating from MSSQL to PostgreSQL - What You Should Know | https://severalnines.com/database-blog/migrating-mssql-postgresql-what-you-should-know |
| Difference between Identity and Sequence in SQL Server 2012 | https://raresql.com/2012/05/01/difference-between-identity-and-sequence/ |
| Sequence vs Identity – Performance Comparison | http://byobi.com/2012/09/sequence-vs-identity-performance-comparison/ |
| Read Excel File in SQL Server with OPENROWSET or OPENDATASOURCE | https://www.mssqltips.com/sqlservertip/6178/read-excel-file-in-sql-server-with-openrowset-or-opendatasource/ |
| Upgrading SQL Server using Availability Groups – Checklist | https://thelonedba.wordpress.com/2019/10/17/upgrading-sql-server-using-availability-groups-checklist/ |
| Using indexed views? WITH (NOEXPAND) for Standard Edition | https://bornsql.ca/blog/using-indexed-views-dont-forget-this-important-tip/ |
| Using indexed views? What is an imprecise or non-deterministic convert? | https://bornsql.ca/blog/using-indexed-views-what-is-an-imprecise-or-non-deterministic-convert/ |
| JSON in your Azure SQL Database? Let’s benchmark some options! | https://techcommunity.microsoft.com/t5/SQL-Customer-Success-Engineering/JSON-in-your-Azure-SQL-Database-Let-s-benchmark-some-options/ba-p/909131 |
| Looking for strange - addition to system_health XE | https://karaszi.com/looking-for-strange |
| What's new in SQL Server version x | https://karaszi.com/new-in-version-x |
| The ultimate guide to the datetime datatypes | https://karaszi.com/the-ultimate-guide-to-the-datetime-datatypes |
| Some numbers that you will know by heart if you have been working with SQL Server for a while | https://sqlservercode.blogspot.com/2019/03/some-numbers-that-you-will-know-by.html |
| #TSQL2sday: How Much Plan Cache History Do You Have? | https://www.brentozar.com/archive/2018/07/tsql2sday-how-much-plan-cache-history-do-you-have/ |
| Fixing SQL Server Management Studio’s Tab Text | https://www.brentozar.com/archive/2011/06/fixing-sql-server-management-studios-tab-text/ |
| An overview of the SQL table variable | https://www.sqlshack.com/an-overview-of-the-sql-table-variable/ |
| Performance Impact of Small Queries | https://forrestmcdaniel.com/2019/06/25/performance-impact-of-small-queries/ |
| How we use SQL Server as a Document Store | https://octopus.com/blog/sql-as-document-store |
| Overlooked T-SQL Gems | https://sqlperformance.com/2019/10/t-sql-queries/overlooked-t-sql-gems |
| Are SQL Server database triggers evil? | https://www.sqlshack.com/are-sql-server-database-triggers-evil/ |
| Configuration Best Practices for SQL Server Tempdb–Initial Sizing | https://logicalread.com/2013/02/12/sql-server-tempdb-best-practices-initial-sizing-w01/ |
| Sql Server Extended Events Trace Overhead | https://nenadnoveljic.com/blog/sql-server-extended-events-trace-overhead/ |
| Measuring "Observer Overhead" of SQL Trace vs. Extended Events | https://sqlperformance.com/2012/10/sql-trace/observer-overhead-trace-extended-events |
| Performance overhead of tracing with Extended Event targets vs SQL Trace under CPU Load | http://andreas-wolter.com/en/performance-overhead-of-tracing-with-extended-event-targets-vs-sql-trace-under-cpu-load/ |
| Fragmentation, the final installment | http://sqlblog.karaszi.com/fragmentation-the-final-installment/ |
| Atomic Durability - How do databases recover from a crash ? | https://concurrencyfreaks.blogspot.com/2019/10/atomic-durability-how-do-databases.html |
| Truth First, or Why You Should Mostly Implement Database First Designs | https://blog.jooq.org/2018/06/06/truth-first-or-why-you-should-mostly-implement-database-first-designs/ |
| SQL Server CHECKPOINT, Lazy Writer, Eager Writer and Dirty Pages in SQL Server | https://www.sqlshack.com/sql-server-checkpoint-lazy-writer-eager-writer-and-dirty-pages-in-sql-server/ |
| T-SQL bugs, pitfalls, and best practices – window functions | https://sqlperformance.com/2019/08/sql-performance/t-sql-bugs-pitfalls-and-best-practices-window-functions |
| #BackToBasics: Why I use lower case for data type names (now) | https://www.sentryone.com/blog/aaronbertrand/backtobasics-lower-case-data-types |
| New high availability and disaster recovery benefits for SQL Server | https://cloudblogs.microsoft.com/sqlserver/2019/10/30/new-high-availability-and-disaster-recovery-benefits-for-sql-server/ |
| Because Your Index Maintenance Script Is Measuring The Wrong Thing | https://www.erikdarlingdata.com/2019/10/because-your-index-maintenance-script-is-measuring-the-wrong-thing/ |
| Memory-Optimized TempDB Metadata | http://www.nikoport.com/2019/10/30/memory-optimized-tempdb-metadata/ |
| Build a SQL Cluster Lab Part 1 | https://www.ryanjadams.com/2019/10/build-a-sql-cluster-lab-part-1/ |
| There is no Such Thing as Object-Relational Impedance Mismatch | https://blog.jooq.org/2015/08/26/there-is-no-such-thing-as-object-relational-impedance-mismatch/ |
| ORMs Under the Hood | https://www.vertabelo.com/blog/orms-under-the-hood/ |
| EMERGENCY-mode repair: the very, very last resort | https://www.sqlskills.com/blogs/paul/checkdb-from-every-angle-emergency-mode-repair-the-very-very-last-resort/ |
| Scalar functions and improvements in SQL Server 2019 | http://sqlblog.karaszi.com/scalar-functions-and-improvements-in-sql-server-2019/ |
| Scalar functions in SQL server 2019, part 2 | http://sqlblog.karaszi.com/scalar-functions-in-sql-server-2019-part-2/ |
| Dos and Don'ts of Dynamic SQL | https://www.sqlservercentral.com/articles/dos-and-donts-of-dynamic-sql |
| Differences Between Sql Server TEXT and VARCHAR(MAX) Data Type | https://sqlhints.com/2016/05/11/differences-between-sql-server-text-and-varcharmax-data-type/ |
| VARBINARY(MAX) Tames the BLOB | https://www.itprotoday.com/microsoft-visual-studio/varbinarymax-tames-blob |
| Query Store Options in SSMS 18.4 | https://www.sqlskills.com/blogs/erin/query-store-options-in-ssms-18-4/ |
| Query Store Performance Overhead: What you need to know | https://www.sqlskills.com/blogs/erin/query-store-performance-overhead/ |
| How to fork a GitHub repository and contribute to an open source project | https://sqldbawithabeard.com/2019/11/29/how-to-fork-a-github-repository-and-contribute-to-an-open-source-project/ |
| But I Need To Compare Two Date Columns In My Where Clause | https://www.erikdarlingdata.com/2019/11/but-i-need-to-compare-two-date-columns-in-my-where-clause/ |
| The Difference Between Fault Tolerance, High Availability, & Disaster Recovery | http://www.pbenson.net/2014/02/the-difference-between-fault-tolerance-high-availability-disaster-recovery/ |
| Why LOB data makes shrink run slooooowly | https://www.sqlskills.com/blogs/paul/why-lob-data-makes-shrink-run-slooooowly-t-sql-tuesday-006/ |
| SQL Server 2019 Scalar UDF inlining - out of memory in some cases | https://sql-sasquatch.blogspot.com/2019/11/sql-server-2019-udf-inlining-oom-in.html |
| Is it true that editing a single row in Management Studio empties and reloads the entire table? | https://bornsql.ca/blog/is-it-true-that-editing-a-single-row-in-management-studio-empties-and-reloads-the-entire-table/ |
| A Guide to SQL Naming Conventions | https://blog.jooq.org/2019/10/29/a-guide-to-sql-naming-conventions/ |
| Stop Mapping Stuff in Your Middleware. Use SQL’s XML or JSON Operators Instead | https://blog.jooq.org/2019/11/13/stop-mapping-stuff-in-your-middleware-use-sqls-xml-or-json-operators-instead/ |
| How Does Accelerated Database Recovery Work | https://www.red-gate.com/simple-talk/sql/database-administration/how-does-accelerated-database-recovery-work/ |
| Recover SQL Server Resource Database | https://www.mssqltips.com/sqlservertip/6194/recover-sql-server-resource-database/ |
| What’s in that database? Getting information about routines | https://www.red-gate.com/simple-talk/blogs/whats-in-that-database-getting-information-about-routines/ |
| The Gloop: An Easier way of Managing SQL Server Documentation | https://www.red-gate.com/simple-talk/blogs/the-gloop-an-easier-way-of-managing-sql-server-documentation/ |
| The SQL of Gaps and Islands in Sequences | https://www.red-gate.com/simple-talk/sql/t-sql-programming/the-sql-of-gaps-and-islands-in-sequences/ |
| Drop Database Objects Practically Risk-Free! | https://thenonclutteredindex.com/2019/04/17/drop-database-objects-practically-risk-free/ |
| Predicate Pushdown and why should I care? | https://techcommunity.microsoft.com/t5/SQL-Server/Predicate-Pushdown-and-why-should-I-care/bc-p/1045243#M1406 |
| Stack Overflow Demo Database Column Store Edition: Downloads And Links | https://www.erikdarlingdata.com/2019/11/stack-overflow-demo-database-column-store-edition-downloads-and-links/ |
| Stack Overflow Demo Database Column Store Edition: Exploring Relationships | https://www.erikdarlingdata.com/2019/11/stack-overflow-demo-database-column-store-edition-exploring-relationships/ |
| Stack Overflow Demo Database Column Store Edition: Helpful Links | https://www.erikdarlingdata.com/2019/11/stack-overflow-demo-database-column-store-edition-helpful-links/ |
| Online, Resumable, and WAIT_AT_LOW_PRIORITY operations in SQL Server | https://littlekendra.com/2019/12/09/online-resumable-and-wait_at_low_priority-operations-in-sql-server/ |
| How filtered indexes could be a more powerful feature | https://sqlperformance.com/2013/04/t-sql-queries/filtered-indexes |
| How Forced Parameterization in SQL Server Affects Filtered Indexes | https://www.mssqltips.com/sqlservertip/6139/how-forced-parameterization-in-sql-server-affects-filtered-indexes/ |
| Filtered Indexes and Forced Parameterization (redux) | https://sqlperformance.com/2019/12/t-sql-queries/filtered-indexes-forced-parameterization |
| Interpreting SQL Server 2019 DBCC MEMORYSTATUS output -- Part 1 | https://sql-sasquatch.blogspot.com/2019/12/interpreting-sql-server-2019-dbcc.html |
| Invisible tempdb Killer | https://www.joshthecoder.com/2019/12/18/invisible-tempdb-killer.html |
| Batch Mode On Row Store Is Fickle | https://www.erikdarlingdata.com/2019/12/batch-mode-on-row-store-is-fickle/ |
| Use Azure To Store Sql Server Backups Offsite | https://www.sqlstad.nl/sql-server/use-azure-to-store-sql-server-backups-offsite/ |
| Handling Data Returned from a SQL Stored Procedure | https://www.drewsk.tech/2019/12/20/handling-data-returned-from-a-sql-stored-procedure/ |
| When QUERY_OPTIMIZER_COMPATIBILITY_LEVEL_140 does not follow CL 140 rules | https://milossql.wordpress.com/2019/12/20/query_optimizer_compatibility_level_140/ |
| SQL Server–HOW-TO: quickly retrieve accurate row count for table | https://blogs.msdn.microsoft.com/martijnh/2010/07/15/sql-serverhow-to-quickly-retrieve-accurate-row-count-for-table/ |
| Do You Have REFERENCES? | https://www.red-gate.com/simple-talk/sql/t-sql-programming/do-you-have-references/ |
| Fun with (columnstore) compression on a very large table – part 1 | https://sqlperformance.com/2019/12/columnstore/fun-with-compression-very-large-table-1 |
| How to Make SELECT COUNT(*) Queries Crazy Fast | https://www.brentozar.com/archive/2019/12/how-to-make-select-count-queries-crazy-fast/ |
| SSISDB Catalog Defaults Best Practices | https://datasteve.com/2019/12/06/ssisdb-catalog-defaults-best-practices/ |
| Temporal Tables, and how to deal with computed columns | https://bornsql.ca/blog/temporal-tables-and-how-to-deal-with-computed-columns/ |
| Cardinality Estimation for Disjunctive Predicates in SQL Server 2014 | https://www.sql.kiwi/2014/04/cardinality-estimation-for-disjunctive-predicates-in-2014.html |
| Create Distributed Availability Group in Sql Server Linux(Redhat) --- step by step | https://techcommunity.microsoft.com/t5/sql-server-support/create-distributed-availability-group-in-sql-server-linux-redhat/ba-p/1003471 |
| Connection options in SSMS | https://sqlstudies.com/2013/11/18/connection-options-in-ssms/ |
| A Script To Automatically Align Columnstore Indexes To Enhance Segment Elimination (and Hence Performances) | https://tsql.tech/a-script-to-automatically-align-columnstore-indexes-to-enhance-segment-elimination-and-hence-performances/ |
| Issues with SQLCMD when using special characters | https://www.mssqltips.com/sqlservertip/5132/issues-with-sqlcmd-when-using-special-characters/ |
| Encrypting passwords with Python Scripts in SQL Notebooks of Azure Data Studio | https://www.sqlshack.com/encrypting-passwords-with-python-scripts-in-sql-notebooks-of-azure-data-studio/ |
| Fun with (columnstore) compression on a very large table – part 2 | https://sqlperformance.com/2020/01/columnstore/fun-with-compression-very-large-table-2 |
| The curious case of the sqlcmd password | https://bornsql.ca/blog/the-curious-case-of-the-sqlcmd-password/ |
| Setting up Management Studio for remote SQL Server | https://www.sqlservercentral.com/articles/setting-up-management-studio-for-remote-sql-server |
| SQL Server Security Best Practices for an Application Installed on SQL Server | https://www.mssqltips.com/sqlservertip/6266/sql-server-security-best-practices-for-an-application-installed-on-sql-server/ |
| PCI Best Practices Guide for SQL Server DBAs | https://www.mssqltips.com/sqlservertip/3609/pci-best-practices-guide-for-sql-server-dbas/ |
| SQL Server Security Checklist | https://www.mssqltips.com/sqlservertip/3159/sql-server-security-checklist/ |
| Replace Model SQL Server Database with a User Database | https://www.mssqltips.com/sqlservertip/6154/replace-model-sql-server-database-with-a-user-database/ |
| SQL Server Linux installation for Amazon EC2 instance with Red Hat OS | https://www.sqlshack.com/sql-server-linux-installation-for-amazon-ec2-instance-with-red-hat-os/ |
| Departure of a SQL Server Administrator – What to Check? | https://thelonedba.wordpress.com/2020/01/03/departure-of-a-sql-server-administrator-what-to-check/ |
| The Curious Case of… transactions rolling back during DBCC CHECKDB | https://www.sqlskills.com/blogs/paul/the-curious-case-of-transactions-rolling-back-during-dbcc-checkdb/ |
| Don’t install SQL Server from a mounted ISO | https://bornsql.ca/blog/dont-install-sql-server-from-a-mounted-iso/ |
| NULL complexities – Part 1 | https://sqlperformance.com/2019/12/t-sql-queries/null-complexities-part-1 |
| NULL complexities – Part 2 | https://sqlperformance.com/2020/01/t-sql-queries/null-complexities-part-2 |
| NULL complexities – Part 3 | https://sqlperformance.com/2020/02/t-sql-queries/null-complexities-part-3-missing-standard-features-and-t-sql-alternatives |
| How to fix the “Agent XPs disabled” error | https://www.sqlshack.com/how-to-fix-the-agent-xps-disabled-error/ |
| Number of Rows Read / Actual Rows Read warnings in Plan Explorer | https://sqlperformance.com/2016/06/sql-indexes/actual-rows-read-warnings-plan-explorer |
| Data Compression + Backup Compression = Double Compression? | https://jesspomfret.com/double-compression/ |
| How Many Bytes Per Character in SQL Server: a Completely Complete Guide | https://sqlquantumleap.com/2019/11/22/how-many-bytes-per-character-in-sql-server-a-completely-complete-guide/ |
| Storage 101: Welcome to the Wonderful World of Storage | https://www.red-gate.com/simple-talk/sql/database-administration/storage-101-welcome-to-the-wonderful-world-of-storage/ |
| How to detect and prevent unexpected growth of the TempDB database | https://www.sqlshack.com/how-to-detect-and-prevent-unexpected-growth-of-the-tempdb-database/ |
| Understanding the SQL Server Proportional fill algorithm | https://www.sqlshack.com/understanding-sql-server-proportional-fill-algorithm/ |
| VALUES() and Long Parameter Lists | https://www.red-gate.com/simple-talk/sql/learn-sql-server/values-and-long-parameter-lists/ |
| Going Serverless with Azure SQL Database | https://www.mssqltips.com/sqlservertip/6273/going-serverless-with-azure-sql-database/ |
| SQLskills SQL101: Why are Statistics so Important? | https://www.sqlskills.com/blogs/kimberly/sql101_whystatisticsareimportant/ |
| Configuring SQL Server Express edition as SQL witness server in Database Mirroring | https://www.sqlshack.com/configuring-sql-server-express-edition-as-sql-witness-server-in-database-mirroring/ |
| The Half Apply Query | https://forrestmcdaniel.com/2020/01/20/the-half-apply-query/ |
| Import JSON data into SQL Server | https://www.sqlshack.com/import-json-data-into-sql-server/ |
| Auditing in AWS RDS SQL Server | https://www.sqlshack.com/auditing-in-aws-rds-sql-server/ |
| Types of SQL Server Indexes | https://www.mssqltips.com/sqlservertip/6274/types-of-sql-server-indexes/ |
| Use SQL Server's UNPIVOT operator to help normalize output | https://www.mssqltips.com/sqlservertip/3000/use-sql-servers-unpivot-operator-to-help-normalize-output/ |
| Prevent SSMS from seeing the server's file system | https://dba.stackexchange.com/a/246783/107045 |
| Add the ability to disable or enable a few new DMVs and DMFs introduced in SQL Server 2017 | https://support.microsoft.com/help/4046638/ |
| Actual Difference Between EXISTS(SELECT 1 …), EXISTS(SELECT * …), and EXISTS(SELECT column …) | https://sqlquantumleap.com/2020/01/24/actual-difference-between-existsselect-1-existsselect-and-existsselect-column/ |
| Why Wait Stats Alone Are Not Enough | https://sqlperformance.com/2020/01/sql-performance/why-waits-alone-are-not-enough |
| Estimating AWS RDS SQL Server costs | https://www.sqlshack.com/estimating-aws-rds-sql-server-costs/ |
| SQL Server Performance Tuning Using Wait Statistics: A Beginner’s Guide | https://www.sqlskills.com/wp-content/uploads/2014/04/sql-server-performance-tuning-using-wait-statistics-whitepaper.pdf |
| sys.xp_delete_files and ‘allow filesystem enumeration’: two new undocumented items in SQL Server 2019 | https://sqlquantumleap.com/2020/01/26/sys-xp_delete_files-and-allow-filesystem-enumeration-two-new-undocumented-items-in-sql-server-2019/ |
| Why Database Monitoring Tools Are So Hard to Interpret | https://www.brentozar.com/archive/2020/01/why-database-monitoring-tools-are-so-hard-to-interpret/ |
| Extended Events Misperceptions: Profiler Is Easier | https://www.scarydba.com/2020/01/20/extended-events-misperceptions-profiler-is-easier/ |
| Extended Events Misperceptions: Profiler Is Easier, Part 2 | https://www.scarydba.com/2020/01/27/extended-events-misperceptions-profiler-is-easier-part-2/ |
| Automate SFTP File Transfer with SQL Server Agent and WinSCP | https://www.mssqltips.com/sqlservertip/6285/automate-sftp-file-transfer-with-sql-server-agent-and-winscp/ |
| Running Database Console Commands (DBCCs) on Azure SQL Database | https://www.databasejournal.com/features/mssql/running-database-console-commands-dbccs-on-azure-sql-database.html |
| How to Remove Times from Dates in SQL Server | https://www.brentozar.com/archive/2020/01/how-to-remove-times-from-dates-in-sql-server/ |
| Export/Import Data using BCP - SQL Server on Linux | https://www.sqlservercentral.com/articles/export-import-data-using-bcp-sql-server-on-linux |
| Prevent SQL Server Blocking using Lock_Timeout | https://www.mssqltips.com/sqlservertip/6279/prevent-sql-server-blocking-using-locktimeout/ |
| Bin Packing Problems: The SQL | https://www.red-gate.com/simple-talk/sql/t-sql-programming/bin-packing-problems-the-sql/ |
| Causation, Correlation and Crackpots | https://www.red-gate.com/simple-talk/sql/t-sql-programming/causation-correlation-and-crackpots/ |
| What Events are in a Trace? | https://www.sqlskills.com/blogs/erin/what-events-are-in-a-trace/ |
| What Are Soft Deletes, and How Are They Implemented? | https://www.brentozar.com/archive/2020/02/what-are-soft-deletes-and-how-are-they-implemented/ |
| Why You Should Switch in Staging Tables Instead of Renaming Them (Dear SQL DBA Episode 26) | https://littlekendra.com/2017/01/19/why-you-should-switch-in-staging-tables-instead-of-renaming/ |
| Changing a column from int to bigint, without downtime | https://am2.co/2019/12/changing-a-column-from-int-to-bigint-without-downtime/ |
| I hate sp_estimate_data_compression_savings | https://am2.co/2019/12/i-hate-sp_estimate_data_compression_savings/ |
| Testing as another user…without their password - impersonate the other user | https://am2.co/2019/12/testing-as-another-user-without-their-password/ |
| How does a database RESTORE affect plan cache? | https://am2.co/2019/10/how-does-a-database-restore-affect-plan-cache/ |
| Recovery of database is 0% complete (approximately 1000000 seconds remain) | https://am2.co/2019/10/recovery-of-database-is-0-complete-approximately-1000000-seconds-remain/ |
| Code to purge data based on creation date | https://am2.co/2019/04/code-to-purge-data-on-creation-date/ |
| Blocking with OBJECT_NAME() | https://am2.co/2019/12/blocking-with-object_name/ |
| Performance Myths: The query result cache | https://sqlperformance.com/2018/07/performance-myths/query-result-cache |
| Fun with (columnstore) compression on a very large table – part 3 | https://sqlperformance.com/2020/02/columnstore/fun-with-columnstore-compression-on-a-very-large-table-part-3 |
| Indexing basics | https://sqlsunday.com/2013/02/19/indexing-basics/ |
| Working with covering indexes | https://sqlsunday.com/2013/02/24/covering-indexes/ |
| Using Erik Darling’s sp_pressure_detector to resolve CPU issues | https://desertdba.com/using-erik-darlings-sp_pressure_detector-to-resolve-cpu-issues/ |
| The Accidental DBA (Day 16 of 30): General Security | https://www.sqlskills.com/blogs/jonathan/the-accidental-dba-day-16-of-30-general-security/ |
| Securing Data in SQL Server | https://www.sqlskills.com/blogs/jonathan/securing-data-in-sql-server/ |
| Performance Testing SQL 2008's Transparent Data Encryption | https://www.databasejournal.com/features/mssql/article.php/3815501/Performance-Testing-SQL-2008146s-Transparent-Data-Encryption.htm |
| Common SQL Server Security Issues and Solutions | https://docs.microsoft.com/en-us/previous-versions/technet-magazine/dd637114(v=msdn.10) |
| Chaos Engineering and SQL Server | https://dbafromthecold.com/2020/01/29/chaos-engineering-and-sql-server/ |
| Different methods to attach SQL Server MDF files | https://www.sqlshack.com/different-methods-to-attach-sql-server-mdf-files/ |
| Learn SQL: How to Write a Complex SELECT Query | https://www.sqlshack.com/learn-sql-how-to-write-a-complex-select-query/ |
| Filling In Missing Values Using the T-SQL Window Frame | https://www.red-gate.com/simple-talk/sql/t-sql-programming/filling-in-missing-values-using-the-t-sql-window-frame/ |
| Select * in a view | https://sqlreitse.home.blog/2020/02/12/select-in-a-view/ |
| T-SQL TUESDAY #123: Aggregates of Aggregates using Windowing Functions | https://jimbabwe.co.za/2020/02/12/t-sql-tuesday-123-life-hacking-by-opening-windows/ |
| SQL Server Statistics: Explained | https://blogs.msdn.microsoft.com/srgolla/2012/09/04/sql-server-statistics-explained/ |
| How to Pass a List of Values Into a Stored Procedure | https://www.brentozar.com/archive/2020/02/how-to-pass-a-list-of-values-into-a-stored-procedure/ |
| What's the difference between a temp table and table variable in SQL Server? | https://dba.stackexchange.com/a/16386/107045 |
| Be Mindful of SQL Server Tempdb Use (aka Tempdb Parasites!) | https://www.sentryone.com/blog/be-mindful-of-sql-server-tempdb-use-aka-tempdb-parasites |
| Robyn Page’s SQL Server Cursor Workbench (Quirky Update) | https://www.red-gate.com/simple-talk/sql/learn-sql-server/robyn-pages-sql-server-cursor-workbench/ |
| Solving the Running Total and Ordinal Rank Problems (Rewritten) (Quirky Update) | https://www.sqlservercentral.com/articles/solving-the-running-total-and-ordinal-rank-problems-rewritten |
| Running totals in “Denali” CTP3 (Quirky Update) | https://blog.waynesheffield.com/wayne/archive/2011/08/running-totals-in-denali-ctp3/ |
| WHERE GETDATE() BETWEEN StartDate AND EndDate Is Hard to Tune. | https://www.brentozar.com/archive/2020/02/where-getdate-between-startdate-and-enddate-is-hard-to-tune/ |
| WHERE GETDATE() BETWEEN StartDate AND COALESCE(CancelDate, EndDate) Is Even Harder to Tune. | https://www.brentozar.com/archive/2020/02/where-getdate-between-startdate-and-coalescecanceldate-enddate-is-even-harder-to-tune/ |
| How to solve the SQL Identity Crisis in SQL Server | https://www.sqlshack.com/solve-identity-crisis-sql-server/ |
| Significant SQL Server 2019 licensing changes | https://www.kevinrchant.com/2020/02/17/significant-sql-server-2019-licensing-changes/ |
| Indexed View Maintenance Is Only As Bad As Your Indexes | https://www.erikdarlingdata.com/2020/02/indexed-view-maintenance-is-only-as-bad-as-your-indexes/ |
| Why Design Impacts Performance on Microsoft SQL Server | https://www.sentryone.com/blog/why-design-impacts-performance-microsoft-sql-server |
| Apply versus Nested Loops Join | https://www.sql.kiwi/2019/06/apply-versus-nested-loops-join.html |
| Inside the Optimizer: Constructing a Plan - Part 1 | https://www.sql.kiwi/2010/07/inside-the-optimiser-constructing-a-plan.html |
| Inside the Optimizer: Constructing a Plan - Part 2 | https://www.sql.kiwi/2010/07/inside-the-optimiser-constructing-a-plan-ii.html |
| Inside the Optimizer: Constructing a Plan - Part 3 | https://www.sql.kiwi/2010/07/inside-the-optimiser-constructing-a-plan-part-3.html |
| Inside the Optimizer: Constructing a Plan - Part 4 | https://www.sql.kiwi/2010/07/inside-the-optimiser-constructing-a-plan-part-4.html |
| Tips for dealing with large SQL Server scripts | https://www.kevinrchant.com/2020/02/24/tips-for-dealing-with-large-sql-server-scripts/ |
| Database Normalization in SQL with Examples | https://www.sqlservercentral.com/articles/database-normalization-in-sql-with-examples |
| Why SQL Server May Not Parallelize a Query | https://logicalread.com/2015/10/30/sql-server-query-parallelizing-mc11/ |
| Parallelism in SQL Server Execution Plan | https://www.mssqltips.com/sqlservertip/5404/parallelism-in-sql-server-execution-plan/ |
| An XEvent a Day (26 of 31) – Configuring Session Options | https://www.sqlskills.com/blogs/jonathan/an-xevent-a-day-26-of-31-configuring-session-options/ |
| Azure SQL Managed Instance Performance Considerations | https://sqlperformance.com/2020/02/azure/sql-managed-instance-performance-considerations |
| The Curious Case of… whether corruption can propagate to secondary databases | https://www.sqlskills.com/blogs/paul/the-curious-case-of-whether-corruption-can-propagate-to-secondary-databases/ |
| Stop and Think Before You Shrink – Shrinking a SQL Server Database | https://www.mlakartechtalk.com/stop-and-think-before-you-shrink-shrinking-a-sql-server-database/ |
| How to Analyze the SQL Server Error Log | https://www.mlakartechtalk.com/how-to-analyze-the-sql-server-error-log/ |
| Converting SQL Trace to Extended Events in SQL Server 2012 | https://www.sqlskills.com/blogs/jonathan/converting-sql-trace-to-extended-events-in-sql-server-2012/ |
| What event information can I get by default from SQL Server? | https://dba.stackexchange.com/a/48053/107045 |
| Removing the default trace – Part 1 | https://sqlperformance.com/2020/03/extended-events/removing-default-trace-1 |
| Removing the default trace – Part 2 | https://sqlperformance.com/2020/04/extended-events/removing-default-trace-2 |
| Removing the default trace – Part 3 | https://sqlperformance.com/2020/04/extended-events/removing-default-trace-3 |
| Keeping DRY in SQL Server with Scalar User Defined Functions – Part 1 | https://www.sentryone.com/blog/keeping-dry-in-sql-server-with-scalar-user-defined-functions-part-1 |
| Different Ways to Monitor SQL Server AlwaysOn Availability Groups | https://codingsight.com/different-ways-to-monitor-sql-server-alwayson-availability-groups/ |
| SQL Server internals: Is Order of Column in the table important? | http://ariely.info/Blog/tabid/83/EntryId/219/SQL-Server-internals-Is-Order-of-Column-in-the-table-important.aspx |
| Code: Order of columns in table might impact the size of the table/database and even related to errors | http://ariely.info/Blog/tabid/83/EntryId/243/Code-Order-of-columns-in-table-might-impact-the-size-of-the-table-database-and-even-related-to-errors.aspx |
| SQL Server Internals: Getting the data of deleted column | http://ariely.info/Blog/tabid/83/EntryId/213/SQL-Server-Internals-Getting-the-data-of-deleted-column.aspx |
| Queue table issues with Availability Groups in SQL Server | https://github.com/XiangGe0405/sqlserver-kit/blob/master/Articles/mssqltips.com/sqlservertip/6284/queue-table-issues-with-availability-groups-in-sql-server |
| Transact-SQL: openjson hierarchy solution | http://ariely.info/Blog/tabid/83/EntryId/239/Transact-SQL-openjson-hierarchy-solution.aspx |
| CREATE DLL TRIGGER ON CREATE_LOGIN to configure default parameters for any new LOGIN | http://ariely.info/Blog/tabid/83/EntryId/240/CREATE-DLL-TRIGGER-ON-CREATE_LOGIN-to-configure-default-parameters-for-any-new-LOGIN.aspx |
| SQL Server Internals: Getting the data of deleted column | http://ariely.info/Blog/tabid/83/EntryId/213/SQL-Server-Internals-Getting-the-data-of-deleted-column.aspx |
| SQL varchar data type deep dive | https://www.sqlshack.com/sql-varchar-data-type-deep-dive/ |
| What is the datatype SQL_VARIANT | https://sqlstudies.com/2020/04/16/what-is-the-datatype-sql_varient/ |
| An Introduction to Asynchronous Processing with Service Broker | https://sqlperformance.com/2014/03/sql-performance/intro-to-service-broker |
| Detecting and Alerting on SQL Server Agent Missed Jobs | https://www.sqlshack.com/detecting-and-alerting-on-sql-server-agent-missed-jobs-2/ |
| Execute multiple jobs Synchronously from in a main job | http://ariely.info/Blog/tabid/83/EntryId/250/Execute-multiple-jobs-Synchronously-from-in-a-main-job.aspx |
| Why Ordering Isn’t Guaranteed Without an ORDER BY | https://www.brentozar.com/archive/2020/04/why-ordering-isnt-guaranteed-without-an-order-by/ |
| How to Attach a SQL Server Database without a Transaction Log and with Open Transactions | https://www.mssqltips.com/sqlservertip/3579/how-to-attach-a-sql-server-database-without-a-transaction-log-and-with-open-transactions/ |
| SQL 2016 - It Just Runs Faster: Indirect Checkpoint Default | https://docs.microsoft.com/en-gb/archive/blogs/psssql/sql-2016-it-just-runs-faster-indirect-checkpoint-default |
| How do checkpoints work and what gets logged | https://www.sqlskills.com/blogs/paul/how-do-checkpoints-work-and-what-gets-logged/ |
| Inside the Storage Engine: What’s in the buffer pool? | https://www.sqlskills.com/blogs/paul/inside-the-storage-engine-whats-in-the-buffer-pool/ |
| What does checkpoint do for tempdb? | https://www.sqlskills.com/blogs/paul/what-does-checkpoint-do-for-tempdb/ |
| Performance issues from wasted buffer pool memory | https://www.sqlskills.com/blogs/paul/performance-issues-from-wasted-buffer-pool-memory/ |
| How It Works: When is the FlushCache message added to SQL Server Error Log? | https://docs.microsoft.com/en-us/archive/blogs/psssql/how-it-works-when-is-the-flushcache-message-added-to-sql-server-error-log |
| Negative identity values don’t suck | https://bornsql.ca/blog/negative-identity-values-dont-suck/ |
| How SQL Server stores data types: integers and decimals | https://bornsql.ca/blog/how-sql-server-stores-data-types-integers-and-decimals/ |
| How SQL Server stores data types: DATETIME, DATE, TIME, and DATETIME2 | https://bornsql.ca/blog/how-sql-server-stores-data-types-datetime-date-time-and-datetime2/ |
| Cross Database Transactions on One Server | https://michaeljswart.com/2020/05/cross_database_transactions/ |
| Your Views Aren’t The Problem. Your Code Is. | https://www.brentozar.com/archive/2020/05/your-views-arent-the-problem-your-code-is/ |
| Can I Offload DBCC CHECKDB To Another Server? | https://www.brentozar.com/archive/2020/05/can-i-offload-dbcc-checkdb-to-another-server/ |
| Negative (-) is an operator and will affect the order of operations. | https://sqlstudies.com/2020/05/18/negative-is-an-operator-and-will-effect-the-order-of-operations/ |
| "0 to 60" : Switching to indirect checkpoints | https://sqlperformance.com/2020/05/system-configuration/0-to-60-switching-to-indirect-checkpoints |
| Parallelism Can Make Queries Perform Worse. | https://www.brentozar.com/archive/2020/05/parallelism-can-make-queries-perform-worse/ |
| A SQL Server DBA myth a day: (15/30) checkpoint only writes pages from committed transactions | https://www.sqlskills.com/blogs/paul/a-sql-server-dba-myth-a-day-1530-checkpoint-only-writes-pages-from-committed-transactions/ |
| Can You Use NVARCHAR As a Universal Parameter? Almost. | https://www.brentozar.com/archive/2020/04/can-you-use-nvarchar-as-a-universal-parameter-almost/ |
| The Learner’s Guide to SQL Server Performance Triage | https://littlekendra.com/2020/03/19/the-learners-guide-to-sql-server-performance-triage/ |
| Learner’s Guide to SQL Server Query Tuning | https://littlekendra.com/2020/05/01/learners-guide-to-sql-server-query-tuning/ |
| How to Get Better Estimates for Modification Queries | https://www.brentozar.com/archive/2020/04/how-to-get-better-estimates-for-modification-queries/ |
| SSMS: Prevent Copy and Paste of Text in “Messages” tab (Cruel Joke #2) | https://sqlquantumleap.com/2020/05/22/ssms-prevent-copy-and-paste-of-text-in-messages-tab-cruel-joke-2/s |
| Compare the Best SQL Server Performance Monitoring Tools | https://www.sentryone.com/compare-best-sql-server-monitoring-tools |
| Minimal Logging with INSERT…SELECT into Heap Tables | https://sqlperformance.com/2019/05/sql-performance/minimal-logging-insert-select-heap |
| Minimal Logging with INSERT…SELECT into Empty Clustered Tables | https://sqlperformance.com/2019/05/sql-performance/minimal-logging-empty-clustered |
| Minimal Logging with INSERT…SELECT and Fast Load Context | https://sqlperformance.com/2019/05/sql-performance/minimal-logging-fast-load-context |
| Avoiding SQL Server Upgrade Performance Issues | https://www.sqlskills.com/blogs/glenn/avoid-sql-server-upgrade-performance-issues/ |
| Compatibility Levels and Cardinality Estimation Primer | https://sqlperformance.com/2019/01/sql-performance/compatibility-levels-and-cardinality-estimation-primer |
| An approach to index tuning – Part 1 | https://sqlperformance.com/2020/03/sql-indexes/an-approach-to-index-tuning-part-1 |
| An approach to index tuning – Part 2 | https://sqlperformance.com/2020/04/sql-indexes/an-approach-to-index-tuning-part-2 |
| Moving A Database to New Storage With No Downtime | https://www.bobpusateri.com/archive/2013/03/moving-a-database-to-new-storage-with-no-downtime/ |
| RESOURCE_GOVERNOR_IDLE in Azure | https://joshthecoder.com/2020/06/15/resource-governor-idle-in-azure.html |
| Automated Backup Tuning | https://sirsql.net/2012/12/13/20121212automated-backup-tuning/ |
| Optimizing Database Restores | https://sirsql.net/2011/09/26/2011926optimizing-database-restores-html/ |
| AVAILABILITY_REPLICA - The Deception of the Log Reuse Wait Type | https://sirsql.net/2020/05/19/the-deception-of-the-log-reuse-wait-type/ |
| Changing an INT to a BIGINT with no downtime | https://michaeljswart.com/2020/06/problem-solving-by-cheating/ |
| New Metadata-Only Column Changes in SQL Server 2016 | https://sqlperformance.com/2020/04/database-design/new-metadata-column-changes-sql-server-2016 |
| Bandwidth-friendly Query Profiling for Azure SQL Database | https://sqlperformance.com/2020/04/sql-performance/bandwidth-friendly-query-profiling-azure-sql-database |
| Column scope and binding order in subqueries | https://sqlinthewild.co.za/index.php/2019/04/23/no-this-is-not-a-bug-in-t-sql/ |
| Improve SQL Server Extended Events system_health Session | https://www.mssqltips.com/sqlservertip/6456/improve-sql-server-extended-events-systemhealth-session/ |
| Page Life Expectancy Doesn’t Mean Jack, and You Should Stop Looking At It. | https://www.brentozar.com/archive/2020/06/page-life-expectancy-doesnt-mean-jack-and-you-should-stop-looking-at-it/ |
| Unsupported but working versions of SQL Server on Windows Server 2019 | https://bornsql.ca/blog/unsupported-but-working-versions-of-sql-server-on-windows-server-2019/ |
| Bad Idea Jeans: Building Big Query Plans | https://www.brentozar.com/archive/2020/06/bad-idea-jeans-building-big-query-plans/ |
| SQL Server performance tuning – RESOURCE_SEMAPHORE waits | https://www.sqlshack.com/sql-server-performance-tuning-resource_semaphore-waits/ |
| Use session_context to create a “variable” that lasts between batches. | https://sqlstudies.com/2020/05/26/use-session_context-to-create-a-variable-that-lasts-between-batches/ |
| Phase out CONTEXT_INFO() in SQL Server 2016 with SESSION_CONTEXT() | https://www.mssqltips.com/sqlservertip/4094/phase-out-contextinfo-in-sql-server-2016-with-sessioncontext/ |
| How to Balance SQL Server Core Licenses Across NUMA Nodes | https://glennsqlperformance.com/2020/06/25/how-to-balance-sql-server-core-licenses-across-numa-nodes/ |
| What is the Difference Between Physical Sockets, Physical Cores, and Logical Cores? | https://glennsqlperformance.com/2019/12/18/what-is-the-difference-between-physical-sockets-physical-cores-and-logical-cores/ |
| What is the Difference Between Physical Sockets, Physical Cores, and Logical Cores? | https://glennsqlperformance.com/2019/12/18/what-is-the-difference-between-physical-sockets-physical-cores-and-logical-cores/ |
| The 201 Buckets Problem, Part 1: Why You Still Don’t Get Accurate Estimates | https://www.brentozar.com/archive/2020/07/the-201-buckets-problem-part-1-why-you-still-dont-get-accurate-estimates/ |
| The 201 Buckets Problem, Part 2: How Bad Estimates Backfire As Your Data Grows | https://www.brentozar.com/archive/2020/07/the-201-buckets-problem-part-2-how-bad-estimates-backfire-as-your-data-grows/ |
| Sql Server — Widely Random Query Exec Times (cxconsumer Wait/cxpacket) & Possible Remediation | https://viktorsrandomposts.wordpress.com/2020/06/26/sql-server-widely-random-query-exec-times-cxconsumer-wait-possible-remediation/ |
| How MAXDOP Really Works | https://www.sql.kiwi/2020/07/how-maxdop-really-works.html |
| What is MaxDOP controlling? | https://techcommunity.microsoft.com/t5/sql-server/what-is-maxdop-controlling/ba-p/1505968 |
| What If You Really DO Need to Shrink a Database? | https://www.brentozar.com/archive/2020/07/what-if-you-really-do-need-to-shrink-a-database/ |
| Everything I Never Wanted to Know About Collation | https://littlekendra.com/2020/07/16/everything-i-never-wanted-to-know-about-collation-14-minute-video-podcast-episode/ |
| Comparing SSIS And Azure Data Factory | https://www.timmitchell.net/post/2020/07/16/comparing-ssis-and-azure-data-factory/ |
| sp_Blitz for All Servers | https://garrybargsley.com/2020/07/14/sp_blitz-for-all-servers/ |
| Where is the SQL Server Community Networking Online? | https://www.brentozar.com/archive/2020/07/where-is-the-sql-server-community-networking-online/ |
| Make the most out of your Azure Disks using Storage Pools | https://blog.coeo.com/make-the-most-out-of-your-azure-disks-using-storage-pools |
| SQL Server High Availability Solutions on Azure VMs | https://www.brentozar.com/archive/2020/07/where-is-the-sql-server-community-networking-online/ |
| How to Get Started with SQL Server Management Studio | https://www.brentozar.com/archive/2020/07/how-to-get-started-with-sql-server-management-studio/ |
| How should I store currency values in SQL Server? | https://bornsql.ca/blog/how-should-i-store-currency-values-in-sql-server/ |
| Read committed isolation level doesn’t guarantee much… | https://www.sqlskills.com/blogs/paul/read-committed-doesnt-guarantee-much/ |
| Prevent Unexpected Failovers When Patching AGs | https://joshthecoder.com/2020/05/21/prevent-unexpected-failovers-when-patching-ags.html |
| Updating Statistics Causes Parameter Sniffing | https://www.brentozar.com/archive/2020/06/updating-statistics-causes-parameter-sniffing/ |
| The Ascending Key Problem in Fact Tables– Part one: Pain! | https://kejserbi.wordpress.com/2011/07/01/the-ascending-key-problem-in-fact-tables-part-one-pain/ |
| The Ascending Key Problem In Fact Tables –Part Two: Stat Job! | http://blog.kejser.org/the-ascending-column-problem-in-fact-tables-part-two-stat-job/ |
| Are Statistics Being Used for inserted and deleted tables and table variables? | https://community.idera.com/database-tools/blog/b/community_blog/posts/are-statistics-being-used |
| Tackling Imperial and US Customary Measurements in Databases | https://www.red-gate.com/simple-talk/blogs/tackling-imperial-and-us-customary-measurements-in-databases/ |
| In-Memory OLTP Best Practices – Part 1 | https://devblogs.microsoft.com/premier-developer/in-memory-oltp-best-practices-part-1/ |
| In-Memory OLTP Best Practices – Part 2 | https://devblogs.microsoft.com/premier-developer/in-memory-oltp-best-practices-part-2/ |
| Things I Wished More Developers Knew About Databases | https://medium.com/@rakyll/things-i-wished-more-developers-knew-about-databases-2d0178464f78 |
| Online migrations at scale | https://stripe.com/blog/online-migrations |
| The Dirty (Baker’s) Dozen of SQL Server Technical Debt | https://blog.coeo.com/the-dirty-bakers-dozen-of-sql-server-technical-debt |
| 15 SQL Server Performance Counters to Monitor In 2020 | https://www.sentryone.com/blog/allenwhite/sql-server-performance-counters-to-monitor |
| Pulling Group By Above a Join | https://www.sql.kiwi/2020/05/pulling-group-by-above-join.html |
| SQLskills SQL101: Running out of ints and bigints | https://www.sqlskills.com/blogs/paul/sqlskills-sql101-running-out-of-ints-and-bigints/ |
| Understanding and Using Parallelism in SQL Server | https://www.simple-talk.com/sql/learn-sql-server/understanding-and-using-parallelism-in-sql-server/ |
| Top Asked Availability Group Questions… and Maybe Some Helpful Tidbits as Answers | https://www.seangallardy.com/top-asked-availability-group-questions-and-maybe-some-helpful-tidbits-as-answers/ |
| Encrypting SQL Server Database Backups | https://sqlundercover.com/2018/04/04/encrypting-sql-server-database-backups/ |
| Using Track Causality to Understand Query Execution | https://sqlperformance.com/2019/01/extended-events/using-track-causality-to-understand-query-execution |
| Understanding SQL Server Backup Types | https://www.sqlshack.com/understanding-sql-server-backup-types/ |
| Scripting the Description of Database Tables Using Extended Properties | https://www.red-gate.com/simple-talk/sql/database-delivery/scripting-description-database-tables-using-extended-properties/ |
| The Table Variable in SQL Server | https://www.sqlshack.com/the-table-variable-in-sql-server/ |
| Multiple Plans for an "Identical" Query | https://sqlperformance.com/2014/11/t-sql-queries/multiple-plans-identical-query |
| Another argument for stored procedures versus ORM versus Add Hoc Queries | https://sqlperformance.com/2013/05/t-sql-queries/another-argument-for-stored-procedures |
| Bad habits to kick : avoiding the schema prefix | https://sqlblog.org/2019/09/12/bad-habits-to-kick-avoiding-the-schema-prefix |
| How not to call Hekaton natively-compiled stored procedures | https://sqlperformance.com/2015/06/t-sql-queries/how-not-to-call-hekaton-procedures |
| A One-Slide Summary of the Differences Between TDE and Always Encrypted | https://www.brentozar.com/archive/2020/07/a-one-slide-summary-of-the-differences-between-tde-and-always-encrypted/ |
| Remember “Nothing Stops a Hekaton Transaction?” Yeah, About That. | https://www.brentozar.com/archive/2020/07/remember-nothing-stops-a-hekaton-transaction-yeah-about-that/ |
| Finding & Downloading Required SQL Server Updates | https://flxsql.com/downloading-latest-sql-server-updates/ |
| SQLskills SQL101: Why do some wait types need to be ignored? | https://www.sqlskills.com/blogs/paul/sqlskills-sql101-why-do-some-wait-types-need-to-be-ignored/ |
| What is the SOS_WORK_DISPATCHER Wait Type? (Or how to work with Call Stacks in SQL Server) | https://orderbyselectnull.com/2018/09/27/what-is-the-sos_work_dispatcher-wait-type/ |
| SQL Server 2019 Aggregate Splitting | https://www.sql.kiwi/2020/08/sql-server-2019-aggregate-splitting.html |
| Security Best Practice: dny and revoke permissions granted to All Users by default - HIGHLY IMPORTANT! | https://ariely.info/Blog/tabid/83/EntryId/241/Security-Best-Practice-dny-and-revoke-permissions-granted-to-All-Users-by-default-HIGHLY-IMPORTANT.aspx |
| The Trillion Row Table | https://orderbyselectnull.com/2017/08/16/the-trillion-row-table/ |
| Temporal Tables and Table Partitioning: Not If You Like Switching Partitions | https://www.erikdarlingdata.com/sql-server/temporal-tables-and-table-partitioning-not-if-you-like-switching-partitions/ |
| Long Running Query on Read-Only Replica that takes moments on the Primary | https://dba.stackexchange.com/questions/237671/long-running-query-on-read-only-replica-that-takes-moments-on-the-primary/ |
| Date Tables are Great for Users, but Not So Great for Performance | https://www.brentozar.com/archive/2020/08/date-tables-are-great-for-users-but-not-so-great-for-performance/ |
| Should I install SSMS on a server running SQL Server? | https://am2.co/2020/04/should-i-install-ssms-on-a-server-running-sql-server/ |
| Finding a table name from a page ID | https://www.sqlskills.com/blogs/paul/finding-table-name-page-id/ |
| Finding Distinct Values Quickly | https://sqlperformance.com/2020/03/sql-performance/finding-distinct-values-quickly |
| Can You Fail To Spill To tempdb? | https://www.joshthecoder.com/2019/07/17/can-you-fail-to-spill-to-tempdb.html |
| Migrating SQL workloads to Microsoft Azure: Databases Trip to Azure SQL Database | https://www.sqlshack.com/migrate-sql-workloads-to-microsoft-azure-databases-trip-to-azure-sql-database/ |
| How It Works: Bob Dorr's SQL Server I/O Presentation | https://techcommunity.microsoft.com/t5/sql-server-support/how-it-works-bob-dorr-s-sql-server-i-o-presentation/ba-p/316031 |
| Who does SQL Server run xp_cmdshell command as? | https://stevestedman.com/2020/04/who-does-sql-server-run-xp_cmdshell-command-as/ |
| Transaction Modes in SQL Server | https://36chambers.wordpress.com/2020/08/10/transaction-modes-in-sql-server/ |
| Working Effectively with Legacy SQL | https://www.catallaxyservices.com/presentations/legacy-sql/ |
| A SQL Server DBA myth a day: (26/30) nested transactions are real | https://www.sqlskills.com/blogs/paul/a-sql-server-dba-myth-a-day-2630-nested-transactions-are-real/ |
| dbatools multithreading commands with PoshRSJob module | https://dbatools.io/multithread/ |
| SQL Server Debugging with WinDbg – an Introduction | https://www.sqlpassion.at/archive/2014/05/05/sql-server-debugging-with-windbg-an-introduction/ |
| Looking deeper into SQL Server using Minidumps | https://docs.microsoft.com/en-gb/archive/blogs/sqlcat/looking-deeper-into-sql-server-using-minidumps |
| Anatomy of a spool operators in SQL Server execution plans | https://sqlserverfast.com/articles/anatomy-of-a-spool/ |
| CAST v/s CONVERT – Is there a difference as far as SQL Server is concerned? Which is better? | https://nakulvachhrajani.com/2011/07/18/cast-vs-convert-is-there-a-difference-as-far-as-sql-server-is-concerned-which-is-better/ |
| #BackToBasics: CAST vs. CONVERT | https://www.sentryone.com/blog/aaronbertrand/backtobasics-cast-vs-convert |
| Productivity Hacks: Migrate in Minutes to the Most Current Version of SQL Server | https://www.rubrik.com/blog/migrate-quickly-current-version-sql-server/ |
| Database alias in Microsoft SQL Server | http://www.baud.cz/blog/database-alias-in-microsoft-sql-server |
| The Curious Case of… the 8060-byte row size limit | https://www.sqlskills.com/blogs/paul/the-curious-case-of-the-8060-byte-row-size-limit/ |
| .NET TransactionScope Considered Annoying - Default Isolation Level is Serializable | https://joshthecoder.com/2020/07/27/transactionscope-considered-annoying.html |
| Parameter Sniffing, Embedding, and the RECOMPILE Options | https://sqlperformance.com/2013/08/t-sql-queries/parameter-sniffing-embedding-and-the-recompile-options |
| Why You’re Tuning Stored Procedures Wrong (the Problem with Local Variables) | https://www.brentozar.com/archive/2014/06/tuning-stored-procedures-local-variables-problems/ |
| Yet Another Post About Local Variables | https://www.erikdarlingdata.com/sql-server/yet-another-post-about-local-variables/ |
| Cleaning up Backups from Azure Blob Storage | http://www.nikoport.com/2020/03/30/cleaning-up-backups-from-azure-blob-storage/ |
| Temporary Table Caching Explained | https://www.sql.kiwi/2012/08/temporary-object-caching-explained.html |
| SQL Server Temporary Object Caching | https://sqlperformance.com/2017/05/sql-performance/sql-server-temporary-object-caching |
| 3 Ways to Run DBCC CHECKDB Faster | https://www.brentozar.com/archive/2020/08/3-ways-to-run-dbcc-checkdb-faster/ |
| Back Up SQL Server 43%-67% Faster by Writing to Multiple Files | https://www.brentozar.com/archive/2020/08/back-up-sql-server-43-67-faster-by-writing-to-multiple-files/ |
| Bad Habits to Kick : Using SELECT * / omitting the column list | https://sqlblog.org/2009/10/10/bad-habits-to-kick-using-select-omitting-the-column-list |
| All The Problems With Select * | https://www.erikdarlingdata.com/sql-server/all-the-problems-with-select/ |
| When Select * Doesn’t Matter | https://www.erikdarlingdata.com/sql-server/when-select-doesnt-matter/ |
| HT Waits – Explained and Animated | https://forrestmcdaniel.com/2020/08/12/ht-waits-explained-and-animated/ |
| SQL Server 100% Online Deployments | https://michaeljswart.com/2018/01/100-online-deployments/ |
| The Curious Case of… setting up a server for DBCC CHECKDB | https://www.sqlskills.com/blogs/paul/the-curious-case-of-setting-up-a-server-for-dbcc-checkdb/ |
| When should a primary key be declared non-clustered? | https://dba.stackexchange.com/q/7741/107045 |
| Guid vs INT - Which is better as a primary key? | https://dba.stackexchange.com/q/264/107045 |
| Control SQL Jobs based on HADR Role – Taking it to the Next Level | https://eitanblumin.com/2020/05/26/sql-jobs-based-on-hadr-role-next-level/ |
| SQL Friday #16: Eitan Blumin on “How to HADR Your SQL Jobs” | https://sqlfriday.net/past-sql-friday-sessions/sql-friday-16-eitan-blumin-on-how-to-hadr-your-sql-jobs/ |
| Choosing the Correct Azure VM Size for Your Workload | https://www.sentryone.com/blog/choosing-the-correct-azure-vm-size-for-your-workload |
| Table Partitioning in SQL Server – The Basics | https://www.cathrinewilhelmsen.net/2015/04/12/table-partitioning-in-sql-server/ |
| Table Partitioning in SQL Server – Partition Switching | https://www.cathrinewilhelmsen.net/2015/04/19/table-partitioning-in-sql-server-partition-switching/ |
| TempDB in SQL Server | https://www.sentryone.com/tempdb-in-sql-server |
| SQL Server’s Cost Threshold for Parallelism | https://www.brentozar.com/archive/2014/11/sql-server-cost-threshold-for-parallelism/ |
| How many CPUs is my parallel query using in SQL Server? | https://www.brentozar.com/archive/2014/11/many-cpus-parallel-query-using-sql-server/ |
| Protecting your data against unauthorised reads on SQL Server | https://monin-it.be/2020/06/23/protectingyourdata/ |
| SET IMPLICIT_TRANSACTIONS ON Is One Hell of a Bad Idea | https://www.brentozar.com/archive/2018/02/set-implicit_transactions-one-hell-bad-idea/ |
| Tempdb: The Ghost Of Version Store | https://kohera.be/blog/sql-server/tempdb-the-ghost-of-version-store/ |
| When Tempdb Becomes Permanentdb (In-memory tempdb metadata and Resource governor problems) | https://kohera.be/blog/sql-server/when-tempdb-becomes-permanentdb/ |
| The Best Medium-Hard Data Analyst SQL Interview Questions | https://quip.com/2gwZArKuWk7W |
| Starting SQL: Why Not Make Everything Dynamic? | https://www.erikdarlingdata.com/starting-sql/starting-sql-why-not-make-everything-dynamic/ |
| dbatools multithreading commands | https://dbatools.io/multithread/ |
| Preventing Brute Force Attacks in SQL Server | https://blog.coeo.com/preventing-brute-force-attacks-in-sql-server |
| Asynchronous T-SQL Execution Without Service Broker | https://www.codeproject.com/Articles/29356/Asynchronous-T-SQL-Execution-Without-Service-Broke |
| Using hash values in SSIS to determine when to insert or update rows | https://www.mssqltips.com/sqlservertip/3170/using-hash-values-in-ssis-to-determine-when-to-insert-or-update-rows/ |
| Capturing Queries Can Be A Pain | https://www.scarydba.com/2020/08/03/capturing-queries-can-be-a-pain/ |
| Building full-text indexes using the Sphinx search engine | https://www.sqlshack.com/building-full-text-indexes-using-the-sphinx-search-engine/ |
| Starting SQL: Measuring A Query | https://www.erikdarlingdata.com/starting-sql/starting-sql-measuring-a-query/ |
| When to use SET vs SELECT when assigning values to variables in SQL Server | https://www.mssqltips.com/sqlservertip/1888/when-to-use-set-vs-select-when-assigning-values-to-variables-in-sql-server/ |
| What is the difference between SET and SELECT when assigning values to variables, in T-SQL? | http://vyaskn.tripod.com/differences_between_set_and_select.htm |
| CHECKDB From Every Angle: How long will CHECKDB take to run? | https://www.sqlskills.com/blogs/paul/checkdb-from-every-angle-how-long-will-checkdb-take-to-run/ |
| CHECKDB From Every Angle: Consistency Checking Options for a VLDB | https://www.sqlskills.com/blogs/paul/checkdb-from-every-angle-consistency-checking-options-for-a-vldb/ |
| Minimizing the impact of DBCC CHECKDB : DOs and DON'Ts | https://sqlperformance.com/2012/11/io-subsystem/minimize-impact-of-checkdb |
| A faster CHECKDB – Part II | https://web.archive.org/web/20150315173540/http://blogs.msdn.com/b/psssql/archive/2012/02/23/a-faster-checkdb-part-ii.aspx |
| A faster CHECKDB – Part III | https://web.archive.org/web/20150206201933/http://blogs.msdn.com/b/psssql/archive/2014/11/10/a-faster-checkdb-part-iii.aspx |
| A faster CHECKDB – Part III | https://web.archive.org/web/20150206201933/http://blogs.msdn.com/b/psssql/archive/2014/11/10/a-faster-checkdb-part-iii.aspx |
| A faster CHECKDB – Part IV (SQL CLR UDTs) | https://web.archive.org/web/20150205043737/http://blogs.msdn.com/b/psssql/archive/2015/01/26/a-faster-checkdb-part-iv-sql-clr-udts.aspx |
| Minimize performance impact of SQL Server DBCC CHECKDB | https://www.mssqltips.com/sqlservertip/2399/minimize-performance-impact-of-sql-server-dbcc-checkdb/ |
| Starting SQL: A Little More Fun With Logging Dynamic SQL | https://www.erikdarlingdata.com/starting-sql/starting-sql-a-little-more-fun-with-logging-dynamic-sql/ |
| Allocation Order Scans | https://sqlperformance.com/2015/01/t-sql-queries/allocation-order-scans |
| Parameter Sniffing in SQL Server 2019: Air_Quote_Actual Plans | https://www.brentozar.com/archive/2019/04/parameter-sniffing-in-sql-server-2019-air_quote_actual-plans/ |
| Guide For Set Up Of Telegraf For Monitoring Sql Server Xplat | https://tracyboggiano.com/archive/2018/02/setup-of-telegraf/ |
| Azure Table Storage Tips for the RDBMS Developer | https://www.sentryone.com/blog/azure-table-storage-tips-for-the-rdbms-developer |
| sql_handle and the SQL Server batch text hash | https://www.sql.kiwi/2020/10/sqlhandle-and-sql-server-batch-text-hash.html |
| Navigating DBCC CHECKDB for VLDB | https://sqlblog.org/2020/11/05/navigating-dbcc-checkdb-for-vldb |
| Hidden Formatting Troubles with STR() (SQL Spackle) | https://www.sqlservercentral.com/articles/hidden-formatting-troubles-with-str-sql-spackle |
| The What, Why, When, and How of Incremental Loads | https://www.timmitchell.net/post/2020/07/23/incremental-loads/ |
| How Do I Know If My Query Is Good Enough for Production? | https://www.brentozar.com/archive/2020/08/how-do-i-know-if-my-query-is-good-enough-for-production/ |
| How to Find Out Whose Queries are Using The Most CPU | https://www.brentozar.com/archive/2020/08/how-to-find-out-whose-queries-are-using-the-most-cpu/ |
| Limitations of SQL Server Native Backup and Restore in Amazon RDS | https://www.mssqltips.com/sqlservertip/5042/limitations-of-sql-server-native-backup-and-restore-in-amazon-rds/ |
| SQL Server Native Backup and Restore in Amazon RDS | https://www.mssqltips.com/sqlservertip/5041/sql-server-native-backup-and-restore-in-amazon-rds/ |
| What Is the SQL Server CEIP Service (telemetry)? | https://www.brentozar.com/archive/2020/10/what-is-the-sql-server-ceip-service/ |
| Maximum Simultaneous User Connections | http://www.sqlnuggets.com/blog/disable-telemetry-on-multiple-sql-servers-with-powershell/ |
| Find Database Connection Leaks in Your Application | https://sqlperformance.com/2017/07/sql-performance/find-database-connection-leaks |
| How to Troubleshoot THREADPOOL Waits and Deadlocked Schedulers | https://eitanblumin.com/2020/10/05/how-to-troubleshoot-threadpool-waits-and-deadlocked-schedulers/ |
| Prevent Lock Escalation On Indexed Views | https://kohera.be/blog/sql-server/prevent-lock-escalation-on-indexed-views/ |
| Concatenating Strings in SQL Server | https://www.madeiradata.com/post/concatenating-strings |
| Why Full Text’s CONTAINS Queries Are So Slow | https://www.brentozar.com/archive/2020/11/why-full-texts-contains-queries-are-so-slow/ |
| Migrating SSIS to Azure – an Overview | https://sqlkover.com/migrating-ssis-to-azure-an-overview/ |
| A Parameterization Puzzle With TOP: Part 1 | https://www.erikdarlingdata.com/execution-plans/a-parameterization-puzzle-with-top-part-1/ |
| A Parameterization Puzzle With TOP: Part 2 | https://www.erikdarlingdata.com/execution-plans/a-parameterization-puzzle-with-top-part-2/ |
| T-SQL: Get The Text Between Two Delimiters | https://www.erikdarlingdata.com/sql-server/t-sql-get-the-text-between-two-delimiters/ |
| Explore dynamic management views for monitoring SQL Server Always On Availability Groups | https://www.sqlshack.com/explore-dynamic-management-views-for-monitoring-sql-server-always-on-availability-groups/ |
| Deploy SQLWATCH to SQL Server using GitHub Actions | https://www.kevinrchant.com/2020/11/17/deploy-sqlwatch-to-sql-server-using-github-actions/ |
| SQL Server table hints – WITH (NOLOCK) best practices | https://www.sqlshack.com/understanding-impact-clr-strict-security-configuration-setting-sql-server-2017/ |
| Memory-Optimized TempDB Metadata in SQL Server 2019 | https://www.mssqltips.com/sqlservertip/6230/memoryoptimized-tempdb-metadata-in-sql-server-2019/ |
| SQLskills SQL101: Should you kill that long-running transaction? | https://www.sqlskills.com/blogs/paul/sqlskills-sql101-should-you-kill-that-long-running-transaction/ |
| A quick and dirty scan of a list of instances using a dynamic linked server | https://sqlstudies.com/2020/11/12/a-quick-and-dirty-scan-of-a-list-of-instances-using-a-dynamic-linked-server/ |
| sp_whoisactive: Analyzing Tempdb Contention | http://whoisactive.com/docs/21_tempdb/ |
| How to Choose Between RCSI and Snapshot Isolation Levels | https://littlekendra.com/2016/02/18/how-to-choose-rcsi-snapshot-isolation-levels/ |
| Explore the SQL query table hint READPAST | https://www.sqlshack.com/explore-the-sql-query-table-hint-readpast/ |
| How Bad Statistics Cause Bad SQL Server Query Performance | https://www.brentozar.com/archive/2020/11/how-bad-statistics-cause-bad-sql-server-query-performance/ |
| How Scalar User-Defined Functions Slow Down Queries | https://www.brentozar.com/archive/2020/11/how-scalar-user-defined-functions-slow-down-queries/ |
| Could verifying your backups be costing you money? | https://blog.coeo.com/verifying-backups-cost |
| Extended Events: System_health And A Long Running Query | https://www.scarydba.com/2020/03/09/extended-events-system_health-and-a-long-running-query/ |
| Altering an indexed view in SQL Server drops all indexes | https://littlekendra.com/2020/03/02/altering-an-indexed-view-in-sql-server-drops-all-indexes/ |
| Deprecated and discontinued features in SQL Server | https://bornsql.ca/blog/deprecated-and-discontinued-features-in-sql-server/ |
| Query Store, Plan Forcing, And Drop/create | https://www.scarydba.com/2020/03/02/query-store-plan-forcing-and-drop-create/ |
| Uncommon SQL in SQL Server | https://nocolumnname.blog/2020/11/20/uncommon-sql/ |
| Configure SQL Server Replication between AWS RDS SQL Server and On-premises SQL Server | https://www.sqlshack.com/configure-sql-server-replication-between-aws-rds-sql-server-and-on-premises-sql-server/ |
| Import data into Azure SQL database from AWS Redshift | https://www.sqlshack.com/import-data-into-azure-sql-database-from-aws-redshift/ |
| When You’re Troubleshooting Blocking, Look at Query #2, Too. | https://www.brentozar.com/archive/2020/11/when-youre-troubleshooting-blocking-look-at-query-2-too/ |
| Finding the One Query to Tune in a Multi-Query Batch | https://www.brentozar.com/archive/2020/11/finding-the-one-query-to-tune-in-a-multi-query-batch/ |
| Recursion in SQL Explained Visually | https://medium.com/swlh/recursion-in-sql-explained-graphically-679f6a0f143b |
| Viva la Famiglia! Stored procedure for created recursive family tree | https://bradsruminations.blogspot.com/2009/10/viva-la-famiglia.html |
| How to Set & Get the Next ID Without Serializable Isolation | https://www.brentozar.com/archive/2020/11/how-to-set-get-the-next-id-without-serializable-isolation/ |
| Discovering Three or Four Part Names in SQL Server Database Code | https://www.red-gate.com/simple-talk/blogs/discovering-three-or-four-part-names-in-sql-server-database-code/ |
| Troubleshooting RESOURCE_SEMAPHORE_QUERY_COMPILE Helper Queries | https://www.erikdarlingdata.com/sql-server/troubleshooting-resource_semaphore_query_compile-helper-queries/ |
| When Do I Need to Use DESC in Indexes? | https://www.brentozar.com/archive/2020/11/when-do-i-need-to-use-desc-in-indexes/ |
| Export Power BI Desktop data to SQL Server | https://ruiromanoblog.wordpress.com/2016/04/21/use-power-bi-desktop-as-an-etl-tool/ |
| Exploring errors to reveal unauthorized information | https://www.red-gate.com/simple-talk/sql/database-administration/exploring-errors-to-reveal-unauthorized-information/ |
| How to run your CTE just once, and re-use the output | https://sqlsunday.com/2020/12/01/run-your-cte-just-once-and-reuse-output/ |
| Documenting SSIS Packages using Sequence Diagrams | https://www.sqlshack.com/documenting-ssis-packages-using-sequence-diagrams-2/ |
| Performance testing with DBCC DROPCLEANBUFFERS | https://www.dbdelta.com/performance-testing-with-dbcc-dropcleanbuffers/ |
| Optimizing memory settings in Analysis Services | https://www.sqlbi.com/articles/optimizing-memory-settings-in-analysis-services/ |
| VMware and SQL Server Best Practices | https://straightpathsql.com/archives/2020/12/vmware-and-sql-server-best-practices/ |
| Autoparameterized Trivial Queries May Not Get Partition Elimination | https://www.brentozar.com/archive/2020/12/autoparameterized-trivial-queries-may-not-get-partition-elimination/ |
| Trigram Wildcard String Search in SQL Server | https://sqlperformance.com/2017/09/sql-performance/sql-server-trigram-wildcard-search |
| Which Locks Count Toward Lock Escalation? | https://littlekendra.com/2017/04/03/which-locks-count-toward-lock-escalation/ |
| The challenge is on! Community call for creating the fastest number series generator | https://sqlperformance.com/2020/12/t-sql-queries/number-series-challenge |
| SQL Injection Prevention Cheat Sheet | https://cheatsheetseries.owasp.org/cheatsheets/SQL_Injection_Prevention_Cheat_Sheet.html |
| A cheat sheet for isolation levels in SQL Server | https://blog.coeo.com/a-cheat-sheet-for-isolation-levels-in-sql-server |
| Don't Fear the Trace | https://www.sentryone.com/blog/dont-fear-the-trace |
| Which sp_configure Options Clear the Plan Cache? | https://www.brentozar.com/archive/2017/09/sp_configure-options-clear-plan-cache/ |
| The danger of HADR_SYNC_COMMIT wait and synchronous replication in AlwaysOn Availability Groups | https://aboutsqlserver.com/2019/06/09/hadr-sync-commit/ |
| Faster SQL Pagination with Keysets, Continued | https://blog.jooq.org/2013/11/18/faster-sql-pagination-with-keysets-continued/ |
| We need tool support for keyset pagination | https://use-the-index-luke.com/no-offset |
| Insight into the SQL Server buffer cache | https://www.sqlshack.com/insight-into-the-sql-server-buffer-cache/ |
| Index-Only Scan: Avoiding Table Access | https://use-the-index-luke.com/sql/clustering/index-only-scan-covering-index |
| The two top performance problems caused by ORM tool | https://use-the-index-luke.com/blog/2013-04/the-two-top-performance-problems-caused-by-ORM-tools |
| Nested loops join and n1 problem in ORM | https://use-the-index-luke.com/sql/join/nested-loops-join-n1-problem |
| Hash join partial objects | https://use-the-index-luke.com/sql/join/hash-join-partial-objects |
| Myth: Select * (asterisk) is bad | https://use-the-index-luke.com/blog/2013-08/its-not-about-the-star-stupid |
| Indexing LIKE Filters | https://use-the-index-luke.com/sql/where-clause/searching-for-ranges/like-performance-tuning |
| Date and time conditions causing SQL performance problems | https://use-the-index-luke.com/sql/where-clause/obfuscation/dates |
| Dates and Times in SQL Server: more functions you should never use | https://bornsql.ca/blog/dates-and-times-in-sql-server-more-functions-you-should-never-use/ |
| Dates and Times in SQL Server: T-SQL functions to get the current date and time | https://bornsql.ca/blog/dates-times-sql-server-t-sql-functions-get-current-date-time/ |
| Super Scaling Queues Using the LMax Disruptor Pattern And The In-Memory OLTP Engine | https://chrisadkin.io/2016/01/18/super-scaling-queues-using-the-lmax-disruptor-pattern-and-the-in-memory-oltp-engine/ |
| Early History of SQL | https://ieeexplore.ieee.org/stamp/stamp.jsp?tp=&arnumber=6359709 |
| Is it a bad practice to always create a transaction? | https://dba.stackexchange.com/a/43256 |
| Incomplete checkpoints and recovery | https://www.sqlskills.com/blogs/paul/incomplete-checkpoints-and-recovery/ |
| 4 SQL Injection Techniques For Stealing Data | https://bertwagner.com/posts/4-sql-injection-techniques-for-stealing-data/ |
| Towards Safer Dynamic SQL | https://www.erikdarlingdata.com/sql-server/towards-safer-dynamic-sql/ |
| Setting the timezone to anything other than UTC | http://yellerapp.com/posts/2015-01-12-the-worst-server-setup-you-can-make.html |
| Advanced Service Broker Sample: Multi-Threading | https://eitanblumin.com/2018/10/31/advanced-service-broker-sample-multi-threading/ |
| Copy a SQL Server database with just the objects and no data | https://www.mssqltips.com/sqlservertip/4664/copy-a-sql-server-database-with-just-the-objects-and-no-data/ |
| QOMPLX Knowledge: Kerberoasting Attacks Explained | https://www.qomplx.com/qomplx-knowledge-kerberoasting-attacks-explained/ |
| How to create a SQL dependency diagram in SQL Server | https://www.sqlshack.com/how-to-create-a-sql-dependency-diagram-in-sql-server/ |
| Query Memory Grants and Resource Semaphores in SQL Server | https://www.sqlpassion.at/archive/2018/10/16/query-memory-grants-and-resource-semaphores-in-sql-server/ |
| Using a Table of Numbers (or a Table of Dates, Months etc) | https://www.sommarskog.se/Short%20Stories/table-of-numbers.html |
| SQL Server MDF and NDF files | https://www.sqlrecoverysoftware.net/sql-server-mdf-file/recover-mdf-ndf.html |
| The SQL Standard ANSI ISO is Public! | https://modern-sql.com/standard |
| SQL Server Full Backup | https://sqlbak.com/academy/full-backup |
| Import data from PDF files using R Scripts SQL Server | https://www.sqlshack.com/import-data-from-pdf-files-using-r-scripts-sql-server/ |
| Adding Additional Data Files To The TempDB Database In SQL Server | https://jackworthen.com/2017/08/24/adding-additional-data-files-to-the-tempdb-database-in-sql-server/ |
| SQL Server Isolation Levels: A Series | https://sqlperformance.com/2014/07/t-sql-queries/isolation-levels |
| SQL Server Isolation Levels: The ACID Properties of Statements & Transactions | https://sqlperformance.com/2014/02/t-sql-queries/confusion-caused-by-trusting-acid |
| SQL Server Isolation Levels: The Serializable Isolation Level | https://sqlperformance.com/2014/04/t-sql-queries/the-serializable-isolation-level |
| SQL Server Isolation Levels: The Repeatable Read Isolation Level | https://sqlperformance.com/2014/04/t-sql-queries/the-repeatable-read-isolation-level |
| SQL Server Isolation Levels: The Read Committed Isolation Level | https://sqlperformance.com/2014/04/t-sql-queries/the-read-committed-isolation-level |
| SQL Server Isolation Levels: Read Committed Snapshot Isolation | https://sqlperformance.com/2014/05/t-sql-queries/read-committed-snapshot-isolation |
| SQL Server Isolation Levels: Data Modifications under Read Committed Snapshot Isolation | https://sqlperformance.com/2014/05/t-sql-queries/data-modifications-under-rcsi |
| SQL Server Isolation Levels: The SNAPSHOT Isolation Level | https://sqlperformance.com/2014/06/sql-performance/the-snapshot-isolation-level |
| SQL Server Isolation Levels: The Read Uncommitted Isolation Level | https://sqlperformance.com/2015/04/t-sql-queries/the-read-uncommitted-isolation-level |
| The OUTPUT Clause for the MERGE Statements | https://www.sqlservercentral.com/articles/the-output-clause-for-the-merge-statements |
| SQLskills SQL101: Query plans based on what’s in memory | https://www.sqlskills.com/blogs/paul/sqlskills-sql101-query-plans-based-on-whats-in-memory/ |
| Performance: String Concatenation in SQL Server | https://stevestedman.com/2021/01/performance-string-concatenation-in-sql-server/ |
| Performance: Faster way to concatenate longer string | https://stevestedman.com/2021/01/performance-faster-way-to-concatenate-longer-string/ |
| Identifying Cost-Saving Opportunities in Azure DevOps | https://www.sentryone.com/blog/cost-savings-in-azuredevops |
| One wide index or multiple narrow indexes? | https://sqlinthewild.co.za/index.php/2010/09/14/one-wide-index-or-multiple-narrow-indexes/ |
| The Hidden Danger of Readable Secondaries in SQL Server AlwaysOn Availability Groups | https://www.apress.com/de/blog/all-blog-posts/readable-secondaries-in-sql-server/16064064 |
| When a Columnstore Index Makes Your Query Fail - 1/0 error | https://www.brentozar.com/archive/2020/06/when-a-columnstore-index-makes-your-query-fail/ |
| Poor Man’s Resource Governor: Database-Scoped Configurations | https://www.brentozar.com/archive/2020/10/poor-mans-resource-governor-database-scoped-configurations/ |
| SQL Server Suddenly Frozen? You Might Be Snapshotting Too Many Databases. | https://www.brentozar.com/archive/2020/09/sql-server-suddenly-frozen-you-might-be-snapshotting-too-many-databases/ |
| How to Batch Updates A Few Thousand Rows at a Time | https://www.brentozar.com/archive/2020/12/how-to-batch-updates-a-few-thousand-rows-at-a-time/ |
| Using Amazon Fsx For Sql Server Failover Cluster Instances – What You Need To Know! | https://clusteringformeremortals.com/2021/01/08/using-amazon-fsx-for-sql-server-failover-cluster-instances-what-you-need-to-know/ |
| Sometimes you CAN upsize a column in-place | https://sqlperformance.com/2020/08/sql-indexes/upsize-column-in-place |
| Which Microsoft Certification Should You Get? | https://www.brentozar.com/archive/2021/01/which-microsoft-certification-should-you-get/ |
| SQL Server RAISERROR Cheatsheet | https://chadbaldwin.net/2021/01/15/raiserror-cheatsheet.html |
| Want to Avoid Deployment Downtime? Replication Probably Isn’t the Answer. | https://www.brentozar.com/archive/2021/01/want-to-avoid-deployment-downtime-replication-probably-isnt-the-answer/ |
| “But Surely NOLOCK Is Okay If No One’s Changing Data, Right?” | https://www.brentozar.com/archive/2021/01/but-surely-nolock-is-okay-if-no-ones-changing-data-right/ |
| Why Multiple Plans for One Query Are Bad | https://www.brentozar.com/archive/2018/03/why-multiple-plans-for-one-query-are-bad/ |
| Partitioned Tables Cause Longer Plan Compilation Times. | https://www.brentozar.com/archive/2021/02/partitioned-tables-cause-longer-plan-compilation-times/ |
| Query Hints You Can Use to Avoid Blocking | https://www.brentozar.com/archive/2021/01/query-hints-you-can-use-to-avoid-blocking/ |
| Changing Statistics Cause Longer Compilation Times | https://www.brentozar.com/archive/2021/02/changing-statistics-cause-longer-compilation-times/ |
| Understanding Execution Plan Operator Timings | https://sqlperformance.com/2021/03/sql-performance/execution-plan-timings |
| What Does a Database Administrator Actually Do? | https://www.brentozar.com/archive/2021/03/what-does-a-database-administrator-actually-do/ |
| How Useful Is Column Store In Standard Edition? | https://www.erikdarlingdata.com/sql-server/how-useful-is-column-store-in-standard-edition/ |
| Task Manager’s CPU numbers are all but meaningless | https://aaron-margosis.medium.com/task-managers-cpu-numbers-are-all-but-meaningless-2d165b421e43 |
| Global temporary tables are almost never the answer in SQL Server | https://blog.greglow.com/2021/02/04/sql-global-temporary-tables-are-almost-never-the-answer-in-sql-server/ |
| Never, Ever, Ever Start T-SQL Comments with Two Dashes | https://www.brentozar.com/archive/2021/04/never-ever-ever-start-t-sql-comments-with-two-dashes/ |
| Why All My Servers Have an 8GB Empty File | https://brianschrader.com/archive/why-all-my-servers-have-an-8gb-empty-file/ |
| Incorrect Results with Parallel Eager Spools and Batch Mode | https://www.sql.kiwi/2021/03/spools-batch-mode-hp.html |
| Deprecated features to take out of your toolbox – Part 1 | https://sqlperformance.com/2021/02/sql-performance/deprecated-features-1 |
| Deprecated features to take out of your toolbox – Part 2 | https://sqlperformance.com/2021/03/sql-performance/deprecated-features-2 |
| Deprecated features to take out of your toolbox – Part 3 | https://sqlperformance.com/2021/07/sql-performance/deprecated-features-3 |
| Troubleshooting Security Cache Issues: USERSTORE_TOKENPERM And TokenAndPermUserStore | https://www.erikdarlingdata.com/sql-server/troubleshooting-security-cache-issues-userstore_tokenperm-and-tokenandpermuserstore/ |
| Execution Plans Don’t Have the Yellow Bang They Really Need. | https://www.brentozar.com/archive/2021/04/execution-plans-dont-have-the-yellow-bang-they-really-need/ |
| The Curious Case of… the un-killable thread | https://www.sqlskills.com/blogs/paul/the-curious-case-of-the-un-killable-thread/ |
| olved steries #1 – SQL FCI Failovers | https://www.seangallardy.com/olved-steries-1-sql-fci-failovers/ |
| Possible configuration error: 1000000 IO requests allocated | https://www.seangallardy.com/possible-configuration-error-1000000-io-requests-allocated/ |
| Availability Group Long Failover Times | https://www.seangallardy.com/availability-group-long-failover-times/ |
| Testing Backups and Offloading CheckDB | https://www.tarynpivots.com/post/2021/testing-backups-offload-dbcc-checkdb/ |
| Fighting with Deadlocks | https://www.tarynpivots.com/post/2021/fighting-with-deadlocks/ |
| Syncing Logins Between Availability Group Replicas | https://www.tarynpivots.com/post/2020/syncing-logins-between-availablity-group-replicas/ |
| SQL JOINs and UNIONs | https://levelup.gitconnected.com/sql-joins-2cc89babb6f9 |
| Some opinionated thoughts on SQL databases | https://blog.nelhage.com/post/some-opinionated-sql-takes/ |
| How MERGE on two different rows can still deadlock you | https://sqlsunday.com/2021/05/04/how-merge-can-deadlock-you/ |
| Auto-failover Groups for Azure – Grace Period With Data Loss Hours | https://sqlworldwide.com/auto-failover-groups-graceperiodwithdatalosshours/ |
| How Parallel Plans Start Up – Part 1 | https://sqlperformance.com/2021/03/sql-performance/parallel-plans-start-1 |
| How Parallel Plans Start Up – Part 2 | https://sqlperformance.com/2021/04/sql-performance/parallel-plans-start-2 |
| How Parallel Plans Start Up – Part 3 | https://sqlperformance.com/2021/04/sql-performance/parallel-plans-start-3 |
| How Parallel Plans Start Up – Part 4 | https://sqlperformance.com/2021/05/sql-performance/parallel-plans-start-4 |
| How Parallel Plans Start Up – Part 5 | https://sqlperformance.com/2021/05/sql-performance/parallel-plans-start-5 |
| Iterators, Query Plans, and Why They Run Backwards | https://www.sql.kiwi/2010/08/iterators-query-plans-and-why-they-run-backwards.html |
| What account is xp_cmdshell using? | https://sqlstudies.com/2021/05/25/what-account-is-xp_cmdshell-using/ |
| Hammer Part 1 -What is HammerDB and why would I use it? | https://t101wilson.wordpress.com/2021/04/17/hammer-part-1-what-is-hammerdb-and-why-would-i-use-it/ |
| Hammer Part 2 -Let the Nail see the Hammer! | https://t101wilson.wordpress.com/2021/05/26/hammer-part-2-let-the-nail-see-the-hammer/ |
| Fun with DATETIME Arithmetics | https://eitanblumin.com/2021/04/27/fun-with-datetime-arithmetics/ |
| Even more fun with DATETIME arithmetics! | https://eitanblumin.com/2021/06/17/even-more-fun-with-datetime-arithmetics/ |
| I learned to love WHILE (true) and you should too | https://eitanblumin.com/2021/02/16/i-learned-to-love-while-true-and-you-should-too/ |
| Troubleshooting Long-Running SHRINK Operations | https://eitanblumin.com/2020/04/07/troubleshooting-long-running-shrink-operations/ |
| The Ultimate Compression Savings Estimation Script for an Entire Database | https://eitanblumin.com/2020/02/18/ultimate-compression-savings-estimation-script-entire-database/ |
| The Complete Guide to Temporary Tables and Table Variables - Part 1 | https://www.madeiradata.com/post/the-complete-guide-to-temporary-tables-and-table-variables-part-1 |
| Store Files in a File System, Not a Relational Database. | https://www.brentozar.com/archive/2021/07/store-files-in-a-file-system-not-a-relational-database/ |
| Most (XML) and Least (SQL_VARIANT) Favorite Data Type | https://eitanblumin.com/2021/03/09/t-sql-tuesday-136-most-and-least-favorite-data-type/ |
| What should the CPU usage be of a fully-loaded CPU that has been throttled? | https://devblogs.microsoft.com/oldnewthing/20210629-00/?p=105378 |
| Fixing Queues with Watermarks | https://forrestmcdaniel.com/2021/06/30/fixing-queues-with-watermarks/ |
| How to Patch SQL Server | https://www.brentozar.com/archive/2021/06/how-to-patch-sql-server/ |
| “I’m getting index seeks. Why are my row estimates still wrong?” | https://www.brentozar.com/archive/2021/06/how-can-index-seeks-get-inaccurate-row-estimates/ |
| OLAP != OLAP Cube | https://www.holistics.io/blog/olap-is-not-olap-cube/ |
| Connecting a SQL Server client on Linux using Active Directory authentication | https://sqlsunday.com/2021/04/15/connecting-linux-using-ad-authentication/ |
| Is a sort faster when the data is already sorted? | https://sqlsunday.com/2021/02/15/is-a-sort-faster-when-data-already-sorted/ |
| Connect using Windows authentication across domains | https://sqlsunday.com/2021/02/05/connect-using-windows-authentication-across-domains/ |
| The uncorrelated correlated subquery | https://sqlsunday.com/2020/12/21/the-uncorrelated-correlated-subquery/ |
| How to fix rounding errors | https://sqlsunday.com/2020/12/15/how-to-fix-rounding-errors/ |
| The curious case of the Top N Sort | https://sqlsunday.com/2020/12/08/the-curious-case-of-the-top-n-sort/ |
| Consolidating grouped transactions into evenly sized batches | https://sqlsunday.com/2020/07/13/grouping-into-evenly-sized-batches/ |
| A “shock absorber” pattern for high-performance data ingestion | https://sqlsunday.com/2021/07/15/a-shock-absorber-pattern-for-high-performance-data-ingest/ |
| Why Are Linked Server Queries So Bad? | https://www.brentozar.com/archive/2021/07/why-are-linked-server-queries-so-bad/ |
| Fundamentals of table expressions, Part 1 | https://sqlperformance.com/2020/04/t-sql-queries/table-expressions-part-1 |
| Fundamentals of table expressions, Part 2 – Derived tables, logical considerations | https://sqlperformance.com/2020/04/t-sql-queries/table-expressions-part-2 |
| Fundamentals of table expressions, Part 3 – Derived tables, optimization considerations | https://sqlperformance.com/2020/06/t-sql-queries/table-expressions-part-3 |
| Fundamentals of table expressions, Part 4 – Derived tables, optimization considerations, continued | https://sqlperformance.com/2020/07/t-sql-queries/table-expressions-part-4 |
| Fundamentals of table expressions, Part 5 – CTEs, logical considerations | https://sqlperformance.com/2020/08/t-sql-queries/table-expressions-part-5 |
| Fundamentals of table expressions, Part 6 – Recursive CTEs | https://sqlperformance.com/2020/09/t-sql-queries/fundamentals-of-table-expressions-part-6-recursive-ctes |
| Fundamentals of table expressions, Part 7 – CTEs, optimization considerations | https://sqlperformance.com/2020/10/t-sql-queries/table-expressions-part-7 |
| Fundamentals of table expressions, Part 8 – CTEs, optimization considerations continued | https://sqlperformance.com/2020/11/t-sql-queries/table-expressions-part-8 |
| Fundamentals of table expressions, Part 9 – Views, compared with derived tables and CTEs | https://sqlperformance.com/2021/06/t-sql-queries/table-expressions-part-9 |
| Fundamentals of table expressions, Part 10 – Views, SELECT *, and DDL changes | https://sqlperformance.com/2021/07/t-sql-queries/table-expressions-part-10 |
| Understanding xp_fileexist and its usage | https://www.sqlshack.com/understanding-xp_fileexist-and-its-usage/ |
| SQL Server Restore Database Options and Examples | https://www.mssqltips.com/sqlservertip/6893/restore-database-sql-server-options-examples/ |
| SQL Server Database RESTORE WITH MOVE or not WITH MOVE | https://www.mssqltips.com/sqlservertip/3113/sql-server-database-restore-with-move-or-not-with-move/ |
| Getting exclusive access to restore SQL Server database | https://www.mssqltips.com/sqlservertip/1407/getting-exclusive-access-to-restore-sql-server-database/ |
| How to migrate a SQL Server database to a lower version | https://www.mssqltips.com/sqlservertip/2810/how-to-migrate-a-sql-server-database-to-a-lower-version/ |
| Make Network Path Visible For SQL Server Backup and Restore in SSMS | https://www.mssqltips.com/sqlservertip/3499/make-network-path-visible-for-sql-server-backup-and-restore-in-ssms/ |
| T-SQL bugs, pitfalls, and best practices – pivoting and unpivoting | https://sqlperformance.com/2019/09/t-sql-queries/t-sql-pitfalls-pivoting-unpivoting |
| How to Prep a SQL Server Availability Group for VM-Level DR Replication | https://www.davidklee.net/2021/02/08/how-to-prep-a-sql-server-availability-group-for-vm-level-dr-replication/ |
| Special Agent Jenkins | https://nvarscar.wordpress.com/2018/05/03/special-agent-jenkins/ |
| What To Avoid If You Want To Use MERGE | https://michaeljswart.com/2021/08/what-to-avoid-if-you-want-to-use-merge/ |
| Solving Gaps and Islands with Enhanced Window | https://www.itprotoday.com/sql-server/solving-gaps-and-islands-enhanced-window-functions |
| How to choose between SQL and NoSQL databases | https://www.red-gate.com/simple-talk/databases/nosql/how-to-choose-between-sql-and-nosql-databases/ |
| SQL Server plan cache mining – Plan attributes | https://www.red-gate.com/simple-talk/homepage/sql-server-plan-cache-mining-plan-attributes/ |
| How to Prep a SQL Server Availability Group for VM-Level DR Replication | https://www.davidklee.net/2021/02/08/how-to-prep-a-sql-server-availability-group-for-vm-level-dr-replication/ |
| How to create an autonomous transaction in SQL Server 2008 | https://techcommunity.microsoft.com/t5/sql-server/how-to-create-an-autonomous-transaction-in-sql-server-2008/ba-p/383471 |
| Cloud Comparison: AWS vs. Azure vs. GCP | https://seniordba.wordpress.com/2021/05/24/cloud-comparison-aws-vs-azure-vs-gcp/ |
| New VLF status value | https://www.sqlskills.com/blogs/paul/new-vlf-status-value/ |
| The Simplest Alternative to sp_MSforeachdb | https://eitanblumin.com/2021/08/05/simplest-alternative-to-sp_msforeachdb/ |
| Your database connection deserves a name | https://andygrunwald.com/blog/your-database-connection-deserves-a-name/ |
| Renaming a Database Table In-Flight | https://engineering.outschool.com/posts/renaming-database-table/ |
| Upgrading/Migrating Large Replicated Databases Without Reinitializing | https://www.sqlskills.com/blogs/jonathan/upgrading-migrating-large-replicated-databases-without-reinitializing/ |
| TempDB configuration for people in a hurry | https://desertdba.com/tempdb-configuration-for-people-in-a-hurry/ |
| Help! My tempdb database won’t shrink! | https://desertdba.com/help-my-tempdb-database-wont-shrink/ |
| SQL Server Checkpoint Monitoring with Extended Events | https://www.mssqltips.com/sqlservertip/6319/sql-server-checkpoint-monitoring-with-extended-events/ |
| "0 to 60" : Switching to indirect checkpoints | https://sqlperformance.com/2020/05/system-configuration/0-to-60-switching-to-indirect-checkpoints |
| A case against using Basic and Standard (S0 & S1) tiers in Azure SQL Databases | https://www.nikoport.com/2021/02/09/a-case-against-using-basic-and-standard-s0-s1-tiers-in-azure-sql-databases/ |
| Experiment: Does sp_recompile on a table update associated views. | https://sqlstudies.com/2021/08/17/experiment-does-sp_recompile-on-a-table-update-associated-views/ |
| On index key size, index depth, and performance | https://www.sqlskills.com/blogs/paul/on-index-key-size-index-depth-and-performance/ |
| SQL Server Hierarchyid Data Type Overview and Examples | https://www.mssqltips.com/sqlservertip/6048/sql-server-hierarchyid-data-type-overview-and-examples/ |
| Make It Easier for the DBA: Give SQL Connections the Application’s Name! | https://bengribaudo.com/blog/2017/06/23/3657/give-sql-connections-the-applications-name |
| You Probably Shouldn’t Index Your Temp Tables. | https://www.brentozar.com/archive/2021/08/you-probably-shouldnt-index-your-temp-tables/ |
| SQL Server Error Handling Gotchas | https://nielsberglund.com/2016/12/31/sql-server-error-handling-gotchas/ |
| B-Trees: More Than I Thought I'd Want to Know | https://benjamincongdon.me/blog/2021/08/17/B-Trees-More-Than-I-Thought-Id-Want-to-Know/ |
| Wait Stats During Hash Spills | https://www.erikdarlingdata.com/sql-server/wait-stats-during-hash-spills/ |
| Shrinking The tempdb System Database Without Restarting SQL Server | https://jackworthen.com/2016/06/02/shrinking-the-tempdb-system-database-without-restarting-sql-server/ |
| Graphing SQL Server wait stats on Prometheus and Grafana | https://blog.developpez.com/mikedavem/p13209/devops/graphing-sql-server-wait-stats-on-prometheus-and-grafana |
| Transition from SSMS to DataGrip: 10 tips | https://blog.jetbrains.com/datagrip/2021/08/19/transition-from-ssms-to-datagrip-10-tips/ |
| Query Store Hints | https://www.sqlskills.com/blogs/erin/query-store-hints/ |
| Announcing SSIS Framework Manager, v1 | https://andyleonard.blog/2021/06/announcing-ssis-framework-manager-v1/ |
| Improving The Performance of RBAR Modifications | https://www.erikdarlingdata.com/sql-server/improving-the-performance-of-rbar-modifications/ |
| Minimal Logging with INSERT…SELECT into Empty Clustered Tables | https://sqlperformance.com/2019/05/sql-performance/minimal-logging-empty-clustered |
| What Is a Cost-Based Optimizer? | https://www.brentozar.com/archive/2021/09/what-is-a-cost-based-optimizer/ |
| Unusual Parameter Sniffing: Big Problems with Small Data | https://www.brentozar.com/archive/2021/02/unusual-parameter-sniffing-big-problems-with-small-data/ |
| Rowcount estimates when there are no Statistics | https://matthewmcgiffen.com/2021/01/26/rowcount-estimates-when-there-are-no-statistics/ |
| Processing Data Queues in SQL Server with READPAST and UPDLOCK | https://www.mssqltips.com/sqlservertip/1257/processing-data-queues-in-sql-server-with-readpast-and-updlock/ |
| Can You Get Parameter Sniffing on Updates and Deletes? | https://www.brentozar.com/archive/2021/01/can-you-get-parameter-sniffing-on-updates-and-deletes/ |
| An Empirical Look at Key Lookups | https://forrestmcdaniel.com/2020/12/30/an-empirical-look-at-key-lookups/ |
| Please stop using this UPSERT anti-pattern | https://sqlperformance.com/2020/09/locking/upsert-anti-pattern |
| The Curious Case of… the failing differential restore | https://www.sqlskills.com/blogs/paul/the-curious-case-of-the-failing-differential-restore/ |
| Starting SQL: Compensating For Lock Waits | https://www.erikdarlingdata.com/starting-sql/starting-sql-compensating-for-lock-waits/ |
| Finding & Downloading Required SQL Server Updates | https://flxsql.com/downloading-latest-sql-server-updates/ |
| Quick SQL Server CPU Comparison Tests | https://www.erikdarlingdata.com/sql-server/quick-sql-server-cpu-comparison-tests/ |
| Using fn_dblog, fn_dump_dblog, and restoring with STOPBEFOREMARK to an LSN | https://www.sqlskills.com/blogs/paul/using-fn_dblog-fn_dump_dblog-and-restoring-with-stopbeforemark-to-an-lsn/ |
|
| https://github.com |
| Terms | https://docs.github.com/site-policy/github-terms/github-terms-of-service |
| Privacy | https://docs.github.com/site-policy/privacy-policies/github-privacy-statement |
| Security | https://github.com/security |
| Status | https://www.githubstatus.com/ |
| Community | https://github.community/ |
| Docs | https://docs.github.com/ |
| Contact | https://support.github.com?tags=dotcom-footer |