One of the functions of a DBA is to keep an eye on free space within the database and database files. The auto grow feature is great as a last resort, but proactively managing the database files is a better approach. Also, this information can be used to shrink data files as needed if there is a lot of free space in the files.

One option is to use sp_spaceused. If we run the following command we can see how much free space there is in the database, but this shows us total free space including the transaction log free space which may be totally misleading.

USE Test5 
GO 

sp_spaceused 

Another option is to use the SpaceUsed property of the FILEPROPERTY function which will tell us how much space is used and then we can calculate free space based on the current size and what is being used.

USE Test5 
GO 

SELECT DB_NAME() AS DbName, 
name AS FileName, 
size/128.0 AS CurrentSizeMB, 
size/128.0 - CAST(FILEPROPERTY(name, 'SpaceUsed') AS INT)/128.0 AS FreeSpaceMB 
FROM sys.database_files; 

Here we can see the output from the above for the Test5 database.

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’

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:

• Power BI app for Android tablets is now available globally
• New dashboard tile actions (All): To access this menu, just tap and hold on a tile in a dashboard, or tap the ellipsis (…). The menu allows you to navigate directly to the underlying report, expand the tile, or even manage an alert for the tile if the type supports it.

• SSRS – multi server support (iOS): you can connect to up to five different SQL Server Reporting Services servers at the same time. All the servers you connect to will be available under the settings screen.
• Scrolling Improvements: added the ability to scroll in any Cartesian chart (Bar, Colum etc.) by touching the chart itself, rather than touching the scroll bar. This new interaction is available in any visual in a report, report focus mode, phone report, or Q&A tile.