I've experimented with PowerBI, but not PowerQuery.  From what is said in this blog, it seems that PowerQuery was created for the SQL uninitiated.  Having been a professional SQL DBA/Developer/Architect...

I'm curious as to number 7.  Remove .ndf files.  What's the reason for doing that?

I like the approach illustrated here.  I have used in the past the dedup-rename method to cleanup the records.  i.e.:

Select <fieldlist> Into <tmp_tablename> From <tablename> Group by <fieldlist>

EXEC sp_rename 'tablename',...

• This reply was modified 4 years ago by  Brandon Forest.

The main difference between PowerBI & SSRS are the datasets.  An SSRS report runs the dataset each time the report is invoked.  PowerBI caches the data from the first run...

This article does address doing an implementation as Cloud Only, but it also addresses using onsite servers.

Under:

There are four levels of the Power BI system:

4.  Power BI Premium is designed...

I agree with Phil's thesis.  I've been in I.T. for 32+ years now.  In every position I always sell myself on my core competencies and then try to learn something...

• This reply was modified 4 years, 2 months ago by  Brandon Forest.

I use Extended Properties on any new table DDL, and important existing tables, to describe both the purpose of the table and the purpose of the column.  When this is...

My favorite timestamp is Select Convert(nVarchar(8), SYSDATETIME(), 112) + '_' + Replace(Convert(nVarchar(8), SYSDATETIME(), 114), ':', '')

Grant,

Thanks for weighing in on this subject.  It's stupid that I even have to justify the upgrade because we're 4 version out of date, but the bean-counters are not convinced...

Jeff,

Thanks for the input.  I knew some of this, but not the issues with the Insert BULK, which is not a feature that I really cared about until now.  I...

Grant,  Thanks for the reply.  Our Production SQL (prodSQL) is a SQL 2012 instance.

I agree.  Don't make uninformed decisions.  To that end, I've created an Extended Events session I called...

I'm hoping that you guys can point a finger in the right direction for me.  We're bouncing on the ceiling for CPU utilization for our prodSQL.  I'm researching ways to...

• This reply was modified 4 years, 11 months ago by  Brandon Forest.

When describing my role as a DBA to anyone outside of our profession, I tell them that I'm a glorified plumber.  I make sure the data pipes are all connected...

I am technically competent to be in the Senior SQL Server DBA position that I am in.  My work ethic is, I am here to provide the tools, policies, and...

AlwaysOn FailOver Clustering (FCI) is associated with Windows Services FailOver Clustering (WSFC).  This is a High Availability (HA) scenario where two (or more) servers share a SAN, or WAN, or...