MS Access vs MS SQL Server
MS Access is actually a combination of a rapid development UI tool and file system based relational database (JET). Pros: – Easy deployment, … Read more
sql-server
When will SSDT-BI be available for Visual Studio 2015
Looks like it’s all part of one installer as of the August update The SSDT Preview update for August 2015 includes a new … Read more
preserving \n from SQL Server Management Studio
To deal with the truncation try converting it to XML for processing DECLARE @S varchar(max) SELECT @S = ” SELECT @S = @S … Read more
How to remove Crash Dump Files under Windows 7
Disk Cleanup, built-in with Windows, can perform this task for you; you must be administrator to perform this task. Another way is to … Read more
Is gradually growing swap usage an indicator for a memory leak?
Backing swap storage is a parameter that is consultable. When it’s sufficient then over-commitment of memory is not required. My previous answer was … Read more
Why don’t I have SQL Profiler on SQL Server Management Studio?
SQL Server Profiler is an optional component of Management Studio. You may have to find and select it below “Performance Tools” during installation. … Read more
SQL management doesn’t run as different user after Win10 Anniversery update
Solved it by right clicking the shortcut -> Properties -> selected Compatibility -> Change settings for all users -> Run this program as … Read more
Which ports to open for Microsoft SQL Server?
If you only have one instance of SQL Server running, and it has the TCP/IP transport enabled for non-local connections, then chances are … Read more
Clean reinstall SQL Server Management Studio
There is absolute no need to reinstall SSMS or VS. Just find the VS shell installer in the folder, where SSMS installer unpacks … Read more
Network Service Account password
You should be able to change it back by going in to Service Properties and changing “Log on as” to “NETWORK SERVICE” (use … Read more
