-->
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 SQL Database and Cost Threshold for Parallelism

We all know that the magic figure for cost threshold for parallelism is 5 by default, meaning if the estimated cost of a query is greater than 5 it may very well generate a parallel plan.

Does this apply to Azure SQL Database? Let’s check.

SELECT @@VERSION

SELECT * FROM…

Read more

3 comments, 1,667 reads

Posted in All About SQL on 16 March 2018

Understanding DBCC FLUSHAUTHCACHE

This command only applies to Azure SQL Database, at a high level it empties the database authentication cache for logins and firewall rules for the current USER database.

In Azure SQL Database the authentication cache makes a copy of logins and server firewall rules which are in the master database… Read more

1 comments, 554 reads

Posted in All About SQL on 14 March 2018

Azure SQL Database – Allow Azure Services to Access Server

When you create a “logical” Azure SQL Server (I say logical because we are not really physically creating anything) there is a setting that is ticked ON by default which is called “Allow Azure services to access server”.

The question is, what does it mean? (See the highlighted section below) Read more

3 comments, 1,989 reads

Posted in All About SQL on 1 March 2018

How to setup Azure SQL Analytics

I am a big fan of this feature, I have written and spoken about it before ( https://blobeater.blog/2018/01/04/azure-sql-analytics/) but I did not cover HOW to set this up. In the previous post mentioned above all I stated was:

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

Read more

2 comments, 741 reads

Posted in All About SQL on 26 February 2018

Saving Costs in Azure

Nobody wants to waste money and being in the cloud is no exception! Luckily for us Azure is very efficient in tracking usage patterns and its associated costs, in this case, potential cost savings.

You can find this information under Help + Support.

Then you will need to navigate to… Read more

0 comments, 1,662 reads

Posted in All About SQL on 15 February 2018

Azure SQL Database sa Connections?

I was using a query on one of my local SQL Servers where I wanted to know what logins were connected to my databases. I actually ended up running the query against my Azure SQL Database and had some very interesting results.

 SELECT login_name ,COUNT(session_id) AS session_count
FROM sys.dm_exec_sessions
GROUP…

Read more

4 comments, 305 reads

Posted in All About SQL on 7 February 2018

Deleting Azure SQL Database VNETs

This is quite a new feature (currently in preview) but an important one where we now have the ability to  isolate connectivity to a database to only a given subnet or set of subnets within your VNET. This is not a theory based blog post but a practical one, setting… Read more

0 comments, 858 reads

Posted in All About SQL on 29 January 2018

The world of Automatic Tuning – SQL Server 2017

Times are changing, 10 years ago I would never have thought that self-tuning databases would be available as a packaged product. I was testing out SQL Server 2017 Automatic Tuning recently and I ended up with the following situation. Below shows an image from the query store.

Before we begin… Read more

3 comments, 2,211 reads

Posted in All About SQL on 22 January 2018

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, 202 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, 450 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

1 comments, 1,392 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

2 comments, 797 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, 535 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, 463 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, 215 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

1 comments, 510 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,361 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

8 comments, 1,291 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, 272 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

3 comments, 368 reads

Posted in All About SQL on 23 November 2017

Newer posts

Older posts