Technical Article

Review: Red Gate SQL Bundle 5

When architects speak with database administrators, it is important they come forearmed. Tools can help. While Microsoft's own database management tools cover the most common database administration scenarios, they don't do anything about some of the most common pain points faced when you need to maintain and deploy SQL Server databases for projects under active development. That's where Red Gate comes in.

SQLServerCentral Article

SQL 2000 DBA Toolkit Part 3

Phonetic matching, working on finding terms that are misspelled, is an art and there are a number of ways to handle it. In SQL Server 2000 the tools are limited, but Michael Coles brings us part 3 of his toolkit with some handy functions that can help you with text searching.

External Article

OUTPUT clause in SQL Server 2005

A SQL Server 2005 feature that I appreciate and want to demonstrate is the OUTPUT clause. The OUTPUT clause helps in returning the actual data from a table soon after an insert. Applications require return values such as the new identity value, the computed column value or the default value generated by the default constraint.

Blogs

Overcoming Imposter Syndrome: A Plan

By

My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...

Advice I Like: Celebrate Success

By

“On the way to a grand goal, celebrate the smallest victories as if each...

Programmatically Retrieving MLV Lineage and Refresh Times

By

Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...

Read the latest Blogs

Forums

BCA KCP Benoa No.Tlp.083179431643

By tophitches

Jl. Suwung Batan Kendal No.2, Sesetan, Denpasar Selatan, Kota Denpasar, Bali 80222

BCA KCP Tebet No.Telp:087757645171

By m88bet

Whatsapp:087757645171 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, Tebet...

BCA KCP Newtown Batam telp/wa:083831618807

By Solarsolutionstexas

Whatsapp:083831618807 Komplek Nagoya Newtown Blok O No. 01 & 02, Lubuk Baja Kota, Kec....

Visit the forum

Question of the Day

May the Fourth Be With You Fun

In honor of May the fourth and Star Wars (may the force be with you), finish this quote:

"Do, or do not.  ..."

See possible answers