Introduction to SQL Server replication
This time I'll talk about some basis with SQL Server replication, whether you need it for High availability (HA), Disaster Recovery (DR), load balance your applications or any other...
2017-10-04
23 reads
SQLDbaInternals
Introduction to SQL Server replication
This time I'll talk about some basis with SQL Server replication, whether you need it for High availability (HA), Disaster...
2017-10-03
726 reads
SQL Server database basics
So today I'll talk about some of the basic items for SQL server that helps to understand the reason of some performance recommendations. This first post will list and...
2017-09-16
14 reads
SQL Server database basics
So today I'll talk about some of the basic items for SQL server that helps to understand the reason of...
2017-09-16
141 reads
SQL Server Replication snapshot initialization taking long time to be applied
Hello all,In today's post I want to share a tip that helped me troubleshoot an issue I was facing and couldn't find much documentation about it. To my friends...
2017-08-25
7 reads
SQL Server Replication snapshot initialization taking long time to be applied
Hello all,
In today's post I want to share a tip that helped me troubleshoot an issue I was facing and...
2017-08-25
4,207 reads
Training and tips to get certified with Microsoft (Part 4 and last)
In the previous posts I posted some questions that I usually get when we talk about getting certified with SQL Server also listed some resources you can use to...
2017-08-21
7 reads
Training and tips to get certified with Microsoft (Part 4 and last)
In the previous posts I posted some questions that I usually get when we talk about getting certified with SQL...
2017-08-21
136 reads
Training and tips to get certified with Microsoft (Part 3)
Welcome back, thanks for keep on reading me, and for the ones who read for the first time, welcome.With this third post I'll keep answering the question Where did...
2017-08-11
4 reads
Training and tips to get certified with Microsoft (Part 3)
Welcome back, thanks for keep on reading me, and for the ones who read for the first time, welcome.
With this...
2017-08-11
182 reads
Blogs
AI and Data Engineering on the Edge: The Good, the Bad, and the Overhyped
Running AI and data pipelines on the edge instead of the cloud has gone...
UNION vs UNIONALL: #SQLNewBlogger
By Steve Jones
While writing another post I realized my UNION query didn’t work as one might...
Deciphering Data Architectures Is Now Available in Multiple Languages
By James Serra
Since the release of my book Deciphering Data Architectures: Choosing Between a Modern Data...
Forums
Secure Cached Plans
Comments posted to this topic are about the item Secure Cached Plans
Complex Data Processing with dbt Python Models: The Fabric Modern Data Platform
Comments posted to this topic are about the item Complex Data Processing with dbt...
Over or Under Provisioned
Comments posted to this topic are about the item Over or Under Provisioned
Question of the Day
Secure Cached Plans
The DMV, sys.dm_exec_cached_plans, contains rows for each cached plan on an instance. In Azure SQL Database, not every used has rights to every database, as there does exist an instance behind each database. How is security handled for this DMV in Azure?
See possible answers