Viewing task status for related objects in the Azure Portal
When working in the Azure portal finding task information when performing tasks against an object that is related to an object can be tough. Before I dive into the how, let me demystify what I’m talking about a little more, as that first statement is a little vague. In the case of my example I…
The post Viewing task status for related objects in the Azure Portal appeared first on SQL Server with Mr. Denny.
When using Always Encrypted in SQL Server 2016, how do I as the DBA view the data?
The short answer is, you don’t. The entire point of Always Encrypted is that the DBA can’t view or modify the data using SQL Server Management Studio. The only way to view and change the data is by using the front end application that created the data. This means that if someone submits a ticket…
The post When using Always Encrypted in SQL Server 2016, how do I as the DBA view the data? appeared first on SQL Server with Mr. Denny.
Fast Track: RealtyTrac’s High Availability Solution
RealtyTrac® is the leading provider of comprehensive housing data and analytics for the real estate and financial services industries, Federal, state and local governments, academic institutions, and the media. Their data is aggregated from parcel-level records of more than 130 million U.S. residential and commercial properties and delivered through customizable products including bulk file licensing, APIs […]
Differences between data types between SQL Server and Oracle
Recently there has been some talk online about how SQL Server processes data type conversions compared to how Oracle’s method for type conversion. I figured that I would clear up some of the confusion that’s out there. When concatenating a number (like an INT) to a string (like a VARCHAR) you get an error message…
The post Differences between data types between SQL Server and Oracle appeared first on SQL Server with Mr. Denny.