Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

The DBA Who Came In From The Cold

I’m Andrew Pruski and I am a SQL Server DBA with 5 years experience in database development and administration.

The online SQL Server community has helped me out immensely throughout my career, whether from providing reference material in blog posts, or answering my (sometimes obscure) questions on forums. So, to try and say thank you, I would like to contribute my own experiences in the hope that they could benefit someone out there.

So here’s my general ramblings and thoughts about working as a SQL Server DBA.

You can find me on twitter @DBAFromTheCold

If you have any feedback on my blog please send me an email to dbafromthecold@gmail.com.

Book Review – SQL Server Internals: In-Memory OLTP by Kalen Delaney

The new SQL Server 2014 feature In-Memory OLTP (code-named “Hekaton”) has been attracting a lot of interest since its release, promising to deliver (if you believe the rhetoric) an increase of up to 100 times in performance.

If you’re like me, you’ve got a copy of SQL Server 2014 Developer… Read more

0 comments, 138 reads

Posted in The DBA Who Came In From The Cold on 9 December 2014

Video – Identifying large queries using Extended Events

A couple of weeks ago I was contacted by Webucator (an online training company) asking if they could use my blog post “Identifying Large Queries using Extended Events” for a video training session in their free series called SQL Server Solutions from the Web.

The main reason… Read more

0 comments, 1,458 reads

Posted in The DBA Who Came In From The Cold on 5 December 2014

Blogging for a year!

I’m actually quite proud of the fact that I’ve now been doing this for a year now (and that I’m still going).

So one year on, what have I learnt?

Syndicate
Get your blog syndicated with other, larger websites. The amount of views my blog got went through the roof… Read more

4 comments, 118 reads

Posted in The DBA Who Came In From The Cold on 7 November 2014

Cardinality Estimation in SQL Server

Each time you view a seek/scan operator in an execution plan, you may have noticed that there’s a value for the estimated number of rows and a value for the actual number of rows. Sometimes these values can be fairly similar and sometimes they can be very different.

The estimated… Read more

0 comments, 145 reads

Posted in The DBA Who Came In From The Cold on 4 November 2014

Identifying large queries using Extended Events

Following on from my last blog post I now want to run through how to identify large queries using Extended Events.

Extended Events were introduced in SQL Server 2008 and allow monitoring to be run against a server with a lower performance impact than profiler sessions and server side traces. Read more

2 comments, 6,693 reads

Posted in The DBA Who Came In From The Cold on 1 October 2014

Identifying large queries using Server Side Traces

Who are your worst offenders? By offenders I mean, queries that are consuming the most resources on your server(s).

I know Extended Events have a lower impact but I like server side traces. Not only because once you’ve set one up, setting up others is very simple but also because… Read more

4 comments, 6,745 reads

Posted in The DBA Who Came In From The Cold on 11 September 2014

The Art of Performance Tuning

Performance tuning often gets called an art as people feel that a certain knack or innate talent comes into play. And whilst I don’t disagree that a certain level of knowledge is involved, I completely disagree that only certain people can performance tune.

Given the correct approach, anyone should be… Read more

1 comments, 7,277 reads

Posted in The DBA Who Came In From The Cold on 28 August 2014

Website Pulse

Short blog post this time as Website Pulse contacted me a few weeks ago with a few questions about working as a DBA. They’ve now published the article, it can be found at the following link:-

http://www.websitepulse.com/blog/for-dbas-think-of-backup-strategies-as-restore-strategies

Let me know if you have any comments or feedback – dbafromthecold@gmail.com


Read more

1 comments, 207 reads

Posted in The DBA Who Came In From The Cold on 31 July 2014

Partitioning Basics – Part 3 – Switching Data

This post follows on from Partitioning Basics – Part 2

In this final part, I want to go through how partitions can be used to archive data from a table. Firstly a table to archive the data from the primary table needs to be created:-

CREATE TABLE dbo.[DemoPartitionedTable_Archive]
(DemoID			INT…

Read more

0 comments, 1,973 reads

Posted in The DBA Who Came In From The Cold on 20 June 2014

Partitioning Basics – Part 2 – Splitting/Merging Partitions

This post follows on from the previous post Partitioning Basics – Part 1

Let’s have a look at the partitions setup in part 1, the following script will show the partition information:-

SELECT 
	t.name AS TableName, i.name AS IndexName, p.partition_number, 
	r.value AS BoundaryValue, p.rows
FROM 
	sys.tables AS t
INNER JOIN…

Read more

2 comments, 359 reads

Posted in The DBA Who Came In From The Cold on 12 June 2014

Partitioning Basics – Part 1 – Creating Partitions

Partitioned tables can be a quick and efficient way to (amongst other things) archive data. In the next couple of posts I will run through the basics of partitioning. Starting with setting up a partitioned table and loading some data.

Let’s create a demo database:-

USE [master];
GO

IF EXISTS(SELECT…

Read more

4 comments, 2,674 reads

Posted in The DBA Who Came In From The Cold on 4 June 2014

Error Log Management

Thought I’d write a quick post about managing error logs within SQL Server. Good error log management is essential for investigating issues that occur in SQL Server. The last thing you want is a very large error log file that takes ages to open when you are trying to determine… Read more

0 comments, 318 reads

Posted in The DBA Who Came In From The Cold on 9 May 2014

Database Design Guidelines For Developers

One of the developers that I work with asked me to write a “brief” (really brief) guide on database design. What I have written below is a summary in bullet point form of best practices when creating databases, tables, indexes, and then querying the data within. It is designed to… Read more

8 comments, 5,506 reads

Posted in The DBA Who Came In From The Cold on 3 April 2014

SQL Server 2014 RTM

The new version of SQL Server will be here on Tuesday.

(Someone at Microsoft has a sense of humour in releasing the newest version of SQL Server on April Fool’s Day.)

At some point the usual argument about when a company should upgrade will be had. I’ve worked companies that… Read more

0 comments, 508 reads

Posted in The DBA Who Came In From The Cold on 30 March 2014

Index Fragmentation

So you’ve setup a bunch of indexes in your database to tune the queries coming in. They’re all running much faster than before and you’re leaning back in your chair feeling pretty pleased with yourself. You’re done right?

Well…no. As data gets inserted into and deleted from tables within a… Read more

3 comments, 948 reads

Posted in The DBA Who Came In From The Cold on 13 March 2014

Who are your victims?

Or….deadlock notifications.

In my previous post I talked about having your own database(s) and what information you could be collecting. One piece of information that you should be collecting is what deadlocks are occurring. There are a few of ways you can collect information on deadlocks, enabling trace flag 1222… Read more

0 comments, 93 reads

Posted in The DBA Who Came In From The Cold on 11 February 2014

Your own personal space

Somewhere to relax, get away from it all (by all I mean pesky Developers wanting code deployed on a bleeding Friday afternoon) and generally unwind. Your worries seem to drift off until there’s a bang on the door…there’s been an issue in Production and you need to investigate. You heave… Read more

0 comments, 111 reads

Posted in The DBA Who Came In From The Cold on 30 January 2014

Shutting down multiple servers with Powershell

I’ve recently helped a company move their infrastructure to a new data centre. Part of this involved shutting down a large number of virtual development application servers. I don’t often shut down servers (maybe an occasional bounce after patching) so I thought about how I wanted to approach it as… Read more

0 comments, 88 reads

Posted in The DBA Who Came In From The Cold on 9 January 2014

Happy New Year!

Happy New Year!

Hope you all had a good Xmas, ate too much, drank too much and are still telling yourselves that this year you will stick to your New Year’s resolutions (ha).

I didn’t blog in December because…I moved to Ireland to start a new job. I’ve always wanted… Read more

0 comments, 69 reads

Posted in The DBA Who Came In From The Cold on 2 January 2014

Disaster Recovery Planning

As a SQL Server DBA it is absolutely vital you regularly take backups of the databases you look after. If something goes wrong, a restore is required and there is no (valid) backup, guess who will get the blame? You really don’t want to be sitting in a meeting with… Read more

0 comments, 85 reads

Posted in The DBA Who Came In From The Cold on 26 November 2013

Older posts