Sites anglophones


Meeting your CCPA needs with Data Classification and Masking

Publié le 6 mars 2020 sur sqlservercentral.com
 

The post Meeting your CCPA needs with Data Classification and Masking appeared first on SQLServerCentral.

Making TRY_CAST and TRY_CONVERT Queries Faster with Indexed Computed Columns

Publié le 5 mars 2020 sur brentozar.com
 

I know this is gonna sound crazy, but let’s say you had a table where people stored all kinds of things in one column: dates, integers, file names, sale prices, file names, you name it. And let’s say your application frequently ran a query …

SQL SERVER – Count NULL Values From Column

Publié le 5 mars 2020 sur journey to sqlauthority
 

The other day, I have received a very simple but interesting question by one of my earlier clients of Comprehensive Database Performance Health Check via email. The question was about how to count NULL values from the column.Honestly, this is a very si …

SQL Server on VMWare Performance Optimization

Publié le 5 mars 2020 sur sqlservercentral.com
 

The post SQL Server on VMWare Performance Optimization appeared first on SQLServerCentral.

Implementing Date Calculations in SQL

Publié le 5 mars 2020 sur sqlservercentral.com
 

Problem A few weeks back, I was working on a report for one of my clients who were using a desktop application as a client tool with SQL as the database. The module on which I was working had a reporting functionality that displayed the Sales Amount by …

Build your DevOps business case with industry insights

Publié le 5 mars 2020 sur sqlservercentral.com
 

The post Build your DevOps business case with industry insights appeared first on SQLServerCentral.

How to Find Cool Questions and Answers on DBA.StackExchange.com

Publié le 4 mars 2020 sur brentozar.com
 

DBA.StackExchange.com is a Stack Overflow site that’s specifically targeted at database administrators. There tend to be some pretty interesting questions in there – not just for SQL Server, but all kinds of databases – but at the sam …

SQL SERVER – Install Error – The Account Running SQL Server Setup Does Not Have Administrator Rights On the Computer. To Continue, Use an Account With Administrator Rights

Publié le 4 mars 2020 sur journey to sqlauthority
 

As a part of my work, I also provide consultancy to fix the issues. In my recent engagement with a client, they were getting an error while installing SQL Server 2019. In this blog, I would share the steps to identify and fix error – The acc …

SQL Server and Undocumented Extended Procedures

Publié le 3 mars 2020 sur simple-talk.com
 

There are several undocumented stored and extended procedures that Microsoft uses internally in SQL Server. When you start to dig for information on them, the general line from Microsoft is not to use them because they could be removed at any time. Tha …

SQL ConstantCare® Population Report: Winter 2020

Publié le 3 mars 2020 sur brentozar.com
 

Ever wonder what’s “normal” out there for SQL Server adoption rates, hardware sizes, or numbers of databases? Let’s find out. Our SQL ConstantCare® service lets users send data in about their SQL Servers and get health & …

How to Create an Ubuntu PowerShell Development Environment – Part 2

Publié le 3 mars 2020 sur simple-talk.com
 

The series so far: How to Create an Ubuntu PowerShell Development Environment – Part 1 How to Create an Ubuntu PowerShell Development Environment – Part 2 Part 1 of this series covered the need for creating a Linux development environment f …

SQL SERVER – Truncating Data and ANSI_WARNINGS

Publié le 3 mars 2020 sur journey to sqlauthority
 

Today’s blog subject of Truncating Data and ANSI_WARNINGS was accidentally discovered while working on the Comprehensive Database Performance Health Check. Let us talk about the topic.It is very much known that in SQL Server 2019, Microsoft has f …

Knowledge Sharing with SQL Notebooks

Publié le 3 mars 2020 sur simple-talk.com
 

Whether presenting at a conference, to colleagues, or to an academic audience, choosing the best tool to share knowledge can be a challenge. PowerPoint is an effective presentation tool so long as the contents are static and there is no need for demons …

SQL Server Checkpoint Monitoring with Extended Events

Publié le 3 mars 2020 sur sqlservercentral.com
 

The post SQL Server Checkpoint Monitoring with Extended Events appeared first on SQLServerCentral.

Database Build Breakers: Avoiding Constraint Violations during SQL Server Deployments

Publié le 3 mars 2020 sur sqlservercentral.com
 

The post Database Build Breakers: Avoiding Constraint Violations during SQL Server Deployments appeared first on SQLServerCentral.


Pages :