The Database Giveth and Taketh Away
A database error at Southwest Airlines confused some customers and was embarrassing. Steve worries that we might want to be more careful in the future about making database mistakes.
2019-04-25
278 reads
Career
How the Company-Startup Thing Worked Out For Me, Year 7
It’s time for my annual update on the wild ride. If you want to catch up, check out past posts in the Brent Ozar Unlimited tag. This post covers...
2019-04-09
You're not really that good at SQL Server
Steve reminds some people that there are reasons to continue to improve your skills.
2019-04-08
1,314 reads
2017-06-16
1,843 reads
Fine Products for the Modern Drudge
As working hours in tech trend upwards, we look at some ways to make life easier.
2014-10-13
112 reads
Beginner, Expert, or Both?
It can be easy to start learning about a topic, think you've mastered it, and become complacent. Steve Jones notes that an expert beginner might be what you are, but it's not necessarily what you want to be.
2013-10-07
304 reads
15 Quick Short Interview Questions Useful When Hiring SQL Developers
Here is a useful exam that you can administer in either 10 or 15 minutes, either oral or written, when you interview for hiring permanent or contract workers for jobs in SQL Server development or support. (This is not a test for SQL Data Base Administrators.)
2014-12-25 (first published: 2013-02-28)
14,620 reads
Interviewing Tips for a Database Position
Interviewing for a database position is a careful game of give and take. Knowing what to expect and how to prepare for your interview is important, but it's only half the battle. You'll also need to ask questions to see if the job, and the company, is a good fit for you.
2013-02-08
5,440 reads
Free eBook: SQL Server Tacklebox
Get a free ebook from Rodney Landrum and Red Gate Software that helps you prepare to deal with the various crisis situations you might encounter with SQL Server.
2013-01-11
4,793 reads
The Technical Nuances of Technical Writing
A helpful guide to writing technical papers by focusing on the non-technical elements.
2012-10-18
4,345 reads
Blogs
Performance Tuning Steps Query by looking an execution plan and effectiveness of the index Part 2
By MUTHUKKUMARAN KALIYAMOORTHY
How to read execution plan to improve poorly... [[ This is a content summary only....
VSCode Tips–Remove the Highlighted Line
By Steve Jones
VSCode was making me crazy as I was writing a script. I like a...
Use T-SQL, not the GUI
By Jen McCown
There’s a very good reason to do most of your DBA work using T-SQL,...
Forums
business intelligence development studio(Bids)
Hello, I have a SQL 2017 and I want to use business intelligence development...
MEMORY CONSUMPTION SQL 2012
hi all, as you can see in attachment sql take 122 giga memory. and...
Issue with max() and aggregate, missunderstanding
Hi all, this is my first post here and I've been looking and trying...
Ask SSC