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 →
Recently someone asked me how to connect SQL Server Management Studio to the database on a Docker image for NAV 2018. Before I could answer Jakub Vaňák already did and said: “Of course it is. If you want to access the default instance inside one of MS NAV containers you can access it from your docker … Read More →
Using Visual Studio Code as a replacement for Sql Server Management Studio is very easy. Once you have downloaded and installed VSCode (download it here), you need to add the mssql extension in Visual Studio Code, which you can find here. Then create a new file in VSCode and give it the extension .sql. The mssql … 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