and ask to join our affiliate program
Here is what is in the Power BI February 2020 update
Incremental refresh is now generally available
Hierarchical slicer (preview)
Updates to the new ribbon (preview)
Title bar updates
New DAX Functions
Funnel and pyramid chart by xViz
OEE Dashboard by 3AG Systems
Organization chart by MAQ Software
PI VIZpack by PQ Systems
Individuals control chart
Individuals and moving range control chart
Multi-group individuals chart
X-bar control chart
X-bar and range control chart
Updates to Zebra BI tables and charts
Microsoft 365 usage analytics
NFL analytics by P3
Acterys for Quickbooks, Xero & WorkflowMax
Non-admin support for query diagnostics
MicroStrategy connector is now generally available
FHIR connector is now generally available
Jamf Pro connector
You can learn how to use Power BI in the SQL Server Bootcamp course
From June 30 2020, you will not be able to take a certification in SQL Server 2019 according to the Microsoft blog post
This because the following courses are ending
There will be no further exams in SQL Server 2019.
If you want to learn how to use SQL Server, then enrol in this course: SQL Server Bootcamp
SQL Server 2019 Developer Edition is free!
Yes that is right, you can download SQL Server 2019 for free.
You can download SQL Server 2019 from here :- Download SQL Server 2019
The Developer Edition is the same as the Enterprise Edition, but the only difference is that you can’t use the Developer Edition in a production environment.
Downloading SQL Server 2019 Developer Edition is still great if you want to learn about all the new features that are now in SQL Server 2019.
If you don’t know what SQL Server is, well SQL Server from Microsoft it is a software solution to store and analysis data using a variety of tools.
You will mainly use
SQL Server Engine
SQL Server Integration Services
SQL Server Analysis Services
This is where raw data is stored as information, and you can do a variety of tasks on this data to suit your needs.
This tool is used to extract, transform and load information in a database or another storage locations
This is used for analysis information to try and find out patterns or summary information.
If you have never used SQL Server before, just download it and install it and try it out.
There comes a time when you have to rebuild all the indexes in a database on SQL Server, and you have to figure out a quick way of doing this. You can set up different jobs and routines to schedule the rebuild, but it is handy to have a script.
You have to rebuild indexes when you are the administrator of a database and realised it is going very slow after you have done some investigation, and you have found out that databases have not been build for a very long time (or never).
If you want a quick way to rebuild your indexes on SQL Server using a script, then use the script below.
This script will find all the indexes within a database and rebuild them. You can change the script if you like to add ONLINE rebuilding if you want your tables to be accessible through the rebuild. I have used this index rebuild many times to speed up the process of fixing performance related problem within a database when you know that there has not been a proper maintenance plan set up for the database.
This script on SQL Server 2012, SQL Server 2016 and SQL Server 2017. I have tried this script on these editions and they work and probably will work on future editions.
I would try this script out in a development environment first just to make sure you are happy with the performance because it will have a performance hit on your server when this is running. It may also take a while to run the script as this is dependant on how big your tables are and how many indexes you have.
DECLARE @Database VARCHAR(255) DECLARE @Table VARCHAR(255) DECLARE @cmd NVARCHAR(500) DECLARE @fillfactor INT SET @fillfactor = 100 DECLARE DatabaseCursor CURSOR FOR SELECT name FROM sys.databases ORDER BY 1 OPEN DatabaseCursor FETCH NEXT FROM DatabaseCursor INTO @Database WHILE @@FETCH_STATUS = 0 BEGIN SET @cmd = 'DECLARE TableCursor CURSOR FOR SELECT ''['' + table_catalog + ''].['' + table_schema + ''].['' + table_name + '']'' as tableName FROM [' + @Database + '].INFORMATION_SCHEMA.TABLES WHERE table_type = ''BASE TABLE''' -- create table cursor EXEC (@cmd) OPEN TableCursor FETCH NEXT FROM TableCursor INTO @Table WHILE @@FETCH_STATUS = 0 BEGIN IF (@@MICROSOFTVERSION / POWER(2, 24) >= 9) BEGIN -- SQL 2005 or higher command SET @cmd = 'ALTER INDEX ALL ON ' + @Table + ' REBUILD ' --PRINT @cmd EXEC (@cmd) END ELSE BEGIN -- SQL 2000 command --DBCC DBREINDEX(@Table,' ',@fillfactor) PRINT 1 END FETCH NEXT FROM TableCursor INTO @Table END CLOSE TableCursor DEALLOCATE TableCursor FETCH NEXT FROM DatabaseCursor INTO @Database END CLOSE DatabaseCursor DEALLOCATE DatabaseCursor
Why not try it and give it a go to see if it works for you?
More tools like this are included in the SQL Server Bootcamp course
Please leave a comment below if this script to rebuild your indexes work or what improvements you could do to it.