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,775 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,139 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,144 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,145 reads
2009-11-30
3,408 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,691 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,011 reads
Blogs
A Couple Quick GENERATE_SERIES Tests
By Steve Jones
I had someone reach out about generate_series() recently, saying they hadn’t realized this was...
How I passed the DP-700 Exam
I recently took and passed the DP-700 exam, which is required for the Microsoft...
Which approach to take: Build it, buy it, cloud it?
As a Consultant, I would typically answer with – it depends! Then a typical...
Forums
Source to Target Mapping (Lineage)
Hi all, I work with an unusual warehouse and I was wondering if anyone...
How do I read XEL files in SSAS?
A colleague of mine has setup SSAS monitoring through Extended Events and these are...
Question of the Day
The Character choice
What happens when I run this code in SQL Server 2022?
create table Names ( namestring varchar(20)) go insert Names select 'Steve' go select choose(namestring, 'steve', 'andy', 'brian') from NamesSee possible answers