More Tips for New (and old) DBAs
Following up on the popular article: Tips for New DBAs, author Craig Outcalt tackles three more issues including customer support and why you should learn T-SQL.
2013-11-29 (first published: 2009-01-12)
25,793 reads
Craig Outcalt
- Interests: Cycling, Family, SQL Server
What’s in YOUR Recovery Plan?
Author Craig Outcalt gives advice on preparing for the worst with a look at what you should consider putting in your disaster recovery plan and why.
2012-12-10 (first published: 2011-09-26)
5,154 reads
SQL Server Memory Management Explained
Author Craig Outcalt takes a deep dive into the SQL Server memory allocation and how it competes with OS memory.
2011-09-20
15,316 reads
Tips for New DBAs
New and old DBAs alike can benefit from going back to the roots of the profession. This series of articles highlight the skills needed to move to the next level of Database Administration.
2010-02-12 (first published: 2008-11-18)
46,190 reads
Predictable Index Fragmentation
This technical article provides an overview of how to produce specific levels of index fragmentation. Useful for creating test plans.
2008-10-29
6,700 reads
Who was that Affinity Masked Man?
Getting the number of processor cores that SQL Server is using is not as straitforward as it could be. Enter the affinity mask, bitwise operations and good old fashioned computer science.
2008-10-17
4,025 reads
Blogs
SQL Server 2025 Generally Available
By Brian Kelley
This was announced last week at Microsoft Ignite and it's been covered by others...
Chatting with Power BI: Who Benefits from This Conversation?
By Rayis Imayev
"Dave: Open the pod bay doors, HAL.HAL: I’m sorry, Dave. I’m afraid I can’t...
A Quick Look at Redgate Data Modeler
By Steve Jones
Redgate acquired a data modeling tool from Vertabelo recently and I wanted to explore...
Forums
SQL Server 2022 order by bug?
Hi, I was using order by on a column with characters and saw something...
SQL Server 2025 Build List
Comments posted to this topic are about the item SQL Server 2025 Build List
Filtered Indexes: The Developer’s Secret Weapon in SQL Server
Comments posted to this topic are about the item Filtered Indexes: The Developer’s Secret...
Question of the Day
Getting The Database Name
I run this code to connect to SQL Server 2022 from the command line.
sqlcmd -S localhost -EAt the command line, I run these two commands:
SELECT ORIGINAL_DB_NAME() GOWhat is returned? See possible answers