(Robert Sheldon) To be able to make full use of the system catalog to find out more about a database, you need to be familiar with the metadata functions. They save a great deal of time and typing when querying the metadata.

(Pinal Dave) This is a follow up blog post of my earlier blog post on the same subject. You can read my earlier blog post over here. I recently received an email where a user asked how to add more than one new column to an existing table with a default value.

(Jason Thomas) I have always been fascinated by maps as a child, and could spend endless hours looking at the globe my parents got me as a present for my 5th birthday. I was so hooked on to it that my parents even considered removing it from my room fearing that it could hamper my social development

(Manoj Pandey) Today while creating a mapping by using import method & template I got a pop-up with following error message in Designer:

(Greg Larsen) In my last article I talked about restricting read access using the new SQL Server 2016 filter predicate feature of a security policy. With the new security policy feature in SQL Server 2016 you can also restrict write operations at the row level.

(Koen Verbeeck) SQL Server 2016 comes with the integration of the popular language R into the database engine. This feature has been introduced in SQL Server 2016 preview CTP 3.0 and is called SQL Server R Services.

(Pinal Dave) One of my recent interaction with a client was to assist in performing Upgrade the SQL Server 2008 R2 with service pack 2.

(Sandeep Chanda) At the recently concluded Build Conference, the Microsoft Azure team announced the preview of Functions, an app service that allows you to execute code on demand. Azure Functions is event-driven and allows serverless execution of code triggered as a result of an event or a coordinat

(Michael J. Swart) The best way to avoid tempdb GAM and PFS contention caused by table-valued parameters (TVPs) is to use Memory-Optimized Table Variables.

(Denny Cherry) There are some systems out there which have a lot of RAM, but only a few processors and these machines may need a non-standard NUMA configuration in order to be properly setup.