(Jack Vamvas) Question: I’m having some problems in migrating CREDENTIAL objects for SQL Server migrations.

(Itzik Ben-Gan) An important part of query tuning is understanding the algorithms that are available to the optimizer to handle various query constructs, e.g., filtering, joining, grouping and aggregating, and how they scale. This knowledge helps you prepare an optimal physical environment for your

(Grant Fritchey) I’ve said it before, but it bears repeating, there is no cause for any kind of panic when it comes to the GDPR. None. There are however, a number of concerns. One of those concerns is, well, concerning. How does the right to be forgotten within the GDPR impact database backups? Let’

(Pinal Dave) In this blog post with the help of Extended Events, we will learn how to identify all the deprecated SQL Server Features.

(Scott Murray) What are Power BI Pulse Charts and how are they used? Can you provide a step by step example on how to get started with Power BI Pulse Charts?

(Pinal Dave) Many times, there are unforeseen conditions and few developers can’t predict which writing the code of a product. This is the reason we have bugs in the products and we all have job to do. One of my clients was not able to run one of the inbuilt reports which come with SQL Server Manage

(Kenneth Fisher) T-SQL Tuesday Our host for T-SQL Tuesday this month is Jens Vestergaard (b/t) and he has asked about our favorite SSMS tool. My initial thought was to talk about using solutions in SSMS but I’d already written about that.

(Hannes du Preez) There are times that you need to access information from the previous row or next row from the current row. Here is a small trick that makes use of a CTE to get this information:

(SourabhAgarwal) Replication Distribution database is the perhaps the most important entity in the entire replication topology. Apart from storing the replication metadata and history for replication agents, the distribution database, in case of transactional replication, also provides intermediate

(Graham Okely) One of the issues with Availability Groups is that you need to make sure the SIDs on the primary and secondary are the same, so when you failover there are no issues connecting to the database.