Browsing articles in "Sql Server Denali"
Dec
15
2011

How do I check SQL replication status via T-SQL?

While searching for t-sql script which can check replication agent status came across a good script which works well for all versions of SQL Server i.e. 2000/2005/2008/2008R2 and above…

Nov
8
2011

Error: 18456, Severity: 14, State: 58

Today while troubleshooting a SQL authentication issue, came across following error: Login failed for user ‘sa’. (Microsoft SQL Server, Error: 18456, Severity: 14, State: 58) When I use SQL Server Authentication to connect server. This was authentication issue, hence first checked the authentication mode and found that it is configured as Windows Authentication instead of Mixed mode (SQL + Windows) authentication Once I modified the authentication mode to mixed mode, it requested me to restart […]

Nov
7
2011

SQL Server 2012 Licensing Changes

The upcoming SQL server will get a major overhaul in terms of licencing, a very good article from Mr. Denny on same is as below, http://itknowledgeexchange.techtarget.com/sql-server/sql-server-2012-licensing-changes/ In short, SQL Server is reducing the number of editions from 6 down to 4 (I’m excluding all the different appliances here). Those editions will be Express, Standard, BI, and Enterprise Edition. The express edition will still be a free edition with limited functionality. BI is a new introduction […]

Oct
31
2011

SQL Server Upcoming version (code name ‘Denali’) announced: SQL Server 2012!

Since last few months SQL Server Denali (code name) is going under testing and recently during SQL Pass Summit 2011 Microsoft announced the name of upcoming SQL server as SQL Server 2012 (Source: http://www.sqlmag.com/article/sqlserverdenali/sql-server-2012-name-upcoming-sql-server-release-140882), it will be released in first half of next year and below are few significant features of SQL server 2012, Source: http://www.sqlmag.com/content1/tabid/461/catpath/sqlserverdenali/topic/sql-server-denali-new-features-140115 The next release of Microsoft SQL Server, code-named Denali, is right around the corner. Microsoft has just released Denali […]

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 35 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

December 2017
M T W T F S S
« Nov    
 123
45678910
11121314151617
18192021222324
25262728293031

View Post by Categories

%d bloggers like this: