Latest Blog Posts
While I was working on a test the other day, it kept failing. Not a big surprise, but I couldn’t figure out why. When I looked at tsqlt.testresults, I saw extra rows. Double rows in fact, and that threw me.
This was my Assemble code.
CREATE TABLE #Expected…
This is the second year of Argenis Without Borders and the second year that I’m taking part. Last year we hit the fund-raising goal and I wore the rainbow fuzzy leggings at the PASS Summit. This year, it feels like we’re a little behind the goal. We need you to… Read more
SQL Saturday #442 in Orlando, FL has come and gone but what a turn out! The event was excellent, we had a great turnout for our session and had a blast! And as a bonus, the BBQ lunch, baked beans, coleslaw, mac n cheese and dessert were amazing. Seriously one… Read more
PowerShell exposes scads of information and provides the professional with a formidable tool for the tool-belt. Over the past several articles, I have demonstrated how this tool can be used to uncover useful information and metadata.
The groundwork has been laid to be able to mine information about each of… Read more
If for any reason you need to place the database on a network share and by default this option is off you can follow the way described below: A database on a network share is created by running T-sql script, graphic mode will not work in this case. So, first… Read more
Thanks for attending my session on T-SQL Window Functions. I hope you learned something you can take back and use in your projects or at your work. You will find an link to the session and code I used below. If you have any questions about the session post them… Read more
A few months back I created a blog post showing that you can indeed create and use indexed views on any core SQL server edition. It has proved to be one of my most read blog posts. Since then Webucator, provider of SQL Server training, got in contact… Read more
My session yesterday was recorded, apart from the fact that me and mark were having a chat for about 25 minutes before it kicked off it seemed to work quite well:
Skip forward to 24:32 to get to the actual content.
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