Viewing 15 posts - 1 through 15 (of 61 total)
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...
January 28, 2021 at 7:18 pm
I'm curious as to number 7. Remove .ndf files. What's the reason for doing that?
November 4, 2020 at 6:56 pm
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',...
November 4, 2020 at 6:42 pm
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...
September 25, 2020 at 11:07 pm
This article does address doing an implementation as Cloud Only, but it also addresses using onsite servers.
There are four levels of the Power BI system:
4. Power BI Premium is designed...
September 25, 2020 at 11:01 pm
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...
September 21, 2020 at 6:47 pm
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...
March 18, 2020 at 4:29 pm
My favorite timestamp is Select Convert(nVarchar(8), SYSDATETIME(), 112) + '_' + Replace(Convert(nVarchar(8), SYSDATETIME(), 114), ':', '')
March 16, 2020 at 4:00 pm
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...
February 26, 2020 at 3:29 pm
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...
February 26, 2020 at 3:16 pm
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...
December 10, 2019 at 12:01 am
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...
December 8, 2019 at 11:32 pm
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...
May 24, 2019 at 5:30 pm
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...
May 24, 2019 at 4:15 pm
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...
March 15, 2019 at 3:53 pm