[This is part Eight of Top 10 Things You Will Hate About Azure SQL Database]
The concept of a noisy neighbor is not unique to Azure SQL Database, but in cloud computing it is the term used to describe a customer monopolizing the resources and degrading the performance for other customers. Of all the items that out of your control this one tops the list. It doesn’t mean you should rule out SQL Database, but it does need to be considered. Read more…
Next Tuesday (8/19) is the August meeting for the Minnesota chapter of the Professional Association for SQL Server (PASSMN). Our presenter this month is the Ross McNeely (twitter | blog). Ross will be presenting a Spatial Data Deep Dive going over Spatial Data types, the Bing Spatial Data Services, and Spatial Analysis. It is a topic I haven’t taken much time to dig into, but it seems like almost every company I have worked at has some sort of geospatial data.
As a part of the PASSMN Board I spend a lot of time talking about SQL and a lot of time talking about talking about SQL. (Trust me that is a real sentence.)
Each month at our user group meetings we have someone present on something that relates to our careers as SQL Server professionals and each year we host a SQL Saturday where we usually have at about 35-40 different people present. We are lucky in the Twin Cities because it isn’t usually hard to fill those spots. We have a lot of people involved in our community and many people who enjoy speaking or at least see the value in it.
[This is part Seven of Top 10 Things You Will Hate About Azure SQL Database]
That never gets old.
While I enjoy the play on words, this just means that the USE statement is not allowed in Azure SQL Database. Three part naming ([ServerName].[DatabaseName].[ObjectName]) is not valid either. You can only run queries in the context of the database you are connected to, which will need to be considered during solution design.
[This is part Six of Top 10 Things You Will Hate About Azure SQL Database]
Security is annoying. Sometimes it can be a fun puzzle to figure out the best way to align what applications and users should be able to access. However, as soon as you have all of the groups and roles set up perfectly and your database is secure, but usable, you have to change it. Now imagine trying to set that up without Windows authentication as part of the equation. Read more…
Tuesday of this week (7/15) was the July meeting for the Minnesota chapter of the Professional Association for SQL Server (PASSMN). Our presenter this month was Mike Matthews (no twitter|no blog – someone should talk to him about this). Mike presented on SQL Server I/O. I didn’t get a blog post put out before the meeting to remind people, but I am hoping to have twelve posts for PASSMN for the year. I’ll just have to reflect on how the meeting went instead of announcing what it will be about.
[This is part Five of Top 10 Things You Will Hate About Azure SQL Database]
You will hate hearing this and you will hate saying this, but you will probably say it. It is a hard argument to go against for SQL Server DBA’s because it brings back almost all of the control that you lose by selecting Azure SQL database. Read more…
Recently I have been encouraging some first time speakers to submit a session for SQL Saturday Mineesota #332. The usual first question is, “What should I talk about?” That’s not what this post is about. I may put something together on that later, but this is going to be a step by step instruction manual for how to submit a session. With screen shots and everything.
[This is part Four of a series on Top 10 Things You Will Hate About Azure SQL Database]
“As of this presentation” or “As of this writing” are words you get used to saying if you talk about Azure SQL Database. For Example – as of this writing the version of Azure SQL database is
Microsoft SQL Azure (RTM) – 11.0.9214.51 Jun 16 2014 21:09:51 Copyright (c) Microsoft Corporation
I gave the lightning talk this blog series is based on a few hours before that update. I know this because I checked the version before I got up and talked in front of a live studio audience. I’m not 100% sure what was released with version 11.0.9214.51, but I was glad I didn’t have to figure it out a few minutes before my presentation.
[This is part Three of Top 10 Things You Will Hate About Azure SQL Database]
If you ask any DBA what they check first when they inherit a new SQL Server they will probably answer, “Make sure the backups are running.” It’s drilled into us that the most important thing for a DBA is to make sure that no data is lost. Which is why one of the first things DBA’s notice about SQL Database is that you cannot run the statement BACKUP DATABASE. Read more…