Latest Blog Posts
If you already have a source code repository for your app code or other databases or you have another team that uses source control then just use theirs.
If you don't then use whatever the members of your team have used most, they all basically do the same thing and…
I had a lot of fun yesterday presenting my talk on how to go from not having your database in version control to deploying to a CI database, running unit tests and generating deployment scripts for a QA/Prod database so effectively how to build a fully functioning continuous delivery process…
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