Did you know that by precompiling LINQ queries you might actually be degrading your app’s performance if you’re not careful? Julie Lerman explains how to ensure you’re not re-precompiling queries each time and losing the expected performance benefits across post-backs, short-lived service operations and other code where critical instances are going out of scope.
With a SQL-meme going through the SQL Server community this week, Steve Jones comments on the various suggestions and offers a way to get your voice heard.
Steve Jones talks about encrypting stored procedures and why it's a bad idea. And that it's a feature that should be removed from SQL Server.
Moving files around is a task that many DBAs need to accomplish. Whether as part of an import or export process, or just for administration purposes, this new article from JD Gonzalez can help you solve this problem.
This article covers the basics of TRY CATCH error handling in T-SQL introduced in SQL Server 2005. It includes the usage of common functions to return information about the error and using the TRY CATCH block in stored procedures and transactions.
This is a matrix transposition challenge. Your job is to change the position of the numbres in a 5x5 matrix.
This article from new author Oleg Netchaev describes the cursor-less script used to generate insert statements. This allows you to efficiently and easily add data generation statements to your project deployments.
This Friday's poll asks what changes the community might like to see at SQLServerCentral.
How do you, as a database administrator, display the wealth of knowledge in your Database to the organization in a meaningful way -- Business Intelligence.
In this sponsored article from Cloudberry, learn how you can backup your SQL Server data to the Amazon EC3 cloud.
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...
BCA KCU THAMRIN Hub.0851•8812•0691 Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, Menteng, Kec....
WhatsApp 083135766741 Ruko Ngaliyan Square, Jl. Prof. Dr. Hamka No.17 No. 3A, Purwoyoso, Kec....
WhatsApp 083135766741 Ruko Srondol Square, Jl. Setia Budi No.147 Blok 5 & 6, Srondol...
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