In my previous article we discussed Change Tracking which is one of the new technologies introduced by Microsoft. This article will focus on Change Data Capture.
2014-12-12 (first published: 2012-01-16)
13,525 reads
In this tip Aaron Bertrand uses SQL Server metadata queries to discover SQL Server views that have certain properties or use certain syntax.
2014-12-12
5,919 reads
Identities, the 'accounts' by which Cloud and Web users identify themselves, are tricky to manage, and tiresome for the users. Cloud services such as Office 365 have their main use in large organisations and so there have to be easy ways for system administrators to maintain them. Microsoft provide three alternative strategies; Cloud identities, Synced identities and federated identities. What is the differences between them, and which should you choose?
2014-12-11
8,211 reads
This metric picks up excessive counts of Virtual Log Files (VLF) in a transaction log that can lead to performance problems, including write performance, restore and recovery times. The ideal value for this metric should be less than 25; excessively high values (greater than 50) can cause high write times when writing to the transaction log.
2014-12-11
7,312 reads
How do you use SQL Server, and how do you expect this to change next year? Fill in our survey, and enter a prize draw to win Amazon vouchers.
2014-12-11 (first published: 2014-12-02)
19,631 reads
Arshad Ali discusses how to use CTE and the ranking function to access or query data from previous or subsequent rows. He also shows you how to leverage the LEAD and LAG analytics functions to achieve the same result without writing a self-join query using CTE and ranking function
2014-12-10
8,382 reads
You created a report that passed three separate values to a stored procedure, simply enough. However, now the user comes back and they want the ability to select multiple values for the report to return data against. Check out this article for a walk-through on how to handle this request.
2014-12-09
13,600 reads
Nominations open until December 10. The Tribal Awards are back and looking to recognize some of the great contributors to the SQL community. Nominations are now open for 11 different categories, but closing soon so make sure your user group, favorite twitter account, or person who's helped you the most this year is nominated.
2014-12-09 (first published: 2014-12-02)
712 reads
Matthew Skelton proposes a way to enable database continuous delivery that isn’t as outlandish as it first appears. What can Conways Law and Microservices tell us about the future of databases and DBAs? Matthew shows us a glimpse.
2014-12-09
7,338 reads
Participate in an online survey on SQL Server Developer Tools for a chance to win one of ten $100 Amazon vouchers.
2014-12-09 (first published: 2014-12-05)
14,836 reads
In last months one of the scenarios where you can use AI has been...
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Comments posted to this topic are about the item Backup to Immutable Storage
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Comments posted to this topic are about the item Expanding into Print
In SQL Server 2025, a backup can be made on Azure Immutable Storage. What changes in how the backup is created?
See possible answers