(Pinal Dave) Yesterday I wrote a blog post discussing how guest user can become security threat. The script which was demonstrated for the example had a small T-SQL query which creates a new user.

(Baya Dewald) Analysis Services databases must serve a large population of users, and it is best to exploit a scale-out approach: distribute the querying load across multiple hosts, each of which has a copy of the same database.

(Bryan Group) I remember when creating reports were a daunting task and one that I generally left for last to complete. I think almost every developer I’ve come in contact with throughout the years is under the same impression (although there are exceptions to every rule) however with the release of

(Brady Upton) My boss is asking for a list of email addresses and phone numbers for all users in the company. I know this data exists in Active Directory, so how can I access this data from SQL Server? In this tip we walk through how you can query Active Directory from within SQL Server Management

(VidhyaSagar) Filetable is a new feature in SQL Server 2012 which allows application to access files that’s stored in disk via SQL Server, that’s the main function. In other words you can store files and directories to windows NTFS folders and these files can be accessed non transactional from appli

(Zimin Max Yang) Ordinary DataReader methods which use SQL statement to retrieve data directly from databases is most straight forward, and is probably the ultimate function block beneath all other higher architectures. However, maintaining SQL statement written in plain text is a pain.

(Deepak Sharma) In this article we will bind three SQL Server tables with a TreeView in a hierarchical order.

(Matteo Lorini) When restoring a database, that has audit specifications defined, on a different server, the audit events are defined but the audit mechanism is not able to capture audit data. In this tip we walk through the steps you need to take to enable capturing of audit data for the database.

(Nakul Vachhrajani) As you know, I recently completed a 10-part tutorial series on the SQL Server Management Studio (SSMS). As I finished writing the tutorial, I remembered that one of the issues most SQL Server developers encounter are the slow load times of the SSMS. Sometimes, SSMS is just not fa

(Pinal Dave) “No Guests PLEASE!” “Doesn’t your Indian tradition suggest welcoming guests and treating them in the best way possible?” “Yes, but I am talking about the Guest user in SQL Server.” “Oh!”