Sites anglophones


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.

SQL SERVER – Update Table Statistics in Parallel with FULLSCAN

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

SQL Server Performance Tuning is a much simpler job if you know exactly where to look for and how to tune the configurations. Here is the real world scenario which I encountered during the recent Comprehensive Database Performance Health Check. Du …

Should you run SSAS/SSIS/SSRS on the SQL Server?

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

When you’re building a new SQL Server, you’re going to see a few intriguing checkboxes during setup. It’s all free, right? Check everything! The services are all free, right? You can just check the boxes for Machine Learning Services, …

How to Apply Non-Standard SQL Formatting Using SQL Prompt

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

Like any good tool, SQL Prompt not only will format your code for you, but will also help you to format the code in an alternative manner, or to apply exceptions to certain parts of a SQL script, where the formatting applies by the current style isn’t …

Why Redgate is Running a Database Development Disasters Contest?

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

Kendra Little explains why Redgate would like to hear your stories of how the database has been left behind.

Frequently Asked Questions for SQL Server Performance Tuning Practical Workshop for EVERYONE

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

Earlier this week I announced my very first online training class open for (US, EU, Asia, and Everywhere) over here: SQL Server Performance Tuning Practical Workshop for EVERYONE – April 23, 2019, and so far I have received an amazing respon …

Using the Wait Statistics Report in Azure Data Studio

Publié le 13 février 2019 sur sqlskills.com - paul randall
 

Azure Data Studio, which used to be called SQL Operations Studio, has a bunch of extensions available, including one called Server Reports from Microsoft. Last year they took my wait stats query (from here) and made it into a report as part of Ser …

How fast can a $21,468/mo Azure SQL DB load data?

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

In my last post, I explored how fast a $5,436/mo Azure SQL DB Hyperscale could load data. I’d had a client who was curious about spinning up their dev environment up there to see how query plans might look different. Well, as long as I was runnin …

Stairway to Server Management Objects (SMO) Level 1: Concepts and Basics

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

Learn how to get started working with SMO and PowerShell.

Provisioning Multiple Masked Databases

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

Addressing common challenges, Redgate’s Chris Unwin explains how to create multiple masked copies of a database, delivered as a group with SQL Provision.

SQL SERVER – New Parallel Operation Cannot be Started Due to Too Many Parallel Operations Executing at this Time

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

One of my clients contacted me via my On Demand (50 Minutes) offering and they were seeing below error message in ERRORLOG – New parallel operation cannot be started due to too many parallel operations executing at this time. Here is the complete …


Pages :