Group items tagged

Filter: All | Bookmarks | Topics Simple Middle

Moving Your SQL Databases to Azure - Things to Know - The Microsoft MVP Award Program B... - 0 views

blogs.msdn.com/...s-to-azure-things-to-know.aspx

sql azuresql azure cloud bi

shared by Chris Stanley on 21 Sep 15 - No Cached

COMPARISON WITH ON-PREMAzure SQL is SQL Server behind the scenes, so most of the functionality is already there including tables, views, stored procedures, triggers, functions, primary and foreign keys and clustered indexes.
...

Cancel
Of course there is no Windows authentication, and it currently uses SQL authentication only.
...

Cancel
There is no to need maintain, balance, upgrade or patch the server as this is all done by Microsoft.
...

Cancel
...14 more annotations...
You also can't reboot the server, so if you end up with a runaway query you may have to open a support ticket.
...

Cancel
There are always 3 copies of the database for high availability during disaster recovery.
...

Cancel
There is a requirement for tables in a SQL Azure database to have a clustered index. This is necessary to keep the 3 copies of the database in sync.
...

Cancel
The maximum SQL Azure database size is currently 500GB, but you can get around this using SQL federations and partitioning your data across multiple nodes.
...

Cancel
There are a number of partially supported and unsupported features. A few of the ones I run into regularly are:• You cannot use the USE [databasename] sql statement. You must physically switch between databases in your application. • Remove from indexes - NOT FOR REPLICATION• Remove from your tables - WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] You can review a full list of unsupported features here: https://azure.microsoft.com/en-us/documentation/articles/sql-database-transact-sql-information/
...

Cancel
When I migrate a database from SQL to SQL Azure, I typically follow this process using SSMS: • Create a blank database on the SQL Azure database server• Generate the scripts from the original database to create the database objects, excluding users• Do a find and replace to remove any unsupported features such as the two mentioned above• Run the create database object scripts against the new SQL Azure database• Create the users and apply permissions for the new database• Use SSMS or SSIS to copy the data over to the new database.
...

Cancel
The SQL Database Management Portal is a web based, scaled down version of SSMS. You can create objects, and run queries and execution plans. But there is no GUI interface for some of the security features like creating users and logins. I find that it's a friendlier experience to create the database server in the portal, and do everything else using SSMS.
...

Cancel
SQL Azure databases are protected by an automatic backup system.
...

Cancel
The length of time the backups are retained depends on what tier you buy – 7 days for Basic, 14 days for Standard and 35 days for Premium.
...

Cancel
The point-in-time restore is a self-service feature that costs you nothing unless you use it. If you use it, you pay regular rates for the new database that gets restored. You get all of the protection without any additional cost.
...

Cancel
SECURITY You are in complete control the IP specific access to SQL Azure Database, at both the server AND database level. No one has access by default.
...

Cancel
every time your IP changes, you have to update your firewall rules.
...

Cancel
SERVICE TIERS AND PERFORMANCE LEVELS There are three tiers, with several levels of performance within them. I will summarize the Microsoft definitions.• Basic: Best suited for a small size database, supporting typically one single active operation at a given time.• Standard: The go-to option for most cloud applications, supporting multiple concurrent queries.• Premium: Designed for high transactional volume, supporting a large number of concurrent users and requiring the highest level of business continuity capabilities.
...

Cancel
Costs can range anywhere from $7 per month for the Basic tier, $19 - $183 per month for a 250GB database in the Standard tier, to $566 to $8500 per month in the Premium tier.
...

Cancel

Partners Say New Azure Machine Learning Service Could Be Microsoft's Secret Weapon In T... - 0 views

www.crn.com/...secret-weapon-in-the-cloud.htm

azure machine learning microsoft cloud statistics bi data analytics

shared by Chris Stanley on 28 Aug 14 - No Cached

Azure Machine Learning is a public cloud-based service that lets developers embed predictive analytics into their applications
...

Cancel
Machine learning software has been around for years but isn't easy to use or deploy, and it's also expensive, Sirosh said. Packaging up machine-learning-as-a-cloud service solves these problems, and by being first to bring it to market, Microsoft has a head start on the likes of Google, Amazon and IBM, he said. "I think, on this particular front, that we are the leaders," Sirosh told CRN.   
...

Cancel
Hiring Sirosh was something of a coup for Microsoft. He joined last July from Amazon, where he spent close to nine years as a vice president in various machine-learning-related roles.
...

Cancel