(Martin Nash) The EM documentation covers a selection of privileges you might want to grant to users in database targets in order to allow them to be used for accessing EM functionality. The privileges mentioned are:
Other News
MySQL Type Conversion Rules
(Baron Schwartz) When you send a query to MySQL, you usually don’t need to think explicitly about the types of the expressions in your query. If you compare this to a lot of programming languages, you’ll find that it’s not always the way things work. In strongly typed languages like Java, for exampl
SQL SERVER – SSMS: Database Consistency History Report
(Pinal Dave) The last place I like to visit is always a hospital. With the monsoon season starting, intermittent rains, it has become sort of a routine to get a cycle of fever every other year (seriously I hate it).
All Azure Queues Are Not Equal
Did you know that Microsoft supports two different kinds of queuing in the Azure Platform? You can view a comparison of both at http://msdn.microsoft.com/en-us/library/hh767287.aspx. There are Azure Queues and Service Bus Queue. Each have their own characteristics. Queues are a basic Rest based technology built on top of the Azure Storage Infrastructure for reliable messaging between services. Service Bus Queues […]
Performing a SharePoint site collection backup and restore from an unattached database using just PowerShell
(Dave The SharePoint Engineer) Backing up and restoring a site collection using PowerShell is a pretty straight forward task and you can read the documentation for Backup-SPSite at http://technet.microsoft.com/en-us/library/ff607901(v=office.15).aspx
Pre-Validating Data with PowerShell Before Importing to SQL Server
(Tim Smith) ETL and SQL developers often import files with invalid data in those files. This has limited challenges with small file sizes, but as files grow to gigabytes worth of data, this task can be tedious. One of these forms of invalid data are lines with extra delimiters; in some cases, these
Microsoft SQL Replication Between Windows Azure Virtual Machines
(Chris Skorlinski) You can use SQL Server Replication technologies to move data between local on premises SQL Server to SQL Server running in Windows Azure Virtual Machines or between Windows Azure Virtual Machines. Similar to move data between non-trusted corporate domains, keys are 1) use SQL Ser
Basic Column Encryption of data with SQL Server
(Vinod Kumar) The more I talk with customers on basic architecture, more are the questions about how to implement. These scenarios when talked look great on whiteboard and when they implement and come back (say after 6 months) is completely different.
Shortcut to Consistent SQL Server Installs Using Configuration Files
(Tim Ford) If you support a large environment for SQL Server, then consistency between SQL instances and simplicity of installations are both key to making your life (at the office at least) easier in both the short- and long- runs.
Be More Social: oAuth, Facebook and Xamarin
(Wallace McClure) It isn’t breaking news that social networks are a big deal to your users. But what’s the best way to add that functionality in the cross-platform development world? One of the best ways is through Xamarin, which provides a set of components that allows developers to concentrate on