Do you wish to know who do change to your table? Who is updating or do anything to your table? ya you can keep log from your app but how about if you wish to done anything on your db site? Then I suggest you to use trigger like below --Create Trigger to insert lastmodifiedtime and lastmodifiedBy acc ...
SQL Server 2008 R2 November CTP has numerous new and enhanced features. This document provides the information you need to fully take advantage of these features. For Analysis Services, numerous enhancements have been added to the PowerPivot field list. These include automatic relationship detection ...
Introduction It was very easy to store location data and just to store the latitude and longitude of the location, by using simple floating point fields. Of course, it was not enough, which can just only achieve simple applications. However, if you want to create more advanced applications or do loc ...
Commençons comme chaque semaine sur l’actualité de Windows Azure. Cette semaine l’éditeur a annoncé l a roadmap de mise à disposition de l’offre : une nouvelle CTP sera disponible le 17 novembre à la PDC,
Back on September 21/22, Microsoft released its most recent cumulative updates for SQL Server 2008. For RTM, this was Cumulative Update #7 (10.00.1818), and for SP1, this was Cumulative Update #4 (10.00.2734). However, if you have requested the SP1 CU #4 hotfix download since November 4th, the downl ...
I just came back from SQL PASS Summit 2009. About a week before that I started to use Twitter and I tried to "tweet" during the conference as much as I can. My Twitter ID is: http://twitter.com/VidasM. I decided that some of my posts could be interesting to people who do not use Twitter, so I cleane ...
En este webcast analizamos las nuevas formas de acceso a base de datos de SQL Server, que están disponibles en ASP.NET 4.0 y Visual Studio 2010. Puede accederlo en la siguiente dirección http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032426170&Culture=es-AR Saludos, Eduardo Castro Marti ...
En esta lección, crearemos las cuentas para que funcionen los agentes de replicación. Deberás crear cuentas de Windows separadas en el servidor local para los siguientes agentes: Agent Location Account name Snapshot Agent Publisher \repl_snapshot Log Reader Agent Publisher
Non-clustered indexes normally have a ‘tipping point’, which is the point at which the query engine decides to change strategies from seeking the index with a nested loop operator back to a seek on the underlying table or choosing to just scan the underlying table and ignore the index. Kimberley Tri ...
In an era of increasingly concern regarding regulations and their impact in the production environment, auditing is one of the most important topics. And, SQL Server 2008 introduces a new SQL Server Audit feature. This post will not cover all the details of it, but it will give you an opportunity to ...
