SQL Server Education (by the geeks, for the geeks)
Hi Friends, Good News. SQL Server 2012 RC0 is now available to download. Donwload Link: http://www.microsoft.com/download/en/details.aspx?id=28145 Start downloading and enjoy the cloud ready SQL. Regards Sarabpreet Anand Like us on …
SQL Server 2012 RC0 Available to download Read MoreHi Friends, Have you ever noticed, while taking a compressed backup the file which gets created initially has a different size than the final file size when the backup completes. To …
SQL Server: Why the size of the backup file changes? Read MoreFor comparing data in tables you don’t need any 3rd party tool, SQL Server ships with the tablediff utility which can be used to compare the data in two tables. You …
SQL Server Compare Data in Two Tables without Any 3rd-Party Tool Read MoreOne fine day i was configuring DB Mail on one of my server and while configuring Mail Account i encountered the following error. This Bug\Problem is applicable to SQLServer 2008 SP1, …
SQL Server DB Mail Account Creation Failed – A Bug Read MoreIn this article i’ll show you the steps to Enable PS in Windows Server 2008 R2. Windows Server 2008 gets shipped with Powershell v1.0. But it is disabled by default to …
Enable Powershell Feature in Windows Server 2008 R2 – SQL Server Read MoreA variable is a symbolic name given to some known or unknown information, for the purpose of allowing the Variable name to be used independently of the information it represents. A variable name …
SQL Server Variables in Powershell Read MoreThe dir command allows you to see the available Files & Folders in a directory. The same command is available in Powershell to see all available Files and Folders in a …
SQL Server: Use of Dir | Get-ChildItem | LS in Powershell Read MoreThe hidden power of Surface Area Configuration Tool SQL Server 2005 comes with a Surface Area Configuration tool. This tool allows you to Control services and features installed on the SQL …
SQL Server: The hidden power of Surface Area Configuration Tool Read MoreHi Friends, If you ever want to get a list of all System and User defined Data Types info which are available in your SQL Environment you can use this Catalog …
How to find all available System and User Defined Data Types in SQL Server? Read MoreHi Friends, Yesterday I published one article “How to find column related detailed info for any table?” In that article i talked about an interesting way to get column related info, …
SQL Server: An Interesting way to get column related info – Part 2 Read More