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,348 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,623 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,222 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,834 reads
Longtime SQL Server author Dinesh Asanka brings us a new article on backing up an Analysis Services database.
2008-07-17
15,556 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,556 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,267 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,544 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,493 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,963 reads
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
J & K, Jl. Caman Raya No.17, RT.003/RW.003, Jatibening, Kec. Pd. Gede, Kota Bks,...
Jl. Gatot Subroto Tim., Penatih Dangin Puri, Kec. Denpasar Tim., Kota Denpasar, Bali 80237
Komplek Bekasi Town Square, Ruko CBD Boulevard Jl. Cut Mutia Blok G No. 1&2,...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers