|
|
NEW! - Remote Monitoring & DBA Services
Front Page News
-
|
In this blog post , I explained different uses of GO command Here is a Fun when you use GO as object name CREATE PROCEDURE GO ( @I INT ) AS SELECT @I AS number Well. The procedure is created and let us try to execute GO 2 What we see is Command ( s )...
|
-
|
Refer a SharePoint Colleague! Forward To A Friend ___________________ Want to receive Idera's monthly newsletter? Sign-up here To ensure that SharePoint performance does not degrade, there are recommended limits that SharePoint sites and libraries should...
|
-
|
En français Get a 300$ early bird discount by registering before September 13th. We are offering an early bird of 300$ CAD for attendees that are registering before September 13th, 2008. Registered attendees have access to the DevTeach Archive sessions...
|
-
|
Recently we had a discussion at work place about setting up the PAGE_VERIFY option to CHECKSUM for few databases on one of the SQL Server 2005 instance (dedicated) that is being used extensively by an application that has very limited maintenance window...
|
-
|
TechNet Webcast: SQL Server 2008 (Part 3 of 3): Integrate Growing Data Volumes (Level 300) Attend this session to learn how to integrate growing volumes of data with the new enhancements in Microsoft SQL Server 2008. We cover new technologies, like Change...
|
-
|
Here is the list of information which is a Technical Rollup email we receive from TRM team. The list is ongoing and I have outlined the important ones that I feel and fits for 'generic' SQL Server environment. Make sure to review, download, test and apply...
|
-
|
Refer a SharePoint Colleague! Forward To A Friend ___________________ Want to receive Idera's monthly newsletter? Sign-up here SharePoint 2007 offers each user the ability to set alerts for other users. This is a convenient feature, but can make management...
|
-
|
Often newbies use empty string and consider it as NULL. But when an empty string is passed, it may not be stored as empty string or NULL. It actually depends on the datatype of the column Consider this example DECLARE @t TINYINT , @s SMALLINT , @i INT...
|
-
|
You may be thinking installing SQL Server 2008 Express Edition is easy, yes it is when you have simple terms of usage. No issues for version 2005 though, just keep in mind about SQL Server 2008 installation when Visual Studio 2008 is/isn't present? issues...
|
-
|
In continuation to the CumulativeUpdate package posts here for SQL Server 2005 SP2 we have another set of cumulative update package no.9 ready for testing. TO obtain this read the notes from Microsoft: .... Apply it only to systems that are experiencing...
|
-
|
Refer a SharePoint Colleague! Forward To A Friend ___________________ Want to receive Idera's monthly newsletter? Sign-up here For a quick reference list of SharePoint URLs to commonly used administrative functions on a SharePoint site, visit the blog...
|
-
|
Refer a SharePoint Colleague! Forward To A Friend ___________________ Want to receive Idera's monthly newsletter? Sign-up here Database maintenance is an important, yet often neglected, aspect of ensuring SharePoint performance. For example, have you...
|
-
|
The question on the subject was asked by one of the Data Integration project developers, which is initiated to migrate a database from Oracle to SQL Server. The process of transactions should be handled from Application and when it comes to the data migration...
|
-
|
The PIVOT operator available in SQL Server 2005 is used to generate the Cross-tab results Consider this example select * from ( select Year ( OrderDate ) as pivot_col , e . lastname , o . OrderDate FROM northwind .. Employees as e INNER JOIN northwind...
|
-
|
Did you see the new logo of SQLBits: IN continuation to the earlier SQLBits-Cubed_Notification post here, now we got the update about final agenda that is fixed for September 13th 2008. For more information refer to MainAgenda page on SQLBits website...
|
-
|
Just a bit of basics about DateTime datatype in SQL Server, it has two different date/time columns. They are DATETIME and SMALLDATETIME and the difference between these two SQL Server date/time data types. SQL Server has a number of default formats it...
|
-
|
Data Dude - if you know about these 2 words then you know what I'm talking about. Visual Studio Team Edition for Database Professionals is an excellent tools for the users to build SQL databases in a managed project environment with support for versioning,...
|
-
|
Are you a SharePoint or IT administrator tired of spending countless hours on routine SharePoint administrative and troubleshooting tasks, like managing space quotas, performing backups, troubleshooting performance issues, configuring permissions, etc,...
|
-
|
If you work in Financial based Enterprise then Sarbanes-Oxley is not a new concept for you as per American law that regulates the accountability of publicly owned companies. Just to talk about t he main purpose of the law it to make sure the financial...
|
-
|
Microsoft have now published the support policy for running SQL Server on Hyper-V. There is support for SQL Server 2008 initially, with plans to include SQL Server 2005 at a later date. http://support.microsoft.com/?id=956893...
|
-
|
Date: Wednesday, August 20, 2008* Time: 4 PM Eastern | 3 PM Central | 1 PM Pacific Speaker: SQL Server MVP, Hilary Cotter Attend and win! Find out how! *Want to attend but can’t make this date? No worries! Each webcast will be archived for up to 6 months....
|
-
|
Training is best method to update and know about new technolgies and when it comes to SQL Server there are no special tricks. SQLKnowHow - gear up for exclusive training from professionals continues such a world-class opporunity for the SQL Server users...
|
-
|
Ok its time to update your local copies of SQL Server 2008 Books OnLine (BOL) too, as we have RTM version in hand. You may have installed it during CTP releases and even during short-time of RC0 release, but as always it is a good practice to update as...
|
-
|
Its over 2 weeks that SQL Server 2008 RTM is released and no doubt in stating that many DBAs might have performed downloads from their MSDN/Technet subscription to install within their environment. Remember feature pack download for SQL Server 2005 couple...
|
-
|
In continuation to SQL Server 2008 installation when Visual Studio 2008 is/isn't present? post that you might be aware that one of the issues with the SQL Server installation was a dependency on Visual Studio 2008 SP1. Though it is not a complete show...
|
|
|
|