|
|
-
|
|
Changing database options to make it read-only, or taking a database offline? If you are using sp_dboption, your code will not work with SQL Server 2012. Use ALTER DATABASE...SET statement instead....
|
|
-
|
|
Starting SQL Server 2012, the WITH APPEND option in the CREATE TRIGGER statement has been deprecated. This option was used for compatibility levels 65 or lower to create another trigger of the same type on any given table....
|
|
-
|
|
AWE (address windowing support) is no longer available for SQL Server 2012. Today, I attempt to highlight the requirements & behaviour around 64-bit editions of SQL Server/operating systems....
|
|
-
|
|
Almost every product comes with a set of predefined system default data. There are very few product teams who use row constructors (introduced in SQL Server 2008) to populate their default data. What these teams fail to realize is that many a times, the conventional approach may have a negative impact on the time it takes to insert the data and also reduces the overall efficiency of the entire data load operation....
|
|
-
|
|
Returning Result sets is perhaps one of the most common methods used by development teams to debug databse triggers. However, returning result sets from triggers is already marked as a deprecated feature. DBAs can use the "disallow results from triggers" switch to begin educating teams to start moving away from this technique....
|
|
-
|
|
The old DATABASEPROPERTY function has been marked as deprecated starting SQL Server 2005. The replacement is the DATABASEPROPERTYEX which provides greater flexibility and exposes many more database properties to the user....
|
|
-
|
|
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....
|
|