ALTER AUTHORIZATION sql to change owner of a database
ALTER AUTHORIZATION changes the ownership of entities . Server level entity ownership can be changed to server- level principals. Database level...
2011-09-27
99,706 reads
ALTER AUTHORIZATION changes the ownership of entities . Server level entity ownership can be changed to server- level principals. Database level...
2011-09-27
99,706 reads
I posted “Window Perfmon scripting, SQL Server perfmon and how to perfmon” which refers to a performance monitor counters.
The perfmon counters...
2011-09-23
3,421 reads
Integration Services is the management interface for SSIS packages. SQL Server uses the “MsDtsSrvr.exe” for executing packages
To highlight the point,...
2011-09-22
1,054 reads
Migrating to SQL Server from another Database platform has a number of considerations
1) Create an inventory of existing applications. Separate into...
2011-09-20
1,150 reads
The process to import data from AS400 uses a SQL Server Linked server. The Linked Server points to an ODBC...
2011-09-16
16,553 reads
The topic for T-SQL Tuesday is Data Presentation. Powershell to Excel is a a good way to presenting data, and...
2011-09-13
3,253 reads
A developer rushes up to you and asks "can you tell me the last time this stored procedure was executed?"....
2011-09-13
1,137 reads
This is a followup on my earlier post ofSQL Server test data generation testing tools.
I had some requests for my...
2011-09-08
5,639 reads
I watched a video recently by Forester Research , discussing Database Cost Savings. The video was intended for IT decision makers,...
2011-09-05
880 reads
It’s not always straightforward to diagnose a server problem. You look through the SQL Server Logs and Event Viewer for...
2011-09-03
1,039 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
Comments posted to this topic are about the item The Backup File Extension
Comments posted to this topic are about the item Ingest and Retrieve data from...
Comments posted to this topic are about the item The DBAccountant
I run this command in SQL Server 2022. What is the extension of the backup file?
BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'See possible answers