|
|
-
|
|
This post is inspired by a question in MSDN forum about disabling certain rendering formats when setting up SSRS subscriptions. This can be achieved by changing the SSRS configuration file as explained below. I never had a real-world scenario where I n...
|
|
-
|
|
Backup and restore database activity is common and routine task for all DBA when need to move database at another place. I did the same thing while needed to move database from one server to other server. But suddenly i encountered one issue while resto...
|
|
-
|
|
Generating multi-part names (four-part, three-part or two-part) for database objects and interpreting them can be labour intensive at times. This post provides scripts that can be used to reduce the manual effort required for these activities...
|
|
-
|
|
Without executing this query, can you find out the output?
select _________ name from
(
select 2e4 _________
) t
...
|
|
-
|
|
A few days before, i just posted one article to check running scheduled jobs and i used master.dbo.xp_sqlagent_enum_jobs system objects and joined with dbo.sysjobs object from msdb database for same. Please read that post before moving down. This was on...
|
|
-
|
|
This will explain how to implement Import wizard step by step with an example...
|
|
-
|
|
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....
|
|