-->
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.

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

0 comments, 86 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, 84 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, 174 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, 168 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, 110 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, 145 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, 177 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, 139 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, 133 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, 133 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, 152 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, 139 reads

Posted in All About SQL on 1 March 2017

SSMS Presenter Mode

SQL Server Management Studio (SSMS) release candidate 17.0 RC2 works side-by-side with generally available releases (16.x), but it is not recommended for production use. There are many enhancements which you can read here: https://docs.microsoft.com/en-us/sql/ssms/sql-server-management-studio-ssms-release-candidate but there is one feature I … Continue reading

Read more

1 comments, 189 reads

Posted in All About SQL on 22 February 2017

SQL Server vNext: sys.dm_db_stats_histogram

Since installing SQL Server vNext CTP 1.3 I found out that there is a new way to return statistics histogram for a specific stat which actually is also available with the latest Cumulative Update for SQL Server 2016 Service Pack … Continue reading

Read more

1 comments, 134 reads

Posted in All About SQL on 21 February 2017

Setting up SQL Server to SQL Database (Azure) Replication

I had a need to setup transactional replication from my SQL Server to SQL Database (Azure) where I only needed a selection of tables that I wanted to off-load to Azure.  For this post I will be going through the … Continue reading

Read more

1 comments, 165 reads

Posted in All About SQL on 20 February 2017

True story: Encryption in progress stuck

Working with a couple of databases that needed TDE I noticed when I enabled one of them that it was stuck on “encryption in progress” for quite a while. Using the following query I confirmed the following: (source: https://msdn.microsoft.com/en-us/library/bb677274.aspx) My … Continue reading

Read more

1 comments, 159 reads

Posted in All About SQL on 16 February 2017

Azure Advisor Recommendations

Logging into the Azure portal is a daily task of mine and my eyes light up when I see features in preview mode. With that being said Azure Advisor Recommendations is what I will be writing about today. What is … Continue reading

Read more

1 comments, 147 reads

Posted in All About SQL on 15 February 2017

Lightweight Statistics Profiling (with a potential bug)

The great thing about new versions of SQL Server is the fact that they are packed full of new features but there some that don’t really get talked about much. I found out about a concept called lightweight query execution … Continue reading

Read more

1 comments, 208 reads

Posted in All About SQL on 13 February 2017

Using Extended Events in Azure

Over the past 6 months I have been trying to push myself to use extended events (XEvents) over SQL trace, once you get past the learning curve it’s probably the way to go. If you are operating in the Azure … Continue reading

Read more

2 comments, 815 reads

Posted in All About SQL on 6 February 2017

SQL Server vNext

I have been pretty busy recently working with Joe Sack from Microsoft and  getting my hands dirty with SQL Server vNext accessing some cool stuff (which obviously I can’t talk about – under NDA) and believe me it is pretty … Continue reading

Read more

1 comments, 455 reads

Posted in All About SQL on 3 February 2017

Older posts