Integrating SQL Server Tools into SQL Change Automation Deployments
The post Integrating SQL Server Tools into SQL Change Automation Deployments appeared first on SQLServerCentral.
Implementing SQL Server Integration Services with Azure Data Factory
The post Implementing SQL Server Integration Services with Azure Data Factory appeared first on SQLServerCentral.
How to Think Like the SQL Server Engine
You’re a developer or a DBA, and you’re comfortable writing queries to get the data you need. You’re much less comfortable trying to design the right indexes for your database server. In the next several posts, you’ll learn: The …
SQL and Scope
One of the first successful programming languages was a relatively simple one named FORTRAN. This was short for “FORmula TRANSlator,” and it attempted to look as much like algebra as it could. The first version of this language had only two …
SQL SERVER – Modifying Table Used In SCHEMABINDING View
While I enjoy working on the Comprehensive Database Performance Health Check, I often love answering the question about blog posts as well. Just earlier I posted about What is SCHEMABINDING in SQL Server Views? and I received a very interesting questio …
How to Use Parameters in PowerShell
The post How to Use Parameters in PowerShell appeared first on SQLServerCentral.
6 steps to a more secure SQL database
Security is often something people think about only after they have had a problem. Given that the average cost of a data breach is $3.92 million (SecurityIntelligence 2019) and ransomware attacks have increased 97% over the past 2 years (PhishMe 2019), …
DevOps Self-Service for Databases with SQL Clone
The post DevOps Self-Service for Databases with SQL Clone appeared first on SQLServerCentral.
What is SCHEMABINDING in SQL Server Views? – Interview Question of the Week #245
Question: What is SCHEMABINDING in SQL Server Views?Answer: SCHEMABINDING keywords prevent tables used in the views to make any such modifications that can affect the view’s definition.When this keyword is used in the view it binds the view to th …
SQL SERVER – Identifying and Fixing PREEMPTIVE_OS_RSFXDEVICEOPS Wait Type
While we say that every day is the learning opportunity is truly correct if you get to work with the new clients every single day Comprehensive Database Performance Health Check. Recently, I walked into a client engagement where I really got stuck with …
Speaking at SQLSaturday Denver on October 12, 2019
I’ll be presenting Dr. DMV’s Troubleshooting Toolkit at SQLSaturday Denver on October 12, 2019. This free event will be held at University of Denver – Sturm Hall, 2040 S Race St, Denver, Colorado, 80210. My session is at 10:15AM.I alw …
SQL SERVER – Listing All Memory Optimized Files with Logical Name and Physical Name
I love my job as SQL Server Performance Tuning Expert and I also appreciate how I am able to help many different organizations with Comprehensive Database Performance Health Check. However, once in a while I end up working with clients who have a very …
Database Build Blockers: Cross-Server Database Dependencies
The post Database Build Blockers: Cross-Server Database Dependencies appeared first on SQLServerCentral.
Entity Framework Core Raw SQL Queries Examples
The post Entity Framework Core Raw SQL Queries Examples appeared first on SQLServerCentral.
The Curious Case of… why a minimally-logged operation doesn’t make a log backup smaller
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working …