We are beginning a new series on SQL – A Magic Series. We will see few of many, yet effective tricks & solutions to make SQL easy in daily use. Let’s begin!! So, the Question we are dealing here is: What does the SQL minus sign (-) mean in ORDER BY -emp_no DESC; ? Before answering that, let’s see, how ORDER […]
Posts Tagged ‘SQL Database’
How to create cascading parameters in Reporting services (SSRS)
What is SSRS? SSRS stands for SQL Server Reporting Services. It is a reporting tool developed by Microsoft that comes free with the SQL Server. It produces formatted reports with the tables of data, graph, and reports. Reports are hosted on a server and configured to run using parameters supplied by users. When we run the […]
How To Create Reports Using SQL Server Reporting Service(SSRS)
SQL Server Reporting Services (SSRS) is a SQL Server subsystem that enables the creation of graphical, Mobile and printed reports using SQL Server and other data sources. It is part of Microsoft SQL Server Services suite. SQL Server is a relational database management system (RDBMS) that supports transaction processing, business intelligence and analytics applications. […]
To SQL or to NoSQL? That is the question.
There is a lot of confusion and hype out there regarding persistence technologies. It can be difficult to choose the right one. There are many considerations, and each situation requires thoughtful investigation. In this post, we’ll take a 10,000-foot view to help orient you in this landscape. To get the most out of this discussion, […]
Tackle Security Concerns for Application Modernization
In our previous post, Create Your Transformation Roadmap for Application Modernization, we offered guidance to prepare your organization for successful cloud adoption. Part 2 of this series addresses some of the security concerns you may stumble upon in your cloud journey. We also share some best practices for infusing security across your organization. Questions about […]
Create Your Transformation Roadmap for Application Modernization
In our previous post, Multiple Paths to Cloud: Migrating Legacy Applications, we explored options that allow you to develop, deploy, and manage new applications on cloud but still continue using your existing data center. Next, we’ll provide guidance on planning and preparing your organization for successful cloud adoption. Part 1 highlights the importance of creating a […]
Multiple Paths to Cloud: Migrating Legacy Applications
In our previous blog post, Multiple Paths to Cloud: Taking a Cloud Native Approach, we discussed the importance of a unified plan for cloud adoption as well as the benefits of cloud native to build apps. In part two, we examine options for migrating legacy applications to the cloud. This path to cloud adoption has […]
Multiple Paths to Cloud: Taking a Cloud Native Approach
Cloud technologies support an increasing amount of digital transformation initiatives. While cloud isn’t the ultimate goal of transformation, it provides speed, innovation, and scale to re-imagine business in the digital age. This two-part series reveals the differences between cloud consumers within your company and the benefits of taking a cloud native approach. Consider Your Audience […]
Northwestern Medicine Uses Epic to Deliver Value-Based Care
Recently, Kate Tuttle, my colleague and healthcare marketing guru, wrote a post over on Perficient’s Healthcare Industry Trends blog, describing the shift from a fee-for-service based model to a value-based care model and the subsequent need for a 360-degree patient view. Many healthcare organizations are facing challenges around transforming data into meaningful information – information […]
Azure: Did You Know? Hybrid Connections as VPN Alternative
In real life cloud deployment scenarios one of the very common cases is when only part of the application resides in the cloud. Usually, it’s when there is a legacy system which can’t be migrated to the cloud and resides on premises, or it’s not optimal to deploy entire system to the cloud. After all, […]
Microsoft Azure Data Platform Capability Expands Yet Again
Yet again, Microsoft builds on their increasingly compelling Data Platform story by bringing out new offerings. As my colleague Stan Tartinovksy wrote last week, Azure Data Warehouse is coming. But that’s not the only new piece of the Microsoft data environment. Also announced at the Ignite 2015 conference was a new Elastic Databases feature for Azure […]
Insights on SQL Server 2014 Data Warehousing Edition
For anyone that is thinking about selecting the Data Warehouse edition of SQL Server 2014, I just want to highlight a few things required to install this product and get it up and running. First off though, what is SQL 2014 DataWarehousing Edition? In short, it is a version of SQL server that is available […]