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
94,980 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,418 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
15,123 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,237 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,134 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
The Effectiveness of Solar Estimation
By Steve Jones
We added a solar system to the ranch as a way to hedge against...
How do I tell if identity_insert is turned on and if so what table?
TLDR; The code to do this is below but it’s a bit hokey and...
Daily Coping 24 Jun 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Shared Work Spaces: Hell, Heaven, Both?
Comments posted to this topic are about the item Shared Work Spaces: Hell, Heaven,...
T-SQL : Slicing time Islands and gaps
Hello, Consider the following table that gives the validity dates of an item :...
Migrate the SSIS Catalog in Just a Few Clicks
Comments posted to this topic are about the item Migrate the SSIS Catalog in...
Ask SSC