The best way of checking SQL Server backups is to restore them and run DBCC CHECKDB on the restored database. To do this regularly means that you need to automate the task. Allen White shows how, with PowerShell.
Monitoring drive space is something every DBA ought to be doing. Shaun Stuarts brings us a method that can easily be used to keep track of your SQL Server instance
Do you work in a great IT shop? Steve Jones talks about some of the things that make one and wonders if you feel you work at a great company.
To meet the upcoming demands on IT systems database administrators (DBAs) need to prepare the database and its supporting infrastructure for increased resource demands. Being proactive now can pay big dividends by maintaining service level agreements (SLAs), avoiding outages and resource shortages, and ensuring a positive overall customer experience.
DBAs are expensive, so isn't their time valuable? Are you aware of what you cost the company and use your time wisely? Steve Jones talks a bit about how to choose on what you should be working.
A DBA should provide two things, a service and leadership. For Grant Fritchey, it was whilst serving a role in the Scouts of America that he had his epiphany. Creative chaos and energy, if tactfully harnessed and directed, led to effective ways to perform team-based tasks. Then he wondered why these skills couldn't be applied to the workplace. Are we DBAs doing it wrong in the way we interact with our co-workers?
The comment from one person has Steve Jones stunned today. He discusses the value of diversity and what we can do in the community.
I have a SQL Server instance that has hundreds of databases. Navigating the database tree in SSMS is a pain and I was wondering if there was a way to limit the list of databases that I see in SSMS?
Renaming and/or moving a large number or SSRS reports through the Report Manager interface is not a trivial task. This article will demonstrate how to achieve this by writing a small console application that will make web services calls to the Reporting Services Web Service.
Can a honeypot provide you with more security? It's an interesting idea from Steve Jones today that might help you detect, and respond, to security events.
The DBA life is fraught with pain. Those battles that we endure are mostly...
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
WA:08218154393 Ruko Cikarang Plaza, Jl. Yos Sudarso No.5 Blk B, RW.6, Cikarang, Kec. Cikarang...
WA:08218154393 Madison Square, Business Park Lippo Cikarang, Jl. MH. Thamrin No.163, Cibatu, Cikarang Selatan,...
Hello, I would like to ask whether it is technically possible to redirect a...
Can I set Accelerated Database Recovery on tempdb?
See possible answers