Its very simple. Open management studio create a new query on the instance where is the database that you are shrinking and paste this query:
Select percent_complete, status, command , estimated_completion_time from sys.dm_exec_requests
And find dbccfilescompact
Its very simple to find all the table or view in a sql db. On management studio select your db and open a new query.
Then past this query
Select * from information_schema.tables
If you want to see only table add
Where table_type =’base table’
Hi everybody, today we speak about some interesting new features on power bi desktop. This upgrade is very interesting. IN particular this month:
A theme file is a JSON file that includes all the colors you want us to use in your report. Se my Next article where i explain how to use it.Last week, Guy in a Cube shows how to configure Active Directory Federated Services (ADFS) and the Web Application Proxy (WAP) role in Windows 2016, so that you can connect from Power BI mobile to SQL Server Reporting Services using OAuth. See the video, it’s very interesting.
During my browsing online about Power Bi i found an interesting solution to Sharepoint power bi. His Name is Ataira Analytics +BI and with their solution can view your Power BI items within a convenient SharePoint web part. You can also send notifications to your corporate groups and add follow-up actions for your team to more tightly collaborate on your business intelligence efforts in one location. Continua a leggere
Here we are with the news about Power Bi Mobile:
Quick Calc and Format of column are two much requested features. In this article I’ll explain how to use this two Features in Power bi. Continua a leggere
In these days Microsoft has announced the introduction of a new web part that enables SharePoint authors to embed Power BI reports directly in SharePoint Online pages with no code required.
This is a easy e short guide to how to integrate power bi report on sharepoint online. We start from requirements:
If you have all the 4 requirements, we can start from Power BI service site where you have published your Report.
Now we can pass to our Sharepoint website and follow these steps:
Embedding a report in SharePoint Online does not automatically give users permission to view the report. The permissions to view the report are set within the Power BI service. There are two ways to provide access to the report within the Power BI service:
Power BI Embedded in sharepoint support data security through Power BI’s Row Level Security features. Users viewing the report embedded in a SharePoint Online page will see the same data they would via PowerBI.com. This makes building secure internal portals to disseminate critical business insights easy and trustworthy.
| Property | Description |
| Page name | Sets the default page that is shown by the web part. Select a value from the drop down. If no pages are displayed, either your report has one page, or the URL you pasted contains a page name. Remove the report section from the URL to select a specific page. |
| Display | Option to adjust how the report is fit within the SharePoint Online page. |
| Show Navigation Pane | Shows or hides the page navigation pane. |
| Show Filter Pane | Shows or hides the filter pane. |
Today Microsoft Team has released a new version of Power BI Desktop. Here the summary of the news
One of the most tedious tasks of working with databases is to write and maintain documentation, in particular writing reports from tables and views.
So why not try to make this task a bit less heavy by using Python?
The script requires that the views are created using create view.
Example:
def extract_columns(in_txt): """Simple function to extract columns between select and from""" # Splitting by select i only choose text after select out_view = re.split(r'(?i)\bselect\b',in_txt)[1] # Splitting by from i only choose text before from out_view = re.split(r'(?i)\bfrom\b',out_view)[0] # Cleaning extra spaces and tabs out_view.strip() return out_view
Let’s start by defining a function with the purpose of extracting only the columns from the script of a view. Thus ignoring everything before the Select statement and everything after the From statement.
import re # We open the file containing the view view = extract_columns(open('input.txt','r',encoding='utf-8').read()) # Now we insert text into the list and we create a new list view_l = view.split('\n') out_l = []
Now we declare the variables we are going to use.
# Now we loop through all the lines of the view for num,line in enumerate(view_l): # Clean extra spaces line = line.strip() # Remove Comments line = line.split('--')[0] # Remove Commas line = line.replace(',','',1) # Substitute Tabs with Spaces line = line.replace('\t',' ') # While two spaces are in line we substitute the with one space while ' ' in line: line = line.replace(' ',' ') # Remove [ and ] line = line.replace ('[','').replace(']','') # If line is not empty if len(line)>0: # If line is not a comment if line[0]!='-': # We add the new line to out_l out_l.append(re.split(r'(?i)\bas\b',line))
Finally we come to the main code.
The first part is a For loop, using the list we created in step2.
For each line the script removes useless characters and comments and then adds the line to the new list.
# Open output file with open('out.txt','w') as out_txt: # For line in output list for line in out_l: # Try / Except to output all the values to the file separated by ',' print(line) if len(line)>1: out_txt.write('as'.join(line[0:-1]).strip()+'|'+str(line[-1]).strip()+'\n') else: out_txt.write(str(line[0]).strip()+'|'+str(line[0]).strip()+'\n')
In the last part we write to an external file using a Try/Except to avoid IndexErrors.
