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…
This was my first time attending the Super Bowl of SQL gatherings and I made the most of it. I got in on Sunday night and headed straight over to the registration. I have had a pretty active SQL Life over the last year and even though I have not been to the Summit before I immediately ran into people I haven’t seen since a random SQL Saturday ago (probably in April, because weren’t they all in April this year?). In addition I started meeting people who I only knew from the Twitterverse. I can’t remember all of the people I saw and met that first night. However, I do know that I waited in line for a while with Jes Borland (B|T), Ed Leighton-Dick (B|T), Mike Fal (B|T), and David Klee (B|T) because they had it up on the big screen for me a couple of days later. If PASS Summit is the super bowl then I have to say it was pretty cool to be up on the Jumbotron, if only for a few seconds.
Saturday October 12th: SQL Saturday #238 in my own back yard.
Monday October 14: I will be attending Redgate’s SQL in the City Charlotte, NC.
October 15-8: My first time attending the PASS Summit!
On Saturday October 19th: I will be presenting at SQL Saturday #237 BI Edition in Charlotte, NC.