r/SQLServer • • Mar 17 '23

SSMS dark theme SQL Shades updated with better results grid

87 Upvotes

Hey everyone, just wanted to share the latest update for SQL Shades, the SQL Server Management Studio dark mode add-in I've been working on. Thanks for all the encouraging DMs and emails!

Biggest change here is a rework of the grid rendering system to improve contrast and add those neat dotted vertical lines like in ADS. Also themed the Object Explorer Details panel and tweaked a few things here and there.

Give it a whirl and let me know what you think: https://www.sqlshades.com/

Cheers, Michael 🌙


r/SQLServer • • Nov 18 '25

Community Share SQL Server 2025 is now out, and Standard goes up to 256GB RAM, 32 cores

86 Upvotes

The evaluation & developer releases are ready for download from here, although some links on MS still point to the preview build: https://www.microsoft.com/en-us/sql-server/sql-server-downloads

The release build is 17.0.1000.7. Big news: Standard Edition now supports up to 32 CPU cores and 256GB memory! https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2025?view=sql-server-ver17&preserve-view=true


r/SQLServer • • Jun 19 '23

Question Am I taking crazy pills? Why does ORDER BY fail in the bottom example?

Post image
86 Upvotes

r/SQLServer • • Nov 16 '22

Community Share [Bitesized] All graphics on DB Indexes

Thumbnail
gallery
85 Upvotes

r/SQLServer • • Jun 12 '17

Ola Hallengren's Maintenance Scripts are Now on Github

Thumbnail
brentozar.com
85 Upvotes

r/SQLServer • • Sep 24 '26

Community Share I built an open-source SSMS extension that turns a query into a refreshable Excel workbook

Post image
81 Upvotes

Send the workbook to an end user, and they can hit Data > Refresh All to rerun the query using their own database credentials.

Currently supports SSMS 22 and Desktop Excel.

It's free/open source. Install instructions and source are here:

https://github.com/flank-project/ssms-extension


r/SQLServer • • Dec 15 '16

dbatools - an open source project, now with over 100 PowerShell commands for DBAs. Here's our most recent release!

Thumbnail
dbatools.io
80 Upvotes

r/SQLServer • • Feb 29 '24

SQL Server Life Hack (status bar color)

79 Upvotes

I don't know who needs to see this, but this is something I've done for years that's saved me from mistakes numerous times when connected to multiple database servers.

Pretty common in my day-to-day to be connected to multiple servers at once. We've all been there, when we've got to hop onto a production server, or even a middle environment where we've got to work with some different data and we've got a bunch of tabs open. The color is sticky, so when you reconnect to the server, the status bar color will retain its setting.


r/SQLServer • • Dec 19 '24

SQL Server 2025 announced

Thumbnail
microsoft.com
77 Upvotes

SQL 2025 has been announced today.

List of new features like keeping statistics on secondary when restarting is nice.

Does anyone could provide link where all new features are provided with details on how to use them?


r/SQLServer • • Dec 09 '25

Discussion SQL Server performance tips beyond indexing? What actually makes a difference?

76 Upvotes

Hey everyone, I've been working with SQL Server for a while now (Nearly Two Years) and I keep hearing "just add an index" whenever queries run slow. (Especially when the table has few millions records or few Billions Records) But there's gotta be more to it than that, right?

What are some GOOD practices that actually speed things up? I'm talking about stuff that makes a real difference in production environments.

And what are the BAD practices I should avoid? Like, what are the things people do that absolutely kill performance without realizing it?

Also, if you've got experience with query tuning, what's something you wish you knew earlier? Any gotchas or common mistakes to watch out for?

I'm trying to level up my database game, so any advice from folks who've been in the trenches would be really helpful.

Teach me every thing possible as you teach and explain to a complete stranger.

Real-world examples are appreciated more than textbook answers!

Thanks in advance!


r/SQLServer • • May 19 '25

SQLServer2025 Announcing the Public Preview of SQL Server 2025

76 Upvotes

I'm excited to announce that the Public Preview of SQL Server 2025 is now available with our fresh new icon! Get started right away by downloading it from https://aka.ms/getsqlserver2025

SQL Server 2025 is the AI-ready enterprise database. AI capabilities are built-in and available in a secure and scalable fashion. The release is built for developers with some of biggest innovations we have provided in a decade including the new Standard Developer Edition. You can connect to Azure easily with Arc or replicate your data with Fabric mirroring. And as with every major release, we have innovations in security, performance, and availably.

We are also announcing today the General Availability of SSMS 21 and a new Copilot experience in Public Preview. Download it today at https://aka.ms/ssms21

Use these resources to learn more:

Per its name SQL Server 2025 will become generally available later in CY25. We look forward to hearing more as you try out all the new features.

Bob Ward, Microsoft


r/SQLServer • • Dec 09 '19

Certification My experience on exam 70-767 (implementing a Data Warehouse using SQL)

75 Upvotes

Hey, everybody. The other day I passed the exam 70-767 https://www.microsoft.com/en-us/learning/exam-70-767.aspx in this post I want to tell about my experience and how it was for me.

  1. environment. Since I have a laptop on Linux and didn't want to bother with virtualization, I rented a server.Core i5-2300, 16 GB RAM, 2 TB HDD. It was enough to install everything you needed and even play with really big databases like https://www.brentozar.com/archive/2018/06/new-stack-overflow-public-database-available-2018-06/

  2. Time. Preparation took 2 months from October to December. As usual, I prepared every day for about 3 hours after the main work (which is partly related to the sql server) and usually a whole day off or even two days off. By the end of November, I had completed the project at my work and began to devote much more time to the preparation of the project. Sometimes almost 8 hours a day.

  3. The purpose of the exam is to get a new job that is 100% related to the sql server and since I have received MCSA: SQL 2016 Database Development before, I get MCSE: Data Management and Analytics as a nice addition. What's more important - I chose DW because it's a new topic for me and I've only worked with OLTP before.

  4. Resources - I have approached the preparation capital.

    а. The book Exam Ref 70-767 Implementing a SQL Data Warehouse. It is well written, but not in detail, it is good to read it when something else has already passed beforehand. So I did in the end.

    b. Course 20463C - This is the oldest course I could access, so I studied the content and compared it to the goals of the exam and came to the conclusion that it fit. In general, if you work through all the labs and carefully read the material and do all the examples, it's a great preparation.

    c. Microsoft: DAT216x Delivering a Relational Data Warehouse - this course is available at https://www.edx.org/course/delivering-a-relational-data-warehouse - not a bad video course, but it is worth watching only after or at the same time with reading a book or courses Course 20463C / 20767

    d. Microsoft: DAT217x https://www.edx.org/course/implementing-etl-with-sql-server-integration-servi is a good video course on SSIS and ETL

    e. there is a separate course on dqs https://www.edx.org/course/data-cleansing-with-data-quality-services-dqs I haven't had time to look at it, but judging by the description it is perfectly correlated with the goals of the exam and will be useful in addition to, for example, a book or a Course 20463C / 20767

    f. https://www.microsoft.com/handsonlabs/selfpacedlabs These selfpacedlabs with a ready environment available to you for about 2 hours where everything is set up and ready to use. I went through these SQ00156, SQ00165, SQ00166, SQ00167, SQ00168, SQ00169, SQ00171. It is interesting for other vendors if such free labs for example for Oracle? In general I advise as practice let on a lab under the ready scenario is important, but all the same I advise all to establish all and to adjust for example dqs, mds, ssis, iis and even a mail wind-type server.

    g. Tests: At the end of the preparation it will be useful to pass the official tests https://www.measureup.com/microsoft-technical/microsoft-practice-tests.html - there are 150 questions - it is enough to pass them all in a few hours in the mode with the correct answer after the choice and there will be a detailed explanation with links to the material. Or there are analogues on udemy https://www.udemy.com/course/70-767-implementing-a-sql-data-warehouse-test-exam/ there the same - but quality of tests below and explanations why the variant chosen by you correct or not is much more scanty. But the price is less, but I still recommend measureup. In the end - practical tests can not be done at all, but to be sure of a successful delivery - it is still better to take them and thus test your knowledge in advance and pump up the necessary topics. But if you do use the tests, it is best to pass them 1-2 days before the exam and after the basic training is finished.

    f. Additionally: books, having started to study a theme in video courses were references to models DW Kimball and Inmon. By the way, the courses themselves take the Kimball model. So here are the books The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, The Kimball Group Reader and Building a Data Warehouse: With Examples in SQL Server, it is by the way 2008, but nothing in general has changed since then. So, books can be read in parts instead of in full, for example, if something requires clarification, it is worth to choose a chapter or even a part of it and read it.

    h. Other videos: not long ago pluralsigh did a free Weekend and I looked a little bit through the courses there:

    https://app.pluralsight.com/library/courses/sql-server-platform-designing-data-warehouse/table-of-contents, https://app.pluralsight.com/library/courses/dimensional-modeling-microsoft-sql-server-platform/table-of-contents, https://app.pluralsight.com/library/courses/azure-sql-data-warehouse-first-look/table-of-contents, https://app.pluralsight.com/library/courses/extracting-transforming-data-ssis/table-of-contents, https://app.pluralsight.com/library/courses/enterprise-data-management/table-of-contents I've seen some of them, but they're still great in terms of content.

  5. As a result, I learned a new topic - DW design - and gained experience of working with ETL in Visual Studio. In general, I am satisfied with the results. The drawbacks are that I probably started preparing too much for it took me 2 months to get ready and you can do it all faster. I got 781 points out of 700 on the exam. The lowest percentage by section was in DQS (I guess I had to take that video course at https://www.edx.org/course/data-cleansing-with-data-quality-services-dqs). There were a couple of questions about cubes and their organization, as well as a few questions about azure SQL Server Stretch - these topics I did not know well and had to answer almost by logical intuition)

  6. Trello board: https://trello.com/b/FOiOQRmW/exam-70-767. This is the second time I have used the trello as a collection of useful information for preparing for the exam, and it is very convenient because a couple of hours before the exam you can see all the important things you have written there and after the exam use boards such as a reference book.

I hope my experience will help you prepare for the exam.


r/SQLServer • • Jan 03 '18

Community Share Microsoft® SQL Server® Notes for Professionals book

Thumbnail
books.goalkicker.com
75 Upvotes

r/SQLServer • • Mar 17 '24

Performance SQL tools that changed your life

74 Upvotes

What did your company implement that improved efficiency of monitoring data flow?

What tools changed your life as Developer, Architect or Administrator?


r/SQLServer • • Sep 18 '22

[Bitesized] High-quality PDF of Summary of Storage Engine's Internals (and announcement :))

Thumbnail
gallery
74 Upvotes

r/SQLServer • • Jun 05 '22

Thank you Just want to thank all those who are nice enough to answer code questions here (or on stack overflow!). It means so much to get help, specially when overwhelmed by code. Best wishes

73 Upvotes

r/SQLServer • • Oct 09 '25

Discussion OMG! I Just Discovered Query Execution Plans 😳

72 Upvotes

First, before y’all come at me, I am NOT a DBA and don’t pretend to be one. I just use SQL server to store some data at work and I am the only one who uses it. Second, there are no apps or anything connecting to the database. Third, it’s small.

With that out of the way, this Query Execution Plan thing is amazing and so informative. It seems I can tell how it’s piecing together the data, and what the processing costs are for each step. I am going to figure out how to use it. While the database is small, there are a few queries I don’t mind speeding up a bit.

This reminds me of when I discovered Linq in C#.

At any rate, what are some tips you have about using the execution plan?

Thanks!


r/SQLServer • • Jan 15 '25

The year ahead for SQL Server

72 Upvotes

I just posted this blog today on the year ahead for SQL Server, Azure SQL, and SQL database in Fabric: The year ahead for SQL Server: Ground to cloud to fabric - Microsoft SQL Server Blog


r/SQLServer • • Mar 12 '18

Rebooting tonight...Wish me luck!

Post image
72 Upvotes

r/SQLServer • • Apr 04 '17

Boss: "Hey, what did I ask you to get started on last week?"

Post image
72 Upvotes

r/SQLServer • • Jun 16 '26

Discussion Article: "SQL Server may be too lucrative for Microsoft to ditch, but too legacy to love" Am curious to hear what you all think

Thumbnail theregister.com
71 Upvotes

r/SQLServer • • Nov 09 '22

Notepad++ plug-in to view, validate and import csv files more easily

71 Upvotes

The CSV Lint plug-in for Notepad++ was updated recently, which I think can be useful to anyone working with datasets and databases. I've created this plugin and have posted about it before, and there have been several updates and added features since then.

The plug-in adds syntax highlighting and it can also convert csv files to SQL insert scripts, which imho is easier than importing it though a wizard or BULK INSERT because it will more accurately detect datetime and decimal values. It automatically detects the datatypes, and it includes a CREATE TABLE part with the correct data types for each column.

It can also validate the csv data beforehand, meaning check for technical errors like missing quotes, datetime formatting errors, incorrect decimal separators etc. The latest version now also has a Sort feature, it works better with Window 11, has improved support for fixed width files and several usability improvements.

I hope this plugin will save everyone some time when working with csv files 👍 Let me know what you think.


r/SQLServer • • Aug 06 '26

AMA Hi! We're the Microsoft SQL team - ask US anything!

70 Upvotes

Hi r/SQLServer community!

I'm Vandana Mahtani, Principal Product Manager on the SQL team at Microsoft, and I'm co-hosting this AMA with my colleagues ucmsft, u/jerry-nixon, u/bluefooted and u/strahinjarodic.

Our team works closely with app developers who are modernizing existing applications and with teams building new cloud-native and AI-powered solutions.

If you are planning your next app architecture, migrating from on-prem SQL Server, or exploring modern data experiences powered by Azure SQL, this AMA is for you. We'll share practical guidance, lessons from real-world projects, and recommendations to help you get started quickly.

We're here to answer your questions about:

  • Modernizing existing applications with Azure SQL:

    • Migration paths from SQL Server

    • Cloud architecture modernization patterns

    • Integrating with Microsoft cloud services

  • Building new modern applications:

    • Cloud-native app backends on Azure SQL Database

    • AI-powered apps and vector-enabled scenarios

    • Local-first development workflows with Azure SQL Database container

  • Cost-conscious app development:

    • Getting started with free and low-friction options

    • Choosing the right SQL deployment model for your scenario

  • Developer productivity and roadmap:

    • Recommended tooling and workflows

    • Where SQL app development is heading next

Whether you are refreshing a long-running enterprise app or creating a brand-new intelligent app, bring your toughest architecture, migration, and implementation questions.

Tutorials, links and resources before the event:

AMA Schedule:

  • Start taking questions 24 hours before the event begins

  • Start answering your questions at: Aug 13, 2026, 09:00 AM PDT / 16:00 UTC

  • End the event after 1 hour

Thank you for your time and attendance. Hope to see you at SQLCon Barcelona and keep your questions flowing :)


r/SQLServer • • Dec 05 '23

Question What is a common bad practice you see in SQL Server?

70 Upvotes

Curious as someone who is about 5-6 months into learning SQL Server and has made a couple of bad code decisions with it. It can be anything from something that causes performance issues to just bad organization