[EN] T-15 minutes to start (but T-7 weeks)

8:45 AM. Friday. Yes! T-15 minutes to start. Exactly in seven weeks at the same time (almost ‘cos not Leicester, but Utrecht time zone) I will start to countdown for my workshop before SQL Saturday No 434 in Utrecht (Netherland). Two more great workshops will be delivering in the same time in different rooms and all three workshops will be provided by SQL Server MVPs:

  • Hugo Kornelis {T|B}Understanding Execution Plans – L.400
  • Dejan Sarka {T|B}Data Mining Algorithms in SQL Server, Excel, R and Azure ML – L.300

My workshops will be a complement for both workshops above. Not only with levels – we will cover all standard levels 200/300/400; but with subjects too – dba,performance/bi, data mining/dba, cloud:

  • Tobiaz KoprowskiWASD-A Journey from Zero to be Hero – L.200

It will be my second workshop about Windows Azure SQL  Database (ater full workshop in Kiev almost year ago: http://bit.ly/1DyHQw0 ) and before next one in Southampton (pssst is not annouced yet). I’m very happy to be selected few weeks ago, and actually working with preparation for this workshop. Full desciption for it are below:

LOGO__SQLSaturday434Windows Azure SQL Database and our Journey from Zero to be Hero. Four years on the market, continuously changing, but still not good enough recognizable. in AD2015 is right time to change this. With a full day Pre-Conf we start on our Premise instances, next we touch the Sky, and as parachute masters we will back to the Earth. On my full day Pre-Conf I want to show you how we can work with Windows Azure SQL Database (formerly known as SQL Azure) and we will focus on:
• pros and cons
• differences
• place to start
• security
• tools, methods and ideas
• SWOT analyse
• backup and restore
• RPO, RTO, ROI, SLA, SLO and more
• Service Level Agreements,
• compliance and responsibility
• best and worst practices

Slides, talks and of course few hour of labs with SQL Server on Premise, SQL Server in the Cloud, In eight (or maybe nine hours) you will learn about everything what you need to start your own journey in the cloud.

Requirements for this workshop:
* Windows 8 or 8.1 (preferred) / Windows 7 is possible (but some workshop feature will not work) / Windows 10 possible too
* SQL Server 2012 minimum in Standard Edition installed (SQL Server 2014 preferred) {LINK:
http://bit.ly/1I7gEn4}
* Active Microsoft Azure Account {LINK: http://bit.ly/1n0AV52}
Each attendee will get printed slides and labs and extra materials useful materials from my special community collection.

Of course after pre-conference seminar, a standard SQL Saturday will happen and we still have place for you. You can go to sites and register for:

Logistics:

  • 25th September – Pre Conference Seminar | Van der Valk Hotel – Vianen, Prins Bernardstraat 75, 4132 XE Vianen, Nederland
  • Early Birds price 199 EUR is valid till 5th of September, after normal price 249 EUR will start
  • 26th September – Full Day Free Conference | University of Utrecht – Marinus Ruppert Building, Leuvenlaan 21, Utrecht, Utrecht, 3584 CE, Netherlands

Register, join us and have fun in Utrecht!

[EN] Improvements of SSMS for Azure Database after CU5 – part one

LOGO__SQL-Azure_rgbApplying latest Cumilative Update {build no 12.0.2456.0} for SQL Server 2014 improving your SQL Server Management Studio functionality. In few next posts I will write about some functionality which are interesting for me, and could be interesting for you.

First of few options which are very interesting for me (in the case of some demo on my sessions at conferences) are tasks SELECT and EDIT. Two fix has been delivered for two not bugs, but missing functionality:

VSTS BUG: 3548910 | KB: 3014156 | LINK: http://bit.ly/13MTeU3 
FIX: An update is available that enables "Edit Top 200 Rows" option for tables and views of SQL Azure database
VSTS BUG: 3548922 | KB: 3014166 | LINK: http://bit.ly/1Db8tCG 
FIX: An update is available that enables "Select Top 1000 Rows" option for tables and views of SQL Azure database

Let’s look how it works. Before installing update I got two databases of SQL Server: one is Adventure Works 2012 on Premise, and one is Adventure Works 2012 in Windows Azure. Using SQL Server Management Studio I trying to check my instances (in all cases I will use same table Person.Address):

Screenshot 2014-12-28 10.50.46

Pict. 01 – With AdventureWorks located in on Premise instance tasks: “Select Top 1000 Rows” and “Edit Top 200 Rows” are available by default.

Screenshot 2014-12-28 10.51.24

Pict. 02 – With AdventureWorks located on Windows Azure Server (as cloud database) bots options are not available.

Problem with missing functionality has been solved after installing Cumulative Update 5.

Screenshot 2014-12-28 19.13.49

Pict. 03 – With With AdventureWorks located on Windows Azure Server both tasks: “Select Top 1000 Rows” and “Edit Top 200 Rows” are available.

 

Second of few really great functionality is focused on deployment database for Windows Azure.

VSTS BUG: 3548883 | KB: 3014164 | http://bit.ly/1xeIWbo
FIX: Cannot use new service tiers Basic, Standard and Premium when you deploy to Windows Azure SQL Database in SSMS 2014

Again let’s look how it works. For this case I use three instances: one with SQL Server 2012 (engine version 11.xx) one with SQL Server 2014 (engine version 12.xx) and one Windows Azure instance. And I use two newly created databases:

  • TestDeploy11 located on SQL Server 2012 instance, compability mode with SQL Server 2012 (110), collation: Chinese_Traditional_Pinyin_100_CI_AS
  • TestDeploy12 located on SQL Server 2014 instance, compability mode with SQL Server 2014 (120), collation: Latin1_General_100_CI_AS

Part one (before updating) >> deploying new database from SQL Server Management Studio 2012 to Windows Azure.

Screenshot 2014-12-31 17.21.35

Pict. 04 – steps: Right Click>Task>Deploy Database to SQL Azure {I starting from SHINGEN instance which is SQL Server 2014 instance}

Screenshot 2014-12-31 17.21.52

Pict. 05 – Welcome screen (we can switch off this screen)

Screenshot 2014-12-31 17.22.07

Pict. 06 – After connecting to Windows Azure SQL Server (where I keep my azure databases) we can choose Web version with size 1 and 5 GB

Screenshot 2014-12-31 17.22.18

Pict. 07 – Or Business Edition with size: 10, 20, 30, 40, 50, 100, 150 GB

Screenshot 2014-12-31 17.22.33

Pict. 08 – On next screen we see short summary of planned deploy

Screenshot 2014-12-31 17.22.49

Pict. 09 – And here we have expected error about Operation Failed. Expected because I tried deploy databese with compability factor 120, even I use SSMS for SQL Server 2012. So, we cannot deploy SQL Server 2014 database from Management Studio 2012 to Windows Azure.

Screenshot 2014-12-31 17.23.03

Pict. 10 – Still on the same Management Studio now I tried to deploy SQL Server 2012 database to Windows Azure {I now working with MIFUNE instance which is SQL Server 2012 instance}

Screenshot 2014-12-31 17.23.21

Pict. 11 – I can choose from the same options for Web Edition and 1 & 5 GB size

Screenshot 2014-12-31 17.23.32

Pict. 12 – And of course Business Edition and 10, 20, 30, 40, 50, 100, 150 GB size

Screenshot 2014-12-31 17.23.43

Pict. 13 – You can see small difference with picture number eight, different name of database

Screenshot 2014-12-31 17.23.56

Pict. 14 – And after clicking on NEXT button deploying started

Screenshot 2014-12-31 17.24.50

Pict. 15 – And finally I have status Operation Completed and my new database is now deployed to Windows Azure.

 

Part Two (after updating) >> deploying new database from SQL Server Management Studio 2014 to Windows Azure.

Screenshot 2014-12-31 17.41.55

Pict. 16 – steps: Right Click>Task>Deploy Database to SQL Azure {I starting from MIFUNE instance which is SQL Server 2012 instance}

Screenshot 2014-12-31 17.42.28

Pict. 17 – I can choose from the same options for Web Edition and 1 & 5 GB size, but here editions are upgraded and Web Edition has status Retired

Screenshot 2014-12-31 17.42.39

Pict. 18 – And of course Business Edition and 10, 20, 30, 40, 50, 100, 150 GB size, and same as above Business Edition has status Retired

Screenshot 2014-12-31 17.43.11

Pict. 19 – And after clicking on NEXT button deploying started (with small change to avoid error: Target Database: TestDeploy11v2)

Screenshot 2014-12-31 17.45.04

Pict. 20 – And finally I have status Operation Completed  and my new database is now deployed to Windows Azure. Now I have two newly deployed databases on my Windows Azure server

Screenshot 2014-12-31 17.48.04

Pict. 21 – Same steps like on pisture number sixteen, and if you have ‘Eagle Eye’ you see that here and on picture sixteen we deploying for Windows Azure SQL Database instead of SQL Azure Database (which happened on SQL Server Management Studio 2012) {I now working with SHINGEN instance which is SQL Server 2014 instance}

Screenshot 2014-12-31 17.48.15

Pict. 22 – Almost the same welcome screen (we can switch off this screen)

Screenshot 2014-12-31 17.48.36

Pict. 23 – Now pure changes starting. First option: Basic Edition with size 1 & 2 GB, with Default Service Objective (Service Tier & Performance Level)

Screenshot 2014-12-31 17.48.55

Pict. 24 – Second option: Standard Edition with 1, 2, 5, 10, 20, 30, 40, 50, 100, 150, 200, 250 GB size

Screenshot 2014-12-31 17.49.01

Pict. 25 – Still second option but with three Service Objective levels: S0, S1, S2

Screenshot 2014-12-31 17.49.10

Pict. 26 – Third option: Premium Edition with 1, 2, 5, 10, 20, 30, 40, 50, 100, 150, 200, 250, 300, 400, 500 GB size

Screenshot 2014-12-31 17.49.15

Pict. 27 – and of course still third option but with three Service Objective levels: P1, P2, P3

Screenshot 2014-12-31 17.49.32

Pict. 28 – Summary with specification same like before

Screenshot 2014-12-31 17.51.34

Pict. 29 – And final result status Operation Completed and my new database is now deployed to Windows Azure. Now I have three newly deployed databases on my Windows Azure server.

 

Part Three >> finally three new deployed databases, I tried to deploy four databases but one was failed because of non-compability expected error.

Screenshot 2014-12-31 17.51.52

Pict. 30 – All three deployed databases are now on my Windows Azure server

image image image

Pict. 31 – Interesting point is at the end, because all my freshly deployed databases have compability level 100 (instead of 110 and 120 as  original “on premise” databases). But this is not subject of this post.

[EN] SQL Relay Autumn Tour – Day Eight

A series of short post about SQL Relay Autumn Tour in United Kingdom, where I speaking, networking, helping and doing more fun and business things. Eight day in London. Last day of two weeks tour. Nope, not two weeks: week tour – week break – week tour. Reiny morning, canceled my plan for walk, so by Picadilly Line I jump from my hostel to Buckingham Palace area, then walked and almost as a first (except Anthony Saxby) SQL Relay affected person came to Cardinal Place where is Microsoft Uk Head Quater in London. Yes, the have big campus in Reading, where you can meet folks from Coeo. But in this post I’m writing only about London’s event.

IMG_8463

Biggest event in very important place. But Victoria Square/Cardinal Place remembering me La Sagrada Familia  – neverending building process. It’s reallly anoying, but… Londoners are prepared for this, for last few years. Two rooms: Auditorium 1 and Auditorium Two – separated after Keynote (of course by Anthony Saxby) and Speaker Room and few other nice places. At the same time at Microsoft happened three or four internal meetings, Dynamyx Training, Azure Talks and something more. I really appreciate local Microsoft’s stuff – the made great, really great job. Two track and special session for me – I didn’t put it on my schedule before SQL Relay, but with free place and collaboration with Tony Rogerson I did’it! So our agenda was simple:

Keynote | Microsoft
Sponsor Sessions by Violin Memory & Pure Storage

Both Tracks: DBA Track & BI/DEV Track
SQL Server 2014 New Features (not Hekaton!) | David Williams

DBA Track
Understanding Parallelism | Christian Bolton
Dave’s SQL Fun Time Hour | David Morrison
SQL Server 20014 Hybrid Cloud Features | Scott Klein
T-SQL Performance Issues : What you should know to find and resolve them | Claire Mora
SQL Azure from Plan, to Backup to Cloud | Tobiasz Koprowski

BI Track
Using PowerPivot and DAX to predict and win Fantasy F1 | Alex Whittles
Introduction to Power BI websites | James Boother
BigData for SQL DBA’s | Alessandro Recino
Business Insight: Structure data in relational databases | Sameer Parve
Fast and Flexible Data Wrangling with Data.Table in R | Matt Dowle

We had few necomers like: David Williams {TWITTER} and Matt Dowle {LINKEDIN} but most interesting was Claire Mora {TWITTER}, because she was First Time Speaker. I had no time for attending on her session, but I’m sure I will do it next time. Last day of SQL Relay 2014 Autumn Tour. Again busy and full of work. It was special for me, because on behalf of Tony Rogerson I was proud to closing conference and whole tour on DBA Track – because Tony was able to closing it only in one room in one time. Fast but long day.