SQL Server 2005 has added many new T-SQL commands, one of which is the OUTPUT command. Longtime SQL Server author Dinesh Asanka brings us a short look at how you can use this command.
2019-08-21 (first published: 2007-07-09)
16,319 reads
We can get data in all sorts of formats in the real world. In this new article from Dinesh Asanka, learn how to use scripting to import data from individual Excel cells.
2010-04-28
16,564 reads
Integration Services has a lot of features to enable to you perform ETL operations on data moving into SQL Server. Longtime author Dinesh Asanka brings us an article on
2009-01-14
12,037 reads
Longtime author Dinesh Asanka brings us a short tutorial on importing your data from Excel 2007 into a database using Integration Services.
2008-10-24
15,804 reads
Longtime SQL Server author Dinesh Asanka brings us a new article on backing up an Analysis Services database.
2008-07-17
15,340 reads
This review of RedGate's new SQL Multi Script tool that aids you in deploying a script across multiple databases.
2008-03-20
3,517 reads
This is an entry level look at how temp tables work in SQL along with some tips about how to use them effectively.
2007-10-02 (first published: 2004-02-11)
82,109 reads
Longtime author Dinesh Asanka takes a look at one of the new tools on the market, SQL Refactor from Red Gate.
2007-03-27
3,531 reads
SQL Server 2005 has brought about many paradigm changes, including substantial changes to the SQL Server Agent subsystem. Dinesh Asanka takes a new look at roles and counters in 2005.
2006-05-03
22,432 reads
SQL Server allows multiple triggers on a table, but the order in which they are executed can sometimes cause problems. Author Dinesh Asanka brings us a technique for managing the order of execution for your triggers.
2006-04-06
11,898 reads
I wanted to figure out how big (or approximately how big) my dump file...
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
I have a table. Structure in script below. I have to compare and see...
I have an application team that is insisting on daily (and for some, weekly)...
i see this in the definition of a linked server on our wh sql...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers