Database Administrtion Skillset Investment Rules
With each new release of SQL Server version, there is something new to learn. In SQL Server 6.5 days, it...
2008-12-05
772 reads
Jeffrey Yao
Database Adminstration Scalability
database administration scalabilityI am working on a project that is very successful in terms of its market
share, i.e. product users...
2008-11-27
1,864 reads
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,361 reads
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,173 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,298 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,785 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
605 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,671 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
895 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,817 reads
Blogs
Can I Change a Primary Key Value? #SQLNewBlogger
By Steve Jones
I heard someone say recently that you can’t change a primary key value in...
SQL Server Index Primer
By Kevin3NF
Indexes 101: What, Why, and When? “What Is an Index?” I get this question...
Secure Azure SQL Server Backups Using Managed Identities
By Arun Sirpal
I do believe most people know about the ability to backup your SQL server...
Forums
Just a rant about the SQL Server 2022 upgrade
Upgrading an instance of SQL Server 2019 to SQL Server 2022 - I am...
Report Server Configuration Manager - The target principal name is incorrect SSL
SQL Server SSRS 2022. Running into ' SSL Provider, error: 0 - The target...
Report Server Configuration Manager - Change Database - SSL Error
SQL Server SSRS 2022. Running into ' SSL Provider, error: 0 - The target...
Question of the Day
Getting the TEXTSIZE
How can I check what value I used for TEXTSIZE? I ran this code:
SET TEXTSIZE 8096But then deleted the code and couldn't remember. Is there a way to check this? See possible answers