|
|
-
|
|
This article will revise 6 important c#/.NET interview questions around concepts like IL code, just in time compiler, common type system; common language specification, code access security and common language run time....
|
|
-
|
|
Some of the common SQL Server interview questions around DML triggers are: How does one identify active v/s disabled triggers and their corresponding trigger events? How can one determine if a trigger is an instead of trigger or not? Today's post presents a simple script using sys.triggers and sys.trigger_events to answer this question....
|
|
-
|
|
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...
|
|
-
|
|
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....
|
|