(Alex Kuznetsov) Database programmers are often caught in the paradox of wanting to implement business rules and complex functionality in one place only, but being concerned by the performance hit of having generic functions or procedures that have a wide range of parameters and outputs.

(Julie Lerman) In November 2011, I wrote a column called “What the Heck Are Document Databases?” (msdn.microsoft.com/magazine/hh547103) in which I discussed some of the most well-known document databases: MongoDB, CouchDB and RavenDB.

(Pinal Dave) Upgrading your SQL Server environment is inevitable and I know most many are doing this given SQL Server 2005 support will end first half next year. Whenever I get in front of customers, I have questions always coming my way around upgrades.

(Rohit Garg) Question : Database snapshot captures only data changes or it will also save real database from DDL changes (like table structure, store procedure etc.)

(Bob Pusateri) It’s 10PM*. Do you know who your sysadmin role members are?

(Kris Wenzel) A reader recently asked me to help them solve a problem combining data from multiple tables into a single result. What was interesting was that the solution used the three ways to combine data that we have recently covered, namely: JOINS, set operators, and subqueries.

(Jeffrey Yao) I will be working for a new company soon and on the first day I want to understand the scope of the new environment in terms of the number of installed SQL Server instances (including SSAS, SSRS etc.), their versions / editions and service accounts. I am told they have hundreds of SQL

(Pinal Dave) Row_number function is used to generate a serial number for a given record set. But you need to always use ORDER BY clause so that the numbers are assigned to the specific order.

(Edwin Sarmiento) In a previous tip on Configure Reporting Services to Run in SharePoint Integrated Mode, we’ve seen how we can integrate Reporting Services with SharePoint. However, a lot has changed between SQL Server 2008 and SQL Server 2012 with SP1 and even SQL Server 2014 as far as SharePoint

(Derik Hammer) Often database administrators must ask themselves a simple, yet tedious question, “what server is that database on,” or maybe, “how many servers do we still have on SQL Server 2005?” This article will cover how to use SQL Server’s Central Management Server to manage your server list a