Most DBAs dread hearing that they need to restore a database to a point in time, especially if the database is a production database. However, knowing how to do this is of the utmost importance for a DBA's skill set. I'll walk you through the steps of how to restore a SQL Server database to a point in time to recover a data table.
The whole entertainment aspect of computing is growing tremendously and we're slowly seeing a convergence in our living rooms of computing capabilites along with entertainment. From rocker chairs with speakers to TiVo-type devices, the Nokia Internet Tablet, and XBOX 360s and Playstations that can enhance our movies.
Another little bit of career advice, this time from longtime author Jeffrey Yao who gives you some pointeres on what you should know for your next job interview.
Some managers love to look solely at numbers when assessing performance, and key performance indicators (KPIs) are right up their street. But how useful are they in the context of software development
Most DBAs don't ever deal with multiple languages or different collation and sort order settings in SQL Server, but it can be a handy piece of information to have. Steve Jones brings us a quick look at a problem in comparing data across databases.
Green is the hot topic these days, and the concept is having an impact on the way people think about datacenters. Companies around the world are announcing ways to save energy and reduce
Deadlocks do not occur too often, but when they do, it can be a time consuming and frustrating endeavor to track them down. In SQL Server 2000, you could alter the message to ensure these were written to the error log and track them down quickly. In SQL Server 2005, it is a little more tricky, but new author Patrick Leblanc brings us a technique for sending out a notification.
Backpressure is an interesting internal memory limiter inside SSIS and in SQL Server 2008 you get to see when the limiter kicks in.
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
By Steve Jones
“You don’t need more time because you already have all the time that you...
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Comments posted to this topic are about the item What Did Healthy Look Like?
Comments posted to this topic are about the item DML Trigger Types
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
How many types of DML triggers are there?
See possible answers