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
100,400 reads
ALTER AUTHORIZATION changes the ownership of entities . Server level entity ownership can be changed to server- level principals. Database level...
2011-09-27
100,400 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,422 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,057 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,152 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,691 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,269 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,139 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,641 reads
I watched a video recently by Forester Research , discussing Database Cost Savings. The video was intended for IT decision makers,...
2011-09-05
883 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,040 reads
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Bonjour à tous, J'ai un problème d'exécution de mes packages SSIS. A chaque opération...
Comments posted to this topic are about the item Being an extroverted introvert at...
I have data that contains poll results, with the poll_id consistuting a single row...
How are the statistics for query optimization stored in SQL Server?
See possible answers