Latest Blog Posts
Quick reminder that the call for speakers for Orlando Code Camp is open through Feb 6 (next week!).
This ran a couple weeks ago (Turn Out The Lights) to see if I could spark a discussion about how/when/why we might think more about costs incurred by the way we provide solutions. Based on the follow-on discussion I didn’t quite achieve that. It reminds me that there… Read more
Have been working through the fantastic training resources from Brent Ozar’s Everything Bundle and on the recommended resources they mention after all the training on log shipping and availability groups that you can use a lab environment from TechNet to actually get going on familiarizing yourself with the technology more. Read more
Hello everyone. Just because I’ve moved on to the executive committee doesn’t mean I’m walking away from these reports. I will continue to communicate all that I can about my role as EVP throughout the year. One of our commitments this year is providing greater insight into each of the… Read more
It’s been a while since I’ve posted as the run up to Xmas last year and this January have been particularly busy. February doesn’t seem to be going to be any quieter but at least I’m being kept on my toes.
Anyway, waaaay back in December the SQL Server Ireland… Read more
Prelude in SQL Minor
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a blog post each month on a SQL Server Basic. Some have hash-tagged this as #backtobasics. Here is the link to that challenge sent via tweet Read more
Q: True or False – Iowa has one of the world’s longest-running SQL Server conferences?
A: True! SQLSaturday #19 was held in the fall of 2009 in Iowa City. We’re one of only a handful of chapters to host an event every year since then.
We’ll hold our eighth SQLSaturday… Read more
SQLKover update: For some reason, this was my most popular blog post on the old LTD site. Over 110,000 views. People must be building them script components.
From time to time I have to script out some logic using a Script Component in a SSIS package. Business as… Read more
Transport security for AlwaysOn Availability Group is an interesting topic, and any day it’s a topic which is debatable.
The transport security involves encryption of packets exchanged between the servers involved, and for AlwaysOn AG the encryption is made possible on the Hadr_endpoint.
By default, its encrypted using AES Read more
This blog describes the various approaches you can use to migrate an on-premises SQL Server database to Azure SQL Database.
In this migration process you migrate both your schema and your data from the SQL Server database in your current environment into SQL Database, provided the existing database passes… Read more
This is the first of 12 posts this year in support of Tim Ford’s #iwanttohelp initiative. These will be completely 100 level, introductory blog posts meant to help people that are just getting started as data professionals. I’ll try to cover several different topics over the year, but felt I… Read more
The CONNECT permission exists at the instance and database levels. Note: as of SQL 2012 it is CONNECT SQL at the instance level, but prior to that it was just CONNECT. It does basically the same thing in both cases. The CONNECT permission allows you to connect to the associated… Read more
By Steve Bolton
…………The last installment of this amateur series of self-tutorials was the beginning of a short detour into using SQL Server to perform goodness-of-fit testing on regression lines, rather than on probability distributions. These are actually quite simple concepts; any college freshman ought to be able to… Read more
I’m happy to announce that my first public session of 2016 will be at SQLSaturday Chicago on March 5! I will be talking about the system_health Extended Events session and the default trace. Here’s the details:
Dammit Jim! Dr McCoy’s Field Guide to system_health (and the default trace)
As DBAs,… Read more
Last Thursday night I had the pleasure of speaking with Gregory Kramer and his friends at the Madison, WI Power BI User Group. We took an introductory look at how Microsoft’s acquisition of Revolution Analytics is making serious waves across the Microsoft data platform. We also walked through leveraging… Read more
That’s a bit short for a blog post, so let me explain. First, the difference between a seek and a scan.
A seek is an operation which navigates down the index’s b-tree looking for a row or for the start/end of a range of rows. A seek requires a… Read more
All bloggers started as beginners. We picked things up, learned them, and got to the point where we wanted to start sharing our knowledge. The problem is that most of us moved on to talking about advanced topics and left people to fend for themselves on the difficult entry-level learning… Read more