|
|
Browse by Tags
All Tags » code ( RSS)
-
|
Here is the interesting invitation to your partner and strong case for you to attend SQLBits conference in Newport. This is an open letter to any partner of a SQL Server DBA, Developer or BI practitioner regardless of gender or age!... read more !......
|
-
|
Here is the quirky error that has caused a resources crunch on a SQL instance, Error : Process ID -2 is not a valid process ID . The actual issue occurred during an update to a table that has been used by Online application to update the action log, intially...
|
-
|
As referred on the Pattern and Practices - deprecate and discontinued Transact SQL features we will now look into (my favs) on SQL Server 2008 TSQL features, rather we spotlight on deprecated and discontinued features! IT is one of the best practice that...
|
-
|
It brings me a great joy and actual skill of solving the TSQL challenge posts by fellow MVP Jacob Sebastian and this thime see the Aurelien and Matthieu have fun with TSQL Challenges post which is a mixture of fun & skill of solving the puzzle. For...
|
-
|
Here is the quirky error that has caused a resources crunch on a SQL instance, Error : Process ID -2 is not a valid process ID . The actual issue occurred during an update to a table that has been used by Online application to update the action log, intially...
|
-
|
Are you looking for detailed explanation and information about XML Schema collections and also about XSD? With a reference to ebook you can learn and build powerful XML schema collections to valid XML documents within your applications? Here is the answer...
|
-
|
The error message text (partial) on the subject will be familiar for the DTS/SSIS users in SQL Server. On the background of the issue is that when you attempt of open a DTS package for editing from SQL Server 2008 Client machine, I have seen questions...
|
-
|
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...
|
-
|
Do not click any of the links below: Here is the piece of advice I would like to share that do not fall for tricks played by SPAMMERS and phishing email you see below: ************************************************************************* Alert Name...
|
-
|
It is a compulsory requirement that you need a license to work/operate a software application. That means it is required for each physical or virtual processor accessed by an operating system environment running such a software. I must admit Licensing...
|
-
|
Ok this is not new to say you can write stored procedures in any language to manage them in SQL Server, as 2005 version has started this CLR integration functionality that is exposed in an assembly called system.data.dll, which is part of the .NET Framework...
|
-
|
Do you like color-coded alert say when you are executing a TSQL script or code against a SQL Server instance, say if its a production server with 'red' indicator or 'green' when it is on testing platform! I have no doubt in stating the...
|
-
|
Do you have any criteria for your Development Environment within the SQL Server platform? Do you perform end-to-end testing whenever a new hotfix or service pack needs to be applied on the SQL Server? So think about having seperate Database Development...
|
|
|