When you have a team of people working together to manage systems, communication becomes important. Steve Jones notes that a lack of working with each other and letting the rest of the team know what you are doing can cause unnecessary work for others.
Not all DBAs have the opportunity to attend formal classroom training or attend conferences. While there are many SQL Server...
A colleague of mine who is getting to grips with SQL Server had an issue after creating and implementing a...
The Transaction Log provides the means by which either the complete set of tasks of a database transaction are performed or none of them are. It ensures that , via rollback, only valid data is written out to the database, and it allows transactions to be played back to recreate the system state right before a failure. Robert Sheldon explains the various basic tasks involved in managing the transaction log.
Would you like to have only SQL Server Authentication on your instances? That's the subject of this Friday's poll.
Some useful undocumented extended and stored procedures in SQL Server 2005
or our first feature on working DBAs and their lives, we selected Grant Fritchey, the self-styled Scary DBA, who has been so successful in the past year with his books and presentations. How does he manage to pack so much into his life? We sent Richard Morris to find out.
Would you like to have only SQL Server Authentication on your instances? That's the subject of this Friday's poll.
Would you like to have only SQL Server Authentication on your instances? That's the subject of this Friday's poll.
Would you like to have only SQL Server Authentication on your instances? That's the subject of this Friday's poll.
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Comments posted to this topic are about the item Pro SQL Server Internals
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Comments posted to this topic are about the item Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers