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 Rayis Imayev
"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help...
By Steve Jones
I saw some good reviews of the small gemma3 model in a few places...
Why you should connect resiliently to SQL Server Transient failures happen — in the cloud...
Are you looking for reliable services to test your milk? FARE LABS is an...
Hi everyone I have a 1000 line SQL query that is too long to...
hi, now and then i want one connection in my ssis pkgs to use...