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
98,839 reads
ALTER AUTHORIZATION changes the ownership of entities . Server level entity ownership can be changed to server- level principals. Database level...
2011-09-27
98,839 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,419 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,053 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,271 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,247 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,135 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,636 reads
I watched a video recently by Forester Research , discussing Database Cost Savings. The video was intended for IT decision makers,...
2011-09-05
879 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,036 reads
By DataOnWheels
Hey folks, fun personal post today. A few weeks ago, I got married! My...
In June this year I took redundancy from the company I’d worked at for...
By Steve Jones
I posted that I was thinking about the AdventOfCode this year, but wasn’t sure...
Comments posted to this topic are about the item Backing Up Master
Comments posted to this topic are about the item Window Function Basics - PARTITION...
Comments posted to this topic are about the item Focus on Growth in Your...