If you have a question about the content of my blog post, leave a comment on that post.
Some posts may also require large amounts of data in order to reproduce specific behaviors – that’s why you’ll often see me using the larger copy, and why we use the larger copy in my training classes. Of course, your rowcounts, memory grants, query plans, etc can change depending on database size (and on your own hardware config, environment settings, etc.) The notebooks use the database name “StackOverflow”, but you can change that to point to different databases depending on what you’re using. They’re all different sizes, but they have the same structure (tables, columns, etc) – just different numbers of rows. Our blog posts will refer to StackOverflow, StackOverflow2010, or StackOverflow2013. Q: Does it matter which Stack Overflow database I use? I leave my test data in the notebook so you can just read it if you want, but if you’re going to run the queries yourself, you’ll want to click the “Clear Results” button in Azure Data Studio so that you don’t get confused about which queries you’ve run, and which cells still have my own data. Open the notebook in ADS, then clear the results if you want to follow along.
This is Microsoft’s cross-platform database tool that works with Windows, Mac, and Linux to run queries against SQL Server or Postgres.
#Azure data studio export full
This is a smaller version of the full database export, but it’s still large enough that you can follow along with most blog posts.
When you see a “Get Notebook” link in one of my posts, it means you can download a SQL Notebook, open it in Azure Data Studio, and follow along with the queries for free.
0 kommentar(er)
