Comments
Sort by recent activity
The syntax seems correct. Let me check with the team. / comments
The syntax seems correct. Let me check with the team.
In some instances the sizes reported by databases can be off. You can try DBCC UPDATEUSAGE to clear that up. More here. / comments
In some instances the sizes reported by databases can be off. You can try DBCC UPDATEUSAGE to clear that up. More here.
It does depend on what kind of performance testing we're talking about. If you want to measure specific query timing metrics, or your disk I/O timings for the server or database, then absolutely not. The overhead introduced by SQL Clone will skew those results.
However, if you're looking at query tuning by using execution plans, then yes, absolutely. The plans generated are going to be the same, using Clone or not. If you're looking to see the volume of I/O of a query, how many pages it reads, then you can also use Clone as part of your performance tuning.
For me, it's whether or not you're attempting to measure system metrics or more granular information. The system metrics, especially I/O are going to be somewhat skewed because of Clone. Most of the other measures are going to be good enough for you to understand what's going on in terms of performance tuning. Just go into it with the knowledge that I/O speed is not something you can accurately measure because of Clone. The rest should be OK with that knowledge. / comments
It does depend on what kind of performance testing we're talking about. If you want to measure specific query timing metrics, or your disk I/O timings for the server or database, then absolutely no...
Generally to get to a multi-step deployment, a lot of people are using deployment software like Team Services Deployment Manager or Octopus. That allows you a very high degree of control on putting additional pre & post steps in line with your Source Control deployments. / comments
Generally to get to a multi-step deployment, a lot of people are using deployment software like Team Services Deployment Manager or Octopus. That allows you a very high degree of control on putting...
I'd like mine to read "Most High Lord of Gorgsnirk, Destroyer of Queries"
Also, I agree, "Noob" probably isn't helpful at the moment. Rookie? Fresher? / comments
I'd like mine to read "Most High Lord of Gorgsnirk, Destroyer of Queries"
Also, I agree, "Noob" probably isn't helpful at the moment. Rookie? Fresher?
I'm attending, speaking and keynoting this year. Very excited about it all. See you there. / comments
I'm attending, speaking and keynoting this year. Very excited about it all. See you there.
Just an FYI on this one, I've been using the tools with SSMS 2017 for quite a while. They work really well. Now, connecting to SQL Server 2017 you might see some hiccups. Let us know. / comments
Just an FYI on this one, I've been using the tools with SSMS 2017 for quite a while. They work really well. Now, connecting to SQL Server 2017 you might see some hiccups. Let us know.
The principal difference is that Microsoft can read the structure below the encryption and then back that up through compression and encryption. It's a difference between access to the underlying code and no access to the underlying code. / comments
The principal difference is that Microsoft can read the structure below the encryption and then back that up through compression and encryption. It's a difference between access to the underlying c...
The problem is that TDE encrypts the data at rest. We can only read what's there and what's there is encrypted. Compressing encrypted files just doesn't work. In fact, I've seen the compression increase the size of files. We would have to be able to read the unencrypted data, which, with TDE, isn't going to happen. / comments
The problem is that TDE encrypts the data at rest. We can only read what's there and what's there is encrypted. Compressing encrypted files just doesn't work. In fact, I've seen the compression inc...
The current version has full internal reporting capability. Here's a video all about it. You can also take advantage of SSRS if you're so inclined. / comments
The current version has full internal reporting capability. Here's a video all about it. You can also take advantage of SSRS if you're so inclined.