DBA Team Structure – Thoughts From Real Life
I once talked about the DBA team building about 3 years ago, now when I look back, I still believe...
2011-11-20
3,327 reads
Jeffrey Yao
Find the largest tables in a database (II)
I once wrote a post to find the largest tables in a database, and now after studying PowerShell, I feel...
2011-09-18
2,025 reads
Job Exit Planning Strategy
I feel somehow sad today (Aug 31, 2011) to see one of my colleagues “laid-off”. I put quotation mark around...
2011-09-01
1,882 reads
Thoughts on DBA Professional Development
As a DBA, we have a lot to work on and also we have a lot to learn about. The...
2011-08-20
1,388 reads
Counting code lines in SPs with Powershell
One of interesting tasks I once had is to check the # of code lines for all user stored procedures (SPs)...
2011-08-14
1,399 reads
Database Administration Operation Road Map
In my company, every two years, we have a tradition to collectively ponder at the technology road map for the...
2011-08-13
2,299 reads
Delete backup files older than days
For almost all sql backup jobs, we want to have a step to delete old backup files older than a...
2011-08-06
4,495 reads
Find the largest tables in a database
From time to time, I need to find the largest tables in terms of rows / used space / total space etc....
2010-09-28
32,518 reads
Restart SQL Server Default Trace
One of my test servers, due to the unexpected growth of a user db, the local drive is used up,...
2010-08-13
11,909 reads
Proposals to win a MSDN Subscription
Recently quite a few MVPs (here, here and here ) are handling out MSDN Ultimate subscriptions in the community. What interests...
2010-07-08
1,163 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