Do You Verify Your Database Backups?
Backup verification is a vital part of a well-designed database maintenance plan and yet some DBAs neglect to do it. Brad McGehee ownders why.
2009-02-24
720 reads
Backup verification is a vital part of a well-designed database maintenance plan and yet some DBAs neglect to do it. Brad McGehee ownders why.
2009-02-24
720 reads
Every DBA needs to give serious consideration to the level of antivirus/antispyware protection they need on their SQL Server instances, and to the performance implications of the strategy they choose.
2009-02-09
625 reads
Being a DBA demands that you keep up with the latest technology, and conferences are one of the best ways to do that. So, despite the fact that training budgets may be shrinking, I suggest you begin lobbying your manager to attend as many SQL Server events as you can. If you can't get your company to send you to a paid conference, then try to attend one of the free ones, on your own time.
2009-02-09
278 reads
Despite the fact DBAs are essentially protectors of an organization’s knowledge, and privy to much confidential information, there is no clearly defined set of rules and standards to help govern and guide their ethical behavior. Brad McGehee thinks it's time for some action on this issue.
2009-02-05
431 reads
With the current economic downturn, many of us are wondering if we will still have a job by the end of this new year. Although DBAs are still in demand, no DBA job is 100% immune from layoffs. Brad suggests that now is the perfect time to invest in yourself.
2009-01-08
182 reads
I spent most of my time at TechEd two weeks ago, volunteering to answer attendee's questions at Microsoft's SQL Server 2008 booth.
2008-06-25
349 reads
Steve Jones is taking well-earned break. In his guest editorial slot, Brad McGehee discusses three simple techniques to help DBAs manage their time more effectively.
2008-06-23
551 reads
By Vinay Thakur
As this is an Artificial Intelligence (AI) World, things are changing. We can see that...
In a containerized app, React and Chakra UI provide a robust and accessible user...
By Steve Jones
nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...
Comments posted to this topic are about the item More Funny SELECTs
Comments posted to this topic are about the item Reducing the Cycle Time
I've set up replication in my SQL 2019 environment in attempt to migrate SQL...
What does this code return?
SELECT ( SELECT COUNT (*), MAX(soh.OrderDate) AS latestorder FROM Sales.SalesOrderHeader AS soh WHERE soh.OrderDate > '01/01/2011' AND soh.OrderDate < '01/01/2012') AS OrdersIn2000 , ( SELECT COUNT (*), MAX(soh.OrderDate) AS latestorder FROM Sales.SalesOrderHeader AS soh WHERE soh.OrderDate > '01/01/2012' AND soh.OrderDate < '01/01/2013') AS OrdersIn2001 , ( SELECT COUNT (*), MAX(soh.OrderDate) AS latestorder FROM Sales.SalesOrderHeader AS soh WHERE soh.OrderDate > '01/01/2013' AND soh.OrderDate < '01/01/2014') AS OrdersIn2002; GOSee possible answers