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
1,991 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,876 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,387 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,121 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,474 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
31,719 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,407 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,158 reads
Blogs
A New Word: Vicarous
By Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
SQL Server Cross Platform Availability Groups and Kubernetes
Say we have a database that we want to migrate a copy of into...
Updating dbatools–Fixing the Certificate Failure
By Steve Jones
I was trying to update my dbatools install to test something and go this...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers