While this is a personal blog, I try to keep it focused on either technical topics or personal development and leadership related to technical topics. This post is a complete deviation from all of the above. Please, read it anyway.
I went to Auschwitz and Birkenau.
Words are failing me… Read more
In just a few weeks I’ll be doing the Buckeye Blitz. That is, a tour of user groups in Ohio (aka, the Buckeye state, after a tree, not a sports team), one per day across a week. Here’s how it breaks down:
I didn’t post an update last month, but I did do something more important: I elicited your feedback on a question the Board needs to act on.
Here’s what I’ve been up to.
First, based on your feedback (thanks) and conversations that I’ve had with members of the Board, I’m… Read more
I love questions. I recently received one about new plans in the Query Store (available in Azure SQL Database now and in SQL Server 2016 after June 1).
Let’s say you have selected a plan that you want to force. You set it up. Now, let’s say the plan ages… Read more
Saying that you should use the correct data type seems like something that should be very straight forward. Unfortunately it’s very easy for things to get confusing. Let’s take a simple… Read more
Letting SQL Server change data types automatically can seriously impact performance in a negative way. Because a calculation has to be run on each column, you can’t get an index seek. Instead, you’re forced to use a scan. I can demonstrate this pretty simply. Here’s a script that sets up… Read more
August two years ago I originally posted, Make the PASS Summit Work for Your Employer. After conversations at several SQL Saturdays over the last couple of months, I decided to refresh and update that original content and post it again.
I keep hearing how the job market has changed. That… Read more
Not all of us are going to use Azure in the same way. That’s just common sense. Therefore, not all of us are going to want it to look the same. Here’s a default view of the portal for a login I created within my own domain:
You can contrast… Read more
For several years, many of us who were involved with working in Azure from the early days, were concerned that Microsoft had bet the farm and could possibly lose it all. They may well have bet the farm, but more and more it’s extremely clear that there is zero likelihood… Read more
If you read the March PASS Board meeting minutes, you saw that there was a discussion around board members and payments related to SQLSaturday precons. The question is simple, for a PASS branded event, should a member of the PASS board receive payment?
There are a couple of relevant… Read more
In SQL Server, in the T-SQL you use to query it, a view looks just like a table (I’m using the AdventureWorks2014 database for all these examples):
SELECT * FROM Production.vProductAndDescription AS vpad;
I’ve been getting lots of questions on views lately. Must be something in the water.
Because SQL Server allows you to treat a view as if it was a table, lots of people pretty much assume that it is a table since they get to treat it that way. The… Read more
THIS IS NOT AN APRIL FOOL POST!
I actually suspected very strongly from the start of the… Read more
I offer instruction on the Azure Data Platform, and have for about six years, since shortly after it came out. I started using Azure SQL Database (although it had a different name then) Day 1.
I know a few other people who don’t work for Microsoft, but have been actively… Read more
I love presenting sessions because you get so many interesting questions. For example, what happens with Optimize for Ad Hoc when Query Store is enabled? Great question. I didn’t have the answer, so, on to testing.
For those who don’t know, Optimize for Ad Hoc is a mechanism for dealing… Read more
I’m all like:
Because I saw this on an eval:
I’ve been trying to ramp up to take advantage of my MSDN subscription and haven’t known where to start. I don’t have that excuse now.
And then I was all like:
We are moving a lot of stuff to…
Time flies. I didn’t notice that I hadn’t posted an update in February.
There’s been a lot going on since I last posted! I’ve attended the executive committee meetings. I’ve also hosted my first board meetings and I took part in my first Town Hall. I’ve been working with PASS… Read more
You can’t query across databases in Azure SQL Database… or can you?
Let’s check. I’ve created two new databases on an existing server:
I’ve created two tables on each respective database:
CREATE TABLE dbo.DB1Table ( ID INT IDENTITY(1, 1) NOT NULL PRIMARY KEY, Val VARCHAR(50) ); CREATE TABLE dbo.DB2Table (…
It’s weird being an introvert who likes to talk to people, but what can I do. I like talking to people. I have a number of upcoming trips, quite literally all over the world, that provide us with the opportunities to get together and have a chat.
First, I’ll be… Read more
Not for you, for me.
I’m sure you’ve heard the statement: Praise in public. Criticize in private.
I agree with this approach. However, I find it extremely difficult to do. It’s one of the fundamental proofs that all leadership, all life for that matter, is about constant practice and discipline.… Read more