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

vCore based performance levels are very new, currently in preview and not yet rolled out to all Azure regions (The preview is not available in the following regions: West Europe, France Central, UK South, and UK West.). It does offer a totally different approach to sizing your database.

It is… Read more

2 comments, 169 reads

Posted in All About SQL on 16 April 2018

Azure SQL DW – Let’s Shuffle?

Initially, the main focus of this post was going to be quick and about using the latest version of SSMS (SQL Server Management Studio) to check out execution plans for Azure SQL Data warehouse (DW). I got a little side tracked by a certain operation called – SHUFFLE, because, I… Read more

1 comments, 563 reads

Posted in All About SQL on 12 April 2018

Azure SQL Database and Columnstore Indexes

I have come to understand the importance of using columnstore indexes when my queries are aggregating and scanning across many millions of rows.

Since I mostly work with Azure SQL Database I was pretty exciting to hear about columnstore support in the standard tier, more specifically S3 and above. Why… Read more

1 comments, 1,576 reads

Posted in All About SQL on 9 April 2018

4 Improvements to Azure SQL Database

If I was a wizard I would make these 4 improvements to Azure SQL Database. They are in no particular order, in fact I could come up with about 10 features / improvements that I would like to see  but I think 4 will be suffice. Some are more realistic… Read more

1 comments, 1,917 reads

Posted in All About SQL on 5 April 2018

Azure SQL Database – Failed to Delete Database Nightmare

After demo building and testing features out within Azure SQL Database I like to delete the databases to save costs. Very rarely the following happens when trying to delete a database within Azure.

The Error

Failed to delete the database: TestDB. ErrorCode: 400 ErrorMessage: Database ‘TestDB’ cannot be deleted because… Read more

2 comments, 173 reads

Posted in All About SQL on 3 April 2018

Database Has Been Paused

I was looking forward to do some work with Azure SQL Data Warehouse (DWH) when I hit the new query button and had the following message pop up –

Cannot connect to database when it is paused. (.Net SqlClient Data Provider)

I totally forgot that with Azure SQL DWH you… Read more

1 comments, 1,947 reads

Posted in All About SQL on 27 March 2018

Backup and Restore Options for Azure SQL DB

I have decided to do a summary blog post on backup and recovery options for Azure SQL Database. If you have a DBA background, you will know the importance of securing backups for your SQL Server databases. We have many options to do such a thing; being full, differential, log… Read more

2 comments, 373 reads

Posted in All About SQL on 26 March 2018

SQL Vulnerability Assessment for Azure SQL Database

Back in September 2017 Microsoft announced a new security feature for Azure SQL Database called the SQL Vulnerability Assessment (VA). It is currently in preview mode where it has the ability to find, you can guess, security based vulnerabilities for your database such as misconfigurations, excessive permissions, and exposed sensitive… Read more

4 comments, 706 reads

Posted in All About SQL on 22 March 2018

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,530 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, 495 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,902 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, 663 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,581 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

3 comments, 223 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, 792 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,056 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, 170 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, 378 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,316 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, 662 reads

Posted in All About SQL on 4 January 2018

Older posts