(Krishnakumar Rukmangathan) Hi folks, recently I came across an interesting issue related to impersonation in SSAS and I thought of sharing with you.

(Rajendra Gupta) Microsoft SQL Server 2016 recently launched SQL Server 2016 SP1 and in this tip we will explore the enhancements to DBCC CLONEDATABASE.

(Manoj Pandey) Basically I have a JSON file output that I want to put into a SQL table, but no matter what syntax I try it doesn’t seem to be working.

(Tibor Karaszi) SQL Server keep statistics for where it waits. This statistics can be find using various DMVs, the most famous of them is probably sys.dm_os_wait_stats. This DMV has accumulated wait stats for each type since you started SQL Server.

(Pinal Dave) Sometimes it is important to read the documentation before assuming things based on the text. This blog is the result of one of my quick interaction with a client who had an issue with Maintenance Plan which they created for backup files.

(NEERAJ Sharma) In some situations we need to create table from another table for many reasons, for example, We need to make some changes in the table`s schema, and we want to keep the original schema as a backup or we just want a look a like table, where we can put some data as backup in future etc

(Jack Vamvas) Msg 15151, Level 16, State 1, Line 1 Cannot alter the login ‘DomainGroup’, because it does not exist or you do not have permission appeared when attempting to DISABLE a login. The statement I was executing was :

(Kenneth Fisher) I’m a big fan of dynamic SQL. In the past I’ve written a How to, a Best Practices and even a Generic Dynamic SP although that last one was a bit so so in my opinion. Depending on what type of dynamic code you are writing QUOTENAME will be your best friend.

(Pinal Dave) While trying to help one of my clients, I was shown below error which was received using bulk insert command. The command was used to move data from Azure Blob Storage to SQL Azure Database. Let us see how to fix the error processing request.

(Denny Cherry) This sort of question comes up a lot. And there’s a lot of it-depends built into the answer, so I’ll try and break this down a little bit for you.