Inspire with Data

using Microsoft Data Platform

Skip to content
Menu

Category: Database administration

Database administration description;

Posted on Apr 10, 2018Sep 1, 2020Performance tuning

Power BI performance tip – Assume Referential Integrity

As my experience goes, there is one option in PowerBI, that people rarely use. But for some of us, especially with some database performance tuning…

Continue Reading
Posted on Mar 11, 2018SQL Tools

Deep dive on Data Discovery and Classification utility in SSMS 17.5

SQL Server Management Studio 17.5 was released recently with several really interesting fixes and functionalities (release notes are here). One of the things, included in…

Continue Reading
Posted on Jun 21, 2014Dec 5, 2017Database administration

Lesson learnt – changing the root drive for SQL Server cluster instance

Playing around with your live SQL Server cluster is always something to be extra careful with. Especially when you have to remove some old storage…

Continue Reading
Posted on Sep 22, 2013Database administration

How to setup and use the AMR Tool in SQL Server 2014

The Analysis, Migrate and Report tool (AMR) is part of SQL Server Management Studio 2014 and it aims at helping you evaluate your workloads and…

Continue Reading
Posted on Sep 16, 2013Database administration

How to check if your databases are part of a replication

If you need to check if there is any database on your SQL instance, related to replication, you have couple of different options – from…

Continue Reading
Posted on Sep 14, 2013Database administration

What are the minimum permissions for Activity Monitor

Activity monitor is something that I do not use very often – it is just easier for me to work with the DMVs and the…

Continue Reading
Posted on Jun 18, 2013Jun 18, 2013Database administration

Getting NTFS cluster size using Powershell

Hi folks, These days I was working on an IO issue and I as every IO performance issue – I started with checking the basics.…

Continue Reading
Posted on Mar 2, 2013Mar 2, 2013How To

Monitoring Data Quality activities on your server

In this short post I will show you how to check for the activities run or being run on your Data Quality Server. First you…

Continue Reading
Posted on Feb 10, 2013How To

How to enable PowerPivot and Power View in Excel 2013

I am working on a presentation for our newest local PASS BI Chapter (Bulgaria BI & .NET Geeks) and around the subject I am preparing…

Continue Reading
Posted on Feb 3, 2013Mar 18, 2013Database administration

Monitoring MDW purge job

During one of my latest investigations on SQL Server MDW, I had to learn a few things the hard way – there are several stored…

Continue Reading

Posts navigation

Page 1 Page 2 … Page 6 Next Page

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 189 other subscribers

Learning

  • Microsoft Virtual Academy
  • PowerBI.com
  • SQL Master Academy
  • SQL Server Builds
  • SQL Skills

Archives

  • January 2020 (1)
  • December 2019 (3)
  • April 2018 (1)
  • March 2018 (1)
  • December 2017 (1)
  • November 2014 (1)
  • June 2014 (1)
  • May 2014 (1)
  • September 2013 (3)
  • June 2013 (1)
  • March 2013 (2)
  • February 2013 (3)
  • January 2013 (2)
  • December 2012 (2)
  • November 2012 (3)
  • October 2012 (2)
  • August 2012 (1)
  • July 2012 (1)
  • June 2012 (2)
  • January 2012 (1)
  • November 2011 (2)
  • October 2011 (3)
  • September 2011 (1)
  • July 2011 (6)
  • June 2011 (2)
  • May 2011 (1)
  • April 2011 (1)
  • March 2011 (4)
  • February 2011 (3)
  • January 2011 (6)
  • December 2010 (6)
  • November 2010 (7)
  • October 2010 (3)
  • September 2010 (3)
  • August 2010 (3)
  • July 2010 (1)
  • June 2010 (1)
  • May 2010 (2)
  • April 2010 (6)
  • March 2010 (3)
  • February 2010 (6)

Pages

  • About
  • Privacy Policy
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
© Copyright 2021 – Inspire with Data
Alkane Theme by WPAlkane ⋅ Powered by WordPress