Some time ago I mentioned a brand new product: SQL Operations Studio. Its feature set was small and aimed mainly at the developer persona. Now, recently, SQL Operations Studio was rebranded as Azure Data Studio. Although they’re effectively the same thing currently, you do need to install Azure Data Studio separately from your existing sqlops Read More →

SQL Operations Studio (preview) is a free tool that runs on Windows, macOS, and Linux, for managing SQL Server, Azure SQL Database, and Azure SQL Data Warehouse; wherever they’re running. SQL Operations Studio (preview) is built on top of Visual Studio Code and offers a lightweight, keyboard focused modern code workflow experience when working with Read More →

SQL Server Management Studio (SSMS) is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server. SSMS combines a broad group of graphical tools with a number of rich script editors to provide developers and administrators of all skill levels access to SQL Server. This release features: improved compatibility with Read More →

Microsoft has made the new Power BI preview available for everyone. If you go here: https://www.powerbi.com you can create your free account to test out the new features of Power BI. Here you can download the Power BI Designer: https://www.powerbi.com/dashboards/downloads/designer so you can get started to create your own Power BI reports. Have a look here to Read More →

The latest weeks I have received  a couple of questions from various Dynamics NAV consultants regarding strange SQL errors Dynamics NAV was throwing. A couple of examples: Table XXXXX coes not exist. Cannot find the user ‘$ndo$…….’, because it does not exist or you dont have permission. You do not have permission to execute table XXXXX. You Read More →

I’m learning about #SQL2012 by watching video sessions at the #SQLServer 2012 Virtual Launch Event: http://www.sqlserverlaunch.com ! This whitepaper provides an overview of the new features, benefits, and functionality in Microsoft SQL Server 2012: SQL Server 2012 What’s New Whitepaper