r/MSSQL • • Apr 16 '24

Pushing database access audit logs to Datadog

23 Upvotes

Need a way to audit database access with an export to Datadog. And also have the user provisioning synced with our Okta users. I started looking around and didn’t quite find anything helpful besides docs on how to connect AD with MSSQL users. Anyone have experience with this?


r/MSSQL • • 16d ago

Hugo Kornelis, long time #sqlfamily member, MVP, creator of SQL Server Execution Plan Reference, speaker, friend, and community member, passed away today after a prolonged fight with cancer.

Thumbnail
bsky.app
14 Upvotes

r/MSSQL • • Dec 01 '20

Query Tuning How to run your CTE just once, and re-use the output

Thumbnail
sqlsunday.com
12 Upvotes

r/MSSQL • • Jan 13 '21

Security Update Microsoft patches Remote Code Execution vulnerability for all supported versions of SQL Server

Thumbnail support.microsoft.com
10 Upvotes

r/MSSQL • • Nov 21 '20

Tutorial The Top 10 Developer Mistakes That Won't Scale on Microsoft SQL Server [Brent Ozar]

Thumbnail
youtube.com
10 Upvotes

r/MSSQL • • Feb 14 '23

Microsoft releases "Important" update for Windows and SQL Server for Remote Code Execution vulnerability

Thumbnail msrc.microsoft.com
8 Upvotes

r/MSSQL • • Mar 27 '22

Tutorial How to add “created” and “updated” timestamps without triggers

Thumbnail
sqlsunday.com
8 Upvotes

r/MSSQL • • Jun 16 '21

Tutorial 24 Database Design Mistakes and How to Avoid Them

Thumbnail
databasestar.com
8 Upvotes

r/MSSQL • • Jun 11 '21

News SQL Server 2019 Cumulative Update 11 has been released

Thumbnail
sqlserverupdates.com
8 Upvotes

r/MSSQL • • Jan 28 '21

News Redgate Software has acquired the assets of PASS, including SQL Saturday and reviving Summit

Thumbnail
red-gate.com
8 Upvotes

r/MSSQL • • Nov 25 '20

Humor Riddle: Why is it pronounced NVARCHAR and not NVARCHAR?

8 Upvotes

Happy Thanksgiving everyone!


r/MSSQL • • Nov 11 '20

Tutorial How to Think Like the SQL Server Engine [Brent Ozar]

Thumbnail
youtube.com
8 Upvotes

r/MSSQL • • Nov 11 '22

Why do StackOverfow users seem mean?

7 Upvotes

Is it just me, or do StackOverflow users seem rude. I've only had a couple posts because I'm new and learning, but they seem so curt and short with me. I think they're annoyed that I don't post with proper etiquette (try as I might). For people that are there to help, they sure seem like they don't want to (even when I try to work with them)


r/MSSQL • • Mar 23 '21

Query Tuning What's New in SQL Server 2019 - Brent Ozar

Thumbnail
youtube.com
7 Upvotes

r/MSSQL • • Sep 24 '20

Important! Microsoft "recalls" SQL Server 2019 CU7 over database snapshot issue. Do not install it and if you have it installed, MSFT advises removing it

Thumbnail
techcommunity.microsoft.com
7 Upvotes

r/MSSQL • • Apr 26 '17

The SQL Server PowerShell module is now available in the Powershell Gallery. No SSMS install required!

Thumbnail
powershellgallery.com
7 Upvotes

r/MSSQL • • Sep 16 '16

SQL Sentry Plan Explorer is now free

Thumbnail
sqlservercentral.com
7 Upvotes

r/MSSQL • • Jun 30 '26

Discussion Pros of MSSQL as a Query Tool

6 Upvotes

What are the pros of using SSMS over other query tools? I currently use Toad Data Point 6.0 (TDD) and I use primarily 2 connections; SQL Server or Oracle. The license for TDD is about to expire. I believe my company is working on renewing the license but I am wondering if this is a good opportunity to start learning and working with SSMS instead.

I would say I have an intermediate understanding of SQL but all the "serious" and more advanced analysts use SSMS. What does SSMS do or have that only it offers?


r/MSSQL • • Apr 12 '26

What is one common mistake in Microsoft SQL Server that beginners make, and how can we avoid it?

6 Upvotes

r/MSSQL • • Jan 15 '26

Help please: need MsSQL for Mac

6 Upvotes

Hi New to the community & SQL… I couldn’t find anyway (other than buying a full licensed version from Microsoft for windows) to download MsSQL on my mac Air machine. Some softwares are bulky and very slow and also do not support many functions Is there any way I could use it on Mac?

Thanks


r/MSSQL • • Jan 02 '26

Temporary table like in oracle

6 Upvotes

Hello,

we switched to ms sql 2019 from oracle and i missing a feature oracle had and i cant figure out a workaround.

On oracle we could create a session based temporary table that stays permanent with a fixed name and could be linked an used via ODBC like an normal table. The only difference to a normal table was that the rows in the table exists only for the session. These table could be used by serveral users without problems, they only got their own records.

We were able to link needed tables and these temporary tables from oracle via ODBC with MS Access.

I cant find a similar solution or workaround in ms sql.
Is there no solution for this?

greetings


r/MSSQL • • Jul 30 '24

Tip [Blog] Everything's a case statement!

6 Upvotes

Yesterday, I was having a fun discussion in the SQL Server slack community about how things like IIF, COALESCE, etc are really just syntactic sugar for CASE statements. So I thought I'd throw together a blog post about it...

https://chadbaldwin.net/2024/07/30/everythings-a-case-statement.html


r/MSSQL • • Mar 21 '23

What's the differrence between sqlcmd and sqlservr commands ?

6 Upvotes