SQL Compare 14 now available on Linux
The post SQL Compare 14 now available on Linux appeared first on SQLServerCentral.
T-SQL Tuesday #119 Changing Your Mind
This post is a response to this month’s T-SQL Tuesday #119 prompt by Alex Yates. T-SQL Tuesday is a way for the SQL Server Community to share ideas about different database and professional topics every month. This month’s topic asks …
Establishing a DevOps Organisation
The radical pace of development promised with DevOps can make some people nervous, especially if they have spent years with the waterfall development model. The very first question that comes to mind is: How do you expedite your development withou …
SQL SERVER Tools I Use and Recommend (Updated: October 2019)
I just returned from the long road trip to teach 21 SQL Server Performance Tuning Scripts Course. One of the most popular questions, I had received what tools I use personally when I work with SQL Server. Though I had answered them during the training …
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 …