Filtering Feature in SQL Server Management Studio

Hi All, How are you doing? I want to draw our attention to pretty handy-dandy (Yet not complete enough) feature in SQL Server Management Studio. That is “Filtering”. Advantage: You can filter the objects (like Tables, Views, Stored Procs etc.) based on certain criteria. You can filter them by “Name, Schema, Owner or Creation Date”. …

Continue reading ‘Filtering Feature in SQL Server Management Studio’ »

SQL Server Database Keys: PrimaryKey, NaturalKey, ForeignKey, UniqueKey, CandidateKey, AlternateKey, CompositeKey, SuperKey, SurrogateKey

Hi Guys, How are you doing? Many a times during interviews I notice that candidates know lots of things but they really hesitate while talking about “SQL Server Database Keys“. And even if they know about keys, they fail to provide proper answers with examples. So, today I would like to summarize few definitions which …

Continue reading ‘SQL Server Database Keys: PrimaryKey, NaturalKey, ForeignKey, UniqueKey, CandidateKey, AlternateKey, CompositeKey, SuperKey, SurrogateKey’ »

Enhanced “Generate Scripts” dialog box in SQL Server 2012 RC0

Hi All, I have been monitoring the “Generate Scripts…” functionality of SQL Server Database. One thing bothers me for last few years or since SQL Server 2005 is that once I right-click on any database -> Tasks -> Generate Scripts, I would expect to generate scripts only for that database which I have selected. But …

Continue reading ‘Enhanced “Generate Scripts” dialog box in SQL Server 2012 RC0’ »