Databases in Azure: Copy and Exports
Toady we are going to make a copy and export your DB to Azure Storage. Lets get started.
2016-07-19
1,173 reads
Data Tier Application
Upgrading Data Tier Applications in SQL Server 2008 R2
Changes are inevitable and like many other things in life your application will change over time. The question is how to upgrade an already deployed Data Tier Application to a newer version; what are the different methods available for upgrade and what considerations should you take?
2010-12-15
2,360 reads
RE: rewrite code to eliminate isnull
I can't believe that there is a general performance problem with ISNULL as it would have been spotted long ago. I have never had any trouble with it and I have used it extensively for many years.If you have a performance problem then it must be related to your specific query or the database design […]
2004-10-26
RE: Help Reqd for Optimization
Agrees with jpipes, get rid of the cursors. Cursors only as a last resort.
2003-07-23
1 reads
Blogs
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Query Store Keeps Switching Itself Off, Getting it Moving Again
I recently received a complaint that Query Store for a particular database was turned...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers