SQL Server Education (by the geeks, for the geeks)
Hi Friends, Couple of weeks back one of the junior DBAs I know was installing SQL Server 2012 on Windows Server 2012 VM. He was confident that every pre-check were good …
An error occurred for a dependency of the feature causing the setup process for the feature to fail (SQL Server 2012) Read MoreHi Friends, Few days back I received a call from one of my friend mentioning that he ran into an issue while alwayson availability group setup. He did add two replicas …
Alwayson availability group setup, Checking for compatibility of the database file location on the secondary replica resulted in an error Read MoreHi Friends, Always On Availability Groups provides an enterprise-level alternative to database mirroring and it gives organizations the ability to manually or automatically fail over a group of database(s) as a …
Joining database on secondary replica resulted in an error Read MoreLike we already know, Windows-based applications can use Windows AWE (Address Windowing Extensions) APIs to allocate and to map physical memory into the process address space. AWE allow 32-bit operating systems …
SQL Server AWE Enabled Option | Deprecated Read MoreMicrosoft SQL Server 2012 Release Candidate 0 (RC 0) introduces 14 new built in functions in SQL Server 2012. These new functions are: Conversion functions PARSE TRY_CONVERT TRY_PARSE Date and time …
New Built in Functions in SQL Server 2012 Denali Read MoreHello Folks, You might have been wondering about the proper steps for the installation of Denali CTP 3. Well, you don’t have to worry anymore. I am going to give you …
SQL Server – Installation Guide for Denali CTP 3 Read More