(Thomas LaRock) Last week I was visiting the SolarWinds home office in Austin and hanging with my fellow Head Geeks. Our conversations often cover a wide range of topics and at times even turn into teaching lessons for each other. I get to learn about networks, storage, virtualization, monitoring, e

(Derik Hammer) SCHEMABINDING is an option that is available for objects in T-SQL which contain user defined code. Examples include, stored procedures, indexes, and functions. Straight from MSDN, SCHEMABINDING…

(Michael J. Swart) One of the limitations of indexed views is that their initial clustered indexes cannot be created online. Try it and you’ll get this error:

(Pinal Dave) I have been getting my hands dirty working with PowerShell commands for a fun learning experience and few have made to this blog. The after effect of this is that I have been pinged for few queries on them too.

(Thomas LaRock) Last week I was visiting the SolarWinds home office in Austin and hanging with my fellow Head Geeks. Our conversations often cover a wide range of topics and at times even turn into teaching lessons for each other. I get to learn about networks, storage, virtualization, monitoring, e

(Derik Hammer) SCHEMABINDING is an option that is available for objects in T-SQL which contain user defined code. Examples include, stored procedures, indexes, and functions. Straight from MSDN, SCHEMABINDING…

(Michael J. Swart) One of the limitations of indexed views is that their initial clustered indexes cannot be created online. Try it and you’ll get this error:

(Scott Murray) Any report designer will often need to find ways to offer easy navigation paths to report consumers. SSRS provides several methods to navigate a report including document maps and bookmarks.

(Pinal Dave) For folks who have not worked with SQL Server Database snapshot feature, please refer to the blog I wrote sometime back (SQL SERVER – 2008 – Introduction to Snapshot Database – Restore From Snapshot).

(derekewilson) Data warehouses typically pull data from various sources and combine the data into a common repository. Keeping up with the source systems and what data is being pulled from each system can be challenging.