(Manoj Pandey) I was trying to move my Master DBs to another folder by using steps mentioned in my one of [previous blog post]. But after all steps, when I tried to Start the services I got error with following popup:

(Ben Snaidero) SQL Server 2016 introduced a new feature called Row-Level Security (RLS) which gives you the ability to provide fine grained access control to row data within a table based on a function that you define. While I do understand the importance of security when it comes to data I still wo

(Dave Ballantyne) If there is one process that should be simpler than it is out of the box, it is creating Excel spreadsheets from SSIS. Over the years i’ve tried doing it a number of ways, using the built in component, Interop , OLE DB etc all suck to one degree or another.

(Denny Cherry) If you are running a PCI compliant system on SQL Server 2005 you are going to fail your next audit. One of the audit requirements is that the vendors must support the version of your software which you are running on.

(Pinal Dave) With every new release some of the default behavior can surprise because you are so much used to them. But when they don’t behave the same, it baffles to when some of these changes were introduced.

(Paul Turley) A new ground-breaking feature in SQL Server 2016 allows report user context to be passed through shared data sources, enabling role-based, row-level security. This feature doesn’t require complex administration configurations, service principal delegation, Kerberos, Claims/Windows Tok

(Laerte Junior) If you’ve read even just a few of my articles on Simple-Talk you know that I’m a big fan of PowerShell + SQL Server. Over the years I have written a lot about how to collect data from your SQL Servers and store it somewhere, maybe in a database, maybe in a word document.

(Manoj Pandey) Well, there are times when you want to move your master database from the default location to some other drive. Now this activity cannot be done with the normal ALTER DATABASE statement with MODIFY FILE option.

(Sergey Gigoyan) Sometimes we need to JOIN tables using character data types and creating an index will help performance, but the columns may be too large to create an index due to the index size limitations.

(Pinal Dave) Your SQL is tuned perfectly and delivers thousands of rows in milliseconds on your test system, but your end users are complaining about slow application performance. Time is of the essence because the poor performance affects productivity and the company’s ability to make money.