Let's learn together!
Backup to URL is not new to SQL 2014, it was first introduced in SQL Server 2012 CU2, but you were allowed to use the URL in query only. Starting with SQL Server 2014 this feature has been totally integrated, now you can specify URL while taking Backup or doing Restore no matter if you are performing the task via Query, Backup\Restore GUI, Powershell cmdlets or using SMO.
Read MoreScenario: Auditors need a list of Users who have DBOwner Database role on any of the database which are hosted
Read MoreCheckpoint is an internal process that writes all dirty pages (modified pages) from Buffer Cache to Physical disk, apart from
Read MoreSQL Server 2014 CTP1 is out with lots of cool & exciting features, if you’ve not yet downloaded it, you
Read MoreIn first part we discussed, what is Execution Context, different types of Tokens available and what all information goes into
Read MoreExecution context is maintained by the login that is connected or executing the query, then it checks the permissions of
Read MoreIn First Part Understanding, Analysing and Troubleshooting Deadlocks – Part1 we discussed what is Deadlock, How SQL Server engine behaves
Read MoreIn First Part Understanding, Analysing and Troubleshooting Deadlocks – Part1 we discussed what is Deadlock, How SQL Server engine behaves
Read MoreA deadlock occurs when two or more tasks permanently block each other by each task having a lock on a
Read MoreAs discussed in earlier Login Impersonation Blog Technically SQL Server and windows both can be configured to authenticate to another
Read More