Latest Blog Posts
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly about using Excel 2013 and later. Much of the content will be a result of my daily interactions with business users and other BI devs. In order to not… Read more
All I can say is, “Wow…Thank you!”. I won a seat on the PASS Board of Directors and it’s very surreal. I am beyond excited, but not for what happened. I’m excited and energized for what is to come. PASS is young and our industry is in constant flux so… Read more
Having just covered the methods to discover the metadata for a deployed session including the details about the session settings, events, actions, and predicates, I am nearly finished with the session metadata. All that remains is to dive into the metadata for Targets.
Through the articles thus far, I have… Read more
Check constraints are useful for more than just verifying the data that goes into your tables. The query optimizer can use them to avoid looking for values that couldn’t possibly be there.
For example, imagine a listprice field with a constraint that keeps the field value over $100. If a… Read more
I decided to check if there is still database mirroring option in MS SQL Server 2014
Wow! It works!
However in the screenshot you see a message that new tables “in memory” can not be used together with mirroring.
It’s worth noting… Read more
I have recently shown that using PowerShell can be extremely powerful in obtaining insight into how to investigate deployed Extended Event Sessions. Throughout the demos I have used, I hope that it has also shown that PowerShell can be very easy to use.
Querying this metadata through TSQL is… Read more
Following up on my previous blog on introducing the “Social DBA”, I spoke about the concept of leveraging social networking to excel in your professional database career. The Microsoft SQL Server technical community is quite a unique and diverse bunch, with the commonality of SQL Server technology… Read more
This is my last day at home for a long time. At least long by my standards. I head to the airport tomorrow for a ten day trip, not returning to CO until Saturday, Oct 17. I rarely travel more than 4 or 5 days at the most, so this… Read more
Crikey, where did that time go! I have been so busy adjusting to my new work life style I have completely neglected my blog.. Well now that I seem to be adjusted to the world of contracting (or rather adjusted to working more than a mile away from where I… Read more
The Assumption I assume you already have a Hyper-V basic configuration on...
The post Get Hyper-V Host To Talk To Guest VM’s With This Simple Trick appeared first on WaterOx Consulting.
Last week I hosted a webinar in which I reviewed some of the coming changes for SQL Server Integration Services in SQL Server 2016. The current beta of SSIS 2016 has some exciting new features that I think you’ll like. The recording of that webinar is below. Enjoy!
The post… Read more
This is a fairly simple one once you’ve seen it, but then so are lots of things :). Let’s say you have a failed SQL Server job.
Here is our job that will fail:
Then we run it and it fails!
And when we click on the error… Read more
In the last article I introduced a power tool that can be used to help manage Extended Events. That tool is PowerShell. In that article, I focused primarily on introducing PowerShell as a power tool to help in discovering the Extended Event Sessions deployed to the server as well… Read more
My Session: Using Azure SQL Database for Enterprise Needs
On 10/6/2015, I presented on Azure SQL Database at TechFuse Minnesota. Some of the highlights from the session included a comparison of the various SQL Server offerings and how Azure SQL Database fits into the overall picture. During the session we… Read more
I’ve been on a testing kick, trying to formalize the ad hoc queries I’ve run into something that’s easier to track. As a result, when I look to solve a problem, I’ve written a test to verify that what I think will happen, actually happens.
I saw a… Read more