Yes, SQL Azure's contained database model will take some getting used to, but the issue isn't just about security, there are technical reasons why this is done. In a cloud...

I once inadvertently coded an update script that looked something like this:

SET @User = 1234;

UPDATE VeryBigTable
SET Status = 0
WHERE User = User;

From...

Assuming each query has the same parameters and the data was static between executions, I would expect the number of page reads and the execution plan to be the same....

Hi Ben,
Using the following Google search expression, I was able to find the diagram you're looking for or at least something similar. It looks like there may be several...

OK, I now see this was entered under 'Articles Requested'. I thought it was a general question. Offhand, I don't know of any limitations that TDE would place on other...

Generally speaking, there is no good reason to repeatedly shrink a database on a schedule. What this does is reduce the physical size of the data file on disk. The...

In the case of a distributed database environment, like retail point of sale, I'd use a composite key like StoreID + TransactionID before I would resort to using GUIDs. So...

This is an old thread, but 
1.  So the files do not become further corrupt, make a backup copy of the .mdf data and .ldf log files. This files should...

I'm not seeing a link the original article, so I'm not sure about the question. However, regarding the question of using TDE with database Stretching, I don't see why it...

The following website has a collection of 3,000+ visual studio themes for download, which also can be imported into SSMS. You can even create new themes here as well.

Unless my off-hours learning and hobby programming turns into a full fledged side business, I don't plan plan to ever spend $,$$$ for a personal on-premises (ie: setup in my...