Sites anglophones


SQL SERVER – Script to Get Partition Info Using DMV

Publié le 24 septembre 2019 sur journey to sqlauthority
 

I consider myself very fortunate as I get to see a new system every other day when I am working with a Comprehensive Database Performance Health Check. During the consultation, one of the questions was is there any way to see the information about the …

Using PowerShell to Generate Logins, Server and Database Permissions

Publié le 24 septembre 2019 sur sqlservercentral.com
 

The post Using PowerShell to Generate Logins, Server and Database Permissions appeared first on SQLServerCentral.

Using tsqlt Tests to Practice Queries

Publié le 24 septembre 2019 sur sqlservercentral.com
 

Recently I was talking with someone that was wondering what the value was of writing unit tests. They were concerned that trying to write tests was a large effort and that they might not catch all bugs, so why write the test? It’s a common viewpoint th …

Redgate need users looking to do CI/CD for Oracle Databases

Publié le 24 septembre 2019 sur sqlservercentral.com
 

The post Redgate need users looking to do CI/CD for Oracle Databases appeared first on SQLServerCentral.

Query Store Questions: 24HOP follow up

Publié le 23 septembre 2019 sur SQLSkills.com - Erin Stellato
 

  A couple weeks ago I presented for the 24HOP Summit Preview and I had a lot of great general questions about how Query Store works.  My session title was “Why You Need Query Store” (you can watch it here) and I only had about 45 …

DBA Training Plan 23: Congratulations! Now, It’s Your Turn.

Publié le 23 septembre 2019 sur brentozar.com
 

I bet you think you suck at databases. You’re sitting there on your computer, reading all kinds of blogs, watching presentations online, and you’re thinking, “Everybody knows more about databases than I do.” We all feel that way …

SQL SERVER – Table Variables or Temp Tables – Performance Comparison – SELECT

Publié le 23 septembre 2019 sur journey to sqlauthority
 

This is the fourth post in the series which I have been writing about the Table Variables and Temp Table. Today we are going to discuss the performance comparison of table variables and temp tables when we are running SELECT queries. I usually discuss …

Best WordPress Security Practices for 2020

Publié le 23 septembre 2019 sur sqlservercentral.com
 

WordPress is currently powering millions of websites. While the blog management system is easy-to-use, it has also fallen victim to repeated security attacks over the last 5 years.  It goes without saying, a high number of security attacks doesn …

New Redgate University Courses to Advance your Skills

Publié le 23 septembre 2019 sur sqlservercentral.com
 

The post New Redgate University Courses to Advance your Skills appeared first on SQLServerCentral.

Where is Table Variable Created? – Interview Question of the Week #243

Publié le 22 septembre 2019 sur journey to sqlauthority
 

Question: Where is Table Variable Created?Answer: On Hard Disk and NOT in Memory.In recent time, I have received this question more times than the past and I believe the reason for it is the recent blog post series which I have done on the performance …

SQL SERVER – Table Variable or Temp Table – Performance Comparison

Publié le 21 septembre 2019 sur journey to sqlauthority
 

Earlier this week, I wrote two blog posts which are comparing performance between regular tables and temp tables. In this blog post, we will talk about Performance Comparison between Table Variable or Temp Table. Before you continue reading this blog p …

SQL SERVER – Regular Table or Temp Table – TempDB Logging Explained

Publié le 20 septembre 2019 sur journey to sqlauthority
 

Yesterday I wrote a blog post about based on the question SQL SERVER – Regular Table or Temp Table – A Quick Performance Comparison my client who is a recently hired me for Comprehensive Database Performance Health Check. The question was a …

Learn the fundamentals of Redgate Products

Publié le 20 septembre 2019 sur sqlservercentral.com
 

The post Learn the fundamentals of Redgate Products appeared first on SQLServerCentral.

SQL Server Permissions List for Read and Write Access for all Databases

Publié le 20 septembre 2019 sur sqlservercentral.com
 

The post SQL Server Permissions List for Read and Write Access for all Databases appeared first on SQLServerCentral.

Mid-Range 1440P AMD Gaming PC Build Guide

Publié le 19 septembre 2019 sur sqlskills.com - glen berry
 

Continuing the series I started yesterday, I thought I would put together a build guide for a Mid-Range 1440P AMD Gaming PC. I am classifying a mid-range gaming machine as costing between about $750.00 to $1500.00 for the main components.Any desktop ma …


Pages :