SQL Server

Power BI February 2020 Update

Here is what is in the Power BI February 2020 update Dataset management Incremental refresh is now generally available Reporting Hierarchical slicer (preview) Updates to the new ribbon (preview) Title bar updates Keytips Accessibility Modeling New DAX Functions FirstNonBlankValue LastNonBlankValue Visualizations Funnel and pyramid chart by xViz OEE Dashboard by 3AG Systems Organization chart by …

Power BI February 2020 Update Read More »

Microsoft Ending SQL Server 2019 Certifications

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 Microsoft Certified Solutions Associate (MCSA) Microsoft Certified Solutions Developer (MCSD) Microsoft Certified Solutions Expert (MCSE) There will be no further exams in SQL Server 2019. …

Microsoft Ending SQL Server 2019 Certifications Read More »

Database

What is a database?

What is a database? I thought I would write this article for people who have no experience in SQL Server or know what a database is. A database is a method of storing information where that information can be accessed to answer or to solve questions. There are many types of databases that you can …

What is a database? Read More »

SQL Server Information

SQL Server Information from a script

SQL Server Information from a script. SQL Server has a lot of useful information that you need to administrate or develop solutions. Here is a great SQL Script to find out information about your SQL Server Instance and operating system. — Get selected server properties SELECT SERVERPROPERTY(‘MachineName’) AS [MachineName], SERVERPROPERTY(‘ServerName’) AS [ServerName], SERVERPROPERTY(‘InstanceName’) AS [Instance], SERVERPROPERTY(‘IsClustered’) …

SQL Server Information from a script Read More »