-->
SQL Clone
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

Azure – SQL Database Premium RS

A very quick post for today, I was navigating my way through the Azure portal within my SQL databases section and came across an edition that I had never seen before and I became very intrigued. It is called Premium … Continue reading

Read more

4 comments, 456 reads

Posted in All About SQL on 28 March 2017

SQLBits 2017

I have never been to SQLBits (https://sqlbits.com/) before (due to budgets) but I am really looking forward to attending which is just over a week away. The Data Platform has evolved so much and this is the chance to get … Continue reading

Read more

0 comments, 198 reads

Posted in All About SQL on 27 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, 289 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

10 comments, 326 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, 219 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, 258 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, 272 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, 263 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

3 comments, 233 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, 241 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, 264 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

2 comments, 257 reads

Posted in All About SQL on 1 March 2017