Latest Blog Posts
Power Pivot is an amazing, flexible and powerful business intelligence tool (among other things) 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… 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
As I noted in my previous post, I am not a fan of scripting. In that post we set up a cluster without using scripts to do so. Before we get to the steps to load our own data, I wanted to take a moment and explore the HDInsight… Read more
When a new SQLSaturday event is launched an email is sent to all the speakers who have opted in to notifications for the region, basically saying “we hope you’ll speak at our event”. It’s lightweight and useful, and generally the only ‘send to all speakers’ message for that event, but… Read more
Performing a transaction log backup every 15 minutes has its advantages. But it also has disadvantages. Ever tried to restore hundreds of transaction log backups one by one in order to bring your database back from disaster? Not a bit of fun that is. Check out this useful script that… Read more
When analysing query plans, one would have noticed the Query cost percentage ( which appear on top of each query in…
By Steve Bolton[
…………I originally intended to save Cook’s and Mahalanobis Distances to close out this series not only because the calculations and concepts are more difficult yet worthwhile to grasp, but also in part to serve as a bridge to a future series of tutorials on using information… Read more
You find yourself cruising along, just doing your thing as a database administrator. Then the CIO plops down into a spare chair in your cubicle to talk about the weather.
Well, not entirely true there. The CIO dropped in because the alerts for disk space have been blowing up everybody’s… Read more
Welcome, back to Zero to Hero in SSIS series(Post #110). In last post #111 ,We gone through the WW (What & Why part) of SSIS in this post we will try to understand How to start SSIS ? How to use SSIS tool ?
You can start… Read more
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.
Another quick post, because this is something that’s annoyed me regularly. Hopefully writing this will help me make fewer mistakes.
Let’s suppose you have an Azure SQL Database.… Read more
U.S. stock markets have taken a beating this past week fueled by China markets. Take a look at how China and US markets fared this year and learn how to create these chart using Power BI Desktop.
The three line charts in the following image represent weekly data Shanghai Composite… Read more
Let me start by saying, I am not a fan of scripting. It definitely has its place and a lot of my peers really like it. It is the easiest way to get functionality out from software vendors such as Microsoft. PowerShell is an incredibly powerful tool which can do… Read more
A lot of times you’ll hear how people are experiencing sudden, intermittent, poor performance on a query, bad parameter sniffing at work, so they’ll fix it by running the following code:
Yeah, you just nuked the cache on your server because you wanted to take out a… Read more
The tail of the log
A little while back I was feeling overwhelmed by the number of blog posts ideas that I had so I asked around if anyone wanted one. Surprisingly I only had one taker. Warwick Rudd (b/t), and he wrote this great post… Read more
What is permissible is not always honorable. – Marcus Tullius Cicero
Rules. Best practices. Guidelines. Design patterns. Policies. All are good and necessary, and you’ll rarely find anyone who will argue against the need to establish boundaries and set expectations. But can adherence to rules and design patterns be taken… Read more
Subject: clustered index
From: A. Developer
I believe the client created this Clustered Index... <horrifying screenshot of a clustered index with many large nvarchar columns as…
As shared in last post Post #110, We are starting SSIS tutorial series ( A Step by Step SSIS learning tutorial) from today.
Before starting anything we might have some questions like What is SSIS ? Why SSIS ? & How to use SSIS ?
In general… Read more