Latest Blog Posts
Memory Fundamentals for SQL Server - AWE ( Address Windowing Extensions), /PAE Switch (Physical Address Extension)
In this module we shall see what is AWE and /PAE…
About mid-way into August of 2015, I learned some important new factors in Search Engine Optimization (SEO) that caused me to make some big changes to the way in which I blogged. Namely – simply reposting a slight variant of a given blog post could hurt your overall… Read more
Proper configuration of the TempDB system database is crucial for optimal performance of a SQL Server instances during heavy loads. The recommended strategy is to create multiple data files, one per CPU core (logical processor), but not more than 8. Those files should be equal in size and with the… Read more
This error caught me out. I am putting this post here firstly to remind me if I do it again adn also to help others who may hit the same issue.
Today I am rewriting a function to create a Hyper-V VM so that I can properly script the creation… Read more
This error caught me out. I am putting this post here firstly to remind me if I do it again and also to help others who may hit the same issue.
I also have been looking at Pester which is a framework for running unit tests within PowerShell
You will… Read more
When I was about 7 years old and got my first computer during the early nineties,
I said “This is the future”.
Now that the future is here and computers are everywhere, I take a look at the world of Data and say “This is the future”.
I started out… Read more
I’m proud to announce that I will be speaking at SQLSaturday Chicago on March 5th 2016! This will be my first SQLSaturday event and I’m really excited that I get to do it as a speaker. I look forward to seeing you there!
My presentation is “Performance Monitoring AlwaysOn Availability… Read more
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