Okay, About That SmartPostgres.com Thing.
Brent Ozar Blog
by Brent Ozar
4d ago
In some of the Query Exercises posts here, you might have noticed links over to similar query exercises at SmartPostgres.com, and the free read-only version of the Stack Overflow database I’m hosting there. I’ve held off the questions for long enough: it’s time to discuss what I’m up to. First off, BrentOzar.com is staying Microsoft-focused. The ~100K of you who subscribe and visit regularly can breathe a sigh of relief. I’m not going to shove Postgres down your throat, hahaha. From time to time, at the bottom of SQL Server focused posts, I may add a section talking about how Postgres approach ..read more
Visit website
[Video] Office Hours: I Feel Like an Amateur Edition
Brent Ozar Blog
by Brent Ozar
6d ago
I started with audio problems, then had video problems halfway in. It’s amusing because we also discuss feeling like a SQL amateur! Here’s what we covered: 00:00 Start 01:52 Does Time Really Exist: Hi Brent! What is the best way to ETL? web application, SSIS, linked server, … 03:55 MyTeaGotCold: What is your vision for what SQL Server will be like in 2030? I feel like a fool for thinking it will involve In-Memory OLTP. 05:49 mailbox: Hey Brent, What’s your take on switching to specializing in Open Source Database platforms( on-prem or cloud)? What would the career impact be? Seems like there ..read more
Visit website
The Future of DBAs: History Rhymes
Brent Ozar Blog
by Brent Ozar
1w ago
Eitan Blumin recently wrote a post about the future of the DBA career in which he talked about the rise of jack-of-all-trades IT professionals. It’s a good post. You should read it. I did, and over the last 20 years, I’m pretty sure I’ve read a dozen variations of that post. There’s a saying: “History doesn’t repeat itself, but it often rhymes.” To give an example, let’s rewind the clock back to 2008. Business Intelligence was all the rage. SQL Server shipped with Analysis Services, Integration Services, and Reporting Services all inside the box. I remember hearing, “You have to learn all of t ..read more
Visit website
[Video] Office Hours: Answers for Your Database Questions
Brent Ozar Blog
by Brent Ozar
1w ago
Y’all post questions and upvote the best ones at https://pollgab.com/room/brento, and I discuss ’em in my home office before tackling a client’s performance issues: Here’s what we covered: 00:00 Start 00:45 Eve: When should you/should you not execute the SSMS recommended Missing Index in the execution plan? 02:42 MyTeaGotCold: Logging sp_WhoIsActive and sp_BlitzFirst to a table has come up on your blog a few times. Do you still bother with it on versions that support Query Store? 04:03 Frozt: Hi Brent, There is a upcoming DB we have that they configured where AG is not in automatic failover ..read more
Visit website
Getting Data Out of an Audit Table: Answers & Discussion
Brent Ozar Blog
by Brent Ozar
1w ago
In last week’s post, I gave you a trigger that populated a history table with all changes to the Users.AboutMe column. It was your job to write a T-SQL query that turned these Users_Changes audit table rows: Into the full before & after data for each change, like the earlier query from the blog post: The trigger will always log the “before” values into the Users_Changes table, but the “after” value could be in a few different places: If other changes have been made to that row, then the “after” value will be the next change for this Users.Id in the Users_Changes table If no other change ..read more
Visit website
Why Generative AI Scares the Hell Out of DBAs
Brent Ozar Blog
by Brent Ozar
1w ago
I was chatting with a client’s DBA about this thought-provoking blog post about data governance in the age of generative AI. The DBA’s concern was, “What if we hook up generative AI tools to the production database, and someone asks for, say, recommended salary ranges for our next CEO based on the current CEO’s salary? Will the AI tool basically bypass our row-level security and give the querying person information that they shouldn’t be allowed to see?” And she had a really good point. If you haven’t worked with AI tools yet, I don’t blame you. You’ve got a real job, dear reader, unlike me wh ..read more
Visit website
I’m Getting Antsy for SQL Server vNext.
Brent Ozar Blog
by Brent Ozar
2w ago
Historically, Microsoft publicly announces the next version of SQL Server about a year before it ships. For example: November 2, 2021, Microsoft announced the private preview of SQL Server 2022. About 6 months later, on May 24, 2022, they announced the public preview. About 12 months after the private preview announcement, on November 16, 2022, SQL Server 2022 was generally available. This was pretty consistent with past releases: about a year before the release, Microsoft would go on record with the features included with the next version, and some companies would be able to start using it ..read more
Visit website
SQL ConstantCare® Population Report: Spring 2024
Brent Ozar Blog
by Brent Ozar
2w ago
The short story: SQL Server 2019 appears poised to swallow the SQL Server market altogether, hahaha. The long story: ever wonder how fast people are adopting new versions of SQL Server, or what’s “normal” out there for SQL Server adoption rates? Let’s find out in the winter 2023 version of our SQL ConstantCare® population report. Out of the thousands of monitored SQL Servers, SQL Server 2019 is now at 49% of the market! That’s the highest percentage we’ve seen for any version in the 3 years that we’ve been doing this analysis. Here’s how adoption is trending over time, with the most recent dat ..read more
Visit website
[Video] Office Hours: Ask Me Anything About Azure and Microsoft Databases
Brent Ozar Blog
by Brent Ozar
3w ago
Back at home in the office, time to settle in with a nice caffeine-free Diet Coke and go through your top-voted questions from https://pollgab.com/room/brento. Why caffeine-free? Because I slug multiple coffees first thing in the morning when I wake up (usually around 3am-4am), and by the time I stream with y’all, I don’t need any more go juice. Here’s what we covered: 00:00 Start 02:30 MyTeaGotCold: Has your opinion of Lock Pages in Memory changed over the past 10 years? 03:48 MustangKirby: How can I check what data or pages are in cache? I woke up last night wondering if data I’m writing t ..read more
Visit website
Who’s Hiring in the Microsoft Data Platform Community? May 2024 Edition
Brent Ozar Blog
by Brent Ozar
3w ago
Is your company hiring for a database position as of May 2024? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid networking here. If your company is hiring, leave a comment. The rules: Your comment must include the job title, and either a link to the full job description, or the text of it. It doesn’t have to be a SQL Server DBA job, but it does have to be related to databases. (We get a pretty broad readership here – it can be any database.) An email address to send resumes, or a link to the application process – if I were you, I’d put an email address be ..read more
Visit website

Follow Brent Ozar Blog on FeedSpot

Continue with Google
Continue with Apple
OR