Tag: Security

Feed: Databasejournal.com - Feature Database Articles. Author: . If you are using row level security in SQL Server 2016 you might find users are updating or inserting rows of data that keep them from seeing the row after they have performed the update or insert statement.  This happens when a user updates or inserts a row that doesn’t pass the filter rules for row level security.  If you want to prevent this from occurring, you can use a blocking predicate. A blocking predicate can be used to keep users from shooting themselves in the foot.  Meaning it will keep a ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Have you ever had a need to place some simple row level security on a SQL Server table?  Meaning you only want certain people to select or update a row.  Well now you can do that in SQL Server 2016 by using row level security.  To implement row level security all you need to do is create a filter predicate, which is just a function, and have a security policy that references that function.  Let me show you how to accomplish this. Suppose you have a table named dbo.Customers that looks like ... Read More

Feed: Microsoft Power BI Blog | Microsoft Power BI. Author: . 2016 has been quite the year for the Power BI Desktop. Over the course of our 11 releases this year, we’ve delivered over 190 features and improvements based on your feedback. For December, we are taking a break from our monthly releases to focus on quality. We’ll start the new year with another Desktop release. In this month's post, we’ll take a look back at the past year, recapping several of our favorite features, and taking a look at our big focus areas from this past year. If you'd like to see ... Read More

Feed: AWS Compute Blog. Author: Bryan Liston. Stephen Liedig, Solutions ArchitectCustomers are using AWS Lambda in new and interesting ways every day, from data processing of Amazon S3 objects, Amazon DynamoDB streams, and Amazon Kinesis triggers, to providing back-end processing logic for Amazon API Gateway. In this post, I explore ways in which you can use Lambda as a policy engine to manage your AWS infrastructure. Lambda’s ability to react to platform events makes it an ideal solution for handling changes to your AWS resource state and enforcing organizational policy. With support for a growing number of triggers, Lambda provides ... Read More

Feed: Planet MySQL. Author: Severalnines. All backup methods have their pros and cons. They also affect database workloads differently. Your backup strategy will depend upon the business requirements, the environment you operate in and resources at your disposal. Backups are usually planned according to your restoration requirement. Data loss can be full or partial, and you do not always need to recover the whole dataset. In some cases, you might just want to do a partial recovery by restoring missing tables or rows. In this case, you will need a combination of Percona Xtrabackup, mysqldump and binary logs to cover ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Introduction Advance Analytics is becoming the norm now. Every organization wants to use the power of advanced analytics to predict future outcomes and take proactive corrective measures to remain competitive and win over its competitors. Therefore, it’s now becoming necessary for every organization to exploit the data that they have (or in some cases external data as well) and predict future outcomes to remain competitive by offering their customers what they want, when they want, and where they want. Looking at this potential, SQL Server 2016 brings native support for doing advanced ... Read More

Feed: Latest imported feed items on Analytics Matters. Evaluating risk vs. return of a big data initiative can be tricky, especially because the open source market is so active and fluid. Financial risk aside, business risk actually plays the bigger spoiler in properly estimating future cash flows and profitability of a big data project. Accounting for risks such as competition, emerging technologies, rising costs and regulatory challenges could make the difference between an accurate financial big data ROI forecast and one that’s woefully wrong. In addition to project risk (which has its own set of challenges), there are four business ... Read More

Feed: Microsoft Azure Blog. Author: Nicole Herskowitz. To paraphrase Daniel Webster (American Statesman, 1782-1852), “If all my developer skills were taken from me with one exception, I would choose to keep the power of learning like a developer, for by it I would soon regain all the rest.” To be a good developer is to be a perpetual learner; it is essential for survival. The problems you solve are always changing, but the programming languages, platforms, hardware, tools and technologies you use to solve them are all moving targets. Even the foundation of the agile development processes most developers follow ... Read More

Feed: Latest imported feed items on Analytics Matters. We are living in an unprecedented era of corporate risk. A 2016 report released by the Computing Technology Industry Association estimates that three out of every four organizations within the last year have been hit by at least one security incident. In the last year alone, there have been breaches and attacks at financial institutions, major telecom companies, universities, healthcare organizations, gaming companies and transportation systems. Risk can come in many different forms, operational, reputational, technological, product, cyber security and fraud, to name a few. A single event, like Samsung choosing to ... Read More

Feed: Microsoft Azure Blog. Author: Microsoft Azure. This post is authored by Julia White, Corporate Vice President, Azure + Security Marketing. Earlier this fall we once again invited our community of IT professionals, developers, and technology decision makers to participate in the 2016 Future of Cloud Survey led by North Bridge Growth Equity Venture Partners and research analyst firm Wikibon, which analyzes trends in cloud computing adoption, use, and challenges every year. The results are in, and while many of the findings reiterate trends we’ve been seeing, there are also a few new trends emerging. As we turn the corner ... Read More