Find the TCP port used by a named instance
We know for SQL Server default instance, if TCP/IP protocol is used, the default TCP port number is always 1433....
2008-11-13
1,340 reads
DBA Philosophy
Database administration complexity model
I have been working as a DBA for sometime now, and have been exposed to various database environments and with...
2008-11-07
1,172 reads
DBA and Doctor
I always feel it is harder to be a DBA than to be a doctor while we are doing almost...
2008-11-02
1,295 reads
ways to find the name of a running job
From time to time, I need to check (in my script) which jobs are running at the moment.So far, I...
2008-10-23
1,784 reads
Database Administration Librarian
If I cannot find a book or info in a library, I always go to a librarian for advice and...
2008-10-07
603 reads
DBA team building
Whenver we start a somewhat big IT project, it is natural for us to build a team dedicated to the...
2008-09-20
2,647 reads
Wish-list for SQL Server Replication
I have been working on sql server replication (on sql server 2K5) for more than 1 year now, starting from...
2008-09-07
894 reads
Database administration culture
"Culture", according to Merriam-Webster Dictionary http://www.merriam-webster.com/dictionary/culture, has one definition as
"the set of shared attitudes, values, goals, and practices that characterizes an...
2008-08-16
1,815 reads
Changing jobs -- Pros and Cons
I read Andy's post Changing Jobs - Should You? today with great interest. I think it is good topic in the...
2008-08-08
1,291 reads
Cold backup and remote control of sql server services
I recently got a request to do a "cold" backup of a small yet complex db environment, I say "small" because...
2008-08-02
705 reads
Blogs
Moving T-SQL Tuesday to Jekyll
By Steve Jones
I got a message a few months back that Microsoft was deprecating the MySQL...
European Microsoft Fabric Community Conference announcements
By James Serra
A TON of new features announcements at the European Microsoft Fabric Community Conference help...
Forums
An error occurred while skipping data rows
I am trying to build an ETL for an Existing Table. The ETL (SSIS)...
What is causing this error?
(This is probably the wrong forum to be posting this question, so please forgive...
Changetracking disabled in database snapshot, new bug in ms sql 2019 ?
Hi, We are using database snapshot together with changetracking to keep a datawarehouse up...
Question of the Day
Data Migration Assistant Targets
In the current (2024) version of the Data Migration Assistant, which on-premises targets are available?
See possible answers