Some things are scary. Other things are dangerous. And in SQL Server, you can have both scary and dangerous at the same time. Scary, that we can deal with. But dangerous, particularly things that are deceptively dangerous, is bad. Scary things Let’s start with scary. Some things give us pause. We see them, think about…
Read more
The end of Mainstream Support. Is that really as dire as it sounds? Because it sounds like I’ll be completely on my own. No support. At least no “mainstream” support, whatever that means. What happens if something goes wrong?
“The server is seriously slow! Can’t we add memory or something?” We’ve all heard this before. You may have even thought it yourself. Adding resources could be an easy fix to a troublesome performance problem. After all, SQL Server hungers for memory. The more the better. And a side of processor goes a long way,…
Read more
We’ve made it! The start of a new year. Now is a great time to reflect on what you’d like to accomplish over the next 12 months at work, and more specifically, what you would like to do with your SQL Server environment this year. To help with that, here are five activities or goals…
Read more
In SQL Server, when someone creates a database, they own it. That means they have elevated permissions on the database. The SQL Server database owner can change configuration parameters, perform maintenance, and grant permissions on the database to other users. The database owner can even drop the database altogether. In highly secure environments (and what…
Read more
Checking the number of tempdb data files is straightforward. Here are three easy ways: one graphical, one T-SQL, and one PowerShell, so you can use your tools of choice.
Recent Comments