(Hector R. Madrid) This is a very old issue, but one that sometimes is hard to remember when needed. I tried to monitor index usage to get rid of some indexes which in my opinion are not in use. I implemented the traditional method of index monitoring:
Other News
Reporting Services Single Sign On (SSO) Authentication – Part 2
(Cliff Green) The first post in this series focused on creating some core validation logic to validate a user request. With the core validation completed the next step is to wire up all the pieces required by SQL Reporting Services. This includes implementation of the security extension interfaces
SQL Server BI in the cloud: feasible or fantasy?
(Don Jones) As surely as business intelligence (BI) and cloud computing have become marketing buzzwords, the two IT trends have indeed come together. An increasing number of vendors are offering cloud-based business intelligence systems, including SQL Server BI in the cloud, often targeting them squ
Security – how to assign rights to database objects
(Piotr Rodak) A few days ago my team mate asked me to check out why one of the logins doesn’t have right to execute to a few stored procedures. Allegedly it had the right before. After a few minutes of digging in the source control it turned out that these procedures were scripted with explicit EXEC
WPF: How to change attached property values at run time
(Ged Mead) WPF uses the concept of attached properties to enable child elements to position themselves inside a parent panel. For instance, child elements housed in a Grid can use the Grid.Row and Grid.Column attached properties to have themselves located in their required location.
ASP.NET Session vs ViewState
(Hima) The following is question that is asked by one of the Community Member from Beyond Relational Website to my personal ID.
ASP.NET Chart Controls in SharePoint 2010: Rendering a Sales Chart with Custom Data
(Steve Fox) SharePoint 2010 is great for BI; you have a ton more options. One of these options is the native Chart Web part, which allows you to create and map data from a number of different sources. For example, if you navigate to your SharePoint site, click Site Actions, Edit Page, Insert tab, We
Building High Performance Queue in Database for storing Orders, Notifications, Tasks
(Omar Al Zabir) We have Queues everywhere. There are queues for asynchronously sending notifications like email and SMS in most websites. E-Commerce sites have queues for storing orders, processing and dispatching them. Factory Assembly line automation systems have queues for running tasks in parall
Improve SQL execution times using the DB2 statement concentrator feature and the DB2 statement reoptimization feature
(Dirk Fechner) The article explains how using parameter markers and literals in SQL statements influences SQL execution times. It advises whether to use parameter markers or literals, depending on the type of the application and data distribution characteristics of the database.
Readers Responses: Timeshare The Old Cloud
SelecTViews: The SQL Server Show with Stephen Wynkoop Cloud security – what SPECIFIC steps can you start taking to assure success? Gazzang also on the show today, along with our Facebook question and upcoming events! [Watch the Show] (it’s free) Readers Responses: Timeshare – The Old Cloud One thing that is clear is that the Timeshare of yesteryear and the […]