Database Weekly is the seven-day roundup from SQLServerCentral. We scour the Internet with a fine-toothed set of queries to compile the most informative weekly newsletter about SQL Server. Over 670,000 SQL Server professionals rely on it to kick-start their week.
Sign up to our newsletter now, to keep up to date with all the latest news.
Latest Database Weekly Newsletter Articles
Find all triggers in a SQL Server Database
Do you know what triggers lurk in your database? Triggers can be implemented to enforce business rules or referential data integrity in database applications.
There are even triggers that allow data modifications to multiple base tables of a view.
SQL–More memory and CPU is not always a win
Granting more to one program (or service), will take it away somewhere else. SQL is no exception, in fact it will happily consume all the resources you grant it – at the risk of starving other systems, including the OS.
Azure Blob Storage Part 4: Uploading Large Blobs
Two ways to upload a file in blocks. One way is to use the parameters that can be changed when calling the UploadFile method on the CloudBlockBlob object. The other way is to programmatically break the file into blocks and upload them one by one, then ask Azure to reassemble them.
Parameter Sniffing, Part 1
Klaus Aschenbrenner describes the scope of the Parameter Sniffing problem, arising when you work with parameterized SQL statements like stored procedures in combination with the plan caching mechanism of SQL Server.