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
- Interests: Performance Tuning Database Servers, Running and Coffee
Performance Monitor Counters for SQL Server performance testing
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
SSIS version in SQL Server
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
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
Import Data from AS400 to SQL Server
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
Powershell , Excel charts and data presentation
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
SQL Server Quiz – the last time a stored procedure was executed
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
TPC-H generate test data , test queries and sql database benchmark
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
Database Cost Savings
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
Server sudden shutdown unavailable
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
Blogs
Becoming Kristyna Ferris <3
By DataOnWheels
Hey folks, fun personal post today. A few weeks ago, I got married! My...
What I Love About My Job
In June this year I took redundancy from the company I’d worked at for...
TryHackMe Advent of Cyber
By Steve Jones
I posted that I was thinking about the AdventOfCode this year, but wasn’t sure...
Forums
Backing Up Master
Comments posted to this topic are about the item Backing Up Master
Window Function Basics - PARTITION BY
Comments posted to this topic are about the item Window Function Basics - PARTITION...
Focus on Growth in Your Career
Comments posted to this topic are about the item Focus on Growth in Your...
Ask SSC