It appears to be my lucky day. Who would have thought that someone I don’t even know would want me to invest $48,000,000 for them. Wow it is so exciting.
ok… now that I am through the sarcasm, I am just logging this to share some of the crazy scams that we come across every day. Sorry Anthony Martinez, but I am going to be unable to take you up on your scam, maybe one of the other recipients listed on the To: line will be able to help you.
In a perfect world, your SQL Server would be so secure that you would not need antivirus software, you would have behind layers of firewalls,… Read More »Using Antivirus with SQL Server
Over the years developing Database Health Monitor I have added a number of keyboard shortcuts to make life easier when working in the application. Some… Read More »Database Health Monitor Keyboard Shortcuts
I am excited to announce that 2 of the sessions that I proposed for PASS Summit 2017 have been accepted. This is the first year… Read More »2 Sessions Accepted for PASS Summit 2017
Today I released the June 2017 version of Database Health Monitor, you can get it on the download page at http://DatabaseHealth.com. Here is what it… Read More »Database Health Monitor June 2017 Version Released Today
Today I had the opportunity to release the May 2017 update of Database Health Monitor. This release is version 2.5.4. There are some new cross-instance… Read More »Database Health Monitor – May 2017 version released today
Here is a question that I received from a friend today and I thought it would be a good post explaining the details: Steve, I… Read More »DBCC FREEPROCCACHE – What is the impact.
I am excited to announce that I will be speaking at (and helping organize) the SQL Conference called Companero Conference in Norfolk VA on October 4th… Read More »I’m Presenting at the Compañero Conference In October
Today Episode 91 released and it is our pleasure to present this episode on DBA Tools. DBA Tools is an open source project (http://DBATools.io) that provides a number of powershell scripts to better help the DBA perform common SQL Server tasks. This was a fun episode with the panel of Chrissy, Rob, Constantine, and Aaron who were super excited to talk with us and we loved their energy.
We all want an easy button. It is human nature. We heard quite a bit about how easy PowerShell will make everything, but for those of us who aren’t programmers, it can be a bit intimidating to get started. The PowerSHell tools from dbatools.io are shaping up to be the closest thing to an easy button for DBAs. On this episode we invited some of the team to chat with us about their tool, how they got started and the types of problems they are looking to solve.
“The features that are now inside of DBA tools, honestly, I would describe them as really awesome.” – Constantine
“I promised you this is the best code ever used and that you will ever have.” – Aaron
“It is important to us that people do feel welcomed and that their codes gets merged in.” – Chrissy
Read More »Podcast Episode 91: DBA Tools – Listen and find out what you are missing.
From time to time I get asked about checkDB, and there are many solutions out there, but I have one that I generally use that is very simple and does the job.
The script below created a stored procedure in the DBHealthHistory database that can be used to check as many databases as you can get through in a specific time interval. Here it is set to 5 minutes, but that usually gets extended for large databases. If you set the job to daily, and the job doesn’t get through checking all the databases today, it will pick up where it left off and check the rest tomorrow.
Depending on the number and size of your databases you may want to run this more than once a day, or for a longer period than the 5 minutes.
Note: the 5 minute limitation is checked before starting the next check, so if you have a database that takes hours to check, that will kick off in the 5 minute interval and run until completion.