Custom SSMS Shortcuts for ETL Developer. Part 3: Source-Target Mapping
Provides a SQL code that generates a source-target transformation query and can be helpful at several stages of data warehouse development lifecycle.
2011-09-29
3,693 reads
Management Studio (SSMS)
Custom SSMS Shortcuts for ETL Developer. Part 2: Extended Properties
With the following technique, you can quickly read information stored in the extended properties of a SQL Server table.
2011-09-27
4,588 reads
Custom SSMS Shortcuts for ETL Developer. Part 1: SELECT in a Keystroke
This is the first of three tips on how ETL Developers can be more productive by applying custom SSMS shortcuts to the most often used tasks.
2011-09-22
6,422 reads
Consultando LDAP via SSMS
A query tem o objetivo de consultar o status do usuario AD via Management Studio.
2011-08-22
398 reads
SSMS: The Query Window Keyboard Shortcuts
Simple-Talk's free wallchart of the most important SSMS keyboard shortcuts aims to help find all those curiously forgettable key combinations within SQL Server Management Studio that unlock the hidden magic that is available for editing and executing queries.
2011-06-24
4,306 reads
SQL Server Management Studio keyboard shortcuts - Part 1
As responsibilities are growing every day, a DBA or developer needs to improve his/her productivity. One way to do this is to use as many shortcuts as possible instead of using your mouse and the menus. In this tip we take a look at common tasks you may perform when using SSMS and the associated shortcut keys.
2011-06-15
6,025 reads
When a SQL file will not open in SSMS
What happens when double clicking a .SQL file doesn't open the file in SSMS? This article provides the solution to fixing that annoying SSMS issue.
2011-04-27
14,323 reads
Hiding System Objects in Object Explorer in SQL Server Management Studio
While looking through the new features and improvements in SQL Server Management Studio (SSMS) we found a potentially interesting one to Hide System Objects in Object Explorer in SQL Server Management Studio. In this tip we will take a look at how to Hide System Objects in Object Explorer.
2011-03-09
4,423 reads
RegEx-Based Finding and Replacing of Text in SSMS
So often, one sees developers doing repetitive coding in SQL Server Management Studio or Visual Studio that could be made much quicker and easier by using the Regular-Expression-based Find/Replace functionality. It is understandable, since the syntax is odd and some features are missing, but it is still worth knowing about.
2011-02-04
3,971 reads
Get script for every action in SQL Server Management Studio
I am always conscious to keep a record of all operations performed on my database servers. Operations through T-SQL in an SSMS query pane can easily be saved in query files. For table modifications through SSMS designer I have predefined setting to generate T-SQL scripts. However there are numerous database and server level tasks that I use the SSMS GUI and I would like to have a script of these changes for later reference. Examples of such actions through the SSMS GUI are backup/restore, changing compatibility level of a database, manipulating permissions, dealing with database or log files or creating/manipulating any login/user. I am looking for any way to generate T-SQL code for such actions, so that it may be kept for later reference
2010-12-20
4,878 reads
Blogs
Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
dataMinds Connect 2025 – Slides & Scripts
You can find all the session materials for the presentation “Indexing for Dummies” that...
Forums
Technological Dinosaurs or Social Dinosaurs?
Comments posted to this topic are about the item Technological Dinosaurs or Social Dinosaurs?
DBCC CHECKIDENT
Comments posted to this topic are about the item DBCC CHECKIDENT
Distributed Availability Group Health: T-SQL and Zabbix
Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...
Question of the Day
DBCC CHECKIDENT
What is returned as a result set when I run this command without a new seed value?
See possible answers