Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Latest Blog Posts

Taking #PowerPivot to the Next Level

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

2 comments, 152 reads

Posted in SQL with Dustin Ryan on 26 August 2015

The Log Chain

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

0 comments, 197 reads

Posted in The Voice of the DBA on 25 August 2015

Exploring the Microsoft Azure HDInsight Query Console (No Scripting Required)

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

0 comments, 94 reads

Posted in DataOnWheels on 25 August 2015

SQLSaturday & The Speaker Wait List

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

0 comments, 118 reads

Posted in SQLAndy on 25 August 2015

Assigned reading: FREEPROCCACHE

I don’t often find myself blogging for the sole purpose of showing you someone else’s blog, but today is one of those days. I’d like you to read Grant Fritchey’s excellent piece, “Targeted Plan Cache Removal“, for this reason: the more people have learned about parameter sniffing, the more popular…

Read more

0 comments, 149 reads

Posted in SQL Awesomesauce on 25 August 2015

Automatic Roll Forward Transaction Log Backups

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

0 comments, 256 reads

Posted in Eitan Blumin on 25 August 2015

Query cost and Query Execution time - Difference

This post is my 100th post :) Was inactive in blogging for few years in between. Now back in full flow. Hope the 200 doesn't take this long !!!

When analysing query plans, one would have noticed the Query cost percentage ( which appear on top of each query in…

Read more

0 comments, 121 reads

Posted in SQL and SQL Only on 25 August 2015

Outlier Detection with SQL Server, part 7: Cook’s Distance

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

0 comments, 289 reads

Posted in Multidimensional Mayhem on 24 August 2015

Compressing Outcomes

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

0 comments, 122 reads

Posted in SQL RNNR on 24 August 2015

WWH of SSIS Zero to Hero in SSIS series (How to Use SSIS ?) TIP #112

Hello Friends,

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

0 comments, 122 reads

Posted in Rajat Jaiswal-337252 on 24 August 2015

Pick the Right Database in Azure

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

0 comments, 162 reads

Posted in The Voice of the DBA on 24 August 2015

Stock Market Chart in Power BI

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

2 comments, 1,145 reads

Posted in Sam Vanga on 24 August 2015

Setting Up an HDInsight Cluster (No Scripts Required)

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

0 comments, 613 reads

Posted in DataOnWheels on 24 August 2015

Targeted Plan Cache Removal

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:

DBCC FREEPROCCACHE();

BOOM!

Yeah, you just nuked the cache on your server because you wanted to take out a… Read more

7 comments, 747 reads

Posted in The Scary DBA on 24 August 2015

The tail of the log

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

0 comments, 143 reads

Posted in SQLStudies on 24 August 2015

Above All, Good Judgment

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

0 comments, 117 reads

Posted in Tim Mitchell on 24 August 2015

Actual Emails: Allow NUNS to Lead You to Good Clustered Index Design

Wrote this email exchange with a colleague who wanted to confirm that the client-proposed design for a table was... less than optimal.


Subject: clustered index
From: A. Developer

Hey William,
I believe the client created this Clustered Index... <horrifying screenshot of a clustered index with many large nvarchar columns as…

Read more

0 comments, 137 reads

Posted in SQL Tact on 23 August 2015

WWH in SSIS ? Zero to Hero in SSIS series TIP#111

Dear Friends,

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

4 comments, 146 reads

Posted in Rajat Jaiswal-337252 on 22 August 2015

016 – Me, Myself and I - WaterOx Consulting

Reading Time: 2 minutes

Me, Myself and I In WOxPod!, episode # 016 – “Me, Myself...

The post 016 – Me, Myself and I appeared first on WaterOx Consulting.

Read more

0 comments, 234 reads

Posted in WaterOx SQL on 21 August 2015

Versions (Master Data Services) - Where to use


Multiple versions of the master data within a model can be created in Master Data Services(MDS). When you create a model for the first time, Master Data Services (MDS) creates a default initial version of the model data.

While working with MDS, I was trying to find when to use…

Read more

0 comments, 111 reads

Posted in SQL & BI on 21 August 2015

Newer posts

Older posts