Today (11/18) is the November meeting for the Minnesota chapter of the Professional Association for SQL Server (PASSMN). Our presenter this month is Microsoft SQL Server MVP Paul Timmerman (T). Paul is presenting on how SQL Server Database Snapshots will make our lives easier. I learned a ton when he presented on Read Committed Snapshot Isolation level last year so I expect to gain some knowledge tonight (evidently Paul only presents sessions with the word snapshot in them).
I can’t remember when I first started hearing about SQL Saturday Winnipeg – it may have been last year at the PASS Summit 2013. I work at the same company as Mark Vaillancourt (B|T) who is the PASS Regional mentor for Canada and he asked if I would be up for a trip north at some point to share some SQL knowledge with Canadians. I’ve never been to Canada which is hard to believe when it is just a short 8 hour drive to Winnipeg (or possibly 2 days depending on weather). I said yes and I even agreed to help with the planning. I may have over extended myself on that second part because I have found it difficult to contribute much from 500 miles away – perhaps it is the language barrier. Read more…
There are some T-SQL best practices that I have been hearing about for so long that it surprises me when I run into people who don’t know about them. Then I remember “every single person in the world starts out with absolutely zero knowledge about SQL Server“. With that in mind I have decided to document some of the things I have been seeing a lot of recently. I have been working on a project refactoring T-SQL for the past several months and one of the patterns I replace without thinking about it is
This month’s host for T-SQL Tuesday is the Real SQL Guy, Tracy McKibben (blog|twitter). In honor of Ada Lovelace Day Tracy has asked us to write about our heroes. I think Ada Lovelace is a great example of a hero and an inspiration as the first computer programmer, but I’ve decided to make my focus a little more local.
A little over two years ago I was starting to get more involved in PASSMN. The people on the PASSMN Board inspired me with their commitment and willingness to donate their time and knowledge to the Minnesota SQL Server community. At the time I didn’t know the board members as people. I viewed them with a certain amount of awe and nervously volunteered to speak and to help with events like SQL Saturday. It was easy to see them as heroes and they inspired me to push myself.
Maybe it is all of the activity these days around planning the current SQL Saturday, but I realized that I am now working side by side with some of these amazing people. My heroes are my fellow board PASSMN board members. They all do work that no one ever knows about and put in hours of volunteer time to help create the great SQL Server community we have here in Minnesota. I can’t begin to list all of the work these people do, but I want everyone to know how great they are. In no particular order here are the PASSMN Board heroes:
I started to write my normal SQL Life blog post about what I am doing in the next couple of months and I was going to casually add a bullet point about speaking at the 2014 PASS Summit (see the badge over to the right?)
Next Tuesday (9/16) is the September meeting for the Minnesota chapter of the Professional Association for SQL Server (PASSMN). Our main presenter this month is the Paula Merns. Paula will be expanding on her checklist presentation from last December and showing us how she uses checklists as a database professional. In addition to the main topic we will have a short presentation on using XML functions to create correlated lists by Riley Major.
[This is part Ten of Top 10 Things You Will Hate About Azure SQL Database]
If Microsoft is good at nothing else they are geniuses when it comes to creating complicated licensing and billing. They have decided to apply their talents to the billing for Azure SQL database. I realize that they have done their homework and the market will probably support the pricing tiers they created, but they also created a change in how new customers will decide to apply SQL Database. The biggest change is that you used to pay for the amount of data you were storing and now you a pay a set fee per database. You decide how much you want to pay based less on the amount of data and more on the performance you hope to get. Read more…
[This is part Nine of Top 10 Things You Will Hate About Azure SQL Database]
Currently there is no way to encrypt at rest data in Azure SQL Database. The data in the pipeline is encrypted using SSL, but if you want to obscure the data in the database there is no mechanism for this. As for encrypting the database files themselves I’m not even sure this makes sense given the platform as a service configuration. While I do know that some companies have used the lack of column level encryption as an excuse not to move to SQL Database I don’t think most will even notice. Read more…
[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…