The mssql extension for Visual Studio Code, used to support SQL Server connections and T-SQL editing, has been updated with IntelliCode functionality and a new Object Explorer, among other new ...

Click "Tools," then "Options," then SQL Server Object Explorer" in Management Studio to open the object explorer. Right-click the "Databases" folder in Object Explorer, and click "Synchronize ...

Lumigent calls this application a "transaction analysis and data recovery solution for Microsoft SQL Server." I call it an essential tool for the SQL Server 7.0 or SQL Server 2000 DBA whose users ...

add-type -AssemblyName "Microsoft.SqlServer.Management.Sdk.Sfc, Version=12.0.0.0,Culture=neutral, PublicKeyToken=89845dcd8080cc91" -ErrorAction Stop. Note that I am running SQL Server 2014 so ...

Installing the Power Tools resulted in a new "Projects" node in SSDT's new SQL Server Object Explorer, or SSOX, (with SSMS-like functionality), where you can see the schema of your database and add, ...

I was talking to a good friend at Microsoft last week, telling him about the problems I’ve been having with SQL Server Management Objects (SMO).