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

Azure Portal – Bad Request

I had a strange issue recently when trying to login to the Azure Portal. Quite simply I would enter my login details and ended up with this message – Bad Request – Request Too Long, HTTP Error 400. The Size of the request headers is too long.

The screen shot… Read more

0 comments, 107 reads

Posted in All About SQL on 16 January 2018

T-SQL Tuesday #98 Round Up

Thank you to everyone that took the time to write and contribute, I enjoyed reading about how you conquered your challenges, here is a round-up in no particular order.

Tracy Boggiano’s story of skiing, migraines and corruption is simply fantastic. System Table corruption is no fun but where there is… Read more

2 comments, 181 reads

Posted in All About SQL on 11 January 2018

Azure SQL Database – Optimizing For Ad-hoc Workloads

Today I found out that it is now possible to enable the setting optimize for ad-hoc workloads at the database level when using Azure SQL Database. Traditionally this was always set at the server level for locally based SQL Servers.

We would usually do something like:

 sp_configure 'optimize for ad…

Read more

0 comments, 1,073 reads

Posted in All About SQL on 8 January 2018

Azure SQL Analytics

Azure SQL Analytics is currently in preview mode, still it is very impressive. The goal of this feature is to visualize important SQL performance metrics for your Azure SQL Database. There are a couple of things you need to do first.

  • Setup a Log Analytics workspace.
  • Enable diagnostics for your…

Read more

1 comments, 372 reads

Posted in All About SQL on 4 January 2018

T-SQL Tuesday #98 – Your Technical Challenges Conquered

Welcome to the January 2018 edition of T-SQL Tuesday and I am your host BlobEater (Arun Sirpal).

If you do not know  what T-SQL Tuesday is then a quick recap. T-SQL Tuesday is a monthly blog initiative hosted by a different blogger each month. This was founded by Adam Machanic… Read more

10 comments, 315 reads

Posted in All About SQL on 2 January 2018

A Basic Bot using Azure Bot Services

I wanted to break out my comfort levels and do something different from Azure SQL Database or straight SQL Server. I really did try something new and created a Chat Bot using Azure’s Bot Service. Warning: I am a DBA by day (and night) so this is a fun post… Read more

1 comments, 282 reads

Posted in All About SQL on 19 December 2017

SQL Server DBCC CHECKDB – Going Parallel

DBCC CHECKDB has the ability to perform parallel checking of objects. However, it absolutely depends on the edition of SQL Server, it only happens when using enterprise edition.

Let’s see this in action. I propose the following tests for this blog post:

  • Test on a SQL Server Enterprise Edition.
  • Test…

Read more

2 comments, 138 reads

Posted in All About SQL on 18 December 2017

SQL Server Failed to Open Loopback Connection – What?

I could not read my error log on one of my local SQL Servers, when I executed the following code:

EXEC sp_readerrorlog

I received the below:

Msg 22004, Level 16, State 1, Line 2 Failed to open loopback connection. Please see event log for more information. Msg 22004, Level 16,… Read more

0 comments, 347 reads

Posted in All About SQL on 12 December 2017

Moving to an Azure SQL Database via Command Line

I have moved many databases to Azure via different methods but I recently came across a new way. Well technically it’s not new, I should say, newly found. The migration was done via the command line which is not exactly ground breaking but it’s nice to have another option.

The… Read more

1 comments, 1,083 reads

Posted in All About SQL on 7 December 2017

Azure SQL Database – Using sp_BlitzIndex

I was doing some normal activities on one of my Azure SQL Databases, I went to make a cup of tea and returned to the following message:

The statement has been terminated. Msg 40544, Level 17, State 12, Line 15 The database ‘TestDB’ has reached its size quota. Partition or… Read more

3 comments, 1,124 reads

Posted in All About SQL on 5 December 2017

I have a new Passion

Yes, I like to blog, maybe slightly more on Azure than SQL Server. I enjoy it and it probably explains why I do about 70 posts a year. I am happy for every single reader even though my numbers are not elite I see growth and this is what motivates… Read more

0 comments, 178 reads

Posted in All About SQL on 28 November 2017

Azure SQL Database – Service Tiers

Naturally the cost of Azure SQL Database directly relates to what tier and performance level you are using. Starting from the least expensive basic database to the more premium ones I thought it would be worthwhile capturing the costs (GBP) across all tiers.

Basic 5 DTUs

Standard (S0) 10 DTUs

Read more

2 comments, 216 reads

Posted in All About SQL on 23 November 2017

SQL Server – DBCC CHECKTABLE

If you know about DBCC CHECKDB then most likely you will know about DBCC CHECKTABLE. Quite simply this command performs primitive system-catalog consistency checks, per-table consistency checks on the single table specified, and cross-table consistency checks on indexed views that refer­ence the specified table. (Page 899 Microsoft SQL Server Internals… Read more

3 comments, 175 reads

Posted in All About SQL on 20 November 2017

Azure SQL Database Alerting

It’s good to be proactive and one way is to setup alerts and it is no different when using Azure SQL Database. I like creating alerts for my Azure SQL Databases and I encourage you to do the same.

I keep things simple and like to look at certain performance… Read more

4 comments, 294 reads

Posted in All About SQL on 16 November 2017

Folks Who Have Made a Difference

TSQL Tuesday time hosted by Ewald (https://sqlonice.com/tsql-tuesday-96-folks-who-have-made-a-difference/) and quite simply one man has morphed me into who I am today – Paul Randal. Over two years ago I was a one of many that had the chance to be mentored by him. It lasted just under one year… Read more

3 comments, 166 reads

Posted in All About SQL on 14 November 2017

SQL Server 2017 – Interleaved Execution

I worked on testing interleaved execution with Microsoft back in January, I didn’t do much, just tested the functionality against some in-house code we had. (If you need a detailed primer on the subject, please see https://blogs.msdn.microsoft.com/sqlserverstorageengine/2017/04/19/introducing-interleaved-execution-for-multi-statement-table-valued-functions/)

As the article states it “changes the unidirectional boundary between the optimization… Read more

2 comments, 569 reads

Posted in All About SQL on 9 November 2017

Azure SQL Database Compatibility Levels

Let’s start off with a quick overview of SQL Server versions and compatibility levels.

  • 100 = SQL Server 2008 and Azure SQL Database
  • 110 = SQL Server 2012 and Azure SQL Database
  • 120 = SQL Server 2014 and Azure SQL Database
  • 130 = SQL Server 2016 and Azure SQL Database

Read more

2 comments, 227 reads

Posted in All About SQL on 6 November 2017

Microsoft MVP!?

What? Is probably the most common reply out there and if it is then that is how I felt when I read the message early Thursday morning.

My ultimate goal in my professional life was to work for Microsoft, you can read about my failed attempt here https://blobeater.blog/2016/09/29/my-application-to-microsoft/ but since… Read more

5 comments, 273 reads

Posted in All About SQL on 2 November 2017

Azure SQL Database Automatic Tuning – Questions Answered

I used to be on the fence regarding whether or not Automatic Tuning should be on as the default when creating Azure SQL Databases. A part of me never liked the idea of Azure creating/dropping indexes or forcing plans without my prior approval but then again if it happens to… Read more

2 comments, 214 reads

Posted in All About SQL on 1 November 2017

SQL Server Phantom Reads

With Halloween around the corner what better topic to discuss than phantom reads. A phantom read occurs when rows have been inserted after a read operation and becomes visible in a follow-up read operation within the same transaction.

I will show you what this looks like with an example. Please… Read more

1 comments, 1,254 reads

Posted in All About SQL on 26 October 2017

Older posts