Microsoft Azure Enhancements

Posted Posted in General

From Read IT Quik: Qubole recently announced that the Qubole Data Platform now supports Microsoft’s business analytics service Power BI. The recently announced integration with Power BI, powered by the company’s Presto implementation, empowers customers with the sole offering on Azure that can federate Power BI queries across varied big data sources, thus allowing users to interact with, analyze, and discover new insights. Qubole, natively designed for Microsoft Azure, provides tight integration across security, compute, and storage along with other crucial facets of the Azure cloud architecture. The integration with Power BI takes that up a notch, bringing in a […]

SQL Phonetic Functions

Posted Posted in General

From IT Jungle: You can use phonetic functions to select or order rows based on the phonetic sound of a string as opposed to the actual characters in the string. The obvious use of phonetic functions is with names, but they can be used with any string columns. I must admit that this touches on one of my pet peeves — the spelling of my surname. I have lost count of the number of times I have had to spell my name two, three, or four times for someone on the phone — and they still get it wrong. (Why […]

How Azure Cloud Shell Can Help You Manage Resources

Posted Posted in General

From TechTarget: Azure Cloud Shell’s browser-based model frees IT teams from installation headaches but presents some formatting and timeout issues that admins need to watch for. While Azure management tools, such as a PowerShell module or the Azure command-line interface, can help admins control their resources, these locally installed systems have their downsides, including software dependences, potential configuration challenges and latency from having to reach an Azure data center that’s potentially thousands of miles away. Azure Cloud Shell — a browser-based command-line tool — reduces these burdens. That said, it can also introduce its own set of challenges if admins […]

Common MongoDB Mistakes

Posted Posted in General

From Info Q: I’ve been a database person for an embarrassing length of time, but I only started working with MongoDB recently. When I was starting out with MongoDB, there are a few things that I wish I’d known about. With general experience, there will always be preconceptions of what databases are and what they do. In hopes of making it easier for other people, here is a list of common mistakes. Key Takeaways – Even though MongoDB doesn’t enforce it, it is vital to design a schema. – Likewise, indexes have to be designed in conjunction with your schema […]

SQL Injection Vulnerabilities

Posted Posted in General

From TechTarget: What’s your situation with regard to web application SQL injection? Are you testing for it from all the right angles? Many people have discovered SQL injection vulnerabilities in their environments and are doing something about it, while others are unaware that they even exist. Still others have a false sense of security because their vulnerability scanners are finding some injection vulnerabilities. Whatever your situation is, SQL injection is arguably the worst of all the web vulnerabilities. It not only exposes sensitive records in your databases, but it also exposes your business to some sizable risks if the issues […]

Copying Files in PowerShell

Posted Posted in General

From TechTarget: Admins proficient in PowerShell can build advanced scripts that copy files for different scenarios with added measures to ensure the duplicates reach their destinations. Copying files between folders, drives and machines is a common administrative task that PowerShell can simplify. Administrators who understand the parameters associated with the Copy-Item commands and how they work together will get the most from the PowerShell commands to copy files. PowerShell has providers — .NET programs that expose the data in a data store for viewing and manipulation — and a set of common cmdlets that work across providers. These include the […]

Azure SQL v SQL Server

Posted Posted in General

From TechGenix: Over the last few years, Microsoft has been focusing more on cloud computing and storage, in a bid to take a substantial market share in this competitive and lucrative market. To this end, it has come up with many products designed for the cloud, and one such product is Azure SQL. Azure SQL is a cloud-based service built along the lines of SQL Server, and so shares many features with on-premises SQL Server. Let’s take a detailed look into how these two database systems compare with each other, and which of the two is best in different situations. […]