May 312016
 
 Posted on: May 31, 2016  Posted by  No Responses »
Find End-Of-Month (EOMONTH) date from SQL

Hi Friends, have you ever struggled to find the end of the month date; I know its not a big deal you can get it from Calendar but what if you need that date for some business logic of yours? May be for Invoice processing or some other scheduling within SQL Server and you want [Read More]

May 272016
 
 Posted on: May 27, 2016  Posted by  No Responses »

RLS (Row Level Security) is a brand new feature which has been introduced in Azure, SQL Databases (v12) and SQL Server 2016. This feature provides you access control on rows of tables for users\logins querying the data. Basically, it filters the rows based on certain characteristics of Users\Logins. After getting this feature it becomes very [Read More]

May 172016
 
 Posted on: May 17, 2016  Posted by  No Responses »
Active Geo Replication Introduction

Active Geo Replication is very similar to AlwaysOn and just like AlwaysON feature you can configure up to 4 readable secondary databases in the same or different regions. All your secondary databases are always available for read only workload. On 25th April 2016 Active Geo replication was made available to all service tiers, means you [Read More]

May 132016
 
 Posted on: May 13, 2016  Posted by  No Responses »

Microsoft announced (General Availability) GA Azure SQL Database elastic pools on 12th May 2016. Azure SQL Database elastic pools are ideally suited for SaaS and line-of-business applications that need the performance, availability, and security isolation benefits of provisioning one database for each tenant or application. Each elastic database in the pool gets the resources it needs [Read More]

May 132016
 
 Posted on: May 13, 2016  Posted by  No Responses »
Must know facts before configuring Dynamic Data Masking

Dynamic data masking is yet another feature of Microsoft to ease your life and provide you out of the box capabilities which decrease the overall time to market for your applications. You don’t have to code the way you had to do it earlier to achieve it. But there are things you must know before configuring [Read More]

May 122016
 
 Posted on: May 12, 2016  Posted by  No Responses »

Microsoft announced new compatibility level 130 for new Azure SQL Databases on 10th May 2016. Azure SQL Database runs millions of databases under several different T-SQL versions, preserving backward compatibility for applications. SQL Database implements a versioning technique called “compatibility level.” The compatibility levels are: SQL Server 2008 and SQL Database v11: 100 SQL Server 2012: 110 SQL [Read More]

May 102016
 
 Posted on: May 10, 2016  Posted by  No Responses »
All about Dynamic Data Masking security

If you are not aware about Dynamic Data Masking, I would recommend you to first read Dynamic Data Masking Intro, How to configure Dynamic Data Masking using Azure SQL Database portal or Using T-SQL. Reading these links will help you understand this feature better. let’s see All about Dynamic Data Masking security.   All about Dynamic [Read More]

May 062016
 
 Posted on: May 6, 2016  Posted by  No Responses »
Right Azure storage replication for SQL Data Log file

As we know starting SQL Server 2014 we can easily place our SQL Data and log files in Azure, it is indispensable to choose Right Azure storage replication for SQL Data & Log file – to know more click here to know about the feature to place SQL Data & Log Files on Azure, click here [Read More]

error: Content is protected !!