Tomorrow (2/18) is the February meeting for the Minnesota chapter of the Professional Association for SQL Server (PASSMN). Our presenter this month is the Real SQL Guy, Tracy Mckibben (Blog|Twitter). He will be presenting on Subqueries for superheroes. He claims it is for T-SQL beginners, but I imagine most people in the audience will learn something about the “lowly subquery.”
In addition to Tracy’s talk we will also be letting people know about some of the many things going on the SQL and Data community. Read more…
Next Tuesday (1/21) is the January meeting for the Minnesota chapter of the Professional Association for SQL Server (PASSMN). It is my first meeting as the board chair so I am sure everything will run smoothly. Our presenter this month is Merrill Aldrich (Blog|Twitter). Merrill has a great dry sense of humor and this month he is presenting on Storage Internals. Which is sort of burying the lead. Merrill wrote a visualization tool for SQL Server data files and he will show us “what happens in a data file when you convert a table from a heap to a clustered index!” and “fragmentation and the havoc wrought by Shrink!” I missed him when he gave this talk at our SQL Saturday event last fall so I am glad we got him to come in and show us at the user group meeting. Read more…
Next Tuesday (12/17) is the December meeting for the Minnesota chapter of the Professional Association for SQL Server (PASSMN). I am excited about this meeting because we have five new speakers each presenting a 10-15 minute topic. Read more…
SQL Server MVP Deep Dives 2, Chapter 12
For this chapter Pawel Potasinski has done exactly what the title suggests. He lays out the steps to create a simple performance dashboard for SQL Server. He specified the version in his chapter title, but he clarifies that these steps can be “implemented on SQL Server 2005 and later (where CLR, DMV’s and SSRS are available).” That one sentence sort of gives away his whole strategy. He shows how to use a Common Language Runtime (CLR) function to get at operating system performance counters. He then combines this with SQL Server Performance counters from the dm_os_perfornamce_coutners DMV and uses a SSRS report to display them both.
SQL Server MVP Deep Dives 2, Chapter 59
This was a hard one. I had to remind myself a couple of times while reading this chapter that I am writing these reviews so that I can understand these topics better.
Before I read this chapter I had never heard of StreamInsight and it took me a while to wrap my head around what exactly this tool is. Finally after doing some Binging around on the topic and reading the chapter for the sixth time these lines jumped out at me:
StreamInsight is a complex event-processing engine…
Once the events leave the input adapter, they enter the engine.
The engine is where all the query logic is introduced and from where the intelligence is derived.
When the topic of online learning comes up with other developers the sites most often mentioned are Pluralsight and CodeAcademy. One of the resources I don’t hear people talk about as much in is an online university called Udacity.
Udacity is the brain child of Sebastian Thrun, a Google Fellow who is behind things like Google Glass and the Google self driving car. He is also a research professor at Stanford and decided that there was a better way to get quality education to more people. The mission they have outlined is this:
“Our mission is to bring accessible, affordable, engaging, and highly effective higher education to the world. We believe that higher education is a basic human right, and we seek to empower our students to advance their education and careers.”
I’ve been lucky enough to have some time to play with Windows Azure over the last couple months and I have some opinions on the platform. Overall I think my opinion on the idea of The Cloud is about the same as when I started. To begin with I wish they hadn’t called it The Cloud – or maybe that it hadn’t stuck as a part of the technical conversation. I think the name conjures up this romantic image for business users of a technology solution that exists out there – somewhere over the rainbow.
In my presentation on Windows Azure SQL Database and SSIS I show how to create a database using the Azure Portal and using T-SQL from SQL Server Management Studio. Using the portal us about as simple as it gets so I’m not going to go through the steps here. To use T-SQL you have to be connected to the master database and then you can quickly create a new database with the CREATE DATABASE command.
CREATE DATABASE <database_name> (EDITION = 'Web', MAXSIZE=1GB)
The edition can be either Web or Business and the only difference I am aware of is the maximum database size. The Web edition can only be up to 5GB and a Business edition has a max size of 150GB.
As I mentioned in my last post I have been learning as much as I can about Windows Azure SQL Database (SQL Database or WASD to those who work with it). I did a lot of research and some demo projects for my presentation on WASD at SQL Saturday #237 in Charlotte, but I know there is more for me to learn. In fact one of the challenges with WASD is that it can change as quickly as DBA’s and developers can learn. I’ve had a lot of conversations about Azure over the last few weeks. These have ranged from in-depth case studies using WASD for a SaaS product offering to people who have never looked at Azure. To help me and maybe others have a baseline for learning about Windows Azure SQL Database I wanted to ask some experts a few questions. The first person that comes to mind for me from the DBA perspective on Azure is the Scary DBA, Grant Fritchey (B|T). Grant is a Product Evangelist for Red Gate Software and his blogging and presenting have had an Azure focus lately. I traded some emails with Grant and he agreed to answer my five cloudy questions. Read more…