Sites anglophones


Do You Still Want Coping Tips?

Publié le 16 juin 2020 sur sqlservercentral.com
 

A simple question, and you can vote by leaving a comment for this article. Do you still want me to include the coping trips in the newsletter after June? When the pandemic shut down much of the world in March, our CEO at Redgate Software asked us to th …

Basic Git for DBAs: the Basics of Branches

Publié le 16 juin 2020 sur sqlservercentral.com
 

This is the third 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 Basic Git for DBAs: Sharing Files Through GitHub In the first few articles, we set up a repository and …

Using a Public Web Service to Consume SQL Server Build Numbers

Publié le 15 juin 2020 sur simple-talk.com
 

During my time as a professional DBA, I have been responsible for quite a few SQL Server instances, all with their own set of characteristics, including different versions and patching levels, the topic of this article. One of the primary duties that D …

[Video] How to Find Queries Using OPTION RECOMPILE (And Their Parameters)

Publié le 15 juin 2020 sur brentozar.com
 

For years, I hated troubleshooting servers with high CPU usage caused by queries constantly asking for new execution plans. Hated it. SQL Server just doesn’t make it easy to find queries with recompile hints. Then Erik Darling’s sp_HumanEve …

Allowing for manual checks and changes during database deployments

Publié le 15 juin 2020 sur sqlservercentral.com
 

The post Allowing for manual checks and changes during database deployments appeared first on SQLServerCentral.

Banker’s Rounding. What is it good for?

Publié le 15 juin 2020 sur sqlservercentral.com
 

No, no, no. The song has nothing to do with this article. It’s not about war, it’s about the Banker’s Rounding method, so we don’t pull the second part of the quote in here. The method is widely used, so it must be good for …

The Database Development Stage

Publié le 12 juin 2020 sur sqlservercentral.com
 

The post The Database Development Stage appeared first on SQLServerCentral.

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 …


Pages :