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,346 reads
DBA Philosophy
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,042 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,901 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,404 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,404 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,344 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,542 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
33,283 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
12,014 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,174 reads
Blogs
Accept the no and move on
By Brian Kelley
Here is a short emotional intelligence (EI) post for today, courtesy of Seth Godin....
Don’t Fight with AI
By Steve Jones
I was recently trying to handle a simple task with a few AI tools...
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Forums
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers