(Mary Mikell Spence) Using RMAN to clone a database is a method that been around for years and years now. Judging from the number of questions that I personally get about it, along with the number of questions I see posted out in the “Interweb”, it’s clear that there is still room for one more step
Author: SSWUG Research
The Performance of the T-SQL Window Functions
(Dwain Camps) Window Functions in SQL greatly simplify a whole range of financial and statistical aggregations on sets of data. Because there is less SQL on the page, it is easy to assume that the performance is better too: but is it?
jQuery UI Tabs with history and bookmarking using jQuery BBQ
When navigating through the steps we would want to use the browser history to go forward and back through the steps. This isn’t included in the jQuery UI tabs we are using, so we need another solution. jQuery BBQ is a library that uses the HTML5 hashchange.event.
SQL Server Concatenate Row Values using T-SQL
(Guru Pratap Ketepalli) Some time we need to show concatenated row values in the SQL Select Statements. Lets say, if we have Customers, Orders and Order details. Incase, if we have to list out all Products that each customer ordered in a single column.
Manage SQL Server Efficiently with PowerShell Remoting
Pro-Center Video Programming for IT Professionals
Dimensional Modeling for the DBA
Pro-Center Video Programming for IT Professionals
SSIS Patterns-Performance testing and optimization using Hashing
Pro-Center Video Programming for IT Professionals
SMO Internals for High Performance Automation
Pro-Center Video Programming for IT Professionals
The Future of the DBA
Pro-Center Video Programming for IT Professionals
Excel 2013: BI for the Masses
Pro-Center Video Programming for IT Professionals