Tag Archives: knowledge

Activedirectory – Group – user – membership validation tool

In any IT environment it is very important to understand how a distribution and security groups work. I have come across many employees with minimal knowledge on providing permissions to individuals and groups. I will just add very basic one … Continue reading

Posted in knowledge, Productivity, Uncategorized, Windows Server | Tagged , , , , | Leave a comment

Microsoft Virtual Labs – TechNet Virtual Labs

Microsoft Virtual labs are created and managed by Microsoft which can be used to test new products without installing. Most of the virtual labs are scenario based, you will be able to login into specific Server which has required product … Continue reading

Posted in knowledge, Productivity, Useful Link | Tagged , , , , | Leave a comment

Knowledge share 2014-11

Traceflag 3226: In my production environment, we take transaction log backups every 10 minutes for all 40+ databases. There are thousands or Successful backup messages in my logs which is very annoying. SQL Server 2008 introduced traceflag 3226 to disable … Continue reading

Posted in knowledge, SQL | Tagged , , , , , , | Leave a comment

Knowledge Share 2014-07

SYNONYM SYNONYM is used to reference an object in usable format. Syntax: create synonym¬†UsableName for Server.DBName.SchemaName.TableName Note: The base object need not exist at synonym create time. SQL Server checks for the existence of the base object at run time. … Continue reading

Posted in knowledge, SQL, Windows Server | Tagged , , , | Leave a comment

Knowledge Share 2014-05

* Function to convert a list into a table (Collected this piece of code from my Colleague, Satya Addala) * Computed columns can not be altered but needs to be dropped and re-created * Caution while creating DDL triggers, specially … Continue reading

Posted in knowledge, Script, SQL, SQL Query | Tagged , , , , , | Leave a comment

Knowledge Share 2014-04

In SQL Server 2014, you can have 8 secondary replicas, it was 4 in SQL 2012 Ref: What’s New (DB Engine) SQL Server 2014 – http://msdn.microsoft.com/en-us/library/bb510411%28v=sql.120%29.aspx#DataFiles What is Cardinality Estimation? This is new feature in SQL Server 2014: The cardinality … Continue reading

Posted in knowledge, Productivity, SQL, sql2014 | Tagged , , , , , , , | Leave a comment