When we examine SQL Servers as part of our SEROShield SQL Server Health Check, we find five commonly overlooked SQL Server settings that can put performance, reliability, and even data at risk. Why are SQL Servers often misconfigured? SQL Server is robust. Microsoft has put a lot of effort into creating a database platform that…
Read more
The moon over my morning walk today. It was bright and beautiful. And under its glow, I realized that my morning walks have become an important routine for me. They are important for my physical and emotional health. They help start the day off on the right foot, so to speak. Similarly, routines are instrumental…
Read more
I sliced into an avocado while making lunch recently. The size of the seed compared to the fruit was shocking! It was huge. There was only a thin layer of fruit surrounding a large, bulbous seed. Interestingly, some avocados are just the opposite – the seed is tiny compared to the amount of fruit inside.…
Read more
SQL Servers? Check. Important databases? Check. SQL Server DBA? Umm, no. Now what? If you’re like some companies, you’ve tasked a sys admin with keeping the SQL Servers running, in their spare time. Not optimal, but a full-time DBA is not in the budget. In an upcoming webinar, Working Without a DBA? A 10-Step Recipe…
Read more
“Oh, we use VM snapshots to backup our SQL Servers.” We sometimes hear this when talking with companies, especially when we’re delivering a SQL Server Health Check Assessment. And why not? It makes sense. Companies take snapshots of their file servers. They snapshot of their web servers before upgrades. FTP servers, Citrix servers, and even…
Read more
Do you schedule DBCC CHECKDB for all of your important databases? Scheduling database integrity checks ranks right up there with backing up your databases when it comes to glamorous activities in the life of a DBA. That is to say, it’s not glamorous at all. Integrity checks don’t bring the same internal swagger as say…
Read more
Don’t sweat the small stuff, they say. That’s good advice. Much of the time. But with SQL Server, the small stuff is worth sweating. In fact, the small stuff can be big. Letting the small stuff go In life, the small stuff can weigh you down. Worrying about things that don’t really matter can strip…
Read more
How many tempdb data files should a SQL Server have? And where should they live? What about their growth settings? Should it be by percent? Or, should they grow by a certain size each time? Are there other tempdb configuration settings I should be concerned with? In short: how should I configure my SQL Server…
Read more
Have you seen the job boards recently? Hiring an experienced full-time DBA is expensive. And many companies simply cannot justify that kind of spend for a full time DBA, especially if they have fewer than a couple of dozen instances of SQL Servers in production. The result? Many companies are working without a SQL Server…
Read more
Hardening and protecting your SQL Server environment is not a one-and-done task. It’s a continuous process. Things change. New Applications are added. Logins come and go. Servers are migrated. In such a dynamic environment, auditing data access in your SQL Server environment is critical. If you are responsible for SQL Servers, you likely ask: Who…
Read more
Recent Comments