(Arun Sirpal) I want to show you what happens when you keep using the undocumented fn_dump_dblog function. (For example if you are consistently dumping the contents into a table for analysis)

(Pinal Dave) Have you ever got into a situation wherein you feel you see something and work for a solution in a completely opposite direction? Recently I was out of the country for a session and at the breakfast table I found a dark red bottle of ketchup which I used for my sandwich.

(Greg Larsen) There are times when you might what to execute a stored procedure where you want the output of the stored procedure to go into a table, instead of having the output display across the screen. Putting the output in a table provides you multiple options for parsing and using the output w

(Eli Leiba) We need to programmatically validate our SQL Server database backups are not corrupted and that the backup can be successfully restored. We have limited storage and time so we are unable to actually restore the database. Are there any options to validate the SQL Server backup and rest

(Pinal Dave) As you might know I try hard to help the community via various channels. Comment on my blog is one of that channels. Here is a blog post which talks about error about Unauthorized Operation.

(Kenneth Fisher) Indexes are great. They speed up our queries. In fact, without them relational database systems wouldn’t work.

(Daniel Nolan) Even a database development framework like Sql Server Data Tools (SSDT) doesn’t get it right all the time, and there are ten deployment ‘gotchas’ in particular that can cause some head-scratching amongst developers to get right.

(Koen Verbeeck) We are using SQL Server Reporting Services (SSRS) 2016. I’d like to create a key performance indicator (KPI) to track the status of my orders. I’d also like to show this KPI on any mobile device. How can we achieve this?

(Manoj Pandey) Today I Detached a Database from SQL Server and moved the mdf/ldf files to an another drive, but while Attaching those files from the new location I got error below by using following script:

(Nakul Vachhrajani) Recently, I started writing about the nuances of SSIS which most accidental SSIS developers may frequently get stumped by due to the differences in behaviour over conventional T-SQL.