Reblog: June 14 to June 20
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-06-21
852 reads
Key Change
I love music. In fact, I like to think that I’m a student of music – although anyone who has heard...
2013-06-21
1,011 reads
Managed Service Accounts - The Saviour for the Domain-based SQL Server Service Account?
For those Database Administrators seeking to lock-down security related to a Service Account(s), there is an option starting with Windows...
2013-06-21
2,240 reads
Huge collection of Free Microsoft eBooks
I must share it, there are many useful resource
http://blogs.msdn.com/b/mssmallbiz/archive/2013/06/18/huge-collection-of-free-microsoft-ebooks-for-you-including-office-office-365-sharepoint-sql-server-system-center-visual-studio-web-development-windows-windows-azure-and-windows-server.aspx?Redirected=true
http://blogs.msdn.com/b/mssmallbiz/archive/2012/07/27/large-collection-of-free-microsoft-ebooks-for-you-including-sharepoint-visual-studio-windows-phone-windows-8-office-365-office-2010-sql-server-2012-azure-and-more.aspx
http://blogs.msdn.com/b/mssmallbiz/archive/2012/07/30/another-large-collection-of-free-microsoft-ebooks-and-resource-kits-for-you-including-sharepoint-2013-office-2013-office-365-duet-2-0-azure-cloud-windows-phone-lync-dynamics-crm-and-more.aspx
Thank you , Eric
2013-06-21
1,961 reads
use Table Variables in transaction
when using table variable, please note table variable doesn't support transaction rollback. here is the words from BOL
Because table variables...
2013-06-20
2,780 reads
TRY, CATCH, and Transactions
The T-SQL TRY/CATCH structure (“new” in SQL 2005!) is, as the professionals say, da bomb. It’s also underused and under-understood,...
2013-06-20
2,411 reads
Exploring Excel 2013 for BI Tip #8: Adding Calculated Measures
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2013-06-20
931 reads
TechEd North America 2013 videos online
Microsoft has posted ALL the session videos for TechEd North America 2013 and they are available for free! What a...
2013-06-20
799 reads
Disaster Recovery’s big brother Operational Recovery
I’m going to get slammed for the title by someone but I stand by it. First some definitions.
Disaster Recovery...
2013-06-20
944 reads
SQL Server Running Slow
A user calls to say the app or server is slow today. Here’s a quick summary of how I get...
2013-06-20
871 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers