The DBA Who Came In From The Cold

Performance tuning often gets called an art as people feel that a certain knack or innate talent comes into play....

2014-09-04 (first published: 2014-08-28)

8,779 reads

Website Pulse

by Andrew Pruski

The DBA Who Came In From The Cold

Short blog post this time as Website Pulse contacted me a few weeks ago with a few questions about working...

2014-07-31

1,169 reads

Partitioning Basics – Part 3 – Switching Data

by Andrew Pruski

The DBA Who Came In From The Cold

This post follows on from Partitioning Basics – Part 2
In this final part, I want to go through how partitions can...

2014-06-24 (first published: 2014-06-20)

3,222 reads

Partitioning Basics – Part 2 – Splitting/Merging Partitions

by Andrew Pruski

The DBA Who Came In From The Cold

This post follows on from the previous post Partitioning Basics – Part 1
Let’s have a look at the partitions setup in...

2014-06-12

1,035 reads

Partitioning Basics – Part 1 – Creating Partitions

by Andrew Pruski

The DBA Who Came In From The Cold

Partitioned tables can be a quick and efficient way to (amongst other things) archive data. In the next couple of...

2014-06-09 (first published: 2014-06-04)

5,060 reads

Error Log Management

by Andrew Pruski

The DBA Who Came In From The Cold

Thought I’d write a quick post about managing error logs within SQL Server. Good error log management is essential for...

2014-05-09

2,357 reads

Database Design Guidelines For Developers

by Andrew Pruski

The DBA Who Came In From The Cold

One of the developers that I work with asked me to write a “brief” (really brief) guide on database design....

2014-04-07 (first published: 2014-04-03)

25,712 reads

SQL Server 2014 RTM

by Andrew Pruski

The DBA Who Came In From The Cold

The new version of SQL Server will be here on Tuesday.
(Someone at Microsoft has a sense of humour in releasing...

2014-03-30

1,505 reads

Index Fragmentation

by Andrew Pruski

The DBA Who Came In From The Cold

So you’ve setup a bunch of indexes in your database to tune the queries coming in. They’re all running much...

2014-03-13

2,464 reads

Who are your victims?

by Andrew Pruski

The DBA Who Came In From The Cold

Or….deadlock notifications.
In my previous post I talked about having your own database(s) and what information you could be collecting. One...

2014-02-11

581 reads

The DBA Who Came In From The Cold

The Art of Performance Tuning

Website Pulse

Partitioning Basics – Part 3 – Switching Data

Partitioning Basics – Part 2 – Splitting/Merging Partitions

Partitioning Basics – Part 1 – Creating Partitions

Error Log Management

Database Design Guidelines For Developers

SQL Server 2014 RTM

Index Fragmentation

Who are your victims?

Blogs

A New Word: Amoransia

The Data API Builder Start and Add Extensions in VS Code

Using OneLake for Excel Files in Microsoft Fabric

Forums

Technical Pain Behaviors

trying to call powershell from TSQL statement

Counting Bits

Question of the Day

Counting Bits