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,403 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,183 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,328 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,798 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
615 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,718 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
906 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,834 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,307 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
720 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers