Latest Blog Posts
I spent the last few weeks travelling a lot compared to my usual routine and I got quickly fed up with bringing my mobile workstation with me. My Dell precision M4600 is a powerhouse, but it’s definitely too big and too heavy for travelling, so I decided it was time… Read more
Welcome to the second Tuesday of the month. And in the database world of SQL Server and the SQL Server community, that means it is time for TSQL2SDAY. This month the host is Sebastian Meine (blog / twitter), and the topic that he wants us to write… Read more
Thank you to everyone that attended my Power BI webinar last month, September 29th. Sorry its taken me a while to finally make the information available, but my schedule has been crazy lately! The good news is, however, the recording is available! So if you weren’t able to watch the… Read more
Have you ever wondered if that black box in your datacenter called the network is performing as well as it should be? Do you have random periods of time where normally fast data movement processes seem to take forever, but the diagnostics on your servers all seem fine? What about… Read more
I am truly grateful I have been selected for this unique contest: http://www.dcac.co/your-pass-speaker-idol-2015-top-12-are
Good luck to all of my fellow Speaker Idol contestants and thanks to Denny Cherry and others for making this happen!
Some words of wisdom I would like to share with my fellow contestants- while… Read more
For many years I didn’t really think about the implications of how I was retrieving data from my SQL Servers in PowerShell. I was just happy that I was able to retrieve the data! As I learned more about SQL Server I started to think of things like SQL injection…
My enthusiasm for analyzing stock market data using Power BI – even after publishing two posts recently (this and this) – is at all-time high, unlike the stock market itself. In today’s edition let’s try to put corrections in perspective.
In the first report shown below,… Read more
Having covered the metadata for a deployed session from just about every angle (yes there is more on metadata that could be discussed, has not yet been discussed, and that I am not planning on covering at this time), it is high-time to start figuring out how to query the… Read more
This month’s T-SQL Tuesday (#71) is hosted by Sebastian Meine (b/t). He has picked an interesting security subject. SQL Server Audits. Fortunately this is one I have a bit of experience with. It’s one of my favorite new features if only because it’s so simple to… Read more
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