-->
Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

All About SQL

I am a Senior DBA with interest in MS technology especially SQL Server and Azure. During 2015 I was mentored by Paul Randal – Data Platform (SQL Server) MVP and during 2016 I completed my SQLskills Immersion training on Internals and Performance Tuning. When I am not working I am in the gym burning calories.

Archives: March 2017

Why did my SQL Server database just go offline?

Note: This post contains a video clip where I show quirky behaviour of the scripted offline task. Personally I rarely use SQL Server Management Studio GUI to do day-to-day tasks, I rather just load a window and start typing stuff … Continue reading

Read more

0 comments, 79 reads

Posted in All About SQL on 24 March 2017

My path from a junior to a senior DBA

A non-technical post but something I have been asked about few times so I thought that I would put pen to paper and tell you about my journey on becoming a senior DBA. You might find it fun to read. Time … Continue reading

Read more

3 comments, 157 reads

Posted in All About SQL on 22 March 2017

TDE: Looking inside your database and backups

TDE (Transparent Data Encryption) encrypts the data files at rest but don’t forget that it also encrypts your backup file too. I fancied looking inside the MDF and a backup of my database before enabling TDE and comparing it to … Continue reading

Read more

1 comments, 104 reads

Posted in All About SQL on 20 March 2017

Corrupt Database – I need that data now!

My database is in the recovery pending state and I want to get in and extract the data out into a new database, I have NO BACKUPS available so some data (even if it is dodgy) is better than nothing. … Continue reading

Read more

3 comments, 140 reads

Posted in All About SQL on 15 March 2017

Extreme situations require extreme commands

The title is adapted from a child-hood movie of mine and is my daily (database-related) WTF moment and it is my entry for this month’s T-SQL Tuesday found: http://www.pontop.dk/single-post/2017/03/07/Announcing-T-SQL-Tuesday-88-%E2%80%93-The-daily-database-related-WTF Having a database in Recovery Pending mode is no laughing matter, … Continue reading

Read more

3 comments, 168 reads

Posted in All About SQL on 14 March 2017

My take on presenting

This idea basically started from Andy Bek’s TSQL Tuesday last year #84 growing new speakers (https://sqlbek.wordpress.com/2016/10/25/t-sql-tuesday-84-growing-new-speakers/ – thanks Andy) and I have decided to share my experiences about what was going on in my head for when I was prepping for … Continue reading

Read more

2 comments, 135 reads

Posted in All About SQL on 10 March 2017

Copying your SQL Database

If you ever need to move a copy of a  SQL database in Azure across servers then here is a quick easy way. So let’s say you need to take a copy of database called [Rack] within Subscription A that … Continue reading

Read more

0 comments, 130 reads

Posted in All About SQL on 7 March 2017

Blog Challenge: I am watching you!

I decided to accept Grant’s (TheScaryDBA) challenge found here- http://www.scarydba.com/2017/03/02/random-blog-post-challenge/ where we have to write a technical blog post that incorporates a certain image of a certain individual. There was someone quite mischievous on my SQL Server, I needed to find out what … Continue reading

Read more

3 comments, 127 reads

Posted in All About SQL on 3 March 2017

Tempdb settings in SQL Server 2016

A nice little error log feature that I noticed in SQL Server 2016 regarding tempdb. Tempdb, a system database in SQL Server, some call it the “public toilet” but honestly it is where temporary user objects are created, internal objects … Continue reading

Read more

1 comments, 146 reads

Posted in All About SQL on 2 March 2017

SQL Server Target vs Total Memory

For this blog post I want to discuss the meaning behind SQL Server: Memory Manager\Target Server Memory (KB) and SQL Server: Memory Manager \Total memory (KB) Perfmon counters.  I will mention how under different situations and configuration settings their behaviour … Continue reading

Read more

1 comments, 133 reads

Posted in All About SQL on 1 March 2017