Latest Blog Posts
With the rise of HDInsight and other Hadoop based tools, it is valuable to understand how Power BI can help you take advantage of those big data investments. If you need to set up a cluster to work with, check out my previous posts on Setting Up an HDInsight Cluster… Read more
This is the third installment of our Getting Started With Power BI Desktop series. The first post is about installation and the second is about getting data. In this post, let’s see how easy it is to create visualization on Power BI Desktop. If you’re quite familiar with creating… Read more
I see a lot of confusion about the place and purpose of the many new database solutions (“NoSQL databases”) compared to the relational databases solutions that have been around for many years. So let me try to explain the differences and best use cases for each.
First lets clarify these… Read more
One of the big goals for SQLSaturday was for it to be a membership drive. It’s worked hugely well in some ways; we’ve added tremendously to the number of PASS members, grown the size of the Chapter mailing lists (for those that held a SQLSat), and introduced a lot of… Read more
The doors close, lights turn off, and cars begin to pull out of the parking lot. Another SQL Saturday event has come and gone, but this time it was different. The reason for this was from the hard work, effort, countless hours, and collaboration that took place.
This past year… Read more
Anyone working with SSIS and Excel probably had the following issue: you are creating an SSIS package using an Excel file in BIDS/SSDT – which is a 32-bit application – and when you try to run the package, it crashes. This is easily fixed by setting the project property Run64BitRuntime Read more
The use of SpaceUsed property of the FILEPROPERTY function gives how much space is used also we can derive lot of other attributes of it such as free space and percentage of free space.
For other versions of SQL you can refer the below SQL.
DECLARE @command VARCHAR(5000)…
As I noted in my first post, I am not a fan of scripting. In that post we set up a cluster without using scripts to do so. Now we are going to look at how to upload files without scripts. While this will work for our demo and… Read more
If you are one of the lucky ones who gets to attend VMworld USA this year, and you have any number of virtualized databases in your environment, you need to attend these sessions!
Compliance training, never a fun topic and I think that is too bad. A combination of companies checking the box, lacking imagination, and being stuck with rules that require doing it annually. Do we really need to review the employee manual if it hasn’t changed since last time? Or… Read more
I recently had the opportunity to attend a three day Agile development workshop. At a very high level, Agile development values making small, iterative changes over short periods of time, unlike traditional software development methods that generally involve a large release at the very end of a project. If you’ve… Read more
Last night I had a lot of fun presenting on one of my favorite topics, MARS and SQL Server protocols including a rather fun live demo.
The slides and demo apps are available: https://github.com/GoEddie/SQLSupper-WhenMarsAttacks
If anyone wants to know more about MARS or TDS feel free to contact me as…
One of the biggest pains with Extended Events is the thing we love to hate – XML. XML is so foreign to many DBAs. It’s not relational and often brings nightmares of parsing and performance issues.
Despite that, Extended Events takes advantage of XML much like we have seen in… Read more
In one of my first IT jobs (back in the dark ages) we had something called the thirty minute rule. Kind of catchy right? But what did it mean? Simply said, if you have made no progress on a problem for 30 minutes go find some help.
The idea… Read more
This weekend, I’ll hop on a plane and fly over to Norway for SQLSaturday Oslo.
I’ll be delivering a session I like a lot: The Data Loading Performance Presentation.
Among other topics, we will talk about the #1 enemy of high performance data loading, Minimal Logging and Bulk… Read more
Power Pivot is an amazing, flexible and powerful business intelligence and there is no doubt about that fact. As a feature included with Excel 2013 and 2016 (and an add-on for Excel 2010), Power Pivot allows user with a little technical expertise to integrate disparate data source together within a… Read more
I ran across a question recently from someone that received a similar message to the one showed in this image:
In this case, the log chain is broken. I’ve received this message, usually from a script that is automatically restoring all the logs in a folder. I’ve also had clients… Read more