Sites anglophones


Why Organizations Need to Pay Attention to Cloud Security

Publié le 12 juin 2020 sur sqlservercentral.com
 

The post Why Organizations Need to Pay Attention to Cloud Security appeared first on SQLServerCentral.

A Single Database View Cost Me $50/Day for Months.

Publié le 11 juin 2020 sur brentozar.com
 

Our SQL Server monitoring product, SQL ConstantCare®, uses Amazon Aurora on the back end. I blogged about our choice of database back in 2018, and at the time, I said: I know, I know. The Microsoft geek in you – and me – wants us to use …

Group By in SQL Sever with CUBE, ROLLUP and GROUPING SETS Examples

Publié le 11 juin 2020 sur sqlservercentral.com
 

The post Group By in SQL Sever with CUBE, ROLLUP and GROUPING SETS Examples appeared first on SQLServerCentral.

Lock Scenarios Using sys.dm_tran_locks

Publié le 11 juin 2020 sur sqlservercentral.com
 

Introduction A transaction is a single logical unit of work. All relational database management systems are expected to follow the four properties of transactions: Atomicity, Consistency, Isolation and Durability. Isolation is necessary in order to mak …

Getting Started with Automatic Database Branch Switching

Publié le 11 juin 2020 sur sqlservercentral.com
 

The post Getting Started with Automatic Database Branch Switching appeared first on SQLServerCentral.

When a Columnstore Index Makes Your Query Fail

Publié le 10 juin 2020 sur brentozar.com
 

If you wanna count the number of rows in a table, I’ve usually said, “It doesn’t matter what you put inside the COUNT() – it can be COUNT(*), COUNT(Id), COUNT(1), or COUNT(‘Chocula’), or even COUNT(1/0) – it al …

Getting Started with Data Masker for SQL Server: I Want to Mask A Database

Publié le 10 juin 2020 sur sqlservercentral.com
 

The post Getting Started with Data Masker for SQL Server: I Want to Mask A Database appeared first on SQLServerCentral.

How to Make Online Presentations Fun and Interactive with OBS Scenes #tsql2sday

Publié le 9 juin 2020 sur brentozar.com
 

In my recent post about how I use Streamlabs OBS for training classes & webcasts, I mentioned that to keep things lively, you wanna have a variety of scenes that you can switch between to keep the viewer engaged. Imagine a TV show or sporting event …

Basic Git for DBAs: Sharing Files Through GitHub

Publié le 9 juin 2020 sur sqlservercentral.com
 

This is the second article in a series on the basics of using Git. The other articles in the series are: Basic Git for DBAs: Getting Started with Git In the first article, we covered the basics. In this one, we will look at how to share our files with …

Challenges and trends for Database Monitoring in 2020

Publié le 9 juin 2020 sur sqlservercentral.com
 

The post Challenges and trends for Database Monitoring in 2020 appeared first on SQLServerCentral.

[Video] Top 3 Pitfalls of Managing Your Azure SQL DB Costs

Publié le 8 juin 2020 sur brentozar.com
 

You manage servers, not invoices. Your company has started to move their databases into Azure, and they’re asking questions that you’re just not ready to answer. How big does your server need to be when you’re moving an existing datab …

SQL Prompt in Azure Data Studio now in free public preview

Publié le 8 juin 2020 sur sqlservercentral.com
 

The post SQL Prompt in Azure Data Studio now in free public preview appeared first on SQLServerCentral.

How Automating Your Tests Improves Productivity

Publié le 8 juin 2020 sur sqlservercentral.com
 

The post How Automating Your Tests Improves Productivity appeared first on SQLServerCentral.

Basic Git for DBAs: Getting Started with Git

Publié le 8 juin 2020 sur sqlservercentral.com
 

There are numerous Git tutorials on the Internet, plenty of initial getting started posts, and no shortage of documentation available. However, for many DBAs and database developers, they often aren’t asked or forced to give version control a try. This …

Migrating SQL Monitor’s Base Service to .NET Core

Publié le 5 juin 2020 sur sqlservercentral.com
 

The post Migrating SQL Monitor’s Base Service to .NET Core appeared first on SQLServerCentral.


Pages :