|
|
-
|
|
Most database documentation and code fail to address name resolution errors – i.e. the ability to ensure that a name uniquely identifies a database object. This post provides an introduction to four-part, three-part and two-part database object naming conventions....
|
|
-
|
|
Microsoft SQL Server Integration Services and it's Architecture....
|
|
-
|
|
What do we mean by Microsoft Business intelligence suite and it'scomponents- SSIS,SSAS,SSRS?...
|
|
-
|
|
Data security is the cornerstone of every business application. There is no arguing to the fact that confidential information needs to be protected by overlapping layers of security. Another aspect of security is data integrity....
|
|
-
|
|
What do we mean by Business Intelligence and how we can achieve an Intelligent Business?...
|
|
-
|
|
RAND function in SQL Server is used to generate a random value between 0 and 1. When you use RAND in the SELECT statement, it generates the same value for the entire resultset. One of my friends asked me if it is possible to have different random values...
|
|
-
|
|
Money is one of the datatypes in SQL Server and it can be used to store monetary values. It will not only accept integer and decimal values but formatted values too. For example you can express values that include comma and currency symbol
Consider the ...
|
|
-
|
|
Some days ago, i worked to get failed jobs detail and an alert for the same. I used some system tables from msdb database to fetch the details for same. And msdb.dbo.sysjobhistory is one of the table among them which used in the script. But this table n...
|
|
-
|
|
Recently I encountered one error, while converting text datatype to varchar datatype and then adding some string to it to convert into xml. I noticed that the Length of the value is 8000 characters around however when I actually copy and paste the recor...
|
|
-
|
|
Hi all This is to inform you SQL PraRup have completed 100’s Download in 5 Day. If you not used yet this too , Download and Use this powerful formatting tool which gives us feature's like Auto Format/Indents all SQL Server Objects at ones Cus...
|
|