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,660 reads
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,660 reads
With the following technique, you can quickly read information stored in the extended properties of a SQL Server table.
2011-09-27
4,535 reads
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,316 reads
A query tem o objetivo de consultar o status do usuario AD via Management Studio.
2011-08-22
394 reads
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
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
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
12,773 reads
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
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
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
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
In a previous blog post we went through how to build a Docker container...
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
I'm tracing activity on one database and would like to include the client_app_name in...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I'm only processing 50,000 records not everything from the Table where there are 250,00...
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers