(Maksym Petrenko, Mike Winer and Joyce Coleman) Data in a data warehouse can be classified according to its temperature. The temperature of data is based on how often it is accessed, how volatile it is, and how important the performance of the queries that access the data is.
Other News
Retrieving SQL Server Fixed Server Roles for Disaster Recovery
(K. Brian Kelley) We ran into a case recently where we had the logins scripted out on my SQL Server instances, but we didn’t have the fixed server roles. As a result, our recovery efforts were only partially successful. We ended up trying to figure out what the server role memberships were for a ser
What Do You Look For in a DBA?
Have you seen the most recent video shows?! So much data, so many databases…to the moon! Cloud exit strategies, cloud security considerations, wireless access to data… Jeopardy!(tm) ….and the SSWUG Virtual Conference, Bus. Intelligence Upgrade hesitations and much more. [Watch the Show] Open source projects and SQL Server, FrontPage Lives?!, Business Intelligence is profiling…. or is it? SQL Server tools […]
So much data, so many databases…to the moon! Cloud exit strategies, cloud security considerations, wireless access to data…
Pro-Center Video Programming for IT Professionals
What Do You Look For in a DBA?
Kalen Delaney Virtual Workshop: SQL Server 2008 Indexes – Internals and Best Practices – Last Day To Register Feb. 25, 2011 – Along with a good database design I would say that Indexes are a cornerstone to good database performance. There are a lot of other skills you can develop in relational databases; but without these two skills, you’re going […]
Virtualizing SQL Server: Myth or reality?
(Don Jones) Can SQL Server live inside a virtual machine?
Auditing SQL Agent job creation and deletion
(Sethu Srinivasan) Auditing can be used to track and log events that occur on system. You can read more about auditing here.
Calling a WCF Service using jQuery in SharePoint
(Anweshi Deverasetty) This blog post explains how a WCF service can be called using jQuery in a SharePoint application. I won’t cover all of the implementation details. This post will highlight the relevant parts of configuring a WCF service to be accessible using jQuery in SharePoint.
Avoid Exposing Collections Directly as Properties
(Steven Smith) Sometimes your domain objects have one-to-many or many-to-many relationships with other objects. For instance, your Customers might have collections of Orders associated with them. The simplest way to model this is to expose a List field or property off of your Customer class
An early look at jQuery UI Grid in ASP.NET MVC – Data Model
(Tomasz Pêczek) More than a week ago The jQuery UI Team has announced that they are building a grid widget. Don’t get me wrong, I’m a huge fan of jqGrid but when jQuery UI will have its own widget I will strongly consider switching. That’s why I decided to test the widget through some basic samples