|
|
Browse by Tags
All Tags » databases ( RSS)
-
|
How about you control what you want to see and get with your hands? A global view of information get a real-hands-on on business intelligence! Here is the newest invention from Microsoft about it, Business Intelligence Surface - click on this link: http...
|
-
|
With reference to the subject line: [UK Government Helps You] as stated its a SPAM email that you might get in this Credit Crunch season that SPAMMERs are targeting the vulnerable users to obtain their personal details. Here I would like to present the...
|
-
|
What will be the main challenge for a DBA/User to manage a large Data Warehouse (DW) environment, size does matter and also think about downtime you need to deploy whenever any patches are required. Before that you need to be perfect or well-versed with...
|
-
|
Quest Software has lined up 2 events where you can learn more about consolidation and virtualisation for your SQL Server environment. SQL Server Technology Day Tuesday, 24 June 2008 9 a.m. - 5 p.m. (lunch included) Maidenhead, Berkshire Join Douglas Chrystall...
|
-
|
Granting permissions to relevant account is a required criteria within the SQL Server databases management, for this even Reporting Services is not exceptional. As per the configuration by default the users connect to the report server by using their...
|
-
|
Choosing a better plan to reduce outage to your database application is a beginner to provide High Availability to your application, irrespective to database or server. You may be aware that SQL Server 2005 version provides the database mirroring which...
|
-
|
In general it is not a best practice to perform SHRINK database operation on a production server, atleast regularly! Sometimes it may be compulsory to keep them sized in order to ensure the disk storage is not compromised for any sudden changes to databases...
|
-
|
The following context is the one I have received from SQL Server Magazine that talks about a good backup tool in the market, study on: Third-Party Tool Enhances SQL Server Backup and Recovery Microsoft SQL Server’s own backup and restore facilities are...
|
-
|
Security - a major ingredient for every Enterprise to avoid the adversaries attempt to invade your customers’ networks and access their servers—to bring them down, infect them with viruses, or steal information about customers or employees, every day...
|
-
|
The message on subject is self-explanatory where your disk subsystem is referring to SQL Server that it is unable to cope up the demand. Having AUTOGROW option enabled on a SQL Server database is a common setup that allows SQL Server automatically expands...
|
-
|
Performance - one word does it all! You are aware that during the Performance Tuning exercise there are few quick wins within the SQL Server Relational Database Engine such as table statistics for data and indexes. When it comes to Analysis Services ...
|
-
|
Its a nightmare when you have got inefficient support person over phone or onsite for the problem you are facing with software or IT related problem. Here is RealWorld problem that how hard and furstating saga you can go with it!...( read more )
|
-
|
Recently I have been through interesting forum post on SQL Server performance website that a user asking how to monitor transaction activity between the databases without using a third party tool. Until SQL 2000 version it is not that easy to get more...
|
-
|
I have had a requirement to see a detailed information about a constraint on a table that includes table fields, type, rules, referenced table and fields for FOREIGN KEYs, etc. Found this useful TSQL to get such information: SELECT k.table_name, k.column_name...
|
-
|
By default the SQL Server database data & log files are created on the default data directory which is Program Files or based on where SQL binary files are installed. In order to find what is the default location you can run following TSQL: declare...
|
More Posts Next page »
|
|