Sites anglophones


Why is SQL Server Consolidation Better Than Having a Scattered Environment?

Publié le 20 février 2019 sur journey to sqlauthority
 

Having a scattered Microsoft SQL Server database platform is cumbersome to maintain, as you continue to accumulate waste capacity to your database servers. Therefore, you should consider consolidating your platform to make it more manageable. Let …

What does Azure SQL DB Automatic Index Tuning actually do, and when?

Publié le 19 février 2019 sur brentozar.com
 

Azure SQL DB’s Automatic Tuning will create and drop indexes based on your workloads. It’s easy to enable – just go into your database in the Azure portal, Automatic Tuning, and then turn “on” for create and drop …

Top 10 Databases for 2019

Publié le 19 février 2019 sur sqlservercentral.com
 

A look at ten top databases fighting for mind-share in 2019.

Learning about DML Triggers

Publié le 19 février 2019 sur sqlservercentral.com
 

Triggers can be confusing and complex for many developers new to SQL. Steve Jones gives a few ideas for learning more about this construct as well as practicing writing them.

Picking over the Bones of a SQL Injection Attack

Publié le 19 février 2019 sur sqlservercentral.com
 

The best way to learn how to protect your databases from SQL Injection is to see it in action. In this article, we attack a vulnerable SQL Server REST interface, explain how the attack unfolds, the mistakes that made it possible, and SQL Monitor’s vita …

SQL SERVER – How to Invoke SSMS Help From Command Prompt?

Publié le 19 février 2019 sur journey to sqlauthority
 

This particular question I just received in my recent SQL Server Performance Tuning Practical Workshop. It was a very interesting question and hence I am going to blog about it. The question which I received was – How to Invoke SSMS Hel …

Building SQL ConstantCare® Version 2: Easy-to-Afford Monitoring

Publié le 18 février 2019 sur brentozar.com
 

tl;dr – SQL ConstantCare® is now just $59 per month, or $495 per year. As we were building SQL ConstantCare®, I wanted it to be mentoring, not monitoring. I wanted to take daily data samples, trend them over time, and give you b …

SQL Source Control v7 Enhancements

Publié le 18 février 2019 sur sqlservercentral.com
 

With the v7 release, SQL Source Control now enforces Git hooks, and provides full support for working with Git repositories hosted on Azure DevOps. It also comes with pre- and post-deployment scripts to make it easier to automate the build and deploy n …

SQL SERVER – Windows Authentication or System Admin Account (SA)

Publié le 18 février 2019 sur journey to sqlauthority
 

I like to say that I am SQL Server Performance Tuning expert but often during the conversation, I end up discussing security as well. Recently I was asked about my preference for Windows Authentication or System Admin Account (SA) during one of th …

How to Find Table Cardinality from the Execution Plan? – Interview Question of the Week #213

Publié le 17 février 2019 sur journey to sqlauthority
 

Question: How to Find Table Cardinality from the Execution Plan? Answer: During SQL Server Performance Health Check, I often get such questions, which are often very interesting. Let me answer this question in two different ways. However, before w …

PostgreSQL – Storing Unicode Characters is Easy

Publié le 16 février 2019 sur journey to sqlauthority
 

One of the interesting features of PostgreSQL database is the ability to handle Unicode characters. In SQL Server, to store non-English characters, we need to use NVARCHAR or NCAHR data type. In PostgreSQL, the varchar data type itself will store both …

Creating SQL Server Agent Job Schedules for Ola Hallengren’s Maintenance Solution

Publié le 15 février 2019 sur sqlskills.com - glen berry
 

Data Platform MVP Ola Hallengren has created and maintained his free SQL Server Maintenance Solution script for over eleven years now. This script creates some objects in your master system database (by default), and it also creates and enables twelve …

[Video] How to Capture Baselines with sp_BlitzFirst

Publié le 15 février 2019 sur brentozar.com
 

Everybody tells you to capture baselines – but what exactly are you supposed to capture? Which Perfmon counters matter? How do you track which data files are growing, and which ones are slow? How can you track which queries are using the most res …

SQL Provision and Azure SQL Database

Publié le 15 février 2019 sur sqlservercentral.com
 

More and more businesses already use, or plan to use, cloud-based infrastructure (PaaS) as their primary database solution. However, they still need to support on-premise or Infrastructure as a Service (IaaS) VM-based workflows for Development and Test …

Script to Run DBCC CheckDB on Alternate SQL Server to Reduce Load on Primary Server

Publié le 15 février 2019 sur sqlservercentral.com
 

In this tip we look at some scripts you can use to automate running your DBCC CheckDBs on an alternate SQL Server instance.


Pages :