Sites anglophones


How to Use Parameters in PowerShell

Publié le 7 octobre 2019 sur sqlservercentral.com
 

The post How to Use Parameters in PowerShell appeared first on SQLServerCentral.

6 steps to a more secure SQL database

Publié le 7 octobre 2019 sur sqlservercentral.com
 

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

Publié le 7 octobre 2019 sur sqlservercentral.com
 

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

Publié le 6 octobre 2019 sur journey to sqlauthority
 

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

Publié le 5 octobre 2019 sur journey to sqlauthority
 

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

Publié le 4 octobre 2019 sur sqlskills.com - glen berry
 

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

Publié le 4 octobre 2019 sur journey to sqlauthority
 

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

Publié le 4 octobre 2019 sur sqlservercentral.com
 

The post Database Build Blockers: Cross-Server Database Dependencies appeared first on SQLServerCentral.

Entity Framework Core Raw SQL Queries Examples

Publié le 4 octobre 2019 sur sqlservercentral.com
 

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

Publié le 3 octobre 2019 sur sqlskills.com - paul randall
 

(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 …

SQL Server Diagnostic Information Queries for October 2019

Publié le 3 octobre 2019 sur sqlskills.com - glen berry
 

This month, I have just done some minor formatting and documentation improvements.I have a T-SQL script that you can use to check whether your instance of SQL Server has been patched to mitigate against the Spectre/Meltdown CPU vulnerability. This work …

SQL SERVER – 7 Resources From Techorama Netherlands 2019

Publié le 3 octobre 2019 sur journey to sqlauthority
 

Just earlier today I completed my second edition of Techorama Netherlands. It was fantastic and I had a great time presenting at a day-long training and also two sessions on technology. In this blog post, I will include a few resources which I promised …

You just Build It don’t you? 12 Common Database Build Blockers

Publié le 3 octobre 2019 sur sqlservercentral.com
 

The post You just Build It don’t you? 12 Common Database Build Blockers appeared first on SQLServerCentral.

Getting a List of the Striped Backup Files

Publié le 3 octobre 2019 sur sqlservercentral.com
 

I had an interesting challenge recently with a customer. They were looking to work with the SQL Clone product from Redgate, but had to deal with striped backups. This isn’t a problem for the product, but this customer wanted to automatically build an i …

SQL SERVER – Drop Multiple Columns from a Single Table

Publié le 2 octobre 2019 sur journey to sqlauthority
 

Recently, while working with a client, we determined that they have many unused indexes and unused columns in their table. I worked along with them doing a Comprehensive Database Performance Health Check. I noticed that DBA was dropping the unused colu …


Pages :