Learn how you can add a new database to your instance if you receive the MDF and LDF files from another source. MVP Brian Knight covers this very useful technique that is used for moving databases to new instances, servers, or even recovering from an disaster.
SQL Server trainer and expert DBA, Andy Warren, thinks that everyone should have a philosophy about security. He starts this installment in looking about how to assign administrative privileges.
Do you avoid certain SQL functionality because you have been told you should NEVER use it?
This paper presents an approach to the definition of function points within database-centric business information systems, the process of counting function points, .
Statistics update date is stored as metadata on the SQL instance, but after a great deal of research against the system tables and DMVs I realized that this information is not readily exposed to the DBA via any other method than the STATS_DATE() function or the SQL Server Management Studio graphical user interface (GUI).
System administrators have a lot of power and temptation to use it. Steve Jones talks about the need to resist temptation and the need for oversight.
System administrators have a lot of power and temptation to use it. Steve Jones talks about the need to resist temptation and the need for oversight.
System administrators have a lot of power and temptation to use it. Steve Jones talks about the need to resist temptation and the need for oversight.
This weeks Database Weekly looks at a longtime leader for the Microsoft SQL Server development team leaving the company.
The Mojave Experiment is a marketing effort by Microsoft that is very interesting in looking at first impressions. Steve Jones comments.
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Comments posted to this topic are about the item GPX distance and time analysis...
Comments posted to this topic are about the item The DBA is Dead; Long...
Comments posted to this topic are about the item Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers