IT Nota

  • Home
  • How To
  • .NET
  • WordPress
  • Contact

How to Change Default Project Folder in SSMS

There are several ways to configure SSMS to point to your own working directory as the default. Here's the easiest to do it without registry hack. You just need to edit the Visual Studio settings file (XML format). Open Windows Explorer, and go to (you can force type): Find vssettings file with the latest modification date. The file name should follow the convention … [Read more...]

May 8, 2014 Filed Under: How To Tagged With: SQL Server, SSMS

How to Find a Column Name in SQL Server Database

This query was originally appeared from SQL Authority Blog and I find it really useful when you need to find a column in any tables in a database. If you need to find all column names that are in the database, just comment out or delete the highlighted line from the SQL command above. Further Reading SQL SERVER – Query to Find Column From All Tables of Database How to Get Table … [Read more...]

March 13, 2014 Filed Under: Database Tagged With: SQL, SQL Server

Using Connection Coloring in SSMS Tools Pack

From previous posting, we demonstrated a way to use custom color coding using SQL Server Management Studio's (SSMS) Registered Servers properties. But using the feature can be very dangerous if you don't have the discipline to follow a strict process of opening new query from the registered servers pane. For example, if you use Change Connection button, the color will stay the same as the last … [Read more...]

March 5, 2014 Filed Under: Database Tagged With: SQL Server, SSMS

How to Use Custom Color in SSMS

With many mistakes made by developers and DBAs alike firing a query in a wrong environment, there is one easy thing that can be done to alleviate this problem. That is by using the color coding on the status bar and you can set this up in the server registration on your SQL Server Management Studio (SSMS). This feature is so easy to overlook because many people just don't bother to look at the … [Read more...]

March 3, 2014 Filed Under: Database Tagged With: SQL Server, SSMS

How to Create a SQL Server Agent Proxy Account

When you need to execute job steps under a specific security context, proxy account can be used to allow users who are not sysadmin to run them. Before you can create a proxy account, you first need to create a credential that needs to be linked later. This can be a window service account or a user's active directory id. Creating a Credential In the Object Explorer, expand Security … [Read more...]

February 6, 2014 Filed Under: Database Tagged With: Microsoft SQL Server, Proxy Account, Server Agent, SQL Server

  • « Previous Page
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • Next Page »
Buy me a coffee Support this site
Buy Me a Coffee?

Categories

  • .NET
  • Coding
  • Cybersecurity
  • Database
  • How To
  • Internet
  • Multimedia
  • Photography
  • Programming
  • Resources
  • Review
  • Tips and Tricks
  • Use Case
  • WordPress
  • Writing

Recent Posts

  • How to Check Installed .NET Framework Version
  • How to Remove .NET Runtime and SDK on Mac
  • How to Solve Intermittent 403 Error in IIS
  • How to Show Hidden Folders and Files in Mac Finder
  • How to Solve MS Office VBA Compile Error UserAuthentication

Recent Posts

  • How to Check Installed .NET Framework Version
  • How to Remove .NET Runtime and SDK on Mac
  • How to Solve Intermittent 403 Error in IIS
  • How to Show Hidden Folders and Files in Mac Finder
  • How to Solve MS Office VBA Compile Error UserAuthentication
  • RSS

Tags

.NET Access AdSense ASP.NET Cdonts Dll Classic ASP Code Editor ETL FSharp Genesis Framework Git Google HP Asset Manager HTML HTML5 Hugo IIS Information Security Internet Internet Information Services iOS JAMStack Linux macOS Microsoft Microsoft SQL Server MVC PHP Python Simple Mail Transfer Protocol Smtp Server Social Media SQL SQL Server SSIS SSMS SSRS Sublime Text Visual Studio Visual Studio Code VPN Windows Windows 8 Windows 10 Windows Server

Copyright © 2011-2022 IT Nota. All rights reserved. Terms of Use | Privacy Policy | Disclosure