|
|
-
|
|
Microsoft SQL Server Sustained Engineering group is pleased to announce the release of SQL Server 2008 Service Pack 3 (SP3). Both the Service Pack and Feature Pack updates are available for download on the Microsoft Download Center. As part of our continued commitment to software excellence for our ......
|
|
-
|
|
Performance Monitor a.k.a perfmon is used to monitor different counters for different purposes. However, some counters are bit confusing. Process and Processor two misleading counters so thought of putting this note. Processor When adding processor object, you have _Total object and 0, 1 .. which ......
|
|
-
|
|
Do you think we have enough SQL Server experts? Article from Brain indicate there are shortage in SQL Server experts. “There are certainly many world-class SQL Server experts, and there have been for quite some time. I suppose it’s more of a matter if there are enough available to satisfy demand. O......
|
|
-
|
|
I am not a fan of Dilbert. But this seems to be something related to SQL. ......
|
|
-
|
|
Microsoft has released SQL Server 2008 SP1 CU8 (Build 2775). There are 18 fixes in this cumulative update, and most of them are for Reporting Services and Analysis Services. Microsoft released SQL Server 2008 R2 RTM CU1. It is Build 1702, and it contains 76 fixes. ......
|
|
-
|
|
Why Auditing? Auditing has become a must in today market environment mainly due to the fact that most security standards required. You need auditing to for following reasons. 1. Detect the system misuse and prevent it being happened again. 2. Take legal actions against the people who are respons......
|
|
-
|
|
Massachusetts recently passed a sweeping new data security law that will have a profound impact on the way the United States, and perhaps the rest of the world, manages and develops data-centric applications. Oddly, most people in the business don’t seem to know about it. Google “Massachusetts da......
|
|
-
|
|
If you're like many small business owners, the news that Microsoft is weeks away from the release of a new version of SQL Server 2008 could seem utterly irrelevant to your interests. But it isn't. Microsoft has added important new features in this version that will help you delve more deeply into yo......
|
|
-
|
|
Having discuss indexes in some what details, this post will give some queries to get the index information of you databases. Ok, if you are a DBA, most of the time you need to manage some others databases. In my carrier, it is only few occasions where I was given task to design fresh database. All ......
|
|
-
|
|
We discussed in previous posts, how important to create index on your tables or views. However, next question will come to you what is number of indexes that you can create or will the be a performance decrease on number of indexes you create?
In all the previous cases, we consider only SELECT stat......
|
|