Once again, I have the opportunity to attend to this wonderful conference in Seattle, fully of new information about our loved database server.
Let’s try to summarize the new information I already saw in the first day and put here some links to you, so you can follow these news and I hope to fill you with the desire to be here next year.
- Polybase isn’t only a tool for PDW anymore, it’s in all SQL editions now, allowing us to query hive and sql server together. More Details: https://msdn.microsoft.com/en-us/library/mt143171.aspx
- R is executed inside SQL server. It’s built in now, we can use sp_execute_external_script to run R script. A link about it: http://blog.revolutionanalytics.com/2015/10/previewing-using-revolution-r-enterprise-inside-sql-server.html
- Always Encrypted has an easy wizard to encrypt only the field you choose finishing with the man-in-the-middle vulnerability. One link about it: https://msdn.microsoft.com/en-us/library/mt163865.aspx
- Always on can do a load balance between secondary readable replicas. Here you can see how to configure it: https://t.co/mh89MA3VAq
- Basic Always on is available in standard edition. This is very good, now it can truly replace mirroring. Brent wrote about this: http://www.brentozar.com/archive/2015/06/how-to-set-up-standard-edition-alwayson-availability-groups-in-sql-server-2016/
- Always on in windows server 2016 can be implemented without a domain. I didn’t attend to this session, if you have a link about this, please, comment. I think it’s only the basic always on.
- Reporting Services was redesigned using HTML 5 to support mobile, you can see more details here https://t.co/cQnTSdIfSB . There are some information about DataZen inside reporting server and R and Reporting Server, but I didn’t attended to this session. If you have more details, please, comment the link.
- Cortana analytics seems to be awesome, the sessions about it are today: https://t.co/X5WhA6omY6
Powerbi hands on
The powerbi hands on was very good and it’s available, you can download now, open the pdf and execute the steps in your machine, takes only one hour. Download from here: https://t.co/UdOFVvUtPs . When I have the full day version, I will update here.
Elastic Database pools
Now you can create a pool for SQL Azure database and it will scale up or down automatically. You can create one pool for databases or put several database in the same pool. A link about this feature: https://azure.microsoft.com/en-us/documentation/articles/sql-database-elastic-pool/
Elastic Database tools
This is a set of tools for .NET to help in a scenario of SaaS. The demo was a ticket service that was offered to several clients. Each client, owner of a theater, needs to have a different database. When the client connects to the server, this tool can check where the database is for this client and make the connection to the correct database. Link about this tool: https://azure.microsoft.com/en-us/documentation/articles/sql-database-elastic-scale-get-started/
Elastic Database queries
You can map several distinct databases as external data in a SQL Azure database and do queries across several databases. It’s a few similar with linked servers. The databases doesn’t need to be in SQL Azure, they can be anywhere. More on Elastic Database Queries: https://t.co/MXWkXkPyDn
Elastic Database Jobs
Completing the elastic scenario, you can run jobs across several databases. You will need this to keep the database schema updated. When you need to update the schema, you can create a job with the script to run in all the databases. More about Elastic Database Jobs: https://t.co/zARO3q1cg4