|
|
-
|
|
SQL Server 2012 (“Denali”) introduces many new features directed towards improving server efficiency and availability and developer/administrator productivity. SQL Server 2012 no longer supports compatibility level 80 (SQL Server 2000) and this introduces the user to error message: 15048, which arises when an incorrect database compatibility level is used....
|
|
-
|
|
A lot of content is available on the Internet describing the new features introduced in SQL Server 2012. However, if you are attempting to certify your database against SQL Server 2012, this series will help you to know about the deprecated (i.e. removed) features of SQL Server 2012 and their corresponding replacements, if any. Today, we discuss the deprecation of the WITH [MEDIA]PASSWORD option duing database/log backups & restores....
|
|
-
|
|
Revisiting Database object names, naming conventions for identifiers and some of the methods that you can use to rectify this - use column aliases, quoted identifiers and square braces. A small lesson in how haste makes waste and how haste sometimes reminds us of things we already know....
|
|
-
|
|
Today's post attempts to explore the chagnes made to the database restore wizard in SQL Server 2012 ("Denali"). I also refer to a common problem related to database restores that I logged as part of Microsoft Connect bug report - 668566....
|
|
-
|
|
Today's post shows how to connect to a SQL server instance (named or otherwise) using the IP address and the TCP/IP port number....
|
|
-
|
|
What TCP/IP port is my SQL Server instance listening on? Can I use SQL Server Management Studio or SQL Server Configuration Manager to find the port number used by SQL Server? Today's post helps database administrators and developers answer this question....
|
|
-
|
|
Part 03 of a 3 part summary on Microsoft TechEd (India) 2012 held in Bengaluru (Bangalore) from March 21-23, 2012 at the Lalit Ashoka Hotel. I attended TechEd 2012 as a TechEd Rockstar....
|
|
-
|
|
Part 02 of a 3 part summary on Microsoft TechEd (India) 2012 held in Bengaluru (Bangalore) from March 21-23, 2012 at the Lalit Ashoka Hotel. I attended TechEd 2012 as a TechEd Rockstar....
|
|
-
|
|
Part 01 of a 3 part summary on Microsoft TechEd (India) 2012 held in Bengaluru (Bangalore) from March 21-23, 2012 at the Lalit Ashoka Hotel. I attended TechEd 2012 as a TechEd Rockstar....
|
|
-
|
|
It's time for a change. This website, BeyondRelational.com, is rolling out a new Blogs module with improved features, feedback and social opportunities. All 146 of my posts have been moved to the new location: http://beyondrelational.com/modules/2/blogs/77/nakuls-blog.aspx?tab=default. All future po......
|
|