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

SQL Server 2017 – SELECT INTO [A SPECIFIC FILEGROUP]

Forget about Adaptive Query Processing for a minute, what other feature have I been waiting for? SELECT INTO a specific filegroup, not the default filegroup! I have needed this feature many times in the past. Let’s take a look at it using the WideWorldImportersDW database.

SELECT INTO [A SPECIFIC FILEGROUP] Read more

1 comments, 109 reads

Posted in All About SQL on 19 June 2018

Azure SQL DB – Login failed for user NT AUTHORITY\ANONYMOUS LOGON.

Now that I have your attention with a powerful title how about some context? It is quite common to get this error message when trying to connect to your Azure SQL Database which obviously resides on a “logical” SQL Server.

For this specific example I was trying to connect to… Read more

1 comments, 125 reads

Posted in All About SQL on 15 June 2018

Azure SQL Database – Stairway Series

Hello all – I am excited to announce that I will be doing a Stairway series on Azure SQL Database hosted over at SQLServerCentral.com.

The aim of this series is to start gently and is very much intended for readers that have zero knowledge of Azure.  Over the series… Read more

0 comments, 147 reads

Posted in All About SQL on 13 June 2018

Linked Server to Azure SQL Database

You may (or may not) have a requirement to setup a linked server to Azure SQL Database from a locally installed SQL Server. One reason could be to pull down some reports from an Azure SQL Database to a local file share. Whatever your reason is hopefully you will find… Read more

2 comments, 1,585 reads

Posted in All About SQL on 5 June 2018

Azure SQL Database – The Default Isolation Is?

So what is the default isolation level for Azure SQL Database? I ran the following code to check it out.

CREATE DATABASE CRMDB
(
EDITION = 'BASIC',

MAXSIZE = 2GB
)

SELECT name, snapshot_isolation_state, is_read_committed_snapshot_on
FROM sys.databases
WHERE name = 'CRMDB'

Or you can use this DBCC command.

DBCC useroptions…

Read more

2 comments, 161 reads

Posted in All About SQL on 30 May 2018

Azure SQL Database / SQL Server – Paused Index Rebuild

I was creating some demo non-clustered indexes in one of my Azure SQL Databases and received the following warning when I executed this code:

CREATE NONCLUSTERED INDEX [dbo.NCI_Time]
ON [dbo].[Audit] ([UserId])
INCLUDE ([DefID],[ShopID])

Msg 10637, Level 16, State 3, Line 7

Cannot perform this operation on ‘object’ with ID 1093578934… Read more

1 comments, 1,655 reads

Posted in All About SQL on 22 May 2018

Handy TSQL for Azure SQL Database

I do not always use the Azure portal to make database changes or to check for certain information. I use it a lot of for blogging purposes but for some tasks I rather just run code via SSMS – SQL Server Management Studio.

Like what?

Creating a database

Very easy… Read more

0 comments, 200 reads

Posted in All About SQL on 14 May 2018

Extended Events – Using Azure Storage

Last year I wrote about Azure SQL Database extended events (https://blobeater.blog/2017/02/06/using-extended-events-in-azure/)  and gave an example where I was capturing deadlocks via the ring buffer. Ever since then I wanted to do a follow-up post but using Azure storage as the … Continue reading

Read more

2 comments, 1,257 reads

Posted in All About SQL on 8 May 2018

Getting my Twitter Data via Azure Logic Apps

As a mini project I wanted to use Azure logic apps to pull tweets from my twitter account when people were tweeting about #Azure / #Microsoft. From here I used cognitive services – sentiment analysis API which returns a numeric … Continue reading

Read more

4 comments, 208 reads

Posted in All About SQL on 2 May 2018

Azure SQL Database – A Copying “Gotcha”

Creating copies of your Azure SQL Database is a common and relatively simple process. You can issue a TSQL statement on the master database such as: Now, I was looking at the following code. You would think this is okay? … Continue reading

Read more

2 comments, 191 reads

Posted in All About SQL on 24 April 2018

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 … Continue reading

Read more

2 comments, 1,908 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 … Continue reading

Read more

1 comments, 664 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 … Continue reading

Read more

1 comments, 1,907 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 … Continue reading

Read more

2 comments, 2,023 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: … Continue reading

Read more

2 comments, 225 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 … Continue reading

Read more

1 comments, 2,041 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 … Continue reading

Read more

2 comments, 440 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, 794 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,624 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, 535 reads

Posted in All About SQL on 14 March 2018

Older posts