Everyone should establish some sort of naming convention for their SQL Server platform. It helps to ensure that developers and DBAs can easily find objects and communicate with one another. New author Michael Lato brings us the start of a series on organizing your SQL Server code with an article on naming conventions.
2008-02-29 (first published: 2007-03-07)
15,204 reads
It seems that SQL Server developers avoid stored procedures whenever possible, especially if they are new to the product. Kathi Kellenberger brings us a basic article that you can give to developers that explains the basics of how you use parameters with ADO.NET, especially output parameters.
2008-02-29 (first published: 2005-08-08)
119,778 reads
This article is a step-by-step checklist to help ensure that you are obtaining the maximum performance possible from SQL Server Analysis Services.
2008-02-29
2,565 reads
Discover the new Analysis Services 2005 drillthrough architecture. See how to set up drillthrough in Analysis Services 2005 and get guidance on migrating drillthrough settings from Analysis Services 2000 databases.
2008-02-29
1,461 reads
As a SQL Server DBA or developer, how do you measure the success of your projects? What about your users? Here is an interesting look by Janet Wong at a few of her projects and how their success was perceived. See if any of your experiences are similar.
2008-02-28 (first published: 2007-04-30)
8,389 reads
Discusses Index Selection impact when functions are wrapped around WHERE clause filtering columns
2008-02-28
16,072 reads
This next post on Full Text search from MVP Simon Sabin examines how you can examine the details of what your indexes contain.
2008-02-28
1,620 reads
How important is disk encryption to you? Do you think about all those replicated or copied databases on laptops? Let us know.
2008-02-28
34 reads
How important is disk encryption to you? Do you think about all those replicated or copied databases on laptops? Let us know.
2008-02-28
36 reads
Part 2 of this article illustrates how to enable Change Data Capture on a database, on a table and how SQL Server tracks the data changes of the CDC enabled table.
2008-02-28
2,718 reads
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
You can find the slides and SQL scripts for my session “Spice up your...
Telp/Wa 628218200233 Jl. Sultan Agung No.19-20 Kavling Blok A, RT.007/RW.007, Medan Satria, Kecamatan Medan...
Telp/Wa 628218200203 Ruko GSA Blok Beufort 08 CB CC CD, RT.9/RW.5, South Tanjung Duren,...
Telp/Wa 628217555651 Jl. Swadaya Raya No. 39 Ruko Swadaya City Square Blok 1. 11-23,...
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers